PREVIEW / stock_1hour / 2024-05-13

all stock 1-hour files

  file:    by_date/stock_1hour/2024/2024-05-13.parquet
  size:    1.3 MB
  rows:    58,821
  symbols: 969

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-05-13 04:00:00	AAPL	Stock	184.3	184.75	183.7	184.6	52235.0
2024-05-13 05:00:00	AAPL	Stock	184.59	185.1	184.54	184.94	29234.0
2024-05-13 06:00:00	AAPL	Stock	184.91	185.3	184.7	185.22	29825.0
2024-05-13 07:00:00	AAPL	Stock	185.21	185.74	185.0	185.37	90982.0
2024-05-13 08:00:00	AAPL	Stock	185.28	185.75	183.91	185.49	231976.0
2024-05-13 09:00:00	AAPL	Stock	185.5	185.65	184.62	185.185	7053322.0
2024-05-13 10:00:00	AAPL	Stock	185.19	186.43	184.94	186.0798	8916500.0
2024-05-13 11:00:00	AAPL	Stock	186.0701	186.27	185.77	186.05	5020087.0
2024-05-13 12:00:00	AAPL	Stock	186.05	186.88	185.97	186.815	6215970.0
2024-05-13 13:00:00	AAPL	Stock	186.81	186.93	186.25	186.7801	6357590.0
2024-05-13 14:00:00	AAPL	Stock	186.78	186.95	186.56	186.815	4167505.0
2024-05-13 15:00:00	AAPL	Stock	186.8199	187.1	186.07	186.285	10669560.0
2024-05-13 16:00:00	AAPL	Stock	186.28	186.48	186.06	186.26	6643047.0
2024-05-13 17:00:00	AAPL	Stock	186.26	186.28	186.13	186.16	24554.0
2024-05-13 18:00:00	AAPL	Stock	186.16	186.29	186.16	186.25	23677.0
2024-05-13 19:00:00	AAPL	Stock	186.25	186.3	186.11	186.14	20553.0
2024-05-13 04:00:00	MSFT	Stock	418.6	418.68	418.15	418.15	4587.0
2024-05-13 05:00:00	MSFT	Stock	418.23	419.35	418.23	418.95	9923.0
2024-05-13 06:00:00	MSFT	Stock	418.65	419.24	418.64	418.64	2487.0
2024-05-13 07:00:00	MSFT	Stock	418.63	418.63	415.65	417.8	21048.0
2024-05-13 08:00:00	MSFT	Stock	418.25	419.3	415.65	418.5	39992.0
2024-05-13 09:00:00	MSFT	Stock	418.39	418.5	410.82	412.11	1860079.0
2024-05-13 10:00:00	MSFT	Stock	412.03	413.41	411.8501	413.355	962139.0
2024-05-13 11:00:00	MSFT	Stock	413.37	414.71	412.9	414.32	644015.0
2024-05-13 12:00:00	MSFT	Stock	414.3	415.7	414.3	415.08	605631.0
2024-05-13 13:00:00	MSFT	Stock	415.04	415.27	413.33	414.26	824136.0
2024-05-13 14:00:00	MSFT	Stock	414.24	414.5194	413.651	414.23	360969.0
2024-05-13 15:00:00	MSFT	Stock	414.18	414.39	413.38	413.75	1116795.0
2024-05-13 16:00:00	MSFT	Stock	413.72	414.55	413.72	414.0499	2952290.0
2024-05-13 17:00:00	MSFT	Stock	414.04	414.05	413.93	413.93	1512.0
2024-05-13 18:00:00	MSFT	Stock	413.94	414.12	413.72	414.05	6880.0
2024-05-13 19:00:00	MSFT	Stock	414.0	414.22	414.0	414.22	5786.0
2024-05-13 04:00:00	NVDA	Stock	90.098	90.364	89.81	90.35	120650.0
2024-05-13 05:00:00	NVDA	Stock	90.329	90.62	90.326	90.53	97400.0
2024-05-13 06:00:00	NVDA	Stock	90.525	90.706	90.4	90.621	100500.0
2024-05-13 07:00:00	NVDA	Stock	90.62	90.724	90.43	90.678	524670.0
2024-05-13 08:00:00	NVDA	Stock	90.5	90.8	89.898	90.728	1709080.0
2024-05-13 09:00:00	NVDA	Stock	90.755	90.888	88.529	89.5665	42880540.0
2024-05-13 10:00:00	NVDA	Stock	89.555	90.343	89.175	90.061	39319460.0
2024-05-13 11:00:00	NVDA	Stock	90.084	90.61	89.82	90.5863	28872500.0
2024-05-13 12:00:00	NVDA	Stock	90.565	90.998	90.456	90.624	25717790.0
2024-05-13 13:00:00	NVDA	Stock	90.631	90.64	89.88	90.364	23955560.0
2024-05-13 14:00:00	NVDA	Stock	90.364	90.374	90.0958	90.25	12471660.0
2024-05-13 15:00:00	NVDA	Stock	90.25	90.46	90.1337	90.399	19283810.0
2024-05-13 16:00:00	NVDA	Stock	90.353	90.411	90.0638	90.3	11629920.0
2024-05-13 17:00:00	NVDA	Stock	90.2993	90.34	90.226	90.34	178710.0
2024-05-13 18:00:00	NVDA	Stock	90.33	90.399	90.226	90.228	210420.0
2024-05-13 19:00:00	NVDA	Stock	90.24	90.289	90.2	90.258	276490.0
2024-05-13 04:00:00	AMZN	Stock	187.89	187.91	187.47	187.86	8987.0
2024-05-13 05:00:00	AMZN	Stock	187.76	187.93	187.72	187.89	3141.0

> showing 50 of 58,821 rows — these rows as CSV

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