vilppuTotal distinct deposit addresses (users) filtered
Updated 2024-08-12
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 Total distinct deposit addresses (users) @ https://flipsidecrypto.xyz/edit/queries/32d74267-20eb-4e97-9271-4311870c3262
-- forked from Total distinct deposit addresses (users) @ https://flipsidecrypto.xyz/edit/queries/c2360b75-1a09-45a0-ac96-2605bde42096
with all_transfers as (
select distinct
block_timestamp,
tx_hash,
tx_position,
trace_index as index,
case
when to_address = '0x0000000000e14e87e5c80a8a90817308fff715d3' then 'YOLO'
when to_address = '0x28ef3eae1abb6d6e22e9bfc7a0944f707e4726b3' then 'YOLO Limited'
when to_address = '0x0000000000acc01064aa5280da3f1c41a35827bc' then 'PokeTheBear'
when to_address = '0x693b37a9859ce9465fb2aadeb03811a26a0c37c0' then 'MoonOrDoom'
when to_address = '0xa56a95f41e64bc76cde7423ab2a2ee1763bd8bcc' then 'MoonOrDoom'
when to_address = '0x96648d17c273a932197acf2232653bed7d69ec6f' then 'Flipper'
when to_address = '0xa596f7d6587de656d0ef099d2f28fe699060bf97' then 'Quantum'
when to_address = '0xc6f17f7935b12a38fe4a80f4f4db7dbaf324224c' then 'Laser Blast'
end as game_type,
origin_from_address as user_address,
cast(amount_precise as float) as amount_eth,
from
blast.core.ez_native_transfers
where
to_address in (
'0x0000000000e14e87e5c80a8a90817308fff715d3', -- YOLO
'0x28ef3eae1abb6d6e22e9bfc7a0944f707e4726b3', -- YOLO Limited
'0x0000000000acc01064aa5280da3f1c41a35827bc', -- PokeTheBear
'0x693b37a9859ce9465fb2aadeb03811a26a0c37c0', -- MoonOrDoom
'0xa56a95f41e64bc76cde7423ab2a2ee1763bd8bcc', -- MoonOrDoom
'0x96648d17c273a932197acf2232653bed7d69ec6f', -- Flipper
'0xa596f7d6587de656d0ef099d2f28fe699060bf97', -- Quantum
'0xc6f17f7935b12a38fe4a80f4f4db7dbaf324224c' -- Laser Blast
)
)
QueryRunArchived: QueryRun has been archived