Madidailyratio
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
›
⌄
WITH tx_v2 as (
SELECT
date_trunc('day', block_timestamp) AS date,
COUNT(DISTINCT TX_HASH) as tx_v2,
COUNT(DISTINCT SENDER) as holders_v2
FROM ethereum.core.ez_dex_swaps
WHERE platform = 'uniswap-v2' and date_trunc('day', block_timestamp) >= '2021-05-05'
GROUP BY date
ORDER BY date ASC),
tx_v3 as (
SELECT
date_trunc('day', block_timestamp) AS date,
COUNT(DISTINCT TX_HASH) as tx_v3,
COUNT(DISTINCT SENDER) as holders_v3
FROM ethereum.core.ez_dex_swaps
WHERE platform = 'uniswap-v3' and date_trunc('day', block_timestamp) >= '2021-05-05'
GROUP BY date
ORDER BY date ASC)
SELECT
a.date as date,
b.tx_v3/a.tx_v2 as tx_ratio,
b.holders_v3/a.holders_v2 as holder_ratio
FROM tx_v2 a join tx_v3 b on a.date=b.date
Run a query to Download Data