near meteor moon - created wallets

MoDeFinear meteor moon - created wallets

Updated 2025-03-18

with meteor_new_wallets as (

select BLOCK_TIMESTAMP, user, tx_hash

from

(select BLOCK_TIMESTAMP, args:new_account_id as user, tx_hash,

rank() over (partition by user order by BLOCK_TIMESTAMP asc) as rank

from near.core.fact_actions_events_function_call

where SIGNER_ID in ('aa-meteor-relayer-2.near','meteor-relayer.near')

and METHOD_NAME='create_account'

and RECEIPT_SUCCEEDED=TRUE)

where rank=1)

select date_trunc(day, BLOCK_TIMESTAMP) as "Date", count(*) as "Wallets",

sum("Wallets") over (order by "Date") as "Total Wallets"

from meteor_new_wallets

group by 1

order by 1 desc

-- select TX_SIGNER,

-- count(*) as "TXs",

-- sum(TRANSACTION_FEE/1e24) as "Fees",

-- sum(TRANSACTION_FEE/1e24*price) as "Fees $USD",

-- avg(TRANSACTION_FEE/1e24*price) as "AVG Fees $USD"

-- from near.core.fact_transactions

-- left join near.price.ez_prices_hourly

-- on TOKEN_ADDRESS='wrap.near' and date_trunc(hour, BLOCK_TIMESTAMP)=hour

-- where tx_succeeded=true

-- and tx:actions[0]:Delegate:delegate_action is not null

-- and BLOCK_TIMESTAMP::date>'2024-01-30'

-- and TX_SIGNER not in ('meteor-relayer.near','aa-meteor-relayer-2.near')

-- group by 1

-- order by 2 desc

-- limit 1000

Last run: 3 months ago

...

353

14KB

237s

flipside