Pine Analyticspointer 7-1
Updated 2024-07-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
WITH live_data AS (
SELECT livequery.live.udf_api( 'https://api.flipsidecrypto.com/api/v2/queries/51cb9885-dd83-4665-8fef-cb9b9a3cc146/data/latest'):"data" AS data
-- UNION
-- SELECT livequery.live.udf_api( 'https://api.flipsidecrypto.com/api/v2/queries/d91b1b01-717b-4b93-98a2-fd7e69a79f3c/data/latest'):"data" AS data
), all_data as (
SELECT
FLATTENED.VALUE:CREATOR AS CREATOR,
FLATTENED.VALUE:DEPOSIT_VOLUME AS DEPOSIT_VOLUME,
FLATTENED.VALUE:WALLETS AS WALLETS
FROM
live_data ,
LATERAL FLATTEN(INPUT => live_data.data) AS FLATTENED
)
SELECT *
FROM all_data
WHERE creator LIKE '{{ creator_pool }}'
Auto-refreshes every 6 hours
QueryRunArchived: QueryRun has been archived