barbodDaily number of gALGO3 receiver in mentioned period
Updated 2022-04-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
WITH application_call AS(
SELECT T1.*,
TRY_BASE64_DECODE_STRING(tx_message:txn:apaa[0]::STRING) AS appa
FROM algorand.application_call_transaction T1
WHERE TRY_BASE64_DECODE_STRING(tx_message:txn:apaa[0]::STRING) ='m'
),
asset_transfer AS(
SELECT T1.*, (asset_amount / pow(10,6)) AS p_asset_amount
FROM algorand.asset_transfer_transaction T1
WHERE INNER_TX = 'true'
),
governance_opportunity AS (
SELECT t1.*, T2.SENDER as transfer_sender, T2.BLOCK_TIMESTAMP as transfer_date, T2.p_asset_amount
FROM application_call T1
JOIN asset_transfer T2 on T2.tx_id = T1.tx_id
WHERE T1.BLOCK_TIMESTAMP >= '2022-03-30 12:00:00.000'
AND T1.BLOCK_TIMESTAMP <= '2022-04-14 06:00:00.000'
)
SELECT date(transfer_date) as date, sum(p_asset_amount) as total_amount
FROM governance_opportunity
GROUP BY transfer_date
Run a query to Download Data