block_timestamp,

block_id,

tx_id,

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

F.Value:denom::string as denom

FROM terra.transactions,

Table(Flatten(input => fee)) F

WHERE

block_timestamp >= current

GROUP BY 1,2,3,5