Flocnew keyless wallets daily copy
Updated 2024-09-04
99
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
›
⌄
-- forked from 0xtanmay / new keyless wallets daily @ https://flipsidecrypto.xyz/0xtanmay/q/Ab4jwNQqmqxI/new-keyless-wallets-daily
SELECT
DATE(block_timestamp) AS day,
COUNT(json_extract_path_text(payload, 'arguments[0]')) AS new_wallets
FROM
aptos.core.fact_transactions
WHERE
sender IN (
'0x59e802ff9d63b377998e1959cc297798a4d2de0cdf17b3194b2dcff4af4f9441',
'0x77fd4b106c60d492617014e08505ef3be53085880ac63d6d43bcd82cd1091f9f',
'0x6bc67c84a4a7e5a7c8ca7b947928c3da34223f6bf7218ea61f94b213cad095fe',
'0xfc740dddfe4a2cacddcd90fd55c1d6bedcdd5c244d8b4835e177ead1089b13f4',
'0x1f0c89f506492acf6060f83e305c168fb564fee3d1598471fad2aa4810bb0c50',
'0x97ac71b84fe0dd39c9d85f7894cdfbeb5fe994a2d78fae9165ae135955d7f1e7',
'0x7dcd43b6ba5d6e303defef99e4c9c9e2c6bf1f551f33cf5b201303b0e735410d'
)
AND json_extract_path_text(payload, 'function') = '0x1::aptos_account::create_account'
AND success = 'true'
GROUP BY
day
ORDER BY
day;
QueryRunArchived: QueryRun has been archived