mamad-5XN3k3Total
Updated 2023-12-18
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
⌄
with tokens as (
select *
/*block_timestamp,
PAYLOAD:"arguments"[1] as token,
tx_hash,
sender as user*/
from aptos.core.fact_transactions
where sender = lower('0xf39b6604cc1274bcc93e651f333c0bb0aadfdff7ae65d17deb155db2399c008b')
--payload_function = '0xc71d94c49826b7d81d740d5bfb80b001a356198ed7b8005ae24ccedff82b299c::bridge::APTS'
)
select
count(DISTINCT user) as users,
count(DISTINCT tx_hash) as mints,
count(DISTINCT token) as tokens
--mints/users as avg_per_user
from tokens
Run a query to Download Data