contract as (

select

date(block_timestamp) as date,

tx_id,

TX_SUCCEEDED,

ATTRIBUTE_VALUE as contract_address

from

sei.core.fact_msg_attributes

where

msg_type = 'instantiate'

and ATTRIBUTE_KEY = '_contract_address'

and TX_SUCCEEDED = 'True'

and block_timestamp::date >= '2023-08-15'

),

max_date as (

select

max(block_timestamp::date) as max_date

from

sei.core.fact_msg_attributes

),

creator as (

select

date,

a.tx_id,

a.TX_SUCCEEDED as status,

contract_address,

tx_from as creator,

(trim(fee, 'usei') / pow(10, 6)) as fee

from

contract a

join sei.core.fact_transactions b on a.tx_id = b.tx_id

),

fnl as (select

trunc(date,'month') as monthly,