mz0111Most popular stablecoins and non-stablecoins traded over time
    Updated 2022-07-28
    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