block_timestamp,

block_id,

tx_id,

SUM(F.Value:amount / POW(10,6)) as fee,

F.Value:denom::string as denom,

gas_used,

gas_wanted as gas_limit

FROM terra.transactions,

Table(Flatten(input => fee)) F

WHERE

block_timestamp >= CURRENT_DATE - 30 and denom in ('uluna') and tx_status = 'SUCCEEDED'

GROUP BY 1,2,3,5,6,7

order by fee desc

limit 20