kaibladeAlgorand USDC Users Stats
Updated 2022-11-22
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
›
⌄
WITH algo_usdc_data AS
(SELECT *
FROM algorand.core.ez_transfer
WHERE asset_name = 'USDC'
AND block_timestamp::date >= CURRENT_DATE() - INTERVAL '2 months'),
senders_data AS
(SELECT tx_sender AS sender,
COUNT(tx_id) AS transfer_volume
FROM algo_usdc_data
GROUP BY sender)
-- repeat_senders AS
-- (SELECT )
SELECT (SELECT COUNT(sender)
FROM senders_data WHERE transfer_volume > 1) AS total_repeat_users,
(SELECT COUNT(sender) FROM senders_data) AS total_senders,
total_repeat_users*100/total_senders AS percent_repeat_users
-- algo_daily_price AS
-- (SELECT DATE_TRUNC ('days', block_timestamp) AS "Days",
-- SUM(amount) AS "Price Volume in USD"
-- FROM algo_usdc_data
-- GROUP BY "Days")
-- SELECT transfer.*, price."Price Volume in USD"
-- FROM algo_daily_transfer transfer
-- FULL JOIN algo_daily_price price
-- ON transfer."Days" = price."Days"
Run a query to Download Data