PREVIEW / stock_1hour / 2006-10-17

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-10-17.parquet
  size:    617 KB
  rows:    29,336
  symbols: 2,392

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-10-17 06:00:00	AAPL	Stock	2.6864	2.6864	2.6864	2.6864	2800.0
2006-10-17 08:00:00	AAPL	Stock	2.6839	2.6861	2.6757	2.6786	1238076.0
2006-10-17 09:00:00	AAPL	Stock	2.68	2.6882	2.6671	2.6739	55378988.0
2006-10-17 10:00:00	AAPL	Stock	2.6739	2.6764	2.6571	2.6618	81917472.0
2006-10-17 11:00:00	AAPL	Stock	2.6618	2.6679	2.6443	2.6532	91838572.0
2006-10-17 12:00:00	AAPL	Stock	2.6532	2.6643	2.65	2.6621	42056672.0
2006-10-17 13:00:00	AAPL	Stock	2.6625	2.6675	2.6518	2.6636	57863512.0
2006-10-17 14:00:00	AAPL	Stock	2.6639	2.6646	2.6536	2.6561	67350472.0
2006-10-17 15:00:00	AAPL	Stock	2.6564	2.6639	2.6518	2.6529	77415576.0
2006-10-17 16:00:00	AAPL	Stock	2.6529	2.6554	2.6479	2.6482	1408372.0
2006-10-17 17:00:00	AAPL	Stock	2.6468	2.6571	2.6464	2.6557	1289120.0
2006-10-17 18:00:00	AAPL	Stock	2.6557	2.6571	2.6543	2.6561	186564.0
2006-10-17 04:00:00	MSFT	Stock	28.35	28.35	28.35	28.35	300.0
2006-10-17 07:00:00	MSFT	Stock	28.37	28.7	28.37	28.42	6686.0
2006-10-17 08:00:00	MSFT	Stock	28.38	28.41	28.27	28.27	306836.0
2006-10-17 09:00:00	MSFT	Stock	28.3	28.36	28.17	28.3	5750392.0
2006-10-17 10:00:00	MSFT	Stock	28.31	28.35	28.25	28.28	5449346.0
2006-10-17 11:00:00	MSFT	Stock	28.28	28.28	28.21	28.25	4986582.0
2006-10-17 12:00:00	MSFT	Stock	28.26	28.39	28.25	28.35	3130179.0
2006-10-17 13:00:00	MSFT	Stock	28.357	28.39	28.27	28.36	4289743.0
2006-10-17 14:00:00	MSFT	Stock	28.35	28.49	28.32	28.43	4542108.0
2006-10-17 15:00:00	MSFT	Stock	28.43	28.51	28.39	28.49	9983005.0
2006-10-17 16:00:00	MSFT	Stock	28.49	28.57	28.43	28.51	717683.0
2006-10-17 17:00:00	MSFT	Stock	28.51	28.58	28.51	28.58	26130.0
2006-10-17 18:00:00	MSFT	Stock	28.55	28.55	28.47	28.47	4400.0
2006-10-17 19:00:00	MSFT	Stock	28.49	28.49	28.49	28.49	100.0
2006-10-17 08:00:00	NVDA	Stock	0.5572	0.5572	0.554	0.554	591000.0
2006-10-17 09:00:00	NVDA	Stock	0.5555	0.5577	0.5427	0.5438	79927800.0
2006-10-17 10:00:00	NVDA	Stock	0.5438	0.5458	0.5382	0.5418	106558200.0
2006-10-17 11:00:00	NVDA	Stock	0.5418	0.5433	0.5358	0.5358	70638180.0
2006-10-17 12:00:00	NVDA	Stock	0.5358	0.5425	0.535	0.5413	70135560.0
2006-10-17 13:00:00	NVDA	Stock	0.5413	0.5453	0.541	0.544	45416280.0
2006-10-17 14:00:00	NVDA	Stock	0.5438	0.5447	0.5392	0.5417	44822040.0
2006-10-17 15:00:00	NVDA	Stock	0.5418	0.5462	0.5387	0.54	91343400.0
2006-10-17 16:00:00	NVDA	Stock	0.5408	0.5442	0.5395	0.54	689340.0
2006-10-17 17:00:00	NVDA	Stock	0.5417	0.5417	0.5415	0.5415	40560.0
2006-10-17 18:00:00	NVDA	Stock	0.5415	0.5415	0.5403	0.5403	30000.0
2006-10-17 19:00:00	NVDA	Stock	0.5425	0.5428	0.5425	0.5428	114000.0
2006-10-17 08:00:00	AMZN	Stock	1.62	1.625	1.6155	1.6205	106500.0
2006-10-17 09:00:00	AMZN	Stock	1.62	1.62	1.6045	1.606	12446640.0
2006-10-17 10:00:00	AMZN	Stock	1.6055	1.6075	1.5875	1.594	20556100.0
2006-10-17 11:00:00	AMZN	Stock	1.594	1.6115	1.5925	1.605	23611940.0
2006-10-17 12:00:00	AMZN	Stock	1.605	1.6195	1.602	1.6175	9785320.0
2006-10-17 13:00:00	AMZN	Stock	1.617	1.6275	1.6135	1.6205	16632640.0
2006-10-17 14:00:00	AMZN	Stock	1.62	1.622	1.6055	1.613	18420520.0
2006-10-17 15:00:00	AMZN	Stock	1.6125	1.6305	1.612	1.625	25831880.0
2006-10-17 16:00:00	AMZN	Stock	1.623	1.631	1.6065	1.6175	525760.0
2006-10-17 17:00:00	AMZN	Stock	1.616	1.63	1.615	1.6295	146000.0
2006-10-17 18:00:00	AMZN	Stock	1.629	1.629	1.629	1.629	8000.0
2006-10-17 09:00:00	CL	Stock	29.895	29.895	29.675	29.86	1267400.0

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

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