PREVIEW / stock_1hour / 2001-09-10

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-09-10.parquet
  size:    358 KB
  rows:    17,364
  symbols: 1,330

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
2001-09-10 08:00:00	AAPL	Stock	0.3089	0.3089	0.3045	0.3054	201600.0
2001-09-10 09:00:00	AAPL	Stock	0.3057	0.3088	0.3021	0.3068	45276000.0
2001-09-10 10:00:00	AAPL	Stock	0.3068	0.3109	0.3036	0.31	50209600.0
2001-09-10 11:00:00	AAPL	Stock	0.31	0.3107	0.3071	0.3091	21772800.0
2001-09-10 12:00:00	AAPL	Stock	0.3089	0.3123	0.3075	0.3111	63644000.0
2001-09-10 13:00:00	AAPL	Stock	0.3114	0.3114	0.3071	0.3104	18771200.0
2001-09-10 14:00:00	AAPL	Stock	0.3105	0.3118	0.3084	0.3098	20484800.0
2001-09-10 15:00:00	AAPL	Stock	0.31	0.3116	0.3071	0.3102	46860800.0
2001-09-10 16:00:00	AAPL	Stock	0.3102	0.3136	0.3093	0.3102	10466400.0
2001-09-10 17:00:00	AAPL	Stock	0.3082	0.3083	0.3082	0.3083	621600.0
2001-09-10 08:00:00	MSFT	Stock	27.35	27.7025	27.25	27.4	127400.0
2001-09-10 09:00:00	MSFT	Stock	27.45	27.9795	27.35	27.85	11163600.0
2001-09-10 10:00:00	MSFT	Stock	27.845	27.925	27.5	27.885	12299000.0
2001-09-10 11:00:00	MSFT	Stock	27.89	28.5305	27.7895	28.375	12905800.0
2001-09-10 12:00:00	MSFT	Stock	28.375	28.475	28.225	28.26	8243000.0
2001-09-10 13:00:00	MSFT	Stock	28.275	28.525	28.2	28.5005	6806600.0
2001-09-10 14:00:00	MSFT	Stock	28.515	28.8	28.375	28.66	9004800.0
2001-09-10 15:00:00	MSFT	Stock	28.675	28.975	28.35	28.79	15806600.0
2001-09-10 16:00:00	MSFT	Stock	28.79	28.875	28.255	28.865	1368200.0
2001-09-10 17:00:00	MSFT	Stock	28.81	28.875	28.6202	28.875	335400.0
2001-09-10 18:00:00	MSFT	Stock	28.85	28.85	28.85	28.85	3000.0
2001-09-10 08:00:00	NVDA	Stock	0.3253	0.3253	0.3204	0.3208	5784000.0
2001-09-10 09:00:00	NVDA	Stock	0.3208	0.3273	0.3199	0.3251	248712000.0
2001-09-10 10:00:00	NVDA	Stock	0.325	0.3258	0.3136	0.3203	531024000.0
2001-09-10 11:00:00	NVDA	Stock	0.3198	0.3223	0.3156	0.3185	241608000.0
2001-09-10 12:00:00	NVDA	Stock	0.3187	0.3195	0.3152	0.3153	82080000.0
2001-09-10 13:00:00	NVDA	Stock	0.3152	0.3158	0.3091	0.3104	205032000.0
2001-09-10 14:00:00	NVDA	Stock	0.3112	0.3163	0.3104	0.313	233184000.0
2001-09-10 15:00:00	NVDA	Stock	0.3133	0.3168	0.3108	0.3156	239880000.0
2001-09-10 16:00:00	NVDA	Stock	0.3156	0.317	0.315	0.3167	19368000.0
2001-09-10 17:00:00	NVDA	Stock	0.3166	0.3166	0.3166	0.3166	216000.0
2001-09-10 18:00:00	NVDA	Stock	0.3167	0.3167	0.3166	0.3166	168000.0
2001-09-10 08:00:00	AMZN	Stock	0.4155	0.4195	0.4025	0.409	346000.0
2001-09-10 09:00:00	AMZN	Stock	0.4125	0.4205	0.4095	0.417	11354000.0
2001-09-10 10:00:00	AMZN	Stock	0.417	0.421	0.411	0.421	19528000.0
2001-09-10 11:00:00	AMZN	Stock	0.421	0.426	0.42	0.424	10908000.0
2001-09-10 12:00:00	AMZN	Stock	0.423	0.4235	0.403	0.4035	6364000.0
2001-09-10 13:00:00	AMZN	Stock	0.403	0.412	0.403	0.4085	10574000.0
2001-09-10 14:00:00	AMZN	Stock	0.4075	0.414	0.405	0.4135	13294000.0
2001-09-10 15:00:00	AMZN	Stock	0.414	0.4325	0.4125	0.432	32764000.0
2001-09-10 16:00:00	AMZN	Stock	0.4315	0.4325	0.43	0.43	4134000.0
2001-09-10 17:00:00	AMZN	Stock	0.432	0.432	0.432	0.432	2000.0
2001-09-10 09:00:00	CL	Stock	27.925	27.975	27.75	27.87	683400.0
2001-09-10 10:00:00	CL	Stock	27.87	28.315	27.77	28.315	955000.0
2001-09-10 11:00:00	CL	Stock	28.31	28.495	28.175	28.475	481200.0
2001-09-10 12:00:00	CL	Stock	28.49	28.625	28.49	28.545	367000.0
2001-09-10 13:00:00	CL	Stock	28.545	28.65	28.5	28.64	420400.0
2001-09-10 14:00:00	CL	Stock	28.65	28.685	28.535	28.63	370200.0
2001-09-10 15:00:00	CL	Stock	28.63	28.715	28.595	28.63	819200.0
2001-09-10 16:00:00	CL	Stock	28.63	28.63	28.63	28.63	74200.0

> showing 50 of 17,364 rows — these rows as CSV

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