banbannardFLOW vs Others NFT Behaviour 2
Updated 2022-07-17
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 base as (select date_trunc('day', block_timestamp) as first_buying_date,
buyer,
nft_collection
from flow.core.fact_nft_sales
where price > 0
and tx_succeeded = 'TRUE'),
flow as (select date_trunc('day', block_timestamp) as selling_date,
count(distinct(a.tx_id)) as flip_tx_count_flow
from flow.core.fact_nft_sales a
join base b
on a.seller = b.buyer
and a.nft_collection = b.nft_collection
where selling_date > first_buying_date
and datediff(day, selling_date, first_buying_date) <= 7
group by 1),
base2 as (select date_trunc('day', block_timestamp) as first_buying_date,
buyer_address,
nft_address
from ethereum.core.ez_nft_sales
where price > 0),
eth as (select date_trunc('day', block_timestamp) as selling_date,
count(distinct(a.tx_hash)) as flip_tx_count_eth
from ethereum.core.ez_nft_sales a
join base2 b
on a.seller_address = b.buyer_address and a.nft_address = b.nft_address
where selling_date > first_buying_date
and datediff(day, selling_date, first_buying_date) <= 7
group by 1),
base3 as (select date_trunc('day', block_timestamp) as first_buying_date,
purchaser,
mint
from solana.core.fact_nft_sales
Run a query to Download Data