Updated 2022-10-09Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
SELECT
date_trunc('day', block_timestamp) AS date,
count(DISTINCT tx_id)AS transactions,
count(DISTINCT TX:body:messages[0]:from_address) AS senders,
count(DISTINCT TX:body:messages[0]:to_address) AS receivers,
sum(TX:body:messages[0]:amount[0]:amount)/pow(10,6) AS LUNA_volume,
sum(fee) AS fees
from terra.core.fact_transactions
where tx:body:messages[0]:amount[0]:denom = 'uluna'
and block_timestamp > '2022-05-15'
and tx_succeeded ilike 'true'
group by 1
order by 1 asc
Run a query to Download Data