PREVIEW / stock_1hour / 2007-12-05

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-12-05.parquet
  size:    813 KB
  rows:    40,414
  symbols: 3,203

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-12-05 04:00:00	AAPL	Stock	6.4636	6.4636	6.4636	6.4636	33600.0
2007-12-05 05:00:00	AAPL	Stock	6.4718	6.4718	6.4718	6.4718	2800.0
2007-12-05 06:00:00	AAPL	Stock	6.4821	6.4821	6.4811	6.4821	33600.0
2007-12-05 07:00:00	AAPL	Stock	6.5	6.5004	6.4814	6.4911	244244.0
2007-12-05 08:00:00	AAPL	Stock	6.4893	6.5375	6.4218	6.5268	7271908.0
2007-12-05 09:00:00	AAPL	Stock	6.5268	6.5589	6.5146	6.5575	125798344.0
2007-12-05 10:00:00	AAPL	Stock	6.5571	6.5943	6.5471	6.5889	132150368.0
2007-12-05 11:00:00	AAPL	Stock	6.5889	6.6368	6.5771	6.6286	129060260.0
2007-12-05 12:00:00	AAPL	Stock	6.6286	6.6429	6.5986	6.6018	119864192.0
2007-12-05 13:00:00	AAPL	Stock	6.6007	6.6161	6.5675	6.5961	109514888.0
2007-12-05 14:00:00	AAPL	Stock	6.5961	6.6032	6.5461	6.5675	111809936.0
2007-12-05 15:00:00	AAPL	Stock	6.5682	6.6318	6.5589	6.6232	137138708.0
2007-12-05 16:00:00	AAPL	Stock	6.625	6.6336	6.5782	6.6332	16042348.0
2007-12-05 17:00:00	AAPL	Stock	6.6314	6.6464	6.6025	6.6429	2426424.0
2007-12-05 18:00:00	AAPL	Stock	6.6432	6.6571	6.6429	6.6571	529312.0
2007-12-05 19:00:00	AAPL	Stock	6.6589	6.6739	6.6589	6.6696	547148.0
2007-12-05 06:00:00	MSFT	Stock	32.9	32.9	32.9	32.9	100.0
2007-12-05 07:00:00	MSFT	Stock	32.95	32.97	32.9	32.96	1700.0
2007-12-05 08:00:00	MSFT	Stock	32.96	33.15	32.77	33.15	1079032.0
2007-12-05 09:00:00	MSFT	Stock	33.13	33.47	33.03	33.42	8727350.0
2007-12-05 10:00:00	MSFT	Stock	33.42	33.92	33.42	33.83	11303546.0
2007-12-05 11:00:00	MSFT	Stock	33.84	33.95	33.73	33.91	6495006.0
2007-12-05 12:00:00	MSFT	Stock	33.91	34.01	33.83	33.95	8496499.0
2007-12-05 13:00:00	MSFT	Stock	33.95	34.33	33.87	34.32	10802084.0
2007-12-05 14:00:00	MSFT	Stock	34.32	34.48	34.23	34.27	12723215.0
2007-12-05 15:00:00	MSFT	Stock	34.27	34.52	34.15	34.16	20198107.0
2007-12-05 16:00:00	MSFT	Stock	34.15	34.302	33.24	34.23	5029655.0
2007-12-05 17:00:00	MSFT	Stock	34.24	34.38	33.915	34.33	50024.0
2007-12-05 18:00:00	MSFT	Stock	34.33	34.35	34.26	34.35	7345.0
2007-12-05 19:00:00	MSFT	Stock	34.38	34.42	34.37	34.42	14176.0
2007-12-05 08:00:00	NVDA	Stock	0.8062	0.825	0.8062	0.825	354120.0
2007-12-05 09:00:00	NVDA	Stock	0.8238	0.8375	0.8188	0.8299	82619040.0
2007-12-05 10:00:00	NVDA	Stock	0.8302	0.8515	0.8292	0.851	138554600.0
2007-12-05 11:00:00	NVDA	Stock	0.851	0.8562	0.8495	0.8523	108157960.0
2007-12-05 12:00:00	NVDA	Stock	0.8525	0.8542	0.8408	0.843	85661800.0
2007-12-05 13:00:00	NVDA	Stock	0.843	0.85	0.84	0.85	56431320.0
2007-12-05 14:00:00	NVDA	Stock	0.8498	0.852	0.8325	0.836	74079040.0
2007-12-05 15:00:00	NVDA	Stock	0.8363	0.845	0.8338	0.84	104485320.0
2007-12-05 16:00:00	NVDA	Stock	0.84	0.8454	0.8148	0.8408	15841760.0
2007-12-05 17:00:00	NVDA	Stock	0.8388	0.845	0.8388	0.8443	219600.0
2007-12-05 18:00:00	NVDA	Stock	0.8443	0.8443	0.8443	0.8443	11200.0
2007-12-05 19:00:00	NVDA	Stock	0.8468	0.8498	0.8458	0.8498	112000.0
2007-12-05 07:00:00	AMZN	Stock	4.7765	4.777	4.7765	4.777	23600.0
2007-12-05 08:00:00	AMZN	Stock	4.7255	4.795	4.725	4.7645	1023660.0
2007-12-05 09:00:00	AMZN	Stock	4.7615	4.7615	4.6515	4.6734	24375540.0
2007-12-05 10:00:00	AMZN	Stock	4.672	4.704	4.639	4.7	24420160.0
2007-12-05 11:00:00	AMZN	Stock	4.7	4.707	4.64	4.647	16216360.0
2007-12-05 12:00:00	AMZN	Stock	4.647	4.675	4.628	4.653	15591920.0
2007-12-05 13:00:00	AMZN	Stock	4.6525	4.661	4.628	4.633	13015300.0
2007-12-05 14:00:00	AMZN	Stock	4.633	4.6395	4.599	4.612	16087740.0

> showing 50 of 40,414 rows — these rows as CSV

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