datavortexswp
Updated 2024-11-23
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
›
⌄
-- Aptos fee data
SELECT
'Aptos' AS blockchain,
TOTAL_NUMBER_OF_SWAPS AS "Total Transactions",
AVG_FEE_PER_SWAP_IN_USD AS "Avg Fees in USD"
FROM
$query('c5a67aea-f20e-4b29-869b-5fc052cf93f3')
UNION ALL
-- BSC fee data
SELECT
'BSC' AS blockchain,
TOTAL_NUMBER_OF_SWAPS AS "Total Transactions",
AVG_FEE_PER_SWAP_IN_USD AS "Avg Fees in USD"
FROM
$query('a7aebb17-f831-4550-a073-498a15a8fefa')
UNION ALL
-- Avalanche fee data
SELECT
'Avalanche' AS blockchain,
TOTAL_NUMBER_OF_SWAPS AS "Total Transactions",
AVG_FEE_PER_SWAP_IN_USD AS "Avg Fees in USD"
FROM
$query('ec795ea1-ba82-44bc-a2cf-3b587e08e59c')
UNION ALL
-- NEAR fee data
SELECT
'Near' AS blockchain,
TOTAL_NUMBER_OF_SWAPS AS "Total Transactions",
AVG_FEE_PER_SWAP_IN_USD AS "Avg Fees in USD"
FROM
QueryRunArchived: QueryRun has been archived