-- When challenges drop, are people buying up moments before the games start? or are they buying throughout games based on performance? -- Are people buying up supplies during games for moments in the challenges and then flipping? -- Or is it just people trying to complete the weekly challenges? -- How hard are the moments floor crashing after the challenges complete? -- What is the average value of the reward packs? (one through five-star packs) -- what is the max a user should spend on moments in the marketplace to get +EV on the pack rewards? --Challenges --1. Thursday Night Challenge. Sept 8 to Saturday Sept 10, 5:30AM CEST --2. Thursday Night Challenge. Sept 15 to Friday Sept 16, 9:30PM CEST --3. Monday Night Challenge. Sept 19 to Tuesday Sept 20, 9:30PM CEST --4. Thursday Night Challenge. Sept 22 to Friday Sept 23, 9:30PM CEST --5. Sunday Slate Challenge. Sept 25 to Monday Sept 26, 6:00PM CEST --6. Sunday Night Challenge. Sept 25 to Monday Sept 26, 10:30PM CEST --7. Monday Night Challenge. Sept 26 to Tuesday Sept 27, 6:30PM CEST --8. End Of Week Challenge. Sept 26 to Tuesday Sept 27, 6:30PM CEST --9. Thursday Night Challenge. Sept 29 to Friday Sept 30, 9:30PM CEST --10. Sunday Slate Challenge. Oct 2 to Monday Oct 3, 9:30PM CEST --11. Sunday Night Challenge. Oct 2 to Monday Oct 3, 9:30PM CEST --12. Monday Night Challenge. Oct 3 to Tuesday Oct 4, 9:30PM CEST --13. End of Week Challenge. Oct 3 to Tuesday Oct 4, 9:30PM CEST WITH challenges as ( SELECT '1. Thursday Night Challenge. Sept 8 to Saturday Sept 10, 5:30AM CEST' as challenge, '2022-09-08 03:30:00' as starting_point, '2022-09-10 03:30:00' as ending_point UNION SELECT '2. Thursday Night Challenge. Sept 15 to Friday Sept 16, 9:30PM CEST' as challenge, '2022-09-15 19:30:00' as starting_point, '2022-09-16 19:30:00' as ending_point UNION SELECT '3. Monday Night Challenge. Sept 19 to Tuesday Sept 20, 9:30PM CEST' as challenge, '2022-09-19 19:30:00' as starting_point, '2022-09-20 19:30:00' as ending_point UNION SELECT '4. Thursday Night Challenge. Sept 22 to Friday Sept 23, 9:30PM CEST' as challenge, '2022-09-22 19:30:00' as starting_point, '2022-09-23 19:30:00' as ending_point UNION SELECT '5. Sunday Slate Challenge. Sept 25 to Monday Sept 26, 6:00PM CEST' as challenge, '2022-09-25 16:00:00' as starting_point, '2022-09-26 16:00:00' as ending_point UNION SELECT '6. Sunday Night Challenge. Sept 25 to Monday Sept 26, 10:30PM CEST' as challenge, '2022-09-25 20:30:00' as starting_point, '2022-09-26 20:30:00' as ending_point UNION SELECT '7. Monday Night Challenge. Sept 26 to Tuesday Sept 27, 6:30PM CEST' as challenge, '2022-09-26 16:30:00' as starting_point, '2022-09-27 16:30:00' as ending_point UNION SELECT '8. End Of Week Challenge. Sept 26 to Tuesday Sept 27, 6:30PM CEST' as challenge, '2022-09-26 16:30:00' as starting_point, '2022-09-27 16:30:00' as ending_point UNION SELECT '9. Thursday Night Challenge. Sept 29 to Friday Sept 30, 9:30PM CEST' as challenge, '2022-09-29 19:30:00' as starting_point, '2022-09-30 19:30:00' as ending_point UNION SELECT '10. Sunday Slate Challenge. Oct 2 to Monday Oct 3, 9:30PM CEST' as challenge, '2022-10-02 19:30:00' as starting_point, '2022-10-03 19:30:00' as ending_point UNION SELECT '11. Sunday Night Challenge. Oct 2 to Monday Oct 3, 9:30PM CEST' as challenge, '2022-10-02 19:30:00' as starting_point, '2022-10-03 19:30:00' as ending_point UNION SELECT '12. Monday Night Challenge. Oct 3 to Tuesday Oct 4, 9:30PM CEST' as challenge, '2022-10-03 19:30:00' as starting_point, '2022-10-04 19:30:00' as ending_point UNION SELECT '13. End of Week Challenge. Oct 3 to Tuesday Oct 4, 9:30PM CEST' as challenge, '2022-10-03 19:30:00' as starting_point, '2022-10-04 19:30:00' as ending_point ), c1 as ( SELECT trunc(block_timestamp,'hour') as hours, case when hours 'During playgame time' group by 1 order by 3 asc

NFL ALL DAY Tournament Round 4