PREVIEW / stock_1hour / 2002-11-14

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-11-14.parquet
  size:    416 KB
  rows:    19,618
  symbols: 1,517

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-14 09:00:00	AAPL	Stock	0.2813	0.2866	0.2813	0.285	18429376.0
2002-11-14 10:00:00	AAPL	Stock	0.285	0.2889	0.2848	0.2877	19667200.0
2002-11-14 11:00:00	AAPL	Stock	0.288	0.29	0.2864	0.2893	17475976.0
2002-11-14 12:00:00	AAPL	Stock	0.2896	0.2907	0.2864	0.2902	14511336.0
2002-11-14 13:00:00	AAPL	Stock	0.2902	0.2914	0.2893	0.29	9544640.0
2002-11-14 14:00:00	AAPL	Stock	0.2896	0.2921	0.2895	0.2921	14787808.0
2002-11-14 15:00:00	AAPL	Stock	0.2921	0.293	0.2898	0.2911	31055752.0
2002-11-14 16:00:00	AAPL	Stock	0.2913	0.2921	0.2875	0.2893	4496912.0
2002-11-14 17:00:00	AAPL	Stock	0.2866	0.2911	0.2866	0.2884	341600.0
2002-11-14 18:00:00	AAPL	Stock	0.2893	0.2893	0.2893	0.2893	28000.0
2002-11-14 08:00:00	MSFT	Stock	27.6825	28.065	27.68	27.99	362860.0
2002-11-14 09:00:00	MSFT	Stock	27.985	28.115	27.77	28.075	12105624.0
2002-11-14 10:00:00	MSFT	Stock	28.075	28.285	28.06	28.225	16882650.0
2002-11-14 11:00:00	MSFT	Stock	28.225	28.34	28.1	28.295	9280240.0
2002-11-14 12:00:00	MSFT	Stock	28.295	28.42	28.22	28.365	6943968.0
2002-11-14 13:00:00	MSFT	Stock	28.365	28.475	28.31	28.315	8526606.0
2002-11-14 14:00:00	MSFT	Stock	28.31	28.48	28.2735	28.48	7535634.0
2002-11-14 15:00:00	MSFT	Stock	28.48	28.5	28.325	28.495	12352088.0
2002-11-14 16:00:00	MSFT	Stock	28.495	28.525	28.22	28.29	2377680.0
2002-11-14 17:00:00	MSFT	Stock	28.335	28.4994	28.26	28.31	65956.0
2002-11-14 18:00:00	MSFT	Stock	28.33	28.445	28.33	28.425	34600.0
2002-11-14 08:00:00	NVDA	Stock	0.0982	0.1025	0.0982	0.1025	3131520.0
2002-11-14 09:00:00	NVDA	Stock	0.1032	0.1066	0.1014	0.1021	270723000.0
2002-11-14 10:00:00	NVDA	Stock	0.1021	0.104	0.1017	0.1028	207600120.0
2002-11-14 11:00:00	NVDA	Stock	0.103	0.1039	0.1021	0.1031	94261920.0
2002-11-14 12:00:00	NVDA	Stock	0.1031	0.1042	0.1026	0.1033	80112000.0
2002-11-14 13:00:00	NVDA	Stock	0.1033	0.1037	0.1022	0.1024	89875200.0
2002-11-14 14:00:00	NVDA	Stock	0.1025	0.1052	0.1022	0.1051	149490240.0
2002-11-14 15:00:00	NVDA	Stock	0.105	0.1052	0.1037	0.1042	180923640.0
2002-11-14 16:00:00	NVDA	Stock	0.1042	0.1049	0.1032	0.1041	14585400.0
2002-11-14 17:00:00	NVDA	Stock	0.1042	0.1046	0.1037	0.1042	719280.0
2002-11-14 18:00:00	NVDA	Stock	0.1037	0.1047	0.1037	0.1047	612000.0
2002-11-14 08:00:00	AMZN	Stock	1.0193	1.04	1.0193	1.04	1248600.0
2002-11-14 09:00:00	AMZN	Stock	1.039	1.07	1.0375	1.065	62590160.0
2002-11-14 10:00:00	AMZN	Stock	1.0645	1.0745	1.0565	1.0675	57155600.0
2002-11-14 11:00:00	AMZN	Stock	1.0675	1.071	1.063	1.064	23222700.0
2002-11-14 12:00:00	AMZN	Stock	1.0635	1.0652	1.061	1.063	19074220.0
2002-11-14 13:00:00	AMZN	Stock	1.063	1.067	1.0605	1.0626	23623400.0
2002-11-14 14:00:00	AMZN	Stock	1.0625	1.066	1.0605	1.065	13212440.0
2002-11-14 15:00:00	AMZN	Stock	1.065	1.069	1.058	1.061	44968140.0
2002-11-14 16:00:00	AMZN	Stock	1.0605	1.065	1.0585	1.0595	3247940.0
2002-11-14 17:00:00	AMZN	Stock	1.06	1.0625	1.06	1.06	456000.0
2002-11-14 18:00:00	AMZN	Stock	1.0625	1.0625	1.0595	1.0595	56140.0
2002-11-14 09:00:00	CL	Stock	26.375	26.39	26.14	26.155	589200.0
2002-11-14 10:00:00	CL	Stock	26.16	26.345	26.125	26.29	697000.0
2002-11-14 11:00:00	CL	Stock	26.26	26.295	26.125	26.155	468600.0
2002-11-14 12:00:00	CL	Stock	26.155	26.39	26.03	26.335	599200.0
2002-11-14 13:00:00	CL	Stock	26.335	26.43	26.31	26.31	621200.0
2002-11-14 14:00:00	CL	Stock	26.315	26.44	26.25	26.42	327600.0
2002-11-14 15:00:00	CL	Stock	26.41	26.455	26.305	26.43	651000.0

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

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