MahrooUntitled Query
Updated 2022-10-02Copy Reference Fork
9
1
2
3
4
5
6
7
8
9
›
⌄
SELECT
case WHEN BLOCK_NUMBER < 15537393 THEN 'Before_Merge'
WHEN BLOCK_NUMBER >= 15537393 THEN 'After_Merge'
END as A,
date_trunc('day',block_timestamp) as day, sum(ETH_VALUE) as eth_amount, COUNT(DISTINCT FROM_ADDRESS) as wallet, COUNT(DISTINCT TX_HASH) as tx_count
FROM ethereum.core.fact_transactions
WHERE day >= '2022-09-01'
group by A, day
order by day asc
Run a query to Download Data