tx_id,

block_timestamp,

tx_from as user,

(fee/1e6) as tx_fee

from lava.core.fact_transactions

where tx_succeeded = 1

and block_timestamp::date >= '2024-07-30'

case

when tx_fee <= 0.001 then '0.001 <= $LAVA'

when tx_fee <= 0.003 then '0.001- 0.003 $LAVA'

when tx_fee <= 0.005 then '0.003 - 0.005 $LAVA'

when tx_fee <= 0.1 then '0.005 - 0.1 $LAVA'

when tx_fee <= 0.5 then '0.1 - 0.5 $LAVA'

when tx_fee <= 1 then '0.5 - 1 $LAVA'

when tx_fee <= 5 then '1 - 5 $LAVA'

when tx_fee <= 10 then '5 - 10 $LAVA'

else 'More than 10 $LAVA'

end as type,

count(distinct tx_id) as transactions,

count(distinct user) as users

from t

group by 1

order by 1