from aptos.core.fact_events

where

BLOCK_TIMESTAMP::date >= '{{Starting_date}}'

and EVENT_RESOURCE = 'PriceFeedUpdate')

SELECT BLOCK_TIMESTAMP::date as date,

count(DISTINCT SENDER) as senders, count(DISTINCT tx_hash) as "Pyth-related txs", sum("Pyth-related txs") over (order by date) as "Cumulative txs"

from aptos.core.fact_transactions join pyth on tx_hash = tx

where

BLOCK_TIMESTAMP::date >= '{{Starting_date}}'

GROUP by all