Week 131 - Snowpark & Python

It was with great delight that Prof. Frosty read Jeff Hollan's announcement that the most frustrating aspect of Snowflake had now been resolved:

On the same day, Doris Lee posted about the fact that Snowpark Pandas can read CSV files directly from S3. What joy! Although we shan't post a screenshot, because that would foil this week's challenge.

This week, we have some data in our public S3 bucket on Snowflake's stock credit to MarketWatch (accessed 2025-02-28)

Your challenge is to use VS Code - or some other IDE - to connect into Snowflake and use Snowpark Pandas to tell us, between the dates 2024-02-28 and 2025-02-27 which day had the greatest variance between open and close & high and low?

import modin.pandas as pd
import snowflake.snowpark.modin.plugin
from snowflake.snowpark import Session

session = Session.builder.config("connection_name", "frosty").create()
s3_loc = 's3://frostyfridaychallenges/challenge_131/snock_stock_market_watch.csv'

Happy Snowflaking!