kaibladeEthereum 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
34
›
⌄
WITH eth_usdc_data AS
(SELECT *, from_address AS sender
FROM ethereum.core.ez_token_transfers
WHERE contract_address = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'
AND block_timestamp::date >= CURRENT_DATE() - INTERVAL '2 months'
),
senders_data AS
(SELECT sender,
COUNT(tx_hash) AS transfer_volume
FROM eth_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
-- flow_daily_price AS
-- (SELECT DATE_TRUNC ('days', block_timestamp) AS "Days",
-- SUM(amount) AS "Price Volume in USD"
-- FROM flow_usdc_data
-- GROUP BY "Days")
-- SELECT transfer.*, price."Price Volume in USD"
-- FROM flow_daily_transfer transfer
-- FULL JOIN flow_daily_price price
-- ON transfer."Days" = price."Days"
Run a query to Download Data