flipside

    send receive in may
    kasadeghsend receive in may
    Updated 2022-06-16
    with greater_than_1_ALGO as (
    select * from flipside_prod_db.algorand.account
    where BALANCE>1
    )

    select count(DISTINCT a.ADDRESS) as "" from greater_than_1_ALGO as a
    join flipside_prod_db.algorand.asset_transfer_transaction as t
    on (a.ADDRESS=t.ASSET_SENDER or a.ADDRESS=t.ASSET_RECEIVER)
    where date(t.BLOCK_TIMESTAMP)>='2022-05-01' and date(t.BLOCK_TIMESTAMP)<='2022-05-30'
    Run a query to Download Data