SELECT

block_timestamp as time,

ARRAY_TO_STRING(TO_ARRAY(event_attributes),',') as string

FROM terra.msg_events

WHERE (

DAY(block_timestamp) = 30 AND YEAR(block_timestamp) = 2021 AND MONTH(block_timestamp)=6 AND

ARRAY_TO_STRING(TO_ARRAY(event_attributes),',') LIKE '%terra%'

)

ORDER BY block_timestamp DESC

), --Jul30 events in string format

Jul30_Address as (

SELECT DISTINCT value as address

FROM Jul30_msg_events, lateral split_to_table(Jul30_msg_events.string, '"')

WHERE value LIKE '%terra%'

), --Addresses that had some kind of activity on Jul30

Q1_stakers as (

SELECT DISTINCT delegator_address

FROM terra.staking

WHERE action='delegate' and YEAR(block_timestamp) = 2021 and MONTH(block_timestamp)<4

) --Addresses that staked during Q1 2021

SELECT COUNT(Jul30_Address.address) as no_of_Q1_2021_stakers_active_on_Jul30

FROM Q1_stakers

INNER JOIN Jul30_Address on Jul30_Address.address=Q1_stakers.delegator_address