PREVIEW / stock_1hour / 2001-07-09

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-07-09.parquet
  size:    360 KB
  rows:    17,166
  symbols: 1,315

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-07-09 08:00:00	AAPL	Stock	0.3932	0.3964	0.3932	0.3964	56000.0
2001-07-09 09:00:00	AAPL	Stock	0.3946	0.4082	0.3871	0.4054	43758400.0
2001-07-09 10:00:00	AAPL	Stock	0.4054	0.4107	0.4034	0.4068	83977600.0
2001-07-09 11:00:00	AAPL	Stock	0.407	0.4089	0.4036	0.4052	39076800.0
2001-07-09 12:00:00	AAPL	Stock	0.4052	0.4071	0.4009	0.4057	31175200.0
2001-07-09 13:00:00	AAPL	Stock	0.4055	0.4091	0.405	0.4054	35425600.0
2001-07-09 14:00:00	AAPL	Stock	0.4054	0.4066	0.4009	0.4009	30374400.0
2001-07-09 15:00:00	AAPL	Stock	0.4007	0.4057	0.3982	0.4052	41955200.0
2001-07-09 16:00:00	AAPL	Stock	0.4054	0.4054	0.3946	0.4054	5017600.0
2001-07-09 08:00:00	MSFT	Stock	33.175	33.25	33.0	33.175	60600.0
2001-07-09 09:00:00	MSFT	Stock	33.25	33.25	32.805	32.875	7157200.0
2001-07-09 10:00:00	MSFT	Stock	32.865	33.455	32.785	33.165	11705800.0
2001-07-09 11:00:00	MSFT	Stock	33.165	33.235	32.8	32.915	11897200.0
2001-07-09 12:00:00	MSFT	Stock	32.915	32.93	32.675	32.77	5770200.0
2001-07-09 13:00:00	MSFT	Stock	32.765	33.425	32.745	32.955	6816400.0
2001-07-09 14:00:00	MSFT	Stock	32.96	32.975	32.575	32.635	7650600.0
2001-07-09 15:00:00	MSFT	Stock	32.63	32.89	32.52	32.845	11158600.0
2001-07-09 16:00:00	MSFT	Stock	32.85	32.915	32.625	32.85	1682000.0
2001-07-09 17:00:00	MSFT	Stock	32.76	32.85	32.76	32.825	11800.0
2001-07-09 18:00:00	MSFT	Stock	32.825	32.845	32.825	32.845	2200.0
2001-07-09 08:00:00	NVDA	Stock	0.3383	0.339	0.336	0.3364	3576000.0
2001-07-09 09:00:00	NVDA	Stock	0.3364	0.3383	0.326	0.3304	230328000.0
2001-07-09 10:00:00	NVDA	Stock	0.3304	0.3399	0.3281	0.3343	227304000.0
2001-07-09 11:00:00	NVDA	Stock	0.3344	0.3345	0.3271	0.329	94776000.0
2001-07-09 12:00:00	NVDA	Stock	0.3292	0.3294	0.3221	0.326	109680000.0
2001-07-09 13:00:00	NVDA	Stock	0.3258	0.3306	0.3253	0.3268	73176000.0
2001-07-09 14:00:00	NVDA	Stock	0.327	0.3275	0.324	0.324	99192000.0
2001-07-09 15:00:00	NVDA	Stock	0.324	0.3296	0.3229	0.3255	126888000.0
2001-07-09 16:00:00	NVDA	Stock	0.3253	0.3278	0.3235	0.3253	15456000.0
2001-07-09 17:00:00	NVDA	Stock	0.3242	0.3258	0.3242	0.3253	480000.0
2001-07-09 18:00:00	NVDA	Stock	0.325	0.325	0.325	0.325	48000.0
2001-07-09 08:00:00	AMZN	Stock	0.76	0.765	0.76	0.765	52000.0
2001-07-09 09:00:00	AMZN	Stock	0.7675	0.783	0.7555	0.78	25736000.0
2001-07-09 10:00:00	AMZN	Stock	0.778	0.7915	0.7745	0.787	32922000.0
2001-07-09 11:00:00	AMZN	Stock	0.785	0.7885	0.775	0.785	19654000.0
2001-07-09 12:00:00	AMZN	Stock	0.7835	0.7855	0.7745	0.777	10870000.0
2001-07-09 13:00:00	AMZN	Stock	0.7765	0.7825	0.774	0.7795	10222000.0
2001-07-09 14:00:00	AMZN	Stock	0.7795	0.785	0.777	0.785	11138000.0
2001-07-09 15:00:00	AMZN	Stock	0.7825	0.795	0.779	0.7905	29090000.0
2001-07-09 16:00:00	AMZN	Stock	0.7905	0.7935	0.7875	0.7905	3240000.0
2001-07-09 17:00:00	AMZN	Stock	0.783	0.7905	0.783	0.7905	20000.0
2001-07-09 09:00:00	CL	Stock	29.52	29.535	29.345	29.375	321400.0
2001-07-09 10:00:00	CL	Stock	29.395	29.445	29.245	29.245	808200.0
2001-07-09 11:00:00	CL	Stock	29.245	29.375	29.125	29.35	491600.0
2001-07-09 12:00:00	CL	Stock	29.33	29.33	29.0	29.22	518200.0
2001-07-09 13:00:00	CL	Stock	29.225	29.315	29.01	29.315	289600.0
2001-07-09 14:00:00	CL	Stock	29.315	29.315	29.17	29.17	386400.0
2001-07-09 15:00:00	CL	Stock	29.17	29.245	29.065	29.2	989600.0
2001-07-09 16:00:00	CL	Stock	29.215	29.215	29.215	29.215	17400.0

> showing 49 of 17,166 rows — these rows as CSV

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