feyikemi2024-07-22 09:05 PM
Updated 2024-07-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
-- SELECT
-- SUM(TRANSACTION_FEE / POW(10, 24)) AS tx_fee,
-- DATE_TRUNC('day', block_timestamp) AS date
-- FROM near.core.fact_transactions
-- WHERE block_timestamp::date > CURRENT_DATE - INTERVAL '30 DAY'
-- GROUP BY 2
-- ORDER BY 2 DESC
SELECT
DISTINCT SYMBOL,
NAME
FROM near.price.ez_prices_hourly
WHERE Symbol ilike '%NEAR%'
QueryRunArchived: QueryRun has been archived