MINT_RANGE | MINTERS | |
|---|---|---|
1 | 0 - 0.001 LBTC | 23912 |
2 | 0.001 - 0.01 LBTC | 18412 |
3 | 0.01 - 0.1 LBTC | 6090 |
4 | 0.1 - 1 LBTC | 1338 |
5 | 1 - 5 LBTC | 393 |
6 | 10+ LBTC | 192 |
7 | 5 - 10 LBTC | 96 |
datavortexminters categories
Updated 2025-03-02
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 mint_data AS (
SELECT
'Ethereum' AS chain,
origin_from_address AS minter,
SUM(decoded_log:value) / 1e8 AS total_minted
FROM ethereum.core.ez_decoded_event_logs
WHERE
contract_address = LOWER('0x8236a87084f8B84306f72007F36F2618A5634494')
AND decoded_log:from = '0x0000000000000000000000000000000000000000'
AND event_name = 'Transfer'
GROUP BY 1, 2
UNION ALL
SELECT
'Base' AS chain,
origin_from_address AS minter,
SUM(decoded_log:value) / 1e8 AS total_minted
FROM base.core.ez_decoded_event_logs
WHERE
contract_address = LOWER('0xecAc9C5F704e954931349Da37F60E39f515c11c1')
AND decoded_log:from = '0x0000000000000000000000000000000000000000'
AND event_name = 'Transfer'
GROUP BY 1, 2
UNION ALL
SELECT
'BSC' AS chain,
origin_from_address AS minter,
SUM(decoded_log:value) / 1e8 AS total_minted
FROM bsc.core.ez_decoded_event_logs
WHERE
contract_address = LOWER('0xecAc9C5F704e954931349Da37F60E39f515c11c1')
AND decoded_log:from = '0x0000000000000000000000000000000000000000'
AND event_name = 'Transfer'
Last run: 2 months ago
7
156B
20s