datavortexFEES 1
Updated 2024-09-11
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 transaction_fees AS (
SELECT
tx_id,
fee / 1e9 AS fee_sol
FROM
solana.core.fact_transactions
)
SELECT
s.swap_to_symbol AS swapped_to,
COUNT(DISTINCT s.tx_id) AS total_swap,
SUM(s.swap_from_amount_usd) AS volume_swapped,
COUNT(DISTINCT s.swapper) AS swappers,
COALESCE(SUM(t.fee_sol), 0) AS total_fees_sol
FROM
solana.defi.ez_dex_swaps s
LEFT JOIN
transaction_fees t
ON
s.tx_id = t.tx_id
WHERE
s.block_timestamp BETWEEN '{{start_date}}' AND '{{end_date}}'
AND s.swap_from_symbol = '{{token1}}'
GROUP BY
s.swap_to_symbol
ORDER BY
volume_swapped DESC;
*/
WITH transaction_fees AS (
SELECT
tx_id,
fee / 1e9 AS fee_sol
FROM
solana.core.fact_transactions
QueryRunArchived: QueryRun has been archived