SocioCryptoArb mint-burn total
Updated 2023-06-22
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
›
⌄
-- contract : 0xff970a61a04b1ca14834a43f5de4533ebddb5cc8 usdc -bridged token
-- native token usdc : '0xaf88d065e77c8cC2239327C5EDb3A432268e5831'
with
mint as (
SELECT sum(amount) as amnt
FROM arbitrum.core.ez_token_transfers
WHERE contract_address IN (lower('0xff970a61a04b1ca14834a43f5de4533ebddb5cc8'), lower('0xaf88d065e77c8cC2239327C5EDb3A432268e5831'))
AND from_address = '0x0000000000000000000000000000000000000000'
--AND block_timestamp >= DATEADD('month', -1*{{last_n_month}}, CURRENT_DATE)
AND block_timestamp<= CURRENT_DATE-1
),
burn as (
SELECT sum(amount) as amnt
FROM arbitrum.core.ez_token_transfers
WHERE contract_address IN (lower('0xff970a61a04b1ca14834a43f5de4533ebddb5cc8'), lower('0xaf88d065e77c8cC2239327C5EDb3A432268e5831'))
AND to_address = '0x0000000000000000000000000000000000000000'
--AND block_timestamp >= DATEADD('month', -1*{{last_n_month}}, CURRENT_DATE)
AND block_timestamp<= CURRENT_DATE-1
)
SELECT
m.amnt as mint_vol,
b.amnt as burnt_vol,
zeroifnull(mint_vol)-zeroifnull(burnt_vol) as net_vol
FROM mint m
LEFT JOIN burn b
on TRUE
Run a query to Download Data