alleriaFlipside Algorand Wallet Behavior 6
Updated 2022-04-07
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
›
⌄
WITH
wallets as (
SELECT
receiver,
COUNT(amount) as no_of_tx,
SUM(amount) as total_ALGO_received
FROM algorand.payment_transaction
WHERE sender = 'TLR47MQCEIC6HSSYLXEI7NJIINWJESIT3XROAYC2DUEFMSRQ6HBVJ3ZWLE'
AND amount < 10000
GROUP BY receiver
),
wallets_dates as (
SELECT
date(block_timestamp) as dates,
block_timestamp,
block_id,
address,
balance,
wallet_type,
no_of_tx,
total_ALGO_received
FROM algorand.account
INNER JOIN algorand.block ON (block_id = created_at)
INNER JOIN wallets ON (receiver = address)
WHERE address in (SELECT receiver FROM wallets)
)
SELECT
COUNT(DISTINCT sender) as unique_wallets
FROM algorand.application_call_transaction
WHERE sender in (SELECT receiver FROM wallets)
Run a query to Download Data