jackguyEuro Stablecoin on Avalanche
Updated 2023-07-01
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
›
⌄
SELECT *
FROM (
SELECT
*,
sum(net_mint_amt) over (order by day) as total_mint_amt
FROM (
SELECT
date_trunc('day', block_timestamp) as day,
sum(CASE when from_address LIKE '0x0000000000000000000000000000000000000000' then amount else 0 end) as mint_amt,
sum(CASE when to_address LIKE '0x0000000000000000000000000000000000000000' then amount else 0 end) as burn_amt,
sum(CASE when from_address LIKE '0x0000000000000000000000000000000000000000' then amount else 0 end) - sum(CASE when to_address LIKE '0x0000000000000000000000000000000000000000' then amount else 0 end) as net_mint_amt
FROM avalanche.core.ez_token_transfers
WHERE contract_address LIKE lower('0xC891EB4cbdEFf6e073e859e987815Ed1505c2ACD')
AND (
from_address LIKE '0x0000000000000000000000000000000000000000'
OR to_address LIKE '0x0000000000000000000000000000000000000000'
)
GROUP BY 1
)
)
WHERE day > '2023-05-01'
Run a query to Download Data