nickpayiatis_Untitled Query
Updated 2022-10-13
9
1
2
3
4
5
6
7
8
9
›
⌄
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