FlippppppaTest2 copy
Updated 2023-07-14
99
1
2
3
4
5
6
7
8
9
10
›
⌄
-- 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