Art Blocks query

Nige7777Art Blocks query

Updated 2021-09-09

select distinct

token_metadata:artist::string,

--token_metadata:description::string,

token_metadata:collection_name::string,

token_metadata:curation_status::string,

token_metadata:"script type"::string,

max(token_metadata:website::string) OVER (partition by token_metadata:collection_name::string order by len(token_metadata:collection_name) desc) as website,--,token_metadata:website::string)) as website,

min(token_id) OVER (partition by token_metadata:collection_name::string order by null) as StartID,

max(token_id) OVER (partition by token_metadata:collection_name::string order by null) as EndID--,

-- token_metadata:royaltyInfo::string--,

-- count(DISTINCT token_id) count_ids,

-- count(*) as all_rows

-- *

from

ethereum.nft_metadata

where 1=1

-- and token_metadata:collection_name::string = 'Abstraction by Hevey'

-- and token_metadata:artist::string = 'Daniel Catt'

-- and token_id = '69000214'

and project_name = 'art_blocks'

order by 6

-- select count(*),

-- left(token_name,charindex('#',token_name)-2) as Project

-- from

-- ethereum.nft_metadata

-- where project_name = 'art_blocks'

-- group by 2

-- limit 5000

Run a query to Download Data

flipside

flipside