Sandeshopensea deals returning users
Updated 2023-08-30
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
›
⌄
with
nft_transactions as (
select
*
from
ethereum.core.ez_nft_transfers
where
block_timestamp::date > '2023-07-09 00:00:00.000'
),
nft_swaps as (
select distinct
sender_nft.tx_hash
from
nft_transactions sender_nft
inner join nft_transactions rec_nft on sender_nft.tx_hash = rec_nft.tx_hash
and sender_nft.nft_from_address = rec_nft.nft_to_address
where
sender_nft.nft_from_address != '0x0000000000000000000000000000000000000000'
and rec_nft.nft_from_address != '0x0000000000000000000000000000000000000000'
and sender_nft.nft_to_address != '0x0000000000000000000000000000000000000000'
and rec_nft.nft_to_address != '0x0000000000000000000000000000000000000000'
),
deals as (
select
ft.*,tr.nft_address,tr.project_name,tr.tokenid
from
ethereum.core.fact_transactions ft
inner join
ethereum.core.ez_nft_transfers tr
on ft.tx_hash=tr.tx_hash
where
1 = 1
and ft.to_address = '0x00000000000000adc04c56bf30ac9d3c0aaf14dc'
and ft.tx_hash in (
select
Run a query to Download Data