binhachonSeasonality - Days and timezone
Updated 2022-11-28
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
with swap_transaction as (
select
tx_id,
count(*) as frequency
from ethereum.dex_swaps
where platform like '%sushi%'
group by tx_id
),
swap_gas as (
select
block_timestamp,
tx_fee
from ethereum.transactions
where tx_id in (select tx_id from swap_transaction where frequency = 2)
)
select
date_part('hour', block_timestamp) as timezonehour,
-- date_part('weekday', block_timestamp) as dayofweek,
dayname(block_timestamp) as dayofweek,
avg(tx_fee) as average_fee
from swap_gas group by timezonehour, dayofweek
Run a query to Download Data