PREVIEW / stock_1hour / 2006-12-21

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-12-21.parquet
  size:    635 KB
  rows:    30,270
  symbols: 2,482

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-12-21 07:00:00	AAPL	Stock	3.0071	3.0389	2.9821	3.0318	35000.0
2006-12-21 08:00:00	AAPL	Stock	3.0318	3.0357	3.0243	3.0243	1206940.0
2006-12-21 09:00:00	AAPL	Stock	3.0275	3.0529	3.0114	3.0357	86346372.0
2006-12-21 10:00:00	AAPL	Stock	3.0357	3.0429	3.0132	3.0161	96071668.0
2006-12-21 11:00:00	AAPL	Stock	3.0161	3.0325	3.0014	3.0257	90402032.0
2006-12-21 12:00:00	AAPL	Stock	3.0257	3.0268	2.97	2.9721	139557208.0
2006-12-21 13:00:00	AAPL	Stock	2.9714	2.9796	2.9357	2.9464	212690044.0
2006-12-21 14:00:00	AAPL	Stock	2.9468	2.9846	2.9396	2.9732	135160144.0
2006-12-21 15:00:00	AAPL	Stock	2.9732	2.9793	2.9582	2.9607	116430104.0
2006-12-21 16:00:00	AAPL	Stock	2.9607	2.9821	2.9593	2.9714	8379448.0
2006-12-21 17:00:00	AAPL	Stock	2.9729	2.9729	2.9643	2.9707	583856.0
2006-12-21 18:00:00	AAPL	Stock	2.9607	2.9729	2.9607	2.9729	6667444.0
2006-12-21 19:00:00	AAPL	Stock	2.9725	2.9739	2.9714	2.9725	204708.0
2006-12-21 04:00:00	MSFT	Stock	30.09	30.09	30.09	30.09	100.0
2006-12-21 05:00:00	MSFT	Stock	30.09	30.09	30.09	30.09	200.0
2006-12-21 08:00:00	MSFT	Stock	30.1	30.11	30.07	30.11	12815.0
2006-12-21 09:00:00	MSFT	Stock	30.08	30.14	29.93	30.0	4292037.0
2006-12-21 10:00:00	MSFT	Stock	30.0	30.06	29.89	30.03	4298207.0
2006-12-21 11:00:00	MSFT	Stock	30.04	30.13	30.03	30.08	3332304.0
2006-12-21 12:00:00	MSFT	Stock	30.08	30.09	29.93	29.99	5330431.0
2006-12-21 13:00:00	MSFT	Stock	29.99	30.09	29.95	30.0	3305600.0
2006-12-21 14:00:00	MSFT	Stock	30.0	30.05	29.99	30.04	2992128.0
2006-12-21 15:00:00	MSFT	Stock	30.04	30.14	29.98	29.98	7151181.0
2006-12-21 16:00:00	MSFT	Stock	29.98	29.99	29.92	29.98	56672.0
2006-12-21 17:00:00	MSFT	Stock	30.0	30.0	30.0	30.0	100.0
2006-12-21 19:00:00	MSFT	Stock	29.98	30.01	29.98	30.01	1500.0
2006-12-21 08:00:00	NVDA	Stock	0.6397	0.6397	0.6392	0.6392	120000.0
2006-12-21 09:00:00	NVDA	Stock	0.6397	0.6417	0.6338	0.6352	22106880.0
2006-12-21 10:00:00	NVDA	Stock	0.6353	0.6417	0.634	0.6402	54743160.0
2006-12-21 11:00:00	NVDA	Stock	0.6403	0.643	0.6387	0.6393	43166700.0
2006-12-21 12:00:00	NVDA	Stock	0.6393	0.6401	0.6315	0.6342	52870080.0
2006-12-21 13:00:00	NVDA	Stock	0.634	0.6343	0.6267	0.6272	64829640.0
2006-12-21 14:00:00	NVDA	Stock	0.6272	0.6333	0.625	0.6327	70228740.0
2006-12-21 15:00:00	NVDA	Stock	0.6327	0.6348	0.6318	0.6322	46098840.0
2006-12-21 16:00:00	NVDA	Stock	0.6323	0.6323	0.6292	0.6315	4882800.0
2006-12-21 17:00:00	NVDA	Stock	0.6315	0.6322	0.6313	0.6322	260340.0
2006-12-21 18:00:00	NVDA	Stock	0.6328	0.6328	0.6328	0.6328	12000.0
2006-12-21 19:00:00	NVDA	Stock	0.6322	0.6322	0.6322	0.6322	27000.0
2006-12-21 08:00:00	AMZN	Stock	2.0	2.0	2.0	2.0	4000.0
2006-12-21 09:00:00	AMZN	Stock	2.0	2.015	1.989	1.9925	9634680.0
2006-12-21 10:00:00	AMZN	Stock	1.9925	2.017	1.9925	2.0075	26206580.0
2006-12-21 11:00:00	AMZN	Stock	2.007	2.0095	2.0005	2.001	19301320.0
2006-12-21 12:00:00	AMZN	Stock	2.001	2.0024	1.9825	1.993	18727940.0
2006-12-21 13:00:00	AMZN	Stock	1.9925	1.9975	1.99	1.9925	12219500.0
2006-12-21 14:00:00	AMZN	Stock	1.9925	1.9975	1.9875	1.9945	11703980.0
2006-12-21 15:00:00	AMZN	Stock	1.9955	1.9995	1.99	1.9945	25330540.0
2006-12-21 16:00:00	AMZN	Stock	1.9925	1.9958	1.9925	1.9958	4050280.0
2006-12-21 17:00:00	AMZN	Stock	1.9945	1.9945	1.9945	1.9945	4000.0
2006-12-21 09:00:00	CL	Stock	32.575	32.685	32.505	32.61	348600.0
2006-12-21 10:00:00	CL	Stock	32.61	32.61	32.38	32.39	768800.0

> showing 50 of 30,270 rows — these rows as CSV

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