iboo-jbj2MVStake Actions over Time
Updated 2022-03-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
SELECT
date_trunc('day',algorand.asset_transfer_transaction.block_timestamp) AS date,
SUM(asset_amount)/1e6 AS liquidity_amount_provide,
COUNT(DISTINCT algorand.asset_transfer_transaction.sender) AS liquidity_sender_provide,
COUNT(DISTINCT algorand.asset_transfer_transaction.tx_group_id) AS stake_actions
FROM algorand.application_call_transaction
JOIN algorand.asset_transfer_transaction
ON algorand.application_call_transaction.tx_group_id = algorand.asset_transfer_transaction.tx_group_id
WHERE
asset_receiver = 'DYLJJES76YQCOUK6D4RALIPJ76U5QT7L6A2KP6QTOH63OBLFKLTER2J6IA'
AND asset_transferred = 465865291
AND app_id = 482608867
AND try_base64_decode_string(algorand.application_call_transaction.tx_message:txn:note::string) = 'Market: mt'
GROUP BY date