Flippppppa2023-03-17 05:53 PM copy
Updated 2023-03-17
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
›
⌄
-- forked from cb6f3643-6589-4899-8b1f-597370030955
SELECT
Allocation AS "Allocated ARB Amount"
, COUNT(DISTINCT(addresses)) AS "Number of Addresses"
FROM (
SELECT
CONCAT('0x', SUBSTR(TOPICS[1], 27, length(TOPICS[1]) - 26)) AS addresses
, CASE DATA
WHEN '0x000000000000000000000000000000000000000000000021e19e0c9bab240000' THEN '625'
WHEN '0x00000000000000000000000000000000000000000000002f6f10780d22cc0000' THEN '875'
WHEN '0x00000000000000000000000000000000000000000000022ba753352c29e80000' THEN '10250'
WHEN '0x00000000000000000000000000000000000000000000003cfc82e37e9a740000' THEN '1125'
WHEN '0x0000000000000000000000000000000000000000000000bdbc41e0348b300000' THEN '3500'
WHEN '0x00000000000000000000000000000000000000000000011c9a62d04ed0c80000' THEN '5250'
WHEN '0x000000000000000000000000000000000000000000000043c33c193756480000' THEN '1250'
WHEN '0x000000000000000000000000000000000000000000000079f905c6fd34e80000' THEN '2250'
WHEN '0x00000000000000000000000000000000000000000000010f0cf064dd59200000' THEN '5000'
WHEN '0x00000000000000000000000000000000000000000000009513ea9de024380000' THEN '2750'
WHEN '0x00000000000000000000000000000000000000000000005ede20f01a45980000' THEN '1750'
WHEN '0x00000000000000000000000000000000000000000000017b7883c06916600000' THEN '7000'
WHEN '0x0000000000000000000000000000000000000000000000581767ba6189c40000' THEN '1625'
WHEN '0x0000000000000000000000000000000000000000000000a2a15d09519be00000' THEN '3000'
WHEN '0x00000000000000000000000000000000000000000000005150ae84a8cdf00000' THEN '1500'
WHEN '0x00000000000000000000000000000000000000000000016deb1154f79eb80000' THEN '6750'
WHEN '0x000000000000000000000000000000000000000000000073324c914479140000' THEN '2125'
WHEN '0x000000000000000000000000000000000000000000000065a4da25d3016c0000' THEN '1875'
WHEN '0x0000000000000000000000000000000000000000000000e664992288f2280000' THEN '4250'
WHEN '0x0000000000000000000000000000000000000000000000cb49b44ba602d80000' THEN '3750'
WHEN '0x00000000000000000000000000000000000000000000018905f62bda8e080000' THEN '7250'
WHEN '0x00000000000000000000000000000000000000000000006c6b935b8bbd400000' THEN '2000'
WHEN '0x000000000000000000000000000000000000000000000152d02c7e14af680000' THEN '6250'
WHEN '0x0000000000000000000000000000000000000000000000878678326eac900000' THEN '2500'
WHEN '0x00000000000000000000000000000000000000000000012a27d53bc048700000' THEN '5500'
WHEN '0x0000000000000000000000000000000000000000000000b02ecf74c313880000' THEN '3250'
WHEN '0x0000000000000000000000000000000000000000000000b6f588aa7bcf5c0000' THEN '3375'
Run a query to Download Data