MahrooUntitled Query
    Updated 2022-10-02
    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