SELECT a.*

-- RECEIVER_ID, min(a.BLOCK_TIMESTAMP) as created_date

from near.core.fact_actions_events a

-- join near.core.fact_receipts b on a.TX_HASH = b.TX_HASH

-- where ACTION_NAME= 'DeployContract'

-- where a.TX_HASH = 'ACihuboZyRWWakR8RRcoHn6w1RM7j9CQ74bkY27UxNtz' -- sample deploy

where a.TX_HASH = 'Dca8zfo5yfCVuqboK68MupAWRkkzBydsYy9LdpxbBxAZ' -- sample deploy

-- and RECEIVER_ID = 'nearmailbot.near'

-- GROUP by RECEIVER_ID

-- )

-- where created_date >= CURRENT_DATE - 30