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_DATE

AND block_timestamp >= '2021-11-27' --oracle price first date

GROUP BY 1,2,3,5