jackguyMint/Renew Activity
    Updated 2023-11-07
    -- 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