datavortexfee2
Updated 2025-01-16
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
›
⌄
⌄
⌄
/*
SELECT
DISTINCT s.tx_hash,
s.block_timestamp,
t.transaction_fee / 1e24 AS transaction_fee_near
FROM
near.defi.ez_dex_swaps s
JOIN near.core.fact_transactions t ON s.tx_hash = t.tx_hash
WHERE
s.platform = 'v2.ref-finance.near'
ORDER BY
s.block_timestamp DESC;
*/
/*
SELECT
COUNT(DISTINCT s.tx_hash) AS total_transactions,
SUM(t.transaction_fee / 1e24) AS total_transaction_fees_near
FROM
near.defi.ez_dex_swaps s
JOIN near.core.fact_transactions t ON s.tx_hash = t.tx_hash
WHERE
s.platform = 'v2.ref-finance.near';
*/
SELECT
s.tx_hash,
COUNT(*) AS row_count
FROM
near.defi.ez_dex_swaps s
JOIN near.core.fact_transactions t ON s.tx_hash = t.tx_hash
GROUP BY
s.tx_hash
HAVING
COUNT(*) > 1;
QueryRunArchived: QueryRun has been archived