Monitize AIBlast retention final 2
999
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 claimert as(
SELECT
distinct TO_ADDRESS as claimer,
min(Block_timestamp::date) as claim_date,
sum(amount) as Claimed_Amount
from blast.core.ez_token_transfers
where contract_address = lower('0xb1a5700fA2358173Fe465e6eA4Ff52E36e88E2ad')
and FROM_ADDRESS = lower('0xf7be503166828fe8565c520d66645ac6a06bbdd7')
and ORIGIN_FUNCTION_SIGNATURE = '0xcd9829d9'
and amount > 0
and TO_ADDRESS != '0xa4bd562c37c19c569c5b4418d12d35fa9964931f'
group by 1
order by 3 desc
),
/*
staket as (
select
distinct FROM_ADDRESS as staker,
sum(amount) as staked_amount
from blast.core.ez_token_transfers
join claimert on FROM_ADDRESS = claimer
where CONTRACT_ADDRESS = lower('0xb1a5700fA2358173Fe465e6eA4Ff52E36e88E2ad')
and TO_ADDRESS = lower('0x7ff3fc53e1Cb5E187a7d98aCc61367e2623694D3')
group by 1
),*/
balancet as (
SELECT
DISTINCT USER AS holder,
sum(AM) as Holding_Volume
from(
SELECT
FROM_ADDRESS as USER,
-1 * AMOUNT as AM
FROM blast.core.ez_token_transfers
Run a query to Download Data