total swaps | successful swaps | failed swaps | total swappers | success rate | average swaps per day | average swappers per day | |
|---|---|---|---|---|---|---|---|
1 | 366605844 | 366596250 | 9594 | 12791045 | 99.997383 | 11825994.967742 | 412614.354839 |
datavortexOVERALL
Updated 2024-09-25
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 overall AS (
SELECT
COUNT(DISTINCT tx_id) AS "total swaps",
COUNT(DISTINCT CASE WHEN succeeded = 'True' THEN tx_id END) AS "successful swaps",
COUNT(DISTINCT CASE WHEN succeeded = 'False' THEN tx_id END) AS "failed swaps",
COUNT(DISTINCT swapper) AS "total swappers"
FROM
solana.defi.fact_swaps
WHERE
block_timestamp > '2024-08-31' AND block_timestamp < '2024-10-01'
),
date_info AS (
SELECT
DATEDIFF('day', '2024-08-31', '2024-10-01') AS days_in_period
),
averages AS (
SELECT
(SELECT "total swaps" FROM overall) / (SELECT days_in_period FROM date_info) AS "average swaps per day",
(SELECT "total swappers" FROM overall) / (SELECT days_in_period FROM date_info) AS "average swappers per day"
)
SELECT
ovl."total swaps",
ovl."successful swaps",
ovl."failed swaps",
ovl."total swappers",
CASE
WHEN ovl."total swaps" > 0 THEN
(ovl."successful swaps" * 100.0 / ovl."total swaps")
ELSE
0
END AS "success rate",
avg."average swaps per day",
avg."average swappers per day"
FROM
overall ovl
Last run: 3 months ago
1
77B
406s