rezarwzTotal Minted Drops
Updated 2024-05-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
with all_drop_registery as (
SELECT
tx_hash,
FROM_ADDRESS as ua,
block_timestamp,
substr(INPUT_DATA, 1, 10) as MethodID,
LiveQuery.utils.udf_hex_to_int(substr(INPUT_DATA, 75, 64)) as id,
LiveQuery.utils.udf_hex_to_int(substr(INPUT_DATA, 139, 64)) as amount
FROM
blast.core.fact_transactions
where
TO_ADDRESS = '0x1cec3bcc174427fa3ba2f94e9d36e5fafee015b6'
and ORIGIN_FUNCTION_SIGNATURE = '0x24e66d68'
and STATUS = 'SUCCESS'
)
SELECT
sum(amount)
FROM
all_drop_registery
QueryRunArchived: QueryRun has been archived