Nige7777Untitled Query
Updated 2021-12-21
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
›
⌄
with cte_buyers as (
select * from ethereum.dex_swaps s
where token_address = lower('0x383518188c0c6d7730d91b2c03a03c837814a899' )
and block_timestamp >= CURRENT_DATE -120
--limit 100
)
,
cte_stakers as (
select * from ethereum.transactions t
WHERE
lower(to_address) in
(lower('0x0822F3C03dcc24d200AFF33493Dc08d0e1f274A2'),
lower('0xFd31c7d00Ca47653c6Ce64Af53c1571f9C36566a'),
lower('0xC8C436271f9A6F10a5B80c8b8eD7D0E8f37a612d'))
and block_timestamp >= CURRENT_DATE -120
)
select b.*, s.from_address from cte_stakers s
left join cte_buyers B on b.to_address = s.from_address
WHERE 1=1
and b.to_address is null
Run a query to Download Data