PREVIEW / stock_1hour / 2024-10-07

all stock 1-hour files

  file:    by_date/stock_1hour/2024/2024-10-07.parquet
  size:    1.4 MB
  rows:    60,838
  symbols: 760

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2024-10-07 04:00:00	AAPL	Stock	224.88	224.92	223.7	224.0	55236.0
2024-10-07 05:00:00	AAPL	Stock	224.0	224.0	223.0	223.7	38753.0
2024-10-07 06:00:00	AAPL	Stock	223.6	223.68	223.41	223.62	26417.0
2024-10-07 07:00:00	AAPL	Stock	223.65	224.29	223.49	224.17	88553.0
2024-10-07 08:00:00	AAPL	Stock	223.85	226.233	223.58	224.65	182262.0
2024-10-07 09:00:00	AAPL	Stock	224.64	225.68	224.05	225.065	3600700.0
2024-10-07 10:00:00	AAPL	Stock	225.03	225.69	224.42	225.31	3284064.0
2024-10-07 11:00:00	AAPL	Stock	225.31	225.31	224.48	224.89	1962935.0
2024-10-07 12:00:00	AAPL	Stock	224.89	224.93	223.892	223.9575	2143669.0
2024-10-07 13:00:00	AAPL	Stock	223.96	224.57	223.4	223.8598	1962078.0
2024-10-07 14:00:00	AAPL	Stock	223.86	223.985	222.23	222.33	2865843.0
2024-10-07 15:00:00	AAPL	Stock	222.32	222.785	221.33	221.72	4818238.0
2024-10-07 16:00:00	AAPL	Stock	221.69	222.03	221.61	221.84	7379350.0
2024-10-07 17:00:00	AAPL	Stock	221.69	222.01	221.69	221.99	73450.0
2024-10-07 18:00:00	AAPL	Stock	222.0	222.06	221.22	221.47	44536.0
2024-10-07 19:00:00	AAPL	Stock	221.38	222.05	221.38	221.8	23657.0
2024-10-07 04:00:00	MSFT	Stock	415.8	416.1	415.46	415.46	4533.0
2024-10-07 05:00:00	MSFT	Stock	415.11	415.2	414.0	414.88	6521.0
2024-10-07 06:00:00	MSFT	Stock	414.8	414.9	414.8	414.89	694.0
2024-10-07 07:00:00	MSFT	Stock	414.81	415.0	414.16	414.35	20523.0
2024-10-07 08:00:00	MSFT	Stock	414.8	416.15	414.16	414.35	38350.0
2024-10-07 09:00:00	MSFT	Stock	414.44	417.11	414.2	414.67	1953614.0
2024-10-07 10:00:00	MSFT	Stock	414.7	416.37	414.66	415.7	1479988.0
2024-10-07 11:00:00	MSFT	Stock	415.6694	415.91	414.69	415.03	854253.0
2024-10-07 12:00:00	MSFT	Stock	415.03	415.05	413.0814	413.24	1063917.0
2024-10-07 13:00:00	MSFT	Stock	413.244	414.0299	412.64	413.29	806255.0
2024-10-07 14:00:00	MSFT	Stock	413.28	413.3498	409.19	409.39	1381960.0
2024-10-07 15:00:00	MSFT	Stock	409.39	410.53	409.0	409.66	2061740.0
2024-10-07 16:00:00	MSFT	Stock	409.54	409.99	409.4	409.54	4725897.0
2024-10-07 17:00:00	MSFT	Stock	409.54	410.0	409.54	409.98	9612.0
2024-10-07 18:00:00	MSFT	Stock	410.0	410.05	408.91	409.4	12452.0
2024-10-07 19:00:00	MSFT	Stock	409.53	410.0	409.42	409.55	5101.0
2024-10-07 04:00:00	NVDA	Stock	124.1	124.88	124.0	124.04	336711.0
2024-10-07 05:00:00	NVDA	Stock	124.04	124.05	123.0	123.48	500760.0
2024-10-07 06:00:00	NVDA	Stock	123.47	123.7	123.34	123.66	142049.0
2024-10-07 07:00:00	NVDA	Stock	123.66	124.52	123.66	124.45	937364.0
2024-10-07 08:00:00	NVDA	Stock	123.69	125.12	123.3548	124.37	2635728.0
2024-10-07 09:00:00	NVDA	Stock	124.38	127.81	124.27	125.915	44809258.0
2024-10-07 10:00:00	NVDA	Stock	125.92	128.09	125.35	127.6907	43971735.0
2024-10-07 11:00:00	NVDA	Stock	127.69	129.65	127.2	129.1713	44729289.0
2024-10-07 12:00:00	NVDA	Stock	129.18	129.64	128.55	128.9808	31994536.0
2024-10-07 13:00:00	NVDA	Stock	128.98	130.55	128.93	130.5308	37796934.0
2024-10-07 14:00:00	NVDA	Stock	130.5308	130.64	127.94	128.0	42417558.0
2024-10-07 15:00:00	NVDA	Stock	128.0401	128.85	127.52	127.79	41082390.0
2024-10-07 16:00:00	NVDA	Stock	127.77	128.4799	127.6501	128.16	14977497.0
2024-10-07 17:00:00	NVDA	Stock	128.1695	128.32	127.72	128.22	514127.0
2024-10-07 18:00:00	NVDA	Stock	128.2198	128.2785	127.75	127.96	606090.0
2024-10-07 19:00:00	NVDA	Stock	127.9534	128.1	127.9105	128.09	458417.0
2024-10-07 04:00:00	AMZN	Stock	186.39	186.66	185.3	185.7	6398.0
2024-10-07 05:00:00	AMZN	Stock	185.7	185.73	182.3	183.25	133742.0

> showing 50 of 60,838 rows — these rows as CSV

> unlock the full archive -- $79 one-time