nickpayiatis_Untitled Query
    Updated 2022-10-13
    select a.BLOCK_TIMESTAMP, SWAP_PROGRAM, b.price_usd, SWAP_FROM_AMOUNT, b.PRICE_USD*SWAP_FROM_AMOUNT as FROM_VOLUME, SWAPPER, tx_group_id
    from flipside_prod_db.algorand.swaps a
    left join flipside_prod_db.algorand.prices_swap b
    on date_trunc('hour',a.BLOCK_TIMESTAMP)=date_trunc('hour',b.BLOCK_HOUR) and SWAP_FROM_ASSET_ID=b.ASSET_ID
    left join flipside_prod_db.algorand.prices_swap c
    on date_trunc('hour',a.BLOCK_TIMESTAMP)=date_trunc('hour',c.BLOCK_HOUR) and SWAP_TO_ASSET_ID=c.ASSET_ID
    where BLOCK_TIMESTAMP>= DATEADD(day, -7, CURRENT_DATE)
    and tx_group_id = 'Pm33vaUx6k10SAiw/F2D6zqXspYFLEkP9naCfUtUQXM='
    order by BLOCK_TIMESTAMP asc
    Run a query to Download Data