strawbettyTotal volume in USD
    Updated 2022-05-12
    with fees as (select TX_GROUP_ID as group_,*
    from algorand.payment_transaction
    where receiver = 'XNFT36FUCFRR6CK675FW4BEBCCCOJ4HOSMGCN6J2W6ZMB34KM2ENTNQCP4'
    )
    ,
    algo as ( select date(BLOCK_TIMESTAMP) as data, sum(amount) as total_algo
    from algorand.payment_transaction
    where TX_GROUP_ID in ( select group_ from fees) and block_timestamp::date >= '2022-01-01'
    group by 1
    order by 1)
    ,
    price as ( select date(BLOCK_HOUR) as date , avg(price_usd) as price_usd
    from algorand.prices_swap
    where asset_id = 0 and BLOCK_HOUR::date >= '2022-01-01'
    group by 1)

    select data, total_algo , price_usd , total_algo*price_usd as total_volume_usd
    from algo join price
    where date = data
    and date >= '2022-01-01'
    order by 1
    Run a query to Download Data