AndyCoolburn
Updated 2022-05-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
WITH go_btc_burn AS
( SELECT sum(asset_amount)*10e-6 AS btc_burn, date_trunc('week', block_timestamp) AS TIME
FROM flipside_prod_db.algorand.asset_transfer_transaction
WHERE asset_id = '386192725'
AND block_timestamp >= '2022-01-01'
AND asset_receiver = 'ETGSQKACKC56JWGMDAEP5S2JVQWRKTQUVKCZTMPNUGZLDVCWPY63LSI3H4'
GROUP BY TIME
),
go_eth_burn AS
( SELECT sum(asset_amount)*10e-6 AS eth_burn, date_trunc('week', block_timestamp) AS TIME
FROM flipside_prod_db.algorand.asset_transfer_transaction
WHERE asset_id = '386195940'
AND block_timestamp >= '2022-01-01'
AND asset_receiver = 'ETGSQKACKC56JWGMDAEP5S2JVQWRKTQUVKCZTMPNUGZLDVCWPY63LSI3H4'
GROUP BY TIME
)
SELECT btc_burn, eth_burn, b.TIME
FROM go_btc_burn b
INNER JOIN go_eth_burn e ON b.TIME = e.TIME
GROUP BY b.TIME, btc_burn, eth_burn
Run a query to Download Data