@thibault_bnd / New Query

SQL query

1SELECT
2date_trunc('week', tx.block_time),
3SUM(amount/1e18 * p.price) AS staked
4FROM numerai."SimpleGriefing_evt_StakeBurned" s
5LEFT JOIN ethereum.transactions tx ON tx.hash = s.evt_tx_hash
6LEFT JOIN prices.usd p ON p.minute = date_trunc('minute', tx.block_time)
7WHERE p.symbol = 'NMR'
8GROUP BY 1;