MadiCompare v2/v3
Updated 2022-10-27Copy Reference Fork
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
›
⌄
SELECT
-- date_trunc('day',BLOCK_TIMESTAMP) as date,
-- platform,
'Uniswap v2' as Version,
COUNT(distinct TX_HASH) as tx_count,
sum(IFF(abs(AMOUNT_IN_USD) > pow(10,9), abs(AMOUNT_IN_USD)/pow(10,18), abs(AMOUNT_IN_USD))) as AMOUNT_USD,
median(IFF(abs(AMOUNT_IN_USD) > pow(10,9), abs(AMOUNT_IN_USD)/pow(10,18), abs(AMOUNT_IN_USD))) as median_AMOUNT_USD
FROM
ethereum.core.ez_dex_swaps
WHERE platform = 'uniswap-v2' and date_trunc('day',BLOCK_TIMESTAMP) >= '2021-05-05'
UNION ALL
SELECT
-- date_trunc('day',BLOCK_TIMESTAMP) as date,
-- platform,
'Uniswap v3' as Version,
COUNT(distinct TX_HASH) as tx_count,
sum(IFF(abs(AMOUNT_IN_USD) > pow(10,9), abs(AMOUNT_IN_USD)/pow(10,18), abs(AMOUNT_IN_USD))) as AMOUNT_USD,
median(IFF(abs(AMOUNT_IN_USD) > pow(10,9), abs(AMOUNT_IN_USD)/pow(10,18), abs(AMOUNT_IN_USD))) as median_AMOUNT_USD
FROM
ethereum.core.ez_dex_swaps
WHERE platform = 'uniswap-v3' and date_trunc('day',BLOCK_TIMESTAMP) >= '2021-05-04'
Run a query to Download Data