saadiqMythics by Choice Amt by Day
    Updated 2023-07-28
    -- 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