iboo-jbj2MVStake Actions over Time
    Updated 2022-03-16
    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