Switchboardlivequery_agg_init_per_authority
Updated 2024-08-13
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
›
⌄
-- forked from livequery_total_agg_init @ https://flipsidecrypto.xyz/edit/queries/6b9a6694-05b1-4c09-b68b-c9453c4353ba
WITH t0 AS (
-- 2022 Q1
SELECT livequery.live.udf_api (
'https://flipsidecrypto.xyz/api/queries/ad801ab3-d543-42eb-99a6-2f5361cd5bd1/latest-run'
):data:jsonData AS data
-- 2022 Q2
UNION SELECT livequery.live.udf_api (
'https://flipsidecrypto.xyz/api/queries/7a0091b7-e2ab-4abd-add2-4e7d5f4de5c9/latest-run'
):data:jsonData AS data
-- 2022 Q3
UNION SELECT livequery.live.udf_api (
'https://flipsidecrypto.xyz/api/queries/37d0d21e-3acd-4ff3-ac6e-4dfab74ad814/latest-run'
):data:jsonData AS data
-- 2022 Q4
UNION SELECT livequery.live.udf_api (
'https://flipsidecrypto.xyz/api/queries/6ca4f829-4d5c-4bb3-b936-31030298ec48/latest-run'
):data:jsonData AS data
-- 2023 Q1
UNION SELECT livequery.live.udf_api (
'https://flipsidecrypto.xyz/api/queries/0d0dde6a-3621-435a-8bcc-013811d8fc3d/latest-run'
):data:jsonData AS data
-- 2023 Q2
UNION SELECT livequery.live.udf_api (
'https://flipsidecrypto.xyz/api/queries/871fd8a8-aa68-49ad-83d0-4aa8cfaa8908/latest-run'
):data:jsonData AS data
-- 2023 Q3
UNION SELECT livequery.live.udf_api (
'https://flipsidecrypto.xyz/api/queries/89d9a934-1e55-460b-ad86-72f26c0333eb/latest-run'
QueryRunArchived: QueryRun has been archived