Elprognerd9 - tx fees
Updated 2022-12-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
›
⌄
SELECT
'UniSwap' as aggregator,
sum(TX_FEE) AS "Total volume of gas fees",
avg(TX_FEE) AS "Average volume of gas fees",
sum(TX_FEE_USD) AS "Total volume of gas fees in USD",
avg(TX_FEE_USD) AS "Average volume of gas fees in USD"
FROM ethereum.core.ez_nft_sales
WHERE origin_to_address = '0xef1c6e67703c7bd7107eed8303fbe6ec2554bf6b' AND block_timestamp >= '2022-11-30'
GROUP BY 1
UNION ALL
SELECT
'Blur' as aggregator,
sum(TX_FEE) AS "Total volume of gas fees",
avg(TX_FEE) AS "Average volume of gas fees",
sum(TX_FEE_USD) AS "Total volume of gas fees in USD",
avg(TX_FEE_USD) AS "Average volume of gas fees in USD"
FROM ethereum.core.ez_nft_sales
WHERE origin_to_address in ('0x000000000000ad05ccc4f10045630fb830b95127','0x39da41747a83aee658334415666f3ef92dd0d541') AND block_timestamp >= '2022-11-30'
GROUP BY 1
UNION ALL
SELECT
'Gem' as aggregator,
sum(TX_FEE) AS "Total volume of gas fees",
avg(TX_FEE) AS "Average volume of gas fees",
sum(TX_FEE_USD) AS "Total volume of gas fees in USD",
avg(TX_FEE_USD) AS "Average volume of gas fees in USD"
FROM ethereum.core.ez_nft_sales
WHERE origin_to_address in ('0x0000000031f7382a812c64b604da4fc520afef4b',
'0xf24629fbb477e10f2cf331c2b7452d8596b5c7a5',
'0x83c8f28c26bf6aaca652df1dbbe0e1b56f8baba2') AND block_timestamp >= '2022-11-30'
GROUP BY 1
Run a query to Download Data