Bitcoin Forum

+-----------+-----------------+----------------------------+
| block_num | block_height*50 | from_unixtime(block_nTime) |
+-----------+-----------------+----------------------------+
|     32485 |         1624250 | 2009-12-31 23:51:57        |
+-----------+-----------------+----------------------------+

mysql> select sum(txout_value/1E8) from block_tx inner join block on block.block_id = block_tx.block_id inner join tx on block_tx.tx_id = tx.tx_id inner join txin on txin.tx_id=tx.tx_
id inner join txout on txout.tx_id = tx.tx_id left join txin txin2 on txin2.txout_id = txout.txout_id left join tx tx2 on tx2.tx_id=txin2.tx_id left join block_tx block_tx2 on block_tx2.tx_id=tx2.tx_id where txin.txout_id is null and block.block_id <= 32485;
+----------------------+
| sum(txout_value/1E8) |
+----------------------+
|           1624252.87 |
+----------------------+

mysql> select case when txin2.txin_id is null then 'not moved' else case when block_tx2.block_id <= 32485 then 'moved i
n 2009' else 'moved after 2009' end end as move_status, sum(txout_value/1E8) from block_tx inner join block on block.bl
ock_id = block_tx.block_id inner join tx on block_tx.tx_id = tx.tx_id inner join txin on txin.tx_id=tx.tx_id inner join txout on txout.tx_id = tx.tx_id left join txin txin2 on txin2.txout_id = txout.txout_id left join tx tx2 on tx2.tx_id=txin2.tx_id left join block_tx block_tx2 on block_tx2.tx_id=tx2.tx_id where txin.txout_id is null and block.block_id <= 32485 group by move_status;
+------------------+----------------------+
| move_status      | sum(txout_value/1E8) |
+------------------+----------------------+
| moved after 2009 |            294800.15 |
| moved in 2009    |            137600.13 |
| not moved        |           1191852.59 |
+------------------+----------------------+

select year(from_unixtime(block.block_nTime)) as year, month(from_unixtime(block.block_nTime)) as month, sum(txout_value)*1E-8 
from block_tx 
  inner join block on block.block_id = block_tx.block_id 
  inner join tx on block_tx.tx_id = tx.tx_id 
  inner join txout on txout.tx_id = tx.tx_id 
  left join txin txin2 on txin2.txout_id = txout.txout_id 
where txin2.txout_id is null 
group by year, month;