flyingfishbreadcrumbs v1
Updated 2022-12-15
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
-- SELECT *
-- FROM ethereum.core.ez_dex_swaps
-- WHERE block_timestamp > '2022-11-10'
-- and origin_from_address = lower('0xc5bacbb46b18cd035c1063d16d32c6bdcf541de8')
-- -- AND (tx_from = '8w3FgNEbAKvetyMx7qfsVqH6kEjiyCctjkfPcN54Rb1B' OR tx_to = '8w3FgNEbAKvetyMx7qfsVqH6kEjiyCctjkfPcN54Rb1B')
-- -- AND (tx_hash = '0x77aac5e1ee357d5e2d4a91b823099ec38e81a92a468fbf9078b8a75b98ae4377' OR tx_hash = '0xbf1b8290e15b7dd124c22731c1316b394fac42b16e6b2ee16118a0d2f893a7d6')
-- and (token_in = '0x5f6a0f971e67eb5fffdb9f1c27572c5eab6a631c' or token_out = '0x5f6a0f971e67eb5fffdb9f1c27572c5eab6a631c')
SELECT *
from ethereum.core.fact_transactions
WHERE block_timestamp > '2022-08-01'
AND (from_address = lower('0xC36a79F41538f7e43194d15E7fF437DA64bD00bD') OR to_address = lower('0xC36a79F41538f7e43194d15E7fF437DA64bD00bD'))
Run a query to Download Data