WEEK | TOTAL_TRANSACTIONS | TOTAL_FEE_USD | |
|---|---|---|---|
1 | 2021-08-16 00:00:00.000 | 582 | 5.678979748 |
2 | 2021-08-23 00:00:00.000 | 15029 | 144.183820918 |
3 | 2021-08-30 00:00:00.000 | 28028 | 270.211168127 |
4 | 2021-09-06 00:00:00.000 | 27879 | 420.656979634 |
5 | 2021-09-13 00:00:00.000 | 24099 | 350.93283116 |
6 | 2021-09-20 00:00:00.000 | 36078 | 459.493048563 |
7 | 2021-09-27 00:00:00.000 | 36981 | 451.833244114 |
8 | 2021-10-04 00:00:00.000 | 107666 | 1300.746641161 |
9 | 2021-10-11 00:00:00.000 | 54483 | 640.578611487 |
10 | 2021-10-18 00:00:00.000 | 46511 | 647.556155408 |
11 | 2021-10-25 00:00:00.000 | 55479 | 1040.868292146 |
12 | 2021-11-01 00:00:00.000 | 29809 | 509.128214332 |
13 | 2021-11-08 00:00:00.000 | 28627 | 519.475503389 |
14 | 2021-11-15 00:00:00.000 | 32695 | 469.415319655 |
15 | 2021-11-22 00:00:00.000 | 24604 | 534.654079496 |
16 | 2021-11-29 00:00:00.000 | 21539 | 442.061808278 |
17 | 2021-12-06 00:00:00.000 | 30016 | 650.917554126 |
18 | 2021-12-13 00:00:00.000 | 19580 | 467.079849121 |
19 | 2021-12-20 00:00:00.000 | 33216 | 1037.329075545 |
20 | 2021-12-27 00:00:00.000 | 24550 | 907.826168752 |
datavortexweekly fee usd
Updated 2025-04-30
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 swap_transactions AS (
SELECT DISTINCT
s.tx_hash,
s.block_timestamp,
t.transaction_fee / 1e24 AS transaction_fee_near,
s.platform
FROM
near.defi.ez_dex_swaps s
JOIN near.core.fact_transactions t ON s.tx_hash = t.tx_hash
),
daily_near_prices AS (
SELECT
DATE_TRUNC('day', hour) AS day,
PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY price) AS median_near_price_usd
FROM
near.price.ez_prices_hourly
WHERE
symbol = 'NEAR'
GROUP BY
DATE_TRUNC('day', hour)
)
SELECT
DATE_TRUNC('week', s.block_timestamp) AS week,
COUNT(DISTINCT s.tx_hash) AS total_transactions,
SUM(s.transaction_fee_near * p.median_near_price_usd) AS total_fee_usd
FROM
swap_transactions s
JOIN daily_near_prices p
ON DATE_TRUNC('day', s.block_timestamp) = p.day
WHERE
s.platform = 'v2.ref-finance.near'
GROUP BY
DATE_TRUNC('week', s.block_timestamp)
ORDER BY
week;
Last run: 25 days ago
...
194
9KB
299s