jackguyUnigrants - 2 - 3
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
SELECT
-- date_trunc('day', block_timestamp) as day,
sum(amount_in_usd) as volume_usd,
count(DISTINCT ORIGIN_FROM_ADDRESS) as users
FROM ethereum.core.ez_dex_swaps
WHERE platform LIKE '%uniswap%'
AND (
token_in in ('0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2',
'0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48',
'0xdac17f958d2ee523a2206206994597c13d831ec7',
'0x1f9840a85d5af5bf1d1762f925bdaddc4201f984',
'0x6b175474e89094c44da98b954eedeac495271d0f',
'0x045e507925d2e05d114534d0810a1ab56839f984',
'0x7fc66500c84a76ad7e9c93437bfc5ac33e2ddae9',
'0x9f8f72aa9304c8b593d555f12ef6589cc3a579a2',
lower('0x514910771AF9Ca656af840dff83E8264EcF986CA'),
lower('0x5A98FcBEA516Cf06857215779Fd812CA3beF1B32'),
lower('0xc944E90C64B2c07662A292be6244BDf05Cda44a7'),
lower('0xD533a949740bb3306d119CC777fa900bA034cd52')
)
OR
token_out in ('0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2',
'0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48',
'0xdac17f958d2ee523a2206206994597c13d831ec7',
'0x1f9840a85d5af5bf1d1762f925bdaddc4201f984',
'0x6b175474e89094c44da98b954eedeac495271d0f',
'0x045e507925d2e05d114534d0810a1ab56839f984',
'0x7fc66500c84a76ad7e9c93437bfc5ac33e2ddae9',
'0x9f8f72aa9304c8b593d555f12ef6589cc3a579a2',
lower('0x514910771AF9Ca656af840dff83E8264EcF986CA'),
lower('0x5A98FcBEA516Cf06857215779Fd812CA3beF1B32'),
lower('0xc944E90C64B2c07662A292be6244BDf05Cda44a7'),
lower('0xD533a949740bb3306d119CC777fa900bA034cd52')
)
)
Run a query to Download Data