Motilola$TAI Weekly Burn Amount
Updated 2024-10-26
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
›
⌄
WITH prices AS (
SELECT
hour::date AS date,
AVG(price) AS Avg_price
FROM solana.price.ez_prices_hourly
WHERE token_address = 'Hax9LTgsQkze1YFychnBLtFH8gYbQKtKfWKKg2SP6gdD'
AND hour::date >= '2024-06-26'
GROUP BY date
),
burn_raw AS(
SELECT
block_timestamp::date AS date,
tx_id,
burn_amount,
burn_authority ,
token_account
FROM solana.defi.fact_token_burn_actions
WHERE mint = 'Hax9LTgsQkze1YFychnBLtFH8gYbQKtKfWKKg2SP6gdD'
AND burn_authority = 'DK8Ff3Nags9ZLKQSyhmQoswVpPNVgedb638jJ3WrQYse'
AND token_account = 'DwutQBdaFKRgZ1VVsVfk3kfYRW9vvprR7F8ccytdXXyd'
AND event_type = 'burn'
AND succeeded = 'TRUE'
AND block_timestamp::date >= '2024-06-26'
),
burn_agg AS (
SELECT
date,
SUM(burn_amount) / pow (10,9) AS amount_burned
FROM burn_raw
GROUP BY date
)
SELECT
QueryRunArchived: QueryRun has been archived