PREVIEW / stock_1hour / 2002-05-13

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-05-13.parquet
  size:    409 KB
  rows:    19,170
  symbols: 1,416

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
2002-05-13 09:00:00	AAPL	Stock	0.4196	0.4205	0.4096	0.4121	28924000.0
2002-05-13 10:00:00	AAPL	Stock	0.4123	0.4254	0.4121	0.423	63700000.0
2002-05-13 11:00:00	AAPL	Stock	0.423	0.4284	0.4223	0.4263	36276800.0
2002-05-13 12:00:00	AAPL	Stock	0.4261	0.4261	0.4209	0.4257	26230400.0
2002-05-13 13:00:00	AAPL	Stock	0.4257	0.4277	0.4191	0.4227	17959200.0
2002-05-13 14:00:00	AAPL	Stock	0.423	0.4271	0.4205	0.427	17242400.0
2002-05-13 15:00:00	AAPL	Stock	0.427	0.4302	0.4243	0.4273	41759200.0
2002-05-13 16:00:00	AAPL	Stock	0.4275	0.4277	0.4249	0.4275	9699200.0
2002-05-13 17:00:00	AAPL	Stock	0.4275	0.4275	0.4275	0.4275	44800.0
2002-05-13 08:00:00	MSFT	Stock	25.125	25.25	25.075	25.21	69200.0
2002-05-13 09:00:00	MSFT	Stock	25.225	25.32	24.875	25.216	10411200.0
2002-05-13 10:00:00	MSFT	Stock	25.225	25.925	25.17	25.695	11537400.0
2002-05-13 11:00:00	MSFT	Stock	25.7	26.19	25.64	26.176	8301600.0
2002-05-13 12:00:00	MSFT	Stock	26.19	26.225	26.0	26.165	6788600.0
2002-05-13 13:00:00	MSFT	Stock	26.165	26.385	25.905	26.025	7462200.0
2002-05-13 14:00:00	MSFT	Stock	26.01	26.23	25.93	26.1535	5556200.0
2002-05-13 15:00:00	MSFT	Stock	26.1535	26.455	26.075	26.345	10073200.0
2002-05-13 16:00:00	MSFT	Stock	26.345	26.375	25.7779	26.25	2494600.0
2002-05-13 17:00:00	MSFT	Stock	26.295	26.35	25.8532	26.35	68600.0
2002-05-13 18:00:00	MSFT	Stock	26.35	26.35	26.29	26.35	2800.0
2002-05-13 08:00:00	NVDA	Stock	0.2667	0.2696	0.2647	0.2696	1440000.0
2002-05-13 09:00:00	NVDA	Stock	0.2699	0.2744	0.2662	0.2732	110556000.0
2002-05-13 10:00:00	NVDA	Stock	0.2733	0.2773	0.2722	0.275	186936000.0
2002-05-13 11:00:00	NVDA	Stock	0.2752	0.2793	0.2748	0.2772	99816000.0
2002-05-13 12:00:00	NVDA	Stock	0.2774	0.2804	0.2756	0.2789	80604000.0
2002-05-13 13:00:00	NVDA	Stock	0.2789	0.2808	0.2755	0.2765	79824000.0
2002-05-13 14:00:00	NVDA	Stock	0.2765	0.2798	0.2759	0.2771	73296000.0
2002-05-13 15:00:00	NVDA	Stock	0.2772	0.2827	0.2756	0.2817	128244000.0
2002-05-13 16:00:00	NVDA	Stock	0.2816	0.2827	0.2764	0.2817	16632000.0
2002-05-13 17:00:00	NVDA	Stock	0.2819	0.2829	0.2817	0.2827	1404000.0
2002-05-13 18:00:00	NVDA	Stock	0.2827	0.283	0.2827	0.2829	708000.0
2002-05-13 08:00:00	AMZN	Stock	0.8475	0.8735	0.83	0.8625	522000.0
2002-05-13 09:00:00	AMZN	Stock	0.8595	0.8725	0.8425	0.8696	18268000.0
2002-05-13 10:00:00	AMZN	Stock	0.8695	0.8725	0.8595	0.869	24322000.0
2002-05-13 11:00:00	AMZN	Stock	0.869	0.8815	0.868	0.8725	19404000.0
2002-05-13 12:00:00	AMZN	Stock	0.873	0.873	0.86	0.87	19722000.0
2002-05-13 13:00:00	AMZN	Stock	0.87	0.8725	0.855	0.8605	10236000.0
2002-05-13 14:00:00	AMZN	Stock	0.861	0.871	0.856	0.8655	12524000.0
2002-05-13 15:00:00	AMZN	Stock	0.867	0.8735	0.864	0.8665	16676000.0
2002-05-13 16:00:00	AMZN	Stock	0.8665	0.869	0.859	0.866	2196000.0
2002-05-13 17:00:00	AMZN	Stock	0.865	0.867	0.865	0.867	42000.0
2002-05-13 09:00:00	CL	Stock	27.66	27.745	27.63	27.72	197400.0
2002-05-13 10:00:00	CL	Stock	27.73	27.925	27.725	27.79	370000.0
2002-05-13 11:00:00	CL	Stock	27.79	27.875	27.76	27.855	262800.0
2002-05-13 12:00:00	CL	Stock	27.865	27.87	27.685	27.775	271600.0
2002-05-13 13:00:00	CL	Stock	27.78	27.855	27.745	27.78	314400.0
2002-05-13 14:00:00	CL	Stock	27.775	27.805	27.715	27.805	297800.0
2002-05-13 15:00:00	CL	Stock	27.81	27.85	27.775	27.81	539000.0
2002-05-13 16:00:00	CL	Stock	27.81	27.815	27.79	27.79	93600.0
2002-05-13 17:00:00	CL	Stock	27.8	27.8	27.8	27.8	2400.0

> showing 50 of 19,170 rows — these rows as CSV

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