kaibladeTop 10 Oldest User Wallets
Updated 2023-03-15
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
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- forked from 40719078-2821-41fe-a8f8-6ba37653d0c5
with
social_inits as (
select * from near.core.fact_actions_events_addkey
where receiver_id = 'social.near'
),
add_signer as (
select
k.tx_hash,
k.block_id,
k.block_timestamp,
t.tx_signer,
k.allowance,
t.tx_signer = t.tx_receiver
from social_inits k
left join near.core.fact_transactions t using (tx_hash)
),
de_dupe_resigners as (
select
block_timestamp,
tx_signer
from add_signer
WHERE block_timestamp::date BETWEEN '{{Start_Date}}' AND '{{End_Date}}'
qualify ROW_NUMBER() over (
PARTITION BY tx_signer
ORDER BY
block_timestamp
) = 1
),
first_tx AS
(SELECT block_timestamp, tx_signer
FROM near.core.fact_transactions
WHERE tx_signer IN (SELECT DISTINCT(tx_signer) FROM de_dupe_resigners)
QUALIFY ROW_NUMBER() OVER (PARTITION BY tx_signer ORDER BY block_timestamp) = 1
Run a query to Download Data