MONTH | SYMBOL | N_UNIQUE_ADDRESS | |
---|---|---|---|
1 | 2022-08-01 00:00:00.000 | SABER | 422 |
2 | 2023-09-01 00:00:00.000 | SABER | 3 |
3 | 2024-01-01 00:00:00.000 | USDH | 16437 |
4 | 2022-05-01 00:00:00.000 | Parrot USD | 8243 |
5 | 2022-05-01 00:00:00.000 | DAI | 615 |
6 | 2022-06-01 00:00:00.000 | USDC (Wormhole) | 1035 |
7 | 2023-02-01 00:00:00.000 | USDC (Wormhole) | 350 |
8 | 2022-12-01 00:00:00.000 | USDC (Wormhole) | 206 |
9 | 2023-04-01 00:00:00.000 | SABER | 24 |
10 | 2023-10-01 00:00:00.000 | USDC | 839079 |
11 | 2022-07-01 00:00:00.000 | USDT | 309239 |
12 | 2023-04-01 00:00:00.000 | USDT | 199656 |
13 | 2023-01-01 00:00:00.000 | USDC | 1165058 |
14 | 2022-06-01 00:00:00.000 | USDT | 408726 |
15 | 2022-04-01 00:00:00.000 | SABER | 711 |
16 | 2022-06-01 00:00:00.000 | Parrot USD | 11214 |
17 | 2022-01-01 00:00:00.000 | USDH | 60 |
18 | 2022-09-01 00:00:00.000 | UST | 9286 |
19 | 2022-10-01 00:00:00.000 | SABER | 100 |
20 | 2022-09-01 00:00:00.000 | DAI | 60 |
0xaimanStablecoin Dominance : Swap
Updated 2024-02-15
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
›
⌄
SELECT
-- swaps.block_timestamp as t,
DATE_TRUNC('month',block_timestamp) as month,
-- CONCAT(label_from.label, ' --> ', label_to.label) AS swap_direction,
Case
when label_from.address = 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB' then 'USDT'
when label_from.address = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' then 'USDC'
when label_from.address = '9vMJfxuKxXBoEa7rM12mYLMwTacLMLDJqHozw96WQL8i' then 'UST'
when label_from.address = 'USDH1SM1ojwWUga67PGrgFWUHibbjqMvuMaDkRJTgkX' then 'USDH'
when label_from.address = 'EjmyN6qEC1Tf1JxiG1ae7UTJhUxSwk1TCWNWqxWV4J6o' then 'DAI'
when label_from.address = '88881Hu2jGMfCs9tMu5Rr7Ah7WBNBuXqde4nR5ZmKYYy' then 'SABER'
when label_from.address = 'E2VmbootbVCBkMNNxKQgCLMS1X3NoGMaYAsufaAsf7M' then 'USDC (Wormhole)'
when label_from.address = 'Ea5SjE2Y6yvCeW5dYTn7PYMuW5ikXkvbGdcmSnXeaLjS' then 'Parrot USD'
end as SYMBOL,
COUNT(swapper) as n_unique_address -- ,
-- -- succeeded,
-- swapper,
-- swap_program,
-- CONCAT(label_from.label, ' --> ', label_to.label) AS swap_direction,
-- label_from.label as from_token,
-- swap_from_amount,
-- label_to.label as to_token,
-- swap_to_amount
FROM
solana.defi.fact_swaps swaps
left join solana.core.dim_labels label_from on SWAP_FROM_MINT = label_from.address
left join solana.core.dim_labels label_to on SWAP_to_MINT = label_to.address
WHERE
label_from.address in (
'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v',
'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB',
'9vMJfxuKxXBoEa7rM12mYLMwTacLMLDJqHozw96WQL8i',
'USDH1SM1ojwWUga67PGrgFWUHibbjqMvuMaDkRJTgkX',
'Ea5SjE2Y6yvCeW5dYTn7PYMuW5ikXkvbGdcmSnXeaLjS',
'E2VmbootbVCBkMNNxKQgCLMS1X3NoGMaYAsufaAsf7M',
Last run: about 1 year ago
...
215
9KB
188s