AG_TYPE | AMT | |
|---|---|---|
1 | Median Daily Fees | 15653.562744762 |
2 | Average Daily Fees | 20986.217923422 |
jackguyUniswap Fe - 2 copy
Updated 2024-01-29
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 tab1 as (
SELECT
date(block_timestamp) as day,
count(*) as events,
sum(amount_USD) as volume,
count(DISTINCT origin_from_address) as users
FROM (
SELECT
block_timestamp,
AMOUNT_usd,
origin_from_address
FROM ethereum.core.ez_token_transfers
WHERE to_address LIKE lower('0x37a8f295612602f2774d331e562be9e61B83a327')
and tx_hash in (
SELECT tx_hash
FROM ethereum.uniswapv3.ez_swaps
ORDER by block_timestamp DESC
) AND block_timestamp >= '2023-10-17'
UNION all
SELECT
-- tx_hash,
block_timestamp,
AMOUNT_usd,
origin_from_address
from ethereum.core.ez_eth_transfers
WHERE eth_to_address LIKE lower('0x37a8f295612602f2774d331e562be9e61B83a327')
and tx_hash in (
SELECT tx_hash
FROM ethereum.uniswapv3.ez_swaps
ORDER by block_timestamp DESC
) AND block_timestamp >= '2023-10-17'
)
GROUP BY 1
)
Last run: about 1 year agoAuto-refreshes every 6 hours
2
78B
76s