count (distinct tx_Id) as "Transactions",

sum (fee/1e6) as "Paid Fees [$LAVA]",

count (distinct block_timestamp::date) as "Active Days"

from lava.core.fact_transactions

where block_timestamp >= '2024-07-30 11:00:00.000' -- Public Mainnet Launch

group by 1

order by 2 DESC

limit 100