KaskoazulUntitled Query
    Updated 2022-04-17
    with A as (
    select ft.tx_id,
    ft.amount,
    ft.tx_from,
    ft.tx_to,
    fe.event_type,
    fe.program_id,
    fe.instruction
    from solana.fact_transactions ft
    inner join solana.dim_labels fe
    on ft.tx_id = fe.tx_id
    where mint = 'USDH1SM1ojwWUga67PGrgFWUHibbjqMvuMaDkRJTgkX'
    )

    select *
    from A



    select *
    from solana.dim_labels
    where address_name like '%Stable%' = 'SSwpkEEcbUqx4vtoEByFjSkhKdCT862DNVb52nZg1UZ'
    --label in ('saber')--'jupiter', 'solend', 'raydium', 'parrot', 'mercurial', 'saber', 'atrix', 'mango%', 'marinade', 'serum')

    select *
    from solana.fact_transactions
    where tx_id in ('2oZMN23yvPusE821TRmFy3xzi5XT2uvX66FLMvwcYh89zMxC9sQiE8jyiX8WfxEjLsmCAyig4XuKmksCtv4KcoZL', '3tcnpFeXJ2nBMAVHfRqQxhuW7XYBGWERPQ8QcXum3AmVpAfuzwn6kjtkpT8BFJEcZwBrNFqy45YUGVQFj3166pkL')
    ('641ydSgkhRQPsDuSjrx8GqhqdqksBfC4su1Hzi9vx2H4Cv779fnNBAef8TLHFJtEYZ3YxuJuttVfVfYpPSsShTPG', '4hSL6cDMUMXa6S4ZrFUdk19MiqcTHxezASHzVJSAFqfAQjJARHYQLtZn4SRWtJUK9j2xasTCMDsaDra77exs5ZU7',
    'EK1FYQmathD33o677Mh21fpTk9D6LWLzjb4V2GSWYkta6UaBfgTgv1wbrxey2A55DKefCQhXeDVkHpbHY7VmY7j')


    select *
    from solana.
    where tx_to = '6YjT74rmcfCpw8LSjPNx5JTmZoYLGrTKnf9arfSgZ4SR'
    Run a query to Download Data