talebimorteza_72Untitled Query
Updated 2022-04-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
select
BLOCK_TIMESTAMP::date as date,
sum(AMOUNT_USD) as Volume_of_Swaps_,
count(tx_id) as Swape_number,
platform
from
ethereum.dex_swaps
where
platform <> 'curve'
AND
Direction = 'IN'
and
block_timestamp >= '2022-02-01' and block_timestamp <= '2022-04-19'
and to_address not in ('0x7a250d5630b4cf539739df2c5dacb4c659f2488d', '0x68b3465833fb72a70ecdf485e0e4c7bd8665fc45')
and from_address not in ('0x7a250d5630b4cf539739df2c5dacb4c659f2488d', '0x68b3465833fb72a70ecdf485e0e4c7bd8665fc45')
and token_address not in ('0x3F7Aff0EF20AA2E646290DfA4E67611B2220C597',
'0x6e36556b3ee5aa28def2a8ec3dae30ec2b208739',
'0xfd957f21bd95e723645c07c48a2d8acb8ffb3794',
'0x7e794ed35788b698ae60cefc98ee48015c4876da',
'0xbd2f0cd039e0bfcf88901c98c0bfac5ab27566e3')
and
amount_usd > 0
group by date, platform
Run a query to Download Data