Keyrock2023-12-20 10:37 AM
Updated 2023-12-20
99
1
2
3
4
5
6
7
8
9
10
›
⌄
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