Crazy_KidSynth Mints + Burns
Updated 2022-04-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
WITH mint AS (SELECT date(block_timestamp) as date, to_asset as asset_minted, sum(to_amount) as amount_minted
FROM thorchain.swaps
WHERE to_asset LIKE '%/%' AND date < CURRENT_DATE
GROUP BY date, to_asset),
burn AS (SELECT date(block_timestamp) as date, from_asset as asset_burned, sum(from_amount) as amount_burned
FROM thorchain.swaps
WHERE from_asset LIKE '%/%' AND date < CURRENT_DATE
GROUP BY date, from_asset)
SELECT mint.date, asset_minted, amount_minted, asset_burned, amount_burned
FROM mint JOIN burn on mint.date = burn.date
ORDER BY mint.date DESC
Run a query to Download Data