permaryphilosophical-cyan
    Updated 2025-03-13
    select
    date_trunc ('day', block_timestamp) as date,
    count (distinct from_address) as "Tactics Buyers",
    sum(amount) as total_weth,
    sum(amount_usd) as "Volume",
    SUM(SUM(amount_usd)) OVER (ORDER BY date_trunc('day', block_timestamp)) AS "Cumulative Volume"
    from blast.core.ez_token_transfers
    where to_address =lower('0x4aF1f00F50EfBFcDF7a8F2ac02e9BC24825438Ac')
    and contract_address = '0x4300000000000000000000000000000000000004'
    group by date
    order by date desc;
    QueryRunArchived: QueryRun has been archived