Keyrock2023-12-20 10:37 AM
    Updated 2023-12-20
    SELECT *
    FROM osmosis.defi.fact_swaps
    -- WHERE TX_FROM = 'osmo1ftrc7zh7wfyhrzpknplygttyp78hgccel7echm'
    -- WHERE lower(FROM_CURRENCY) = lower('ibc/2F498A0751C798A0D9A389AA3691123DADA57DAA4FE165D5C75894505B876BA6E4')
    ORDER BY BLOCK_TIMESTAMP DESC
    LIMIT 10
    -- WHERE POOL_IDS = [ '1325' ]
    -- ORDER BY BLOCK_ID ASC
    --WHERE FROM_CURRENCY = 'factory/osmo1mlng7pz4pnyxtpq0akfwall37czyk9lukaucsrn30ameplhhshtqdvfm5c/ulvn'
    -- WHERE TX_ID = 'ABBE090DB48A93846845180F869C06FF7B51C32E54C53E337909289620467F80' --TX_SUCCEEDED = 'true' AND TRADER = 'osmo1ftrc7zh7wfyhrzpknplygttyp78hgccel7echm'
    QueryRunArchived: QueryRun has been archived