saadiqMythics by Choice Amt by Day
Updated 2023-07-28
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
-- forked from Mythics by Choice Amt @ https://flipsidecrypto.xyz/edit/queries/1087a394-45e4-406c-bf6a-b86bd7f7ff5d
-- forked from cxkoda / 2023-07-25 06:03 PM @ https://flipsidecrypto.xyz/cxkoda/q/Hoc_7UsO13pZ/2023-07-25-06-03-pm
select
left(block_timestamp, 10) as day,
case
when right(topics[3], 1) = 1 then '1 option: Stone + Oddity'
when right(topics[3], 1) = 2 then '2 options: Runic'
when right(topics[3], 1) = 3 then '3 options: Legendary'
else 'wuh?'
end as reveal_type,
count(*) as count
from
ethereum.core.fact_event_logs
where
topics[0] = '0x378bf134aa072ab220f450ccf61455cf6a5570c3bb43e22e0be670f12beb19fb'
group by
day,
topics[3]
order by
day desc,
reveal_type;
Run a query to Download Data