winnie-fsThe Heist JSON
Updated 2023-11-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 helius_call as (
select
1 as page_start,
helius_das.get_assets_by_group(
'mainnet',
-- the network, 'mainnet' or 'devnet'
{ 'groupKey': 'collection',
'groupValue': '6d9pvGuM6iG9GVuxRzSVHEQCdy44arm6oyqu6aUzrzLo',
'page': page_start,
-- Starts at 1
'limit': 1000,
'sortBy': { 'sortBy': 'created',
'sortDirection': 'asc' } }
) as response
union
all
select
page_start + 1 as page_end,
helius_das.get_assets_by_group(
'mainnet',
-- the network, 'mainnet' or 'devnet'
{ 'groupKey': 'collection',
'groupValue': '6d9pvGuM6iG9GVuxRzSVHEQCdy44arm6oyqu6aUzrzLo',
'page': page_end,
-- Starts at 1
'limit': 1000,
'sortBy': { 'sortBy': 'created',
'sortDirection': 'asc' } }
) as response
from
helius_call
where
page_end <= 33
),
heist_mints as (
select
Run a query to Download Data