adriaparcerisasTibles Mint Marketplace: List of users, listings and FP
Updated 2024-09-24
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
listings AS (
SELECT
-- event_data:nftType:typeID as collection
event_data:nftID AS nft_id,
event_data:storefrontAddress AS user,
ROUND(event_data:salePrice, 2) AS price
FROM flow.core.fact_events
WHERE event_contract in ('A.3cdbb3d569211ff3.NFTStorefrontV2','A.4eb8a10cb9f87357.NFTStorefront','A.4eb8a10cb9f87357.NFTStorefrontV2') AND event_type='ListingAvailable'
and (
event_data::string ilike '%A.481914259cb9174e.Aggretsuko.NFT%'
or event_data::string ilike '%A.321d8fcde05f6e8c.Seussibles.NFT%'
or event_data::string ilike '%A.4f7ff543c936072b.OneShots.NFT%'
or event_data::string ilike '%A.848d8db862439fc6.FraggleRock.NFT%'
or event_data::string ilike '%A.0a2fbb92a8ae5c6d.Sk8tibles.NFT%'
)
),
purchases AS (
SELECT
-- event_data:nftType:typeID as collection
event_data:nftID AS nft_id,
event_data:storefrontAddress AS user,
ROUND(event_data:salePrice, 2) AS price
FROM flow.core.fact_events
WHERE event_contract in ('A.3cdbb3d569211ff3.NFTStorefrontV2','A.4eb8a10cb9f87357.NFTStorefront','A.4eb8a10cb9f87357.NFTStorefrontV2') AND event_type='ListingCompleted'
and (
event_data::string ilike '%A.481914259cb9174e.Aggretsuko.NFT%'
or event_data::string ilike '%A.321d8fcde05f6e8c.Seussibles.NFT%'
or event_data::string ilike '%A.4f7ff543c936072b.OneShots.NFT%'
or event_data::string ilike '%A.848d8db862439fc6.FraggleRock.NFT%'
or event_data::string ilike '%A.0a2fbb92a8ae5c6d.Sk8tibles.NFT%'
)
),
current_listings AS (
SELECT
QueryRunArchived: QueryRun has been archived