strawbettyDaily volume in ALGO
    Updated 2022-05-12

    with tx_group_ids_0 as (
    select tx_group_id as group_id
    from algorand.payment_transaction
    where receiver ='XNFT36FUCFRR6CK675FW4BEBCCCOJ4HOSMGCN6J2W6ZMB34KM2ENTNQCP4'
    group by 1
    ),
    tx_group_ids as (
    select tx_group_id as group_id , max(amount) as sale_amount
    from algorand.payment_transaction
    where tx_group_id in (select * from tx_group_ids_0 )
    and amount is not NULL
    group by 1
    ),
    amounts as (
    select date_trunc('hour',block_timestamp) as hour ,
    sum (sale_amount) as Volume ,
    count (DISTINCT tx_group_id) as transactions,
    sum (sale_amount*price_usd) as USD_volume
    from algorand.payment_transaction p join tx_group_ids ids join algorand.prices_swap
    on ids.group_id = p.tx_group_id
    and date_trunc('hour',block_timestamp) = date_trunc('hour',block_hour)
    where prices_swap.asset_id = 0
    group by 1
    )
    select date_trunc('day',hour) as date ,
    sum (Volume) as volume ,
    sum ( transactions ) as transactions ,
    sum (USD_volume) as USD_volume
    from amounts
    group by 1
    Run a query to Download Data