ErsvanDetails transactions stablecoins
    Updated 2022-06-03
    WITH w_transactions (BLOCK_TIMESTAMP, ASSET_NAME, AMOUNT, TX_MESSAGE, TX_ID, ASSET_ID) AS
    (
    SELECT
    BLOCK_TIMESTAMP,
    asset_name,
    TX_MESSAGE:txn:aamt AS AMOUNT,
    TX_MESSAGE,
    TX_ID,
    asset.ASSET_ID AS ASSET_ID
    FROM
    algorand.transactions
    JOIN algorand.asset ON algorand.transactions.asset_id = algorand.asset.asset_id
    WHERE
    asset.ASSET_ID IN (31566704, 312769, 2757561, 465865291, 684649988, 506189856)
    AND TX_TYPE_NAME = 'asset transfer'
    AND TX_MESSAGE:txn:aamt IS NOT NULL
    )

    SELECT * FROM flipside_prod_db.algorand.asset_transfer_transaction WHERE ASSET_ID = '31566704' ORDER BY BLOCK_TIMESTAMP DESC LIMIT 1

    --0.136582
    --SELECT * FROM w_transactions
    --SELECT TX_MESSAGE:txn:aamt/1e6 FROM w_transactions WHERE TX_ID = 'XPQRE3EBDYPLFDHUFDSJ3RTOH633AV34UVCXFAOWLCW2RS3DH72Q'

    --XPQRE3EBDYPLFDHUFDSJ3RTOH633AV34UVCXFAOWLCW2RS3DH72Q NO APLICA
    --5CWEBKY256FMF2U5GS2AQKXFUDD634AYNSG3HYCVCHSD4FUXS3CA APLICA
    --BLOCK_TIMESTAMP, TX_MESSAGE, FEE, SENDER, TX_ID
    --DATE_TRUNC('month', block_timestamp) AS MONTH_DATE
    --TX_MESSAGE:txn:aamt/1e6 AS amount
    --
    Run a query to Download Data