pavlyshynAstroport_pools
Updated 2022-05-11
9
1
2
3
4
5
6
7
8
9
›
⌄
select
'astro' as PROTOCOL, BLOCK_ID, BLOCK_TIMESTAMP,
CONTRACT_ADDRESS, TOTAL_SHARE, TOKEN_0_CURRENCY, TOKEN_0_AMOUNT,
TOKEN_1_CURRENCY, TOKEN_1_AMOUNT
from astroport.pool_reserves
where block_timestamp > CURRENT_DATE() - INTERVAL '14 day'
--and block_id<7419895
and contract_address IN ('terra1jxazgm67et0ce260kvrpfv50acuushpjsz2y0p')
order by block_id
Run a query to Download Data