flipside

    memecoin portfolio
    cyphermemecoin portfolio
    Updated 2024-12-07
    -- select * from solana.core.fact_token_balances
    -- where owner = '59h6Mdtcwmm8LPKrZTDXEcEsE949cFdjgMJ6V9Ysz6mH'
    -- and block_timestamp::date > '2024-12-01';


    -- swap 20 usdt for 33 act
    -- select * from solana.defi.fact_swaps_jupiter_summary
    -- where tx_id = '5Gu5nDj1XdYUmD2E3NUU93foqX9qmNr3sRtJMmibqU847W6L6FPd2ouQMTzZoGRjxbJZ1HhFVoNHDQBBeoUKwPxD'

    select * from solana.defi.fact_swaps_jupiter_summary
    where tx_id = '2usomLvCHWWtR9ei4LTaCN4EfUM8MG8tLa8J8QAcY3MDBZaoLJvexMAGqj2BA64xJ5Bow22Tks4q9ms2EJYVQdBz'
    QueryRunArchived: QueryRun has been archived