ValiMohammadibase 2
Updated 2024-04-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
base.defi.ez_dex_swaps
WHERE
TOKEN_OUT = '0xd02c83c1d519adf4b5da39c4eefd10fbed192773'
ORDER BY
block_timestamp
LIMIT
100
-- with a as (
-- SELECT
-- *
-- FROM
-- base.defi.ez_dex_swaps
-- WHERE
-- TOKEN_OUT = '0xd02c83c1d519adf4b5da39c4eefd10fbed192773'
-- ),
-- b as (
-- SELECT
-- *
-- FROM
-- base.defi.ez_dex_swaps
-- WHERE
-- TOKEN_OUT = '0xAaF2cDd7ff7D88A321Da49eFA9fdCC9226cBF3eB'
-- ), -- select * from a join b on a.swapper = b.swapper
-- c AS (
-- select
-- a.block_timestamp,
-- a.ORIGIN_FROM_ADDRESS as swapper,
-- b.ORIGIN_FROM_ADDRESS as signer
-- from
-- a
-- join b on a.ORIGIN_FROM_ADDRESS = b.ORIGIN_FROM_ADDRESS
-- ORDER by
QueryRunArchived: QueryRun has been archived