SELECT block_timestamp,

SUBSTR(fee, LENGTH(REGEXP_SUBSTR(fee, '\\d+')) + 1) AS fee_currency,

REGEXP_SUBSTR(fee, '\\d+')::numeric AS fee_amount

FROM osmosis.core.fact_transactions

WHERE tx_succeeded

AND block_timestamp >= CURRENT_DATE - 365

AND fee_amount > 0

SELECT block_timestamp::DATE AS date, fee_currency, project_name,

count(*), sum(fee_amount)

FROM tx

LEFT JOIN osmosis.core.dim_tokens ON address = fee_currency

WHERE project_name != 'OSMO'

GROUP BY date, fee_currency, project_name