Updated 2024-03-22
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
›
⌄
-- select
-- TX_id,
-- block_timestamp,
-- ORIGIN_FROM_ADDRESS,
-- ORIGIN_TO_ADDRESS,
-- AMOUNT_OUT,
-- AMOUNT_IN,
-- SYMBOL_IN,
-- SYMBOL_OUT
-- from
-- solana.defi.fact_swaps
-- where
-- lower(contract_address) = '0xe09d908d36214df3db603d1f42f05b137773c26c'
-- -- AND origin_from_address = '0x31f58e771c3a2780c73042b6f28d243abb39e39b'
-- -- AND SYMBOL_IN = 'WBNB'
-- order by
-- block_timestamp asc
-- LIMIT 500
SELECT
*
FROM
solana.defi.fact_swaps
WHERE
swap_to_mint = '382stwqaL4TztEZpu8pYa97xkMECtdy8DW3qBn5wAo4W'
ORDER BY
BLOCK_TIMESTAMP ASC
LIMIT
500
QueryRunArchived: QueryRun has been archived