[Earlyfans] -Total since the snapshot of friday 10th to sunday 19th

saeedmzn[Earlyfans] -Total since the snapshot of friday 10th to sunday 19th

Updated 2024-08-26

-- forked from [Earlyfans] -Total @ https://flipsidecrypto.xyz/edit/queries/6db2d95a-8de9-46c2-8c6a-6435880ccf84

-- forked from [Earlyfans] - posts listed on earlyfans over time @ https://flipsidecrypto.xyz/edit/queries/a0c6dc7c-7be6-4c99-a168-6b5d99ea1cf9

-- 0x4b17a9318238403ddac8e3a790c3b06d18132bf4 --EARLYFANS contract

---0x7135b32e9903bdb4e19a8b1d22fc2038964b8451 --Thruster_LP

-- 0x7135b32e9903bdb4e19a8b1d22fc2038964b8451 --Early token

with new_users as (

select

ORIGIN_FROM_ADDRESS user ,

min (BLOCK_TIMESTAMP) min_date

from blast.core.ez_decoded_event_logs

where CONTRACT_ADDRESS ='0x4b17a9318238403ddac8e3a790c3b06d18132bf4'

and BLOCK_TIMESTAMP::date <= '2024-05-19'

-- and EVENT_NAME ='PostListed'

group by 1 having min_date::date >= '2024-05-10'

)

select date_trunc(hour,min_date) date ,

count (user) num_new_users ,

sum (num_new_users) over (order by date) cum_new_users

from new_users

group by 1

-- with txns as (

-- select BLOCK_TIMESTAMP::date date ,

-- ORIGIN_FROM_ADDRESS user ,

-- EVENT_NAME ,

-- tx_hash ,

-- decoded_log:postID postID

-- from blast.core.ez_decoded_event_logs

-- where CONTRACT_ADDRESS ='0x4b17a9318238403ddac8e3a790c3b06d18132bf4'

-- and EVENT_NAME ='PostListed'

-- ),

-- transfers as (

-- select tx_hash ,

-- symbol ,

-- amount ,

QueryRunArchived: QueryRun has been archived