alitaslimiTransfers Transferring Users
Updated 2023-05-17
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
›
⌄
WITH
-------------------------------------------------- Algorand --------------------------------------------------
-- Algorand AS (
-- SELECT
-- block_timestamp,
-- tx_id AS tx,
-- tx_sender AS user,
-- address_name AS user_name,
-- label_type AS wallet_type,
-- amount,
-- CASE
-- WHEN amount < 1 THEN '<1'
-- WHEN amount >= 1 AND amount < 10 THEN '1-10'
-- WHEN amount >= 10 AND amount < 100 THEN '10-100'
-- WHEN amount >= 100 AND amount < 1000 THEN '100-1000'
-- WHEN amount >= 1000 AND amount < 10000 THEN '1000-10000'
-- WHEN amount >= 10000 AND amount < 100000 THEN '10000-100000'
-- ELSE '>100000'
-- END as bucket
-- FROM
-- algorand.core.ez_transfer transfers
-- LEFT JOIN
-- algorand.core.dim_label labels
-- ON
-- transfers.tx_sender = labels.address
-- WHERE
-- block_timestamp::date BETWEEN (CURRENT_DATE - 30) AND (CURRENT_DATE - 1)
-- AND asset_id = 31566704
-- AND amount > 0
-- ),
-------------------------------------------------- Arbitrum --------------------------------------------------
Arbitrum AS (
SELECT
block_timestamp,
tx_hash AS tx,
from_address AS user,
Run a query to Download Data