[Ethereum] How to get circulating supply for crypto currency

Ethereum-based tokens are intrinsically bound to Ethereum. Any token transaction would be in the form of a valid Ethereum transaction, in a block on the Ethereum chain. (see footnote)

It's entirely possible, as you've seen, to reward miners in a token for including a token-related transaction. This would indeed probably require modifying mining software, although in a future where tokens are common this might become a default setting. Either way, a token miner would also be an Ethereum miner. There'd be no way to mine only the tokens--nor, really, would there be any reason when you could get 5+ ETH per mined block for no extra effort.

At the moment, token transactions are payed for in ETH, which any miner would accept. The problem with paying solely in tokens is that even if someone will include the transaction, no unmodified miner would. That's why, as far as I know, there are no token-based fees currently in common use.

Footnote: An Ethereum smart contract could host a sidechain, and then the sidechain would have its own kind of miner. That said, sidechains have less use in Ethereum, since you can write contracts to have most sidechain features.

Here is an article on how to export Ethereum data to csv and analyze it with Amazon Athena https://medium.com/@medvedev1088/exporting-and-analyzing-ethereum-blockchain-f5353414a94e

It uses https://github.com/medvedev1088/ethereum-etl which outputs the data into blocks.csv, transactions.csv, erc20_transfers.csv.

blocks.csv

Column                  | Type               |
------------------------|---------------------
block_number            | bigint             |
block_hash              | hex_string         |
block_parent_hash       | hex_string         |
block_nonce             | hex_string         |
block_sha3_uncles       | hex_string         |
block_logs_bloom        | hex_string         |
block_transactions_root | hex_string         |
block_state_root        | hex_string         |
block_miner             | hex_string         |
block_difficulty        | bigint             |
block_total_difficulty  | bigint             |
block_size              | bigint             |
block_extra_data        | hex_string         |
block_gas_limit         | bigint             |
block_gas_used          | bigint             |
block_timestamp         | bigint             |
block_transaction_count | bigint             |

transactions.csv

Column              |    Type     |
--------------------|--------------
tx_hash             | hex_string  |
tx_nonce            | bigint      |
tx_block_hash       | hex_string  |
tx_block_number     | bigint      |
tx_index            | bigint      |
tx_from             | hex_string  |
tx_to               | hex_string  |
tx_value            | bigint      |
tx_gas              | bigint      |
tx_gas_price        | bigint      |
tx_input            | hex_string  |

erc20_transfers.csv

Column              |    Type     |
--------------------|--------------
erc20_token         | hex_string  |
erc20_from          | hex_string  |
erc20_to            | hex_string  |
erc20_value         | bigint      |
erc20_tx_hash       | hex_string  |
erc20_block_number  | bigint      |