rajsUntitled Query
Updated 2023-03-08
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
SELECT
case when amount_out_usd is null then amount_in_usd / (amount_out / pow(10,18)) else amount_out_usd / (amount_in / pow(10,18)) end as price,
case when amount_out_usd is null then amount_in else amount_in / pow(10,18) end as amount_in_adj,
case when amount_out_usd is null then amount_out / pow(10,18) else amount_out end as amount_out_adj,
*
from ethereum.core.ez_dex_swaps
-- where tx_hash = '0x3a9bcbf964a055478cabf8d91465358380fb87fccb0221f7f3bac87d5a08c688'
where origin_from_address = '0x2d6d167ff383fe060c4b64d5f6ce21f0dbebf7f2'
-- and contract_address = '0xc15e41eb55af2c0f7c34fb150a688f672d4b1be2'
and contract_address = '0xaa1656b7d4629476fa4cf76ccfbc01a4653bac71'
order by block_timestamp
-- limit 3
Run a query to Download Data