kidaUniswap 100 Bucket
Updated 2024-10-21
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
›
⌄
-- forked from Uniswap 1k Bucket @ https://flipsidecrypto.xyz/edit/queries/88eeed99-df9e-4e2a-9531-4673a8c45fe8
-- forked from Uniswap 10k Bucket @ https://flipsidecrypto.xyz/edit/queries/cf71929a-a656-4a37-a7bc-b8fb27b67123
-- forked from Uniswap 100k Bucket @ https://flipsidecrypto.xyz/edit/queries/5dd9fc35-4a3e-4194-9c55-71250f4c394b
-- forked from Uniswap 1M Bucket @ https://flipsidecrypto.xyz/edit/queries/d9877aba-d729-4615-a19d-5b693349d470
with prices as (
select
trunc(hour, 'hour') as hour,
avg(price) as price
from
ethereum.price.ez_prices_hourly
where symbol = 'ETH'
group by 1
),
transactions as (
select
trunc(d.block_timestamp, 'hour') as hour,
d.tx_hash,
d.amount_in_usd,
d.amount_out_usd,
coalesce(d.amount_in_usd, d.amount_out_usd) as tx_vol,
t.gas_used,
t.gas_limit,
t.gas_price,
t.effective_gas_price,
t.tx_fee
-- t.tx_fee_precise
from ethereum.defi.ez_dex_swaps d
join ethereum.core.fact_transactions t
on t.tx_hash = d.tx_hash
where platform like 'uniswap%'
and tx_vol is not null
QueryRunArchived: QueryRun has been archived