flipside

    cbBTC 2
    Pine AnalyticscbBTC 2
    Updated 2024-11-07
    -- forked from cbBTC 1 @ https://flipsidecrypto.xyz/studio/queries/8b36abcd-53e4-4c18-ac69-e0c5e6c624ea

    with tab1 as (
    SELECT
    date(block_timestamp) as date,
    sum(
    CASE when from_address like '0x0000000000000000000000000000000000000000' then amount
    when to_address like '0x0000000000000000000000000000000000000000' then -amount
    else 0 end
    ) as net_mint,
    sum(net_mint) over (order by date) as supply


    from base.core.ez_token_transfers
    WHERE CONTRACT_ADDRESS LIKE lower('0xcbB7C0000aB88B473b1f5aFd9ef808440eed33Bf')
    --LIMIT 100
    GROUP BY 1
    ), tab2 as (
    SELECT
    date(hour) as day,
    median(price) as price

    from ethereum.price.ez_prices_hourly
    where token_address like lower('0x2260FAC5E5542a773Aa44fBCfeDf7C193bc2C599')
    GROUP by 1
    )

    SELECT
    *,
    supply * price as marketcap

    from tab1
    left outer join tab2
    on day = date
    ORDER by 1 DESC

    QueryRunArchived: QueryRun has been archived