Nige7777Untitled Query
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
›
⌄
with c_buyers AS
(
select * from ethereum.dex_swaps
where token_address = '0x383518188c0c6d7730d91b2c03a03c837814a899'
and direction = 'IN'
and block_timestamp > CURRENT_DATE - 90
)
, cte_stakers
as
(
select * from ethereum.transactions where
to_address in (
lower('0x0822F3C03dcc24d200AFF33493Dc08d0e1f274A2'),
lower ('0xFd31c7d00Ca47653c6Ce64Af53c1571f9C36566a'),
lower('0xC8C436271f9A6F10a5B80c8b8eD7D0E8f37a612d'))
and block_timestamp > CURRENT_DATE - 90
)
select * from c_buyers b
left join cte_stakers s
on s.from_address = b.to_address
--where b.to_address is null
Run a query to Download Data