Soheil_MKUntitled Query
Updated 2022-09-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
SELECT
BLOCK_TIMESTAMP::date as date,
TX_HASH,
ORIGIN_FROM_ADDRESS,
AMOUNT_OUT,
AMOUNT_IN,
((AMOUNT_OUT-AMOUNT_IN)/AMOUNT_IN)*100
from ethereum.core.ez_dex_swaps
where TOKEN_out =lower('0xA0b86991c6218b36c1d19D4a2e9Eb0cE3606eB48') --usdc
and TOKEN_in =lower('0xdAC17F958D2ee523a2206206994597C13D831ec7') --usdt
and AMOUNT_OUT > AMOUNT_IN
order by 6 desc
limit 1000
Run a query to Download Data