Arkanntransfer 1
    Updated 2023-01-22
    SELECT
    date_trunc('month',BLOCK_TIMESTAMP) as date,
    SYMBOL,
    sum(AMOUNT_USD) as Volume,
    count(distinct ORIGIN_FROM_ADDRESS) as transferor_number,
    count(*) as transfers_number,
    sum(Volume) over (partition by symbol order by date) as Cumulative_Volume,
    sum(transfers_number) over (partition by symbol order by date) as Cumulative_transfers_number
    FROM
    ethereum.core.ez_token_transfers
    WHERE CONTRACT_ADDRESS = LOWER('0x92D6C1e31e14520e676a687F0a93788B716BEff5')
    GROUP BY 1,2
    Run a query to Download Data