0xbuddha98New Kook's Query-3
Updated 2024-12-11
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
›
⌄
-- forked from New Kook's Query-2 @ https://flipsidecrypto.xyz/studio/queries/05ff8436-5030-4fbe-8fd7-1a65a5ed297e
WITH fresh_wallet_traders AS (
SELECT
from_address,
MIN(block_timestamp)
FROM
ethereum.core.fact_transactions
WHERE
from_address IN (
SELECT
trader
FROM
crosschain.defi.ez_dex_swaps
WHERE
block_timestamp > CURRENT_TIMESTAMP() - INTERVAL '3 day'
)
GROUP BY
1
HAVING
MIN(block_timestamp) > CURRENT_TIMESTAMP() - INTERVAL '3 day'
),
fresh_wallet_buys AS (
SELECT
token_out,
amount_out_usd AS buy,
trader
FROM
crosschain.defi.ez_dex_swaps s
WHERE
s.trader IN (
SELECT
from_address
FROM
fresh_wallet_traders
)
QueryRunArchived: QueryRun has been archived