0xaimanTop NFT Projects on Polygon
Updated 2022-07-15
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 raw as( select * from (with s1 as (select block_timestamp, tx_id,contract_address, event_inputs:tokenId as token_id, event_inputs:from as NFT_seller ,event_inputs:to as nft_buyer from flipside_prod_db.polygon.events_emitted
where event_name='Transfer' and event_inputs:tokenId is not null
and event_removed='FALSE'),
s2 as (
select tx_id, event_inputs:takerAssetFilledAmount/10e17 as price_paid from flipside_prod_db.polygon.events_emitted
where event_name='Fill' and event_inputs:makerFeeAssetData like '0%'
)
select block_timestamp as t, s1.tx_id,contract_address as NFT_ca, NFT_seller,NFT_buyer, token_id, price_paid
from s1 inner join s2 on s1.tx_id=s2.tx_id
)x inner join flipside_prod_db.polygon.labels as s
on x.NFT_ca=s.address
where s.LABEL_TYPE ='nft'
)
select nft_ca as project_address,case when nft_ca='0xc083c69ce2d496f4914cbb9e015d6afdcf8756cb' then 'Bit-Balls'
when nft_ca='0x46d8156857adca0708a0432b5f1efe47a411f29b' then 'Virtual Connect Punks'
when nft_ca='0x7e83e43bf89acbcdc56f314c455bb966bb4cdb4b' then 'PEYOTES'
when nft_ca='0xdb348f248091c41473a630a6ff6c10acc158d22f' then 'Poly Duckz'
when nft_ca='0xeaff5998efc71fea5f6a4cd0aef0571becdb4906' then 'DOTs NFT ART' end as NFT_project, avg_purchase_by_buyer
from (select nft_ca, avg(n_txn) as avg_purchase_by_buyer
from (select NFT_ca,NFT_buyer, count(tx_id) as n_txn
from raw
group by 1,2)
Run a query to Download Data