itsxenux$CRUMB Airdrop number of transactions
    Updated 2022-06-08
    with query AS (select date_trunc('day', block_timestamp) as date_time,
    count(distinct tx_id) transactions
    from flipside_prod_db.algorand.asset_transfer_transaction att
    join flipside_prod_db.algorand.account_asset aaa
    on att.asset_id = aaa.asset_id
    where att.sender = 'R6HMZIHUFPPFOOKO2ZBFA3M5ZGZ27ON67BOAIPTPQRPICNV75BWDLNFALE'
    and aaa.asset_name LIKE '%Crumb Token%'
    group by date_time)

    select date_time, transactions
    from query
    where transactions > 1
    order by date_time
    Run a query to Download Data