winnie-fscontracts_created_daily_through_yesterday copy
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
›
⌄
-- forked from charliemarketplace / contracts_created_daily_through_yesterday @ https://flipsidecrypto.xyz/charliemarketplace/q/xYmfghKyBrT-/contracts_created_daily_through_yesterday
/* Contracts Part 1 */
-- 2010 to 2020-11-30
with historic1 AS (
select
livequery.live.udf_api (
'https://flipsidecrypto.xyz/api/v1/queries/eb5d093b-58d2-46d3-b036-6f96a3a6db5f/data/latest'
):data as json_data
),
contracts1 AS (
SELECT
d.value:"CHAIN"::VARCHAR AS chain,
d.value:"DAY_"::date AS day_,
TO_NUMBER(d.value:"N_CONTRACTS") AS N_CONTRACTS
FROM
historic1,
LATERAL FLATTEN(input => historic1.json_data::VARIANT) d
),
/* Contracts Part 2 */
-- 2020-12-01 to 2021-05-30
historic2 AS (
select
livequery.live.udf_api (
'https://flipsidecrypto.xyz/api/v1/queries/461bd76b-7f89-408e-919f-c86e7ee3c98b/data/latest'
):data as json_data
),
contracts2 AS (
SELECT
d.value:"CHAIN"::VARCHAR AS chain,
d.value:"DAY_"::date AS day_,
TO_NUMBER(d.value:"N_CONTRACTS") AS N_CONTRACTS
Run a query to Download Data