How common is "flipping" on Flow (selling within 24 hrs, within a week etc) compared to other chains
mlhHow common is "flipping" on Flow (selling within 24 hrs, within a week etc) compared to other chains
Updated 2022-07-16
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 flow_whale as ( select buyer , count(DISTINCT(tx_id)) as total_sales , sum(price) as volume
from flow.core.fact_nft_sales
group by 1
order by 3 desc
limit 100)
,
flow as ( select min(BLOCK_TIMESTAMP::date) as date , buyer , NFT_COLLECTION as nft
from flow.core.fact_nft_sales
where block_timestamp::date >= '2022-05-09' and buyer in ( select buyer from flow_whale)
group by 2,3
order by 1)
,
flow_sales as ( select min(block_timestamp::date) as sale_date , seller , NFT_COLLECTION
from flow.core.fact_nft_sales
where block_timestamp::date >= '2022-05-09' and seller in ( select buyer from flow) and nft_collection in ( select nft from flow)
group by 2,3)
,
final_flow as ( select datediff(day,date , sale_date) as differ, buyer, seller , nft_collection , nft
from flow_sales a join flow b on a.seller = b.buyer and a.nft_collection = b.nft
where differ >= 0)
,
ethereum_whale as ( select buyer_address ,count(DISTINCT(tx_hash)) as total_sales, sum(price_usd) as volume
from ethereum.core.ez_nft_sales
where price_usd is not null and BLOCK_TIMESTAMP::date >= '2022-05-09'
group by 1
order by 3 desc
limit 100)
,
ethereum as (select min(BLOCK_TIMESTAMP::date) as date , buyer_address , NFT_ADDRESS as nft
from ethereum.core.ez_nft_sales
where BLOCK_TIMESTAMP::date >= '2022-05-09' and buyer_address in (select buyer_address from ethereum_whale)
group by 2,3
order by 1)
,
Run a query to Download Data