Pine AnalyticsOpen Eden 1
Updated 2024-06-07
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
31
32
33
34
35
36
›
⌄
SELECT
*
FROM (
SELECT
date_trunc('week', block_timestamp) as week,
'Ethereum' as chain,
sum(
CASE when to_address LIKE '0x0000000000000000000000000000000000000000' then -amount
else amount end
) as net_mint,
sum(net_mint) over (ORDER by week) as supply
FROM ethereum.core.ez_token_transfers
WHERE contract_address LIKE lower('0xdd50C053C096CB04A3e3362E2b622529EC5f2e8a')
AND (
to_address LIKE '0x0000000000000000000000000000000000000000'
OR from_address LIKE '0x0000000000000000000000000000000000000000'
)
GROUP BY 1,2
UNION all
SELECT
date_trunc('week', block_timestamp) as week,
'Arbitrum' as chain,
sum(
CASE when to_address LIKE '0x0000000000000000000000000000000000000000' then -amount
else amount end
) as net_mint,
sum(net_mint) over (ORDER by week) as supply
FROM arbitrum.core.ez_token_transfers
WHERE contract_address LIKE lower('0xF84D28A8D28292842dD73D1c5F99476A80b6666A')
AND (
to_address LIKE '0x0000000000000000000000000000000000000000'
Auto-refreshes every 3 hours
QueryRunArchived: QueryRun has been archived