shadilAlgorand x Fifa Partnership - ALGOs being transferred
    Updated 2022-05-08
    SELECT
    date(block_timestamp) as date,
    count(DISTINCT sender) as count_senders,
    sum(amount) as volume,
    case when date>='2022-05-02' then 'after'
    else 'before' end as spliter
    from algorand.payment_transaction
    where date(block_timestamp) >= '2022-04-01'
    and amount is not NULL
    and amount != 0
    and asset_id = 0 -- ALGO
    GROUP BY date
    Run a query to Download Data