PREVIEW / stock_1hour / 2002-11-12

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-11-12.parquet
  size:    418 KB
  rows:    19,576
  symbols: 1,499

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-11-12 08:00:00	AAPL	Stock	0.271	0.271	0.271	0.271	1400000.0
2002-11-12 09:00:00	AAPL	Stock	0.2718	0.2759	0.2718	0.2755	20965000.0
2002-11-12 10:00:00	AAPL	Stock	0.2754	0.2802	0.2729	0.2795	43729560.0
2002-11-12 11:00:00	AAPL	Stock	0.2793	0.2798	0.2763	0.2796	26634496.0
2002-11-12 12:00:00	AAPL	Stock	0.2796	0.2832	0.2782	0.283	14678608.0
2002-11-12 13:00:00	AAPL	Stock	0.2827	0.2836	0.2804	0.2813	7713720.0
2002-11-12 14:00:00	AAPL	Stock	0.2814	0.2864	0.2814	0.2848	19627608.0
2002-11-12 15:00:00	AAPL	Stock	0.2845	0.2846	0.2765	0.2793	61383000.0
2002-11-12 16:00:00	AAPL	Stock	0.2793	0.2796	0.2736	0.2736	4502400.0
2002-11-12 17:00:00	AAPL	Stock	0.2793	0.2793	0.2793	0.2793	9956800.0
2002-11-12 18:00:00	AAPL	Stock	0.2791	0.2791	0.2786	0.2786	56000.0
2002-11-12 08:00:00	MSFT	Stock	27.09	27.125	26.9645	27.125	59200.0
2002-11-12 09:00:00	MSFT	Stock	27.1	27.165	26.95	27.135	10509162.0
2002-11-12 10:00:00	MSFT	Stock	27.13	27.42	27.105	27.36	16778876.0
2002-11-12 11:00:00	MSFT	Stock	27.36	27.475	27.33	27.45	7455734.0
2002-11-12 12:00:00	MSFT	Stock	27.45	27.45	27.335	27.435	6632044.0
2002-11-12 13:00:00	MSFT	Stock	27.44	27.475	27.35	27.47	6159086.0
2002-11-12 14:00:00	MSFT	Stock	27.475	27.715	27.454	27.625	8966930.0
2002-11-12 15:00:00	MSFT	Stock	27.625	27.625	27.159	27.25	14956410.0
2002-11-12 16:00:00	MSFT	Stock	27.255	27.307	27.18	27.215	3790858.0
2002-11-12 17:00:00	MSFT	Stock	27.2155	27.4159	27.2155	27.22	1783600.0
2002-11-12 18:00:00	MSFT	Stock	27.24	27.25	27.24	27.25	6600.0
2002-11-12 08:00:00	NVDA	Stock	0.0879	0.0908	0.0875	0.0902	3852240.0
2002-11-12 09:00:00	NVDA	Stock	0.0903	0.0917	0.0885	0.0901	144285480.0
2002-11-12 10:00:00	NVDA	Stock	0.09	0.0962	0.0897	0.0956	357965760.0
2002-11-12 11:00:00	NVDA	Stock	0.0954	0.0979	0.0947	0.0976	185501280.0
2002-11-12 12:00:00	NVDA	Stock	0.0978	0.0978	0.0954	0.097	118410840.0
2002-11-12 13:00:00	NVDA	Stock	0.0969	0.0975	0.0947	0.0962	116184600.0
2002-11-12 14:00:00	NVDA	Stock	0.0962	0.0983	0.0959	0.0962	143145000.0
2002-11-12 15:00:00	NVDA	Stock	0.0962	0.0963	0.0939	0.0949	246775320.0
2002-11-12 16:00:00	NVDA	Stock	0.0952	0.0957	0.0948	0.0954	8266800.0
2002-11-12 17:00:00	NVDA	Stock	0.0951	0.0952	0.0951	0.0952	1740000.0
2002-11-12 18:00:00	NVDA	Stock	0.0954	0.0957	0.0952	0.0954	912000.0
2002-11-12 08:00:00	AMZN	Stock	0.976	0.976	0.953	0.953	7800.0
2002-11-12 09:00:00	AMZN	Stock	0.9536	0.9675	0.9505	0.9602	16479700.0
2002-11-12 10:00:00	AMZN	Stock	0.96	0.985	0.9585	0.98	32447860.0
2002-11-12 11:00:00	AMZN	Stock	0.9805	0.988	0.9735	0.9865	20381700.0
2002-11-12 12:00:00	AMZN	Stock	0.986	0.9925	0.9805	0.989	26031960.0
2002-11-12 13:00:00	AMZN	Stock	0.9885	0.995	0.9875	0.9938	32543700.0
2002-11-12 14:00:00	AMZN	Stock	0.9935	0.9995	0.9895	0.994	34980560.0
2002-11-12 15:00:00	AMZN	Stock	0.994	0.9945	0.9865	0.991	33036600.0
2002-11-12 16:00:00	AMZN	Stock	0.9915	0.992	0.9885	0.99	2574580.0
2002-11-12 17:00:00	AMZN	Stock	0.991	0.9915	0.9886	0.9895	916520.0
2002-11-12 18:00:00	AMZN	Stock	0.9885	0.9885	0.9885	0.9885	24000.0
2002-11-12 09:00:00	CL	Stock	27.15	27.15	27.0	27.01	350000.0
2002-11-12 10:00:00	CL	Stock	27.025	27.225	27.005	27.11	503200.0
2002-11-12 11:00:00	CL	Stock	27.12	27.165	26.91	26.915	425000.0
2002-11-12 12:00:00	CL	Stock	26.93	27.0	26.875	26.895	239600.0
2002-11-12 13:00:00	CL	Stock	26.9	26.925	26.75	26.76	550400.0
2002-11-12 14:00:00	CL	Stock	26.76	26.85	26.62	26.625	486000.0

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

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