jangobAstroport
Updated 2024-06-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
-- SELECT *
-- FROM sei.defi.fact_dex_swaps
-- WHERE
-- PLATFORM = 'astroport'
-- AND POOL_ADDRESS = 'sei1ltr0r989uds8y0gahfl6uqec5rqulks06fyugpre0syml8ul0jtsjgv69c'
-- AND BLOCK_TIMESTAMP >= '2024-05-06'
-- LIMIT 10
-- SELECT *
-- FROM sei.defi.fact_lp_actions
-- WHERE
-- PLATFORM = 'astroport'
-- AND POOL_ADDRESS = 'sei1ltr0r989uds8y0gahfl6uqec5rqulks06fyugpre0syml8ul0jtsjgv69c'
-- AND BLOCK_TIMESTAMP >= '2024-05-06'
-- LIMIT 10
-- SELECT *
-- FROM sei.core.fact_transactions
-- WHERE
-- TX_ID = 'E39F1BF7201224F8EAFBB3774BFA3C6AA7840BD38E64D14601E4C9914FF22D41'
-- AND BLOCK_TIMESTAMP > '2024-03-02'
-- LIMIT 10
-- SELECT *
-- FROM sei.core.fact_msg_attributes
-- WHERE
-- TX_ID = 'E39F1BF7201224F8EAFBB3774BFA3C6AA7840BD38E64D14601E4C9914FF22D41'
-- AND BLOCK_TIMESTAMP > '2024-03-02'
-- -- AND ATTRIBUTE_KEY = 'commission_amount'
-- LIMIT 10
-- SELECT *
-- FROM sei.core.fact_transfers
-- WHERE
-- TX_ID = '4C8494D994E3ADB38205C1453DF09CB11351306497402171458875435B82429A'
QueryRunArchived: QueryRun has been archived