-- providing action over time
select date_trunc('day',block_timestamp) "Date", count(*) "No. of Providng Action"
from flipside_prod_db.ethereum_core.fact_event_logs
where contract_name = 'NFTXStakingZap' and event_name = 'UserStaked'
group BY "Date"
order by "Date"