PREVIEW / stock_1hour / 2006-09-27

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-09-27.parquet
  size:    610 KB
  rows:    29,180
  symbols: 2,375

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
2006-09-27 04:00:00	AAPL	Stock	2.7661	2.7661	2.7661	2.7661	3920.0
2006-09-27 07:00:00	AAPL	Stock	2.7843	2.7843	2.7829	2.7829	16800.0
2006-09-27 08:00:00	AAPL	Stock	2.7829	2.7889	2.7496	2.75	10216780.0
2006-09-27 09:00:00	AAPL	Stock	2.7507	2.7668	2.7339	2.7464	142417548.0
2006-09-27 10:00:00	AAPL	Stock	2.7464	2.7532	2.7164	2.7332	197784048.0
2006-09-27 11:00:00	AAPL	Stock	2.7336	2.7368	2.7229	2.7332	93471560.0
2006-09-27 12:00:00	AAPL	Stock	2.7332	2.7386	2.7229	2.7311	75673360.0
2006-09-27 13:00:00	AAPL	Stock	2.7311	2.735	2.7161	2.7265	67169060.0
2006-09-27 14:00:00	AAPL	Stock	2.7268	2.7314	2.7079	2.7189	102006072.0
2006-09-27 15:00:00	AAPL	Stock	2.7189	2.7325	2.7121	2.7275	110322912.0
2006-09-27 16:00:00	AAPL	Stock	2.7289	2.7293	2.7261	2.7289	2708804.0
2006-09-27 17:00:00	AAPL	Stock	2.7289	2.7304	2.7243	2.725	150808.0
2006-09-27 18:00:00	AAPL	Stock	2.7268	2.7286	2.7268	2.7282	180768.0
2006-09-27 19:00:00	AAPL	Stock	2.7254	2.7254	2.7236	2.7236	97300.0
2006-09-27 07:00:00	MSFT	Stock	27.24	27.24	27.24	27.24	100.0
2006-09-27 08:00:00	MSFT	Stock	27.25	27.29	27.17	27.18	492684.0
2006-09-27 09:00:00	MSFT	Stock	27.18	27.39	27.09	27.38	5422408.0
2006-09-27 10:00:00	MSFT	Stock	27.38	27.44	27.29	27.35	11937908.0
2006-09-27 11:00:00	MSFT	Stock	27.35	27.37	27.26	27.348	5317399.0
2006-09-27 12:00:00	MSFT	Stock	27.35	27.42	27.32	27.38	6863189.0
2006-09-27 13:00:00	MSFT	Stock	27.37	27.45	27.32	27.35	8149691.0
2006-09-27 14:00:00	MSFT	Stock	27.35	27.38	27.3	27.37	9830356.0
2006-09-27 15:00:00	MSFT	Stock	27.37	27.47	27.3	27.46	16222767.0
2006-09-27 16:00:00	MSFT	Stock	27.46	27.72	27.45	27.68	870352.0
2006-09-27 17:00:00	MSFT	Stock	27.65	27.69	27.62	27.63	10042.0
2006-09-27 18:00:00	MSFT	Stock	27.63	27.63	27.59	27.61	20600.0
2006-09-27 19:00:00	MSFT	Stock	27.61	27.62	27.6	27.62	4061.0
2006-09-27 08:00:00	NVDA	Stock	0.5002	0.5055	0.5	0.5	356040.0
2006-09-27 09:00:00	NVDA	Stock	0.4987	0.5118	0.4985	0.5087	75522000.0
2006-09-27 10:00:00	NVDA	Stock	0.5088	0.5183	0.5088	0.5142	114820260.0
2006-09-27 11:00:00	NVDA	Stock	0.5141	0.516	0.512	0.5132	52765380.0
2006-09-27 12:00:00	NVDA	Stock	0.5133	0.5152	0.5105	0.5107	37739040.0
2006-09-27 13:00:00	NVDA	Stock	0.5107	0.5118	0.5058	0.509	48446160.0
2006-09-27 14:00:00	NVDA	Stock	0.5092	0.51	0.5007	0.5013	84623940.0
2006-09-27 15:00:00	NVDA	Stock	0.5012	0.5047	0.4975	0.5022	146879280.0
2006-09-27 16:00:00	NVDA	Stock	0.5022	0.5045	0.5008	0.5028	6287100.0
2006-09-27 17:00:00	NVDA	Stock	0.5017	0.5017	0.5007	0.5007	42000.0
2006-09-27 08:00:00	AMZN	Stock	1.6215	1.6215	1.611	1.613	66000.0
2006-09-27 09:00:00	AMZN	Stock	1.613	1.623	1.605	1.611	13197520.0
2006-09-27 10:00:00	AMZN	Stock	1.6115	1.621	1.5965	1.608	19800500.0
2006-09-27 11:00:00	AMZN	Stock	1.608	1.623	1.5965	1.6155	15217240.0
2006-09-27 12:00:00	AMZN	Stock	1.6155	1.619	1.6055	1.6105	7503480.0
2006-09-27 13:00:00	AMZN	Stock	1.611	1.614	1.5985	1.6095	9127820.0
2006-09-27 14:00:00	AMZN	Stock	1.6095	1.6147	1.6045	1.606	15749780.0
2006-09-27 15:00:00	AMZN	Stock	1.606	1.6225	1.601	1.619	23838900.0
2006-09-27 16:00:00	AMZN	Stock	1.62	1.6375	1.6165	1.6165	221340.0
2006-09-27 17:00:00	AMZN	Stock	1.6315	1.6345	1.625	1.625	10000.0
2006-09-27 08:00:00	CL	Stock	31.18	31.18	31.18	31.18	119200.0
2006-09-27 09:00:00	CL	Stock	31.065	31.13	30.955	31.04	289200.0
2006-09-27 10:00:00	CL	Stock	31.05	31.155	31.02	31.1045	402000.0

> showing 50 of 29,180 rows — these rows as CSV

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