Moewallet paramethric
Updated 2024-07-27
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with wallets as (select
d.value:"USERS" as users
from (
select livequery.live.udf_api(
'https://flipsidecrypto.xyz/api/v1/queries/c8b851c1-902c-4e8f-b9f4-2216698d5723/data/latest'
):"data" as data
) responses join lateral flatten (input => responses.data) d
)
, age as (select
distinct FROM_ADDRESS as wallet ,
min(BLOCK_TIMESTAMP) as fst ,
datediff(day,fst,current_date) as age
from blast.core.fact_transactions where
FROM_ADDRESS in (select users from wallets)
group by 1
)
, txs as ( with wallets as (select
d.value:"USERS" as users
from (
select livequery.live.udf_api(
'https://flipsidecrypto.xyz/api/v1/queries/c8b851c1-902c-4e8f-b9f4-2216698d5723/data/latest'
):"data" as data
) responses join lateral flatten (input => responses.data) d
),
-- ----------------------------------------------------------------------------------------------------
send as (select
distinct FROM_ADDRESS,
TO_ADDRESS,
tx_hash,
'ETH' as token
from blast.core.ez_native_transfers
QueryRunArchived: QueryRun has been archived