PREVIEW / stock_1hour / 2007-01-23

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-01-23.parquet
  size:    658 KB
  rows:    31,405
  symbols: 2,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
2007-01-23 05:00:00	AAPL	Stock	3.0932	3.0932	3.0932	3.0932	28000.0
2007-01-23 06:00:00	AAPL	Stock	3.0932	3.0932	3.0911	3.0932	28000.0
2007-01-23 07:00:00	AAPL	Stock	3.0914	3.0914	3.0489	3.0557	890680.0
2007-01-23 08:00:00	AAPL	Stock	3.0571	3.0786	3.0554	3.0714	10170300.0
2007-01-23 09:00:00	AAPL	Stock	3.0714	3.1125	3.0539	3.09	252341880.0
2007-01-23 10:00:00	AAPL	Stock	3.0914	3.0943	3.0596	3.0936	225521884.0
2007-01-23 11:00:00	AAPL	Stock	3.0921	3.1254	3.0896	3.1186	221690868.0
2007-01-23 12:00:00	AAPL	Stock	3.1185	3.1246	3.1079	3.1143	105731360.0
2007-01-23 13:00:00	AAPL	Stock	3.1136	3.1207	3.095	3.097	79633484.0
2007-01-23 14:00:00	AAPL	Stock	3.0971	3.1021	3.0661	3.0768	148201620.0
2007-01-23 15:00:00	AAPL	Stock	3.0764	3.0806	3.0554	3.0604	149581460.0
2007-01-23 16:00:00	AAPL	Stock	3.0625	3.0732	3.0604	3.0625	2078160.0
2007-01-23 17:00:00	AAPL	Stock	3.0625	3.0761	3.0607	3.0761	1092000.0
2007-01-23 18:00:00	AAPL	Stock	3.0764	3.0782	3.0606	3.0754	837648.0
2007-01-23 19:00:00	AAPL	Stock	3.0754	3.0779	3.0721	3.0732	171052.0
2007-01-23 07:00:00	MSFT	Stock	30.68	30.68	30.68	30.68	100.0
2007-01-23 08:00:00	MSFT	Stock	30.67	30.67	30.62	30.65	4050.0
2007-01-23 09:00:00	MSFT	Stock	30.66	30.9	30.52	30.88	5442075.0
2007-01-23 10:00:00	MSFT	Stock	30.89	30.89	30.69	30.72	6711154.0
2007-01-23 11:00:00	MSFT	Stock	30.71	30.76	30.67	30.75	6286681.0
2007-01-23 12:00:00	MSFT	Stock	30.74	30.77	30.65	30.73	5340667.0
2007-01-23 13:00:00	MSFT	Stock	30.72	30.92	30.72	30.9	6606799.0
2007-01-23 14:00:00	MSFT	Stock	30.91	30.96	30.66	30.72	7173346.0
2007-01-23 15:00:00	MSFT	Stock	30.72	30.87	30.72	30.75	7747503.0
2007-01-23 16:00:00	MSFT	Stock	30.75	30.798	30.69	30.71	104485.0
2007-01-23 17:00:00	MSFT	Stock	30.71	30.77	30.71	30.77	4390.0
2007-01-23 18:00:00	MSFT	Stock	30.77	30.82	30.738	30.82	9788.0
2007-01-23 19:00:00	MSFT	Stock	30.82	30.82	30.8	30.8	1021.0
2007-01-23 08:00:00	NVDA	Stock	0.5292	0.5292	0.525	0.5267	1119720.0
2007-01-23 09:00:00	NVDA	Stock	0.526	0.5312	0.519	0.5306	69961740.0
2007-01-23 10:00:00	NVDA	Stock	0.5303	0.5307	0.523	0.5277	63176220.0
2007-01-23 11:00:00	NVDA	Stock	0.5277	0.533	0.5273	0.531	70516260.0
2007-01-23 12:00:00	NVDA	Stock	0.531	0.5363	0.5303	0.5355	73339800.0
2007-01-23 13:00:00	NVDA	Stock	0.5356	0.54	0.5356	0.539	80312580.0
2007-01-23 14:00:00	NVDA	Stock	0.539	0.5393	0.5303	0.535	111370140.0
2007-01-23 15:00:00	NVDA	Stock	0.5352	0.5368	0.5295	0.5312	145183440.0
2007-01-23 16:00:00	NVDA	Stock	0.5315	0.5315	0.5267	0.5295	741840.0
2007-01-23 17:00:00	NVDA	Stock	0.5295	0.5305	0.5295	0.5305	21000.0
2007-01-23 18:00:00	NVDA	Stock	0.5285	0.5315	0.5283	0.5315	237300.0
2007-01-23 09:00:00	AMZN	Stock	1.836	1.8535	1.8305	1.846	12974760.0
2007-01-23 10:00:00	AMZN	Stock	1.8465	1.8465	1.815	1.818	23890300.0
2007-01-23 11:00:00	AMZN	Stock	1.8175	1.85	1.816	1.8465	14747400.0
2007-01-23 12:00:00	AMZN	Stock	1.8465	1.8465	1.8325	1.842	9309060.0
2007-01-23 13:00:00	AMZN	Stock	1.8425	1.844	1.831	1.8345	6690860.0
2007-01-23 14:00:00	AMZN	Stock	1.834	1.8355	1.815	1.825	14119100.0
2007-01-23 15:00:00	AMZN	Stock	1.825	1.829	1.8195	1.8215	19537620.0
2007-01-23 16:00:00	AMZN	Stock	1.8215	1.8245	1.8155	1.8155	387740.0
2007-01-23 17:00:00	AMZN	Stock	1.8375	1.8375	1.8375	1.8375	5300.0
2007-01-23 18:00:00	AMZN	Stock	1.837	1.8375	1.8215	1.8215	29140.0
2007-01-23 08:00:00	CL	Stock	33.26	33.26	33.26	33.26	165400.0

> showing 50 of 31,405 rows — these rows as CSV

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