jackguyMint/Renew Activity
Updated 2023-11-07
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 dom base 2 copy @ https://flipsidecrypto.xyz/edit/queries/2985f8b0-a61f-4049-8ee9-13305ef11aaf
-- forked from dom base 2 @ https://flipsidecrypto.xyz/edit/queries/55a55e05-cbb6-4e43-b775-5d3e0cbd25fd
WITH live_data AS (
SELECT livequery.live.udf_api( 'https://api.flipsidecrypto.com/api/v2/queries/e2141b89-7a59-4fdf-9ed9-4f2fd90992c4/data/latest'):"data" AS data
UNION
SELECT livequery.live.udf_api( 'https://api.flipsidecrypto.com/api/v2/queries/08295c10-75fd-4bcc-a215-554937bb4afa/data/latest'):"data" AS data
UNION
SELECT livequery.live.udf_api( 'https://api.flipsidecrypto.com/api/v2/queries/3d8c5156-398b-4667-9386-df1fb2674e7b/data/latest'):"data" AS data
UNION
SELECT livequery.live.udf_api( 'https://api.flipsidecrypto.com/api/v2/queries/712ef342-8fe1-45d0-9b8b-1b249bdb54c8/data/latest'):"data" AS data
UNION
SELECT livequery.live.udf_api( 'https://api.flipsidecrypto.com/api/v2/queries/fb419e2b-8028-43ce-9bed-fb45b6be4f2b/data/latest'):"data" AS data
UNION
SELECT livequery.live.udf_api( 'https://api.flipsidecrypto.com/api/v2/queries/32434e06-6f92-4d49-a23f-2ff7b0857033/data/latest'):"data" AS data
UNION
SELECT livequery.live.udf_api( 'https://api.flipsidecrypto.com/api/v2/queries/d24db630-b063-412b-9142-2a3be59f3869/data/latest'):"data" AS data
)
SELECT
FLATTENED.VALUE:BLOCK_TIMESTAMP::TIMESTAMP AS block_timestamp,
FLATTENED.VALUE:DOMAIN::STRING AS domain,
FLATTENED.VALUE:TX_ID::STRING AS tx_id,
Run a query to Download Data