DiamondEVAL: TotalSwaps-DapperSports copy
    Updated 2023-03-27
    SELECT
    Date,
    COUNT(*) AS Total,
    SUM(ContainsJJ) AS "Jolly Jokers"
    FROM
    (
    SELECT
    to_date(BLOCK_TIMESTAMP) as Date,
    *,
    CASE
    WHEN CHARINDEX(
    'A.699bf284101a76f1.JollyJokers',
    EVENT_DATA::String
    ) > 0 THEN 1
    ELSE 0
    END AS ContainsJJ
    FROM
    FLOW.CORE.FACT_EVENTS
    where
    event_contract IN ('A.9066631feda9e518.Swap')
    and event_type = 'ProposalExecuted'
    and TX_SUCCEEDED = TRUE
    )
    group by
    1
    order by
    1 desc
    -- A.e4cf4bdc1751c65d.AllDay.NFT
    Run a query to Download Data