DAY | LABEL | SWAP_COUNT | CUMULATIVE_SWAP_COUNT | |
|---|---|---|---|---|
1 | 2025-04-22 00:00:00.000 | ShapeShift | 2 | 26624 |
2 | 2025-04-22 00:00:00.000 | THORWallet | 12 | 58859 |
3 | 2025-04-22 00:00:00.000 | Bitget | 13 | 7631 |
4 | 2025-04-22 00:00:00.000 | Others | 32 | 96009 |
5 | 2025-04-22 00:00:00.000 | THORSwap | 7 | 381741 |
6 | 2025-04-22 00:00:00.000 | Trustwallet | 73 | 982883 |
7 | 2025-04-22 00:00:00.000 | Asgardex | 6 | 169526 |
8 | 2025-04-22 00:00:00.000 | Ledger | 4 | 9644 |
9 | 2025-04-22 00:00:00.000 | rj | 3 | 1343 |
10 | 2025-04-22 00:00:00.000 | brt | 1 | 3 |
11 | 2025-04-21 00:00:00.000 | Bitget | 52 | 7618 |
12 | 2025-04-21 00:00:00.000 | THORSwap | 56 | 381734 |
13 | 2025-04-21 00:00:00.000 | Others | 144 | 95977 |
14 | 2025-04-21 00:00:00.000 | Ledger | 40 | 9640 |
15 | 2025-04-21 00:00:00.000 | rj | 56 | 1340 |
16 | 2025-04-21 00:00:00.000 | THORWallet | 48 | 58847 |
17 | 2025-04-21 00:00:00.000 | Trustwallet | 710 | 982810 |
18 | 2025-04-21 00:00:00.000 | ShapeShift | 22 | 26622 |
19 | 2025-04-21 00:00:00.000 | Asgardex | 54 | 169520 |
20 | 2025-04-20 00:00:00.000 | brt | 1 | 2 |
pietrektSwap Count by DEX
Updated 4 hours ago
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 init AS ( SELECT
block_timestamp, tx_id, from_amount_usd,
affiliate_address,
array_size(affiliate_addresses_array) as aff_adds_count,
CASE
WHEN aff_adds_count >= 2 AND affiliate_address = '-_' THEN affiliate_addresses_array[1]
ELSE affiliate_address
END AS fixed_aff_add
from thorchain.defi.fact_swaps
),
swaps_filtered AS (SELECT min(block_timestamp) as block_timestamp,
tx_id, max(from_amount_usd) as swap_volume_usd,
fixed_aff_add as aff_add
FROM init WHERE AFFILIATE_ADDRESS IS NOT NULL AND (tx_id NOT IN (SELECT DISTINCT tx_id FROM thorchain.defi.fact_refund_events))
group by tx_id, aff_add),
asgardex_swaps AS (SELECT min(block_timestamp) as block_timestamp, tx_id, max(from_amount_usd) as swap_volume_usd, max(min_to_amount) as min_to_amount,
CASE
WHEN min(affiliate_address) IS NULL THEN 'dx'
END AS aff_add
FROM thorchain.defi.fact_swaps group by tx_id),
asgardex_swaps_filtered AS (SELECT block_timestamp, tx_id, swap_volume_usd, aff_add from asgardex_swaps WHERE (RIGHT(min_to_amount, 3) = '999')),
thorswap_swaps_before_aff_address AS (SELECT min(block_timestamp) as block_timestamp, tx_id, max(from_amount_usd) as swap_volume_usd, max(min_to_amount) as min_to_amount,
CASE
WHEN min(affiliate_address) IS NULL THEN 'T'
END AS aff_add
FROM thorchain.defi.fact_swaps WHERE (to_date(block_timestamp) < '2022-04-24') group by tx_id),
thorswap_swaps_before_aff_address_filtered AS (SELECT block_timestamp, tx_id, swap_volume_usd, aff_add from thorswap_swaps_before_aff_address WHERE RIGHT(min_to_amount, 3) = '111'),
trust_ios_swap_ids AS (SELECT min(block_timestamp) AS block_timestamp, tx_id FROM thorchain.defi.fact_swaps_events
WHERE RIGHT(memo,3) like '%::0%' and memo like '%=:%' AND block_timestamp < '2023-06-14'
GROUP BY tx_id),
Last run: about 4 hours agoAuto-refreshes every 24 hours
...
10893
517KB
9s