KowalskiDeFiETH/USD Price Action | Pre-Post Merge
Updated 2023-03-11
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
›
⌄
WITH
weth as (
SELECT
DATE_TRUNC('hour',hour) as date,
COUNT(DISTINCT TX_HASH) as number_transactions,
AVG(price) as price,
CASE
WHEN tr.block_number < 15537351 THEN 'Pre-Merge'
ELSE 'Post-Merge'
END as merge_label
FROM ethereum.core.fact_hourly_token_prices AS pr
INNER JOIN ethereum.core.fact_transactions AS tr
ON DATE_TRUNC('hour',tr.block_timestamp)=pr.hour
WHERE token_address ='0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'
AND hour::date > '2022-09-01' AND hour::date < CURRENT_DATE
AND tr.block_timestamp::date > '2022-09-01' AND tr.block_timestamp::date < CURRENT_DATE
GROUP BY date, merge_label
),
wbtc as (
SELECT
DATE_TRUNC('hour',hour) as date,
COUNT(DISTINCT TX_HASH) as number_transactions,
AVG(price) as price,
CASE
WHEN tr.block_number < 15537351 THEN 'Pre-Merge'
ELSE 'Post-Merge'
END as merge_label
FROM ethereum.core.fact_hourly_token_prices AS pr
INNER JOIN ethereum.core.fact_transactions AS tr
ON DATE_TRUNC('hour',tr.block_timestamp)=pr.hour
WHERE token_address ='0x2260fac5e5542a773aa44fbcfedf7c193bc2c599'
AND hour::date > '2022-09-01' AND hour::date < CURRENT_DATE
AND tr.block_timestamp::date > '2022-09-01' AND tr.block_timestamp::date < CURRENT_DATE
GROUP BY date, merge_label
)
SELECT
Run a query to Download Data