DiamondEVAL: TotalSwaps-DapperSports copy
Updated 2023-03-27
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
›
⌄
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