puriftest
Updated 2024-10-07
9999
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 phase1 as (
select
value:ADDRESS as ADDRESS
, value:POINTS as POINTS
, value:HOLDINGS as HOLDINGS
, value:TOTAL_POINTS as TOTAL_POINTS
from (
select
live.udf_api('https://flipsidecrypto.xyz/api/v1/queries/1daacded-02d9-467f-a930-51604a2ee88d/data/latest') as resp
), lateral flatten (input => resp:data)
),
phase2 as (
select
value:ADDRESS as ADDRESS
, value:POINTS as POINTS
, value:HOLDINGS as HOLDINGS
, value:TOTAL_POINTS as TOTAL_POINTS
from (
select
live.udf_api('https://flipsidecrypto.xyz/api/v1/queries/d68509ca-8829-4da0-9d5d-a3605bcb4a6b/data/latest') as resp
), lateral flatten (input => resp:data)
),
galxe(address) as (
select address from (
VALUES
('0x00d47aaea542ddaa6948b7aa70deeefb2330268f'),
('0x0101eaee8d0013234c32936963ff504a9954220b'),
('0x015e17de5fc58dce5e5d1f45c9d50ec2b534417b'),
('0x01d2862da9d4fd9542d60bf9f769888435707176'),
('0x01d9799410061ccc2dab6b1ed11700c23ee17b3b'),
('0x01f93fd12c504f9388bad220a6486ec5b3bc1337'),
('0x021f0d85a407500a4a74709e1b9ee7b5f4afa176'),
('0x0288ef956ed186ab3dfa92b77714814e5a55bfa4'),
('0x029df4209e87663493725c70bdbd03e97d5b7c4b'),
('0x03001ce0b980054462645767250e6a025a5d164e'),
('0x0315e4330dad50358d3efe8d7e0401fb9bc5baf1'),
QueryRunArchived: QueryRun has been archived