No Data to Display
h4wkholders
Updated 2025-02-25
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
›
⌄
with base_api as (
select
d.value:"DATE"::text as date,
'BONK' as type,
d.value:"HOLDERS"::text as holders
from (
select livequery.live.udf_api(
'https://flipsidecrypto.xyz/api/v1/queries/6cef4a77-25f3-448a-a8b7-1ab2b626f30b/data/latest'
):"data" as data
) responses join lateral flatten (input => responses.data) d
where date >= '2024-02-09' and date < CURRENT_DATE
UNION
select
d.value:"DATE"::text as date,
'BonkSOL' as type,
d.value:"HOLDERS"::text as holders
from (
select livequery.live.udf_api(
'https://flipsidecrypto.xyz/api/v1/queries/178249ec-529a-4687-b273-dc7f0d3616d1/data/latest'
):"data" as data
) responses join lateral flatten (input => responses.data) d
where date >= '2024-02-09' and date < CURRENT_DATE
)
select date,
"'BONK'" as "BONK",
"'BonkSOL'" as "BonkSOL"
from base_api
PIVOT(sum(holders) FOR type IN (
'BONK',
'BonkSOL')
)
Last run: about 2 months ago
0
2B
2s