select

min(block_timestamp_discovered_at) as first_pool_discovered,

min(block_timestamp_last_updated) as first_pool_updated

from ton.defi.fact_dex_pools

where project = 'ston.fi'

),

first_trade as (

select

min(block_timestamp) as first_trade_timestamp,

min(event_time) as first_trade_unix

from ton.defi.fact_dex_trades

where project = 'ston.fi'

),

first_v2_trade as (

select

min(block_timestamp) as first_v2_trade_timestamp

from ton.defi.fact_dex_trades

where project = 'ston.fi'

and version = 2

select

fp.first_pool_discovered as "first pool discovery day",

fp.first_pool_updated as "first pool activity day",

ft.first_trade_timestamp as "first trade day",

fv2.first_v2_trade_timestamp as "first v2 trade day",