Afonso_Diazby marketplace
Updated 2024-09-06
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
pricet as (
select
hour::date as date,
avg(price) as price_usd
from
flow.price.ez_prices_hourly
where symbol = 'FLOW'
group by 1
),
sales as (
select
tx_id,
seller,
buyer,
price,
block_timestamp,
nft_collection,
case currency
when 'A.ead892083b3e2c6c.DapperUtilityCoin' then 'USDC'
when 'A.1654653399040a61.FlowToken' then 'FLOW'
when 'A.3c5959b568896393.FUSD' then 'FUSD'
when 'A.ead892083b3e2c6c.FlowUtilityToken' then 'FLOW'
end as symbol,
case marketplace
when 'A.c1e4f4f4c4257510.Market' then 'TopShot'
when 'Gigantik Primary Market' then 'Gigantik'
when 'A.921ea449dffec68a.FlovatarMarketplace' then 'Flovatar'
when 'A.a49cc0ee46c54bfb.MotoGPNFTStorefront' then 'MotoGP'
when 'A.097bafa4e0b48eef.FindMarketSale' then 'Find Market'
when 'A.62b3063fbe672fc8.ZeedzMarketplace' then 'Zeedz'
when 'A.09e03b1f871b3513.TheFabricantMarketplace' then 'Fabricant'
when 'A.85b075e08d13f697.OlympicPinMarket' then 'Olympic Pin Market'
QueryRunArchived: QueryRun has been archived