mlhUntitled Query
    Updated 2022-10-07
    SELECT count(DISTINCT tx_id) AS trxs,
    count(DISTINCT TX:body:messages[0]:from_address) AS users,
    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-01'
    and tx_succeeded ilike 'true'
    Run a query to Download Data