mz0111Most popular stablecoins and non-stablecoins traded over time
Updated 2022-07-28Copy Reference Fork
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
distinct destination,
tx,
case
when DESTINATION = '5uBU2zUG8xTLA6XwwcTFWib1p7EjCBzWbiy44eVASTfV' then 'USD Coin (USDC)'
when DESTINATION = 'Hv7yPYnGs6fpN3o1NZvkima9mKDrRDJtNxf23oKLCjau' then 'USDT (USDT)'
when DESTINATION = '9KMH3p8cUocvQRbJfKRAStKG52xCCWNmEPsJm5gc8fzw' then 'Tether USD (Portal from BSC) (USDTbs)'
when DESTINATION = 'DukQAFyxR41nbbq2FBUDMyrtF2CRmWBREjZaTVj4u9As' then 'BUSD Token (Portal from BSC) (BUSDbs)'
when DESTINATION = 'Hv7yPYnGs6fpN3o1NZvkima9mKDrRDJtNxf23oKLCjau' then 'USDT (USDT)'
when DESTINATION = '9MQ6FFBm7Nk9jMY65m8MYvsno2akEGPLMLjargoccvic' then 'Swim Hexapool LP (swimUSD)'
when DESTINATION = '4R6b4aibi46JzAnuA8ZWXrHAsR1oZBTZ8dqkuer3LsbS' then 'USD Coin (Portal from Ethereum) (USDCet)'
when DESTINATION = 'DwjutE8CB1WNUzy78f44BdJNWMF1pYC5wd6eTchRcacL' then 'USD Coin (Portal from Polygon) (USDCpo)'
when DESTINATION = '9KMH3p8cUocvQRbJfKRAStKG52xCCWNmEPsJm5gc8fzw' then 'Tether USD (Portal from BSC) (USDTbs)'
when DESTINATION = '2DMUL42YEb4g1HAKXhUxL3Yjfgoj4VvRqKwheorfFcPV' then 'Tether USD (Portal from Ethereum) (USDTet)'
when DESTINATION = 'APG2hZqzk54NVjscBZ13iEZ9StR4Jpv82767hpHJwFQ7' then 'GDuUFXEhUm4jG71vPxYRX3VxUMJ5etGvHTR1iKwTdb6p token address'
when DESTINATION = 'Hv4t3QZhbb2enUYmXm2X2pRCJ4jsVNb8pRhLDqs6oHNZ' then 'GST (GST)'
when DESTINATION = 'BBHCpu6xKDjvoUDTBmBmejAoN4ADNeZiYcvKfVv7yz3L' then 'Swim Hexapool LP (swimUSD)'
when DESTINATION = '6zbeCeeUGbjiiW9PpxVuMqLmWZowoaDsMmWtRmX5Nx5W' then 'Swim Hexapool LP (swimUSD)'
end as token_name
FROM (
(SELECT
distinct (INNER_INSTRUCTION:instructions[0]:parsed:info:destination) as destination,
count(tx_id) as tx
FROM solana.core.fact_events
where program_Id in ( 'SWiMDJYFUGj6cPrQ6QYYYWZtvXQdRChSVAygDZDsCHC' , 'SWimmSE5hgWsEruwPBLBVAFi3KyVfe8URU2pb4w7GZs')
and SUCCEEDED = 'TRUE'
and destination IS NOT NULL
group by 1
order by 2 DESC)
union ALL
(SELECT
DISTINCT (INNER_INSTRUCTION:instructions[0]:parsed:info:destination) as destination,
count(tx_id) as tx
Run a query to Download Data