flipside

    transfers - Daily - $DOGE
    Flipside Teamtransfers - Daily - $DOGE
    Updated 2024-07-24
    -- forked from transfers - Daily - $DOGE @ https://flipsidecrypto.xyz/edit/queries/66430d5f-1833-4c3c-908d-e1eafeb70846

    -- forked from transfers - Daily - $PEPE @ https://flipsidecrypto.xyz/edit/queries/50d3abb5-44d4-4b41-b04c-7f94ca11c583

    -- forked from Swap - Daily - $PEPE @ https://flipsidecrypto.xyz/edit/queries/070b87e6-111b-487c-b814-eeac5f9ed3fd

    select date_trunc('day',BLOCK_TIMESTAMP) as date
    , sum(AMOUNT_USD) as volume
    , count(TX_HASH) as transactions
    , count(distinct ORIGIN_FROM_ADDRESS) as users
    from bsc.core.ez_token_transfers
    where CONTRACT_ADDRESS = '0xba2ae424d960c26247dd6c32edc70b295c744c43'
    and date >= '2024-01-01'
    group by 1




    QueryRunArchived: QueryRun has been archived