gonisgone100%
Updated 2025-03-18Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
select
DATE_TRUNC('month', block_timestamp) AS month,
sum(AMOUNT) as burn_amount
from
kaia.core.ez_token_transfers
where
block_timestamp > current_date - interval '12 months'
AND SYMBOL = 'MBX'
AND LOWER(TO_ADDRESS) = LOWER('0x4343cAA984a49b2184681a26031c5e75e02D7942')
GROUP BY
month
ORDER BY
month;
QueryRunArchived: QueryRun has been archived