flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
Untitled Query
mamad-5XN3k3
Untitled Query
Updated 2022-07-03
Copy Reference
Fork
9
1
2
3
4
5
›
⌄
select
TX_ID
,
BLOCK_TIMESTAMP
,
MARKETPLACE
,
NFT_COLLECTION
,
NFT_ID
,
BUYER
,
SELLER
,
PRICE
,
CURRENCY
from
flow
.
core
.
fact_nft_sales
where
SPLIT_PART
(
NFT_COLLECTION
,
'.'
,
3
)
ilike
'%allday%'
and
TX_SUCCEEDED
=
'TRUE'
Results
Run a query to Download Data