ErsvanDetails transactions stablecoins
Updated 2022-06-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
›
⌄
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