SELECT COUNT(*) AS transactions

FROM AXELAR.defi.ez_bridge_squid

WHERE block_timestamp >= CURRENT_DATE - INTERVAL '1 DAY' AND block_timestamp < CURRENT_DATE

),

previous_day AS (

SELECT COUNT(*) AS transactions

FROM AXELAR.defi.ez_bridge_squid

WHERE block_timestamp >= CURRENT_DATE - INTERVAL '2 DAY' AND block_timestamp < CURRENT_DATE - INTERVAL '1 DAY'

SELECT

current_day.transactions AS current_day_transactions,

previous_day.transactions AS previous_day_transactions,

((current_day.transactions - previous_day.transactions) / previous_day.transactions) * 100 AS daily_growth_rate

FROM current_day, previous_day;

SELECT count(*)

FROM AXELAR.defi.ez_bridge_squid

WHERE block_timestamp >= '2024-06-03 00:00:00' AND block_timestamp < '2024-06-04 00:00:00';