andurilPegaxy Volume
    Updated 2022-03-07
    select block_timestamp::date as date,
    count(distinct tx_id) as txs,
    'Pegaxy' as game
    from polygon.events_emitted
    where contract_address = lower('0xc1c93D475dc82Fe72DBC7074d55f5a734F8cEEAE')
    and block_timestamp::date between current_date() - 60 and current_date()-1
    and tx_succeeded = 'TRUE'
    group by 1

    Run a query to Download Data