suchanadGetting Started copy
    -- forked from Getting Started @ https://flipsidecrypto.xyz/edit/queries/a81d1e10-23d0-4433-984f-3f86f22de884

    -- Query: https://flipsidecrypto.xyz/edit/queries/a0762596-67b8-4d83-871a-96e7a7de25a5
    -- Analyst: @alitaslimi

    with
    -------------------- BTC Price --------------------
    prices as (
    select
    price
    from
    bitcoin.price.ez_hourly_token_prices
    qualify
    hour = last_value(hour) over (order by hour)
    ),
    -------------------- Issuers --------------------
    issuers as (
    select
    ft.value:TICKER as ticker,
    ft.value:TYPE as type,
    ft.value:ISSUER as issuer,
    ft.value:CUSTODIAN as custodian,
    ft.value:FEE as fee
    from (
    select
    livequery.live.udf_api (
    'https://flipsidecrypto.xyz/api/v1/queries/bc8abcd7-aa55-4ef9-83c1-1b7bf81313e0/data/latest'
    ):data as data
    ) lq,
    table(flatten(input => lq.data)) ft
    ),
    -------------------- Addresses --------------------
    addresses as (
    select
    ft.value:TICKER as ticker,
    ft.value:ADDRESS as address
    Run a query to Download Data