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,

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

)

),

deposits_per_address as (