FlippppppaTest2 copy
    Updated 2023-07-14
    -- forked from jp12 / Test2 @ https://flipsidecrypto.xyz/jp12/q/NfgFuSK1U7WI/test2

    -- SELECT DISTINCT ORIGIN_FUNCTION_SIGNATURE, FIRST_VALUE(tx_hash) OVER(PARTITION BY ORIGIN_FUNCTION_SIGNATURE ORDER BY block_timestamp DESC) AS tx
    -- SELECT to_char(date_trunc('day', block_timestamp), 'yyyy-mm-dd') as date, avg(rune_usd) as avg_rune_price

    SELECT *
    FROM osmosis.core.dim_labels
    LIMIT 500


    Run a query to Download Data