kaibladeMost Bought Tokens
Updated 2023-03-15
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
›
⌄
-- forked from 14addafc-38d7-4cb9-aef0-8948d553bb55
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
),
swap_tx AS
(SELECT tx_hash, block_timestamp,
trader, platform,
(CASE
WHEN token_in = 'USDC.e' THEN 'USDC'
Run a query to Download Data