select

t.block_timestamp,

t.tx_id,

w.value as wallet

from

terra.transactions t,

lateral flatten(input => t.tx_from) w

where

tx_status = 'SUCCEEDED'

),

new_wallets as (

select

wallet,

min(block_timestamp) :: date as join_date

from

flattened_transactions

group by

wallet

having

join_date >= current_date - 90

),

transactions as (

select

ft.block_timestamp,

ft.tx_id,

ft.wallet,

nw.join_date

from

new_wallets nw

inner join flattened_transactions ft on nw.wallet = ft.wallet

transaction_types as (

select

t.wallet,

e.event_type,