crypto_edgarLand Pull 6
Updated 2024-02-23
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
11 as page_start,
helius_das.get_assets_by_group(
'mainnet',
-- the network, 'mainnet' or 'devnet'
{ 'groupKey': 'collection',
'groupValue': 'FiYyx2DXEsQtK6iVzQyFzJSistUa56xnKFagotrd2Mzf',
'page': page_start,
-- Starts at 1
'limit': 1000,
'sortBy': { 'sortBy': 'created',
'sortDirection': 'asc' } }
) as response
union
all
select
12 as page_start,
helius_das.get_assets_by_group(
'mainnet',
-- the network, 'mainnet' or 'devnet'
{ 'groupKey': 'collection',
'groupValue': 'FiYyx2DXEsQtK6iVzQyFzJSistUa56xnKFagotrd2Mzf',
'page': page_start,
-- Starts at 1
'limit': 1000,
'sortBy': { 'sortBy': 'created',
'sortDirection': 'asc' } }
) as response
),
heist_land_mints as (
select
CURRENT_TIMESTAMP() AS BLOCK_TIMESTAMP,
f.value :id as MINT,
f.value :ownership:owner as TX_TO,
f.value :content:metadata:attributes as metadata