CryptoLionUntitled Query
Updated 2021-11-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
-- SELECT
-- date_trunc('day',terra.transactions.block_timestamp) as day,
-- sum(fee[0]:amount::float/POW(10,6)) as fee_no_curr,
-- sum(fee[0]:amount::float/POW(10,6))*avg(price_usd) as fee,
-- fee[0]:denom::string as currency,
-- count(tx_id)
-- FROM terra.transactions
-- INNER JOIN terra.oracle_prices on terra.transactions.fee[0]:denom::string = terra.oracle_prices.currency
-- AND date_trunc('day',terra.transactions.block_timestamp) = date_trunc('day',terra.oracle_prices.block_timestamp)
-- WHERE terra.transactions.block_timestamp >= getdate() - interval '10 days'
-- GROUP BY 1,4
-- ORDER BY 1 DESC
SELECT DISTINCT
ACTION
FROM terra.staking
LIMIT 5
Run a query to Download Data