PapasotgoBTC,goETH wallets minting daily
    Updated 2023-01-03
    SELECT
    date_trunc('day',block_timestamp) as block_day,
    SUM(asset_amount)/100000000 as Minted_ETH_BTC,
    COUNT(DISTINCT(asset_receiver)) as Users,
    asset_id
    FROM
    algorand.asset_transfer_transaction
    WHERE
    (
    asset_id = '386192725' OR
    asset_id = '386195940'
    )
    AND
    sender = 'ETGSQKACKC56JWGMDAEP5S2JVQWRKTQUVKCZTMPNUGZLDVCWPY63LSI3H4'
    GROUP BY block_day,asset_id
    ORDER BY block_day
    Run a query to Download Data