vendettaBTC.b Bridged by User Address copy
Updated 2023-02-17
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
-- forked from 10ff028e-0148-482c-a487-ed418a0202e8
--darvishi
with mint_table as (
select
block_timestamp, tx_hash, event_inputs:value::number/power(10,8) as mint_amount, event_inputs:to as to_address
from
avalanche.core.fact_event_logs
where
tx_status='SUCCESS'
and event_name='Transfer'
and
origin_function_signature='0xa888d914'
and to_address not in ('0x621fa9c13aea2796209498f1327a9f1ca7eabd9e')
)
select
sum(mint_amount) as minted_amt, to_address
from mint_table
group by to_address
Run a query to Download Data