abcfy2redbrick users hold ERC 5169
Updated 2024-07-04
999
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
›
⌄
-- ERC 5169 list:
-- mainnet:
-- - Devconnect 2022 Co-Work Ticket Stub V4: 0x7db4de78e6b9a98752b56959611e4cfda52269d2
-- - Devcon VI Suit Up Collection: 0x3c7e352481f4b2fdec1e642a3f0018661c77513d
-- - EDCON2023 Suit Up Collection: 0x186fb870f8f77a4390391614c6b61374ad69da77
-- polygon:
-- - Devcon VI Souvenir V3: 0x7db4de78e6b9a98752b56959611e4cfda52269d2
-- - Shanghai 2023 Collectible: 0x3c7e352481f4b2fdec1e642a3f0018661c77513d
-- - SmartCat Reward (SCR): 0xd5ca946ac1c1f24eb26dae9e1a53ba6a02bd97fe
-- - Perion (PRN): 0xae2fdaea5dd454fbe4ee331a4f74e61e4aeaf452
with raw_data1 as (
select
live.udf_api(
'GET',
'https://science.flipsidecrypto.xyz/googlesheets/readsheet',
{ 'Content-Type': 'application/json' },
{ 'sheets_id': '1FrZBSTHX9XSldDirhu07fBJU1WoQNItp3_E7kRSIXLs',
'tab_name': 'split1' }
) :data as result
),
raw_data2 as (
select
live.udf_api(
'GET',
'https://science.flipsidecrypto.xyz/googlesheets/readsheet',
{ 'Content-Type': 'application/json' },
{ 'sheets_id': '1FrZBSTHX9XSldDirhu07fBJU1WoQNItp3_E7kRSIXLs',
'tab_name': 'split2' }
) :data as result
),
redbrick_wallets as (
select
LOWER(p.value:wallet) wallet
from
raw_data1,
LATERAL FLATTEN(input => raw_data1.result) p
QueryRunArchived: QueryRun has been archived