Abbas_ra21Daily amount
    Updated 2024-03-01
    with main AS (select
    block_timestamp,
    TX_HASH,
    DECODED_LOG:to AS User,
    DECODED_LOG:value/1e18 AS Amount
    FROM
    ethereum.core.ez_decoded_event_logs
    where
    EVENT_NAME = 'Transfer'
    and CONTRACT_NAME = 'pufETH'
    and ORIGIN_TO_ADDRESS = '0x4aa799c5dfc01ee7d790e3bf1a7c2257ce1dceff'
    and DECODED_LOG:from='0x0000000000000000000000000000000000000000')
    select
    block_timestamp::date AS Day,
    sum(Amount) AS "Total Deposited Amount",
    sum("Total Deposited Amount") over (order by Day) AS "Cumulative Deposited Amount",
    count(DISTINCT User) AS Users,
    Count(*) AS TXns,
    avg(Amount) AS "Avg Deposited Amount",
    median(Amount) AS "Median Deposited Amount"
    from main group by 1
    Auto-refreshes every 24 hours
    QueryRunArchived: QueryRun has been archived