PREVIEW / stock_1hour / 2024-03-01

all stock 1-hour files

  file:    by_date/stock_1hour/2024/2024-03-01.parquet
  size:    1.4 MB
  rows:    60,919
  symbols: 1,121

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-03-01 04:00:00	AAPL	Stock	180.6	181.21	180.6	180.84	9841.0
2024-03-01 05:00:00	AAPL	Stock	180.78	180.78	178.66	178.86	139149.0
2024-03-01 06:00:00	AAPL	Stock	178.85	179.45	178.71	179.12	77121.0
2024-03-01 07:00:00	AAPL	Stock	179.2	180.12	179.2	180.06	158377.0
2024-03-01 08:00:00	AAPL	Stock	179.37	181.3	179.3	179.6	237006.0
2024-03-01 09:00:00	AAPL	Stock	179.6	180.53	179.06	179.245	7829913.0
2024-03-01 10:00:00	AAPL	Stock	179.24	180.4	177.67	178.295	11816847.0
2024-03-01 11:00:00	AAPL	Stock	178.295	178.47	177.72	177.935	6785817.0
2024-03-01 12:00:00	AAPL	Stock	177.935	178.66	177.38	178.524	6699548.0
2024-03-01 13:00:00	AAPL	Stock	178.53	179.39	178.33	179.32	5738903.0
2024-03-01 14:00:00	AAPL	Stock	179.315	180.22	179.3	180.005	6183131.0
2024-03-01 15:00:00	AAPL	Stock	180.005	180.01	179.415	179.63	7669887.0
2024-03-01 16:00:00	AAPL	Stock	179.64	179.66	179.02	179.03	5947566.0
2024-03-01 17:00:00	AAPL	Stock	179.04	179.1	179.04	179.06	39687.0
2024-03-01 18:00:00	AAPL	Stock	179.06	179.15	179.0307	179.0307	28780.0
2024-03-01 19:00:00	AAPL	Stock	179.02	179.12	178.95	179.0	27673.0
2024-03-01 04:00:00	MSFT	Stock	413.65	414.24	413.65	414.0	2140.0
2024-03-01 05:00:00	MSFT	Stock	413.85	413.91	411.83	412.21	8444.0
2024-03-01 06:00:00	MSFT	Stock	412.45	412.8	412.03	412.73	4070.0
2024-03-01 07:00:00	MSFT	Stock	412.68	413.19	412.0	412.5	13056.0
2024-03-01 08:00:00	MSFT	Stock	412.98	414.64	412.34	412.76	37088.0
2024-03-01 09:00:00	MSFT	Stock	412.92	414.9682	410.88	412.315	1917825.0
2024-03-01 10:00:00	MSFT	Stock	412.3	413.2	411.6	412.215	1606479.0
2024-03-01 11:00:00	MSFT	Stock	412.23	413.5	411.93	412.72	1137200.0
2024-03-01 12:00:00	MSFT	Stock	412.75	414.15	412.45	414.09	769278.0
2024-03-01 13:00:00	MSFT	Stock	414.15	415.2388	413.88	415.07	1038039.0
2024-03-01 14:00:00	MSFT	Stock	415.09	415.74	414.49	415.2931	932390.0
2024-03-01 15:00:00	MSFT	Stock	415.31	415.87	414.65	415.56	1843539.0
2024-03-01 16:00:00	MSFT	Stock	415.5	415.52	413.997	415.04	2747569.0
2024-03-01 17:00:00	MSFT	Stock	414.72	415.0	414.02	414.5	12982.0
2024-03-01 18:00:00	MSFT	Stock	414.5	414.6	414.3	414.55	10198.0
2024-03-01 19:00:00	MSFT	Stock	414.45	414.52	414.17	414.43	7954.0
2024-03-01 04:00:00	NVDA	Stock	80.139	80.14	79.85	80.09	222470.0
2024-03-01 05:00:00	NVDA	Stock	80.06	80.06	79.575	79.687	201400.0
2024-03-01 06:00:00	NVDA	Stock	79.698	79.991	79.698	79.921	217480.0
2024-03-01 07:00:00	NVDA	Stock	79.93	80.0	79.701	79.88	913930.0
2024-03-01 08:00:00	NVDA	Stock	79.842	80.2	79.701	80.06	2717400.0
2024-03-01 09:00:00	NVDA	Stock	80.056	80.552	79.435	80.3895	58440000.0
2024-03-01 10:00:00	NVDA	Stock	80.407	81.28	80.153	81.2666	64416240.0
2024-03-01 11:00:00	NVDA	Stock	81.272	82.061	81.215	81.797	66458850.0
2024-03-01 12:00:00	NVDA	Stock	81.793	81.934	81.426	81.8192	32131820.0
2024-03-01 13:00:00	NVDA	Stock	81.826	82.188	81.651	82.1605	27411510.0
2024-03-01 14:00:00	NVDA	Stock	82.164	82.259	81.908	82.11	27186840.0
2024-03-01 15:00:00	NVDA	Stock	82.1114	82.3	81.763	82.293	42339670.0
2024-03-01 16:00:00	NVDA	Stock	82.294	82.561	82.24	82.342	19886520.0
2024-03-01 17:00:00	NVDA	Stock	82.3609	82.582	82.35	82.4166	1139350.0
2024-03-01 18:00:00	NVDA	Stock	82.4139	82.48	82.32	82.322	581530.0
2024-03-01 19:00:00	NVDA	Stock	82.335	82.78	82.335	82.65	918980.0
2024-03-01 04:00:00	AMZN	Stock	176.98	177.75	176.98	177.36	12725.0
2024-03-01 05:00:00	AMZN	Stock	177.23	177.23	176.04	176.4	19353.0

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

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