PREVIEW / stock_1hour / 2007-02-06

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-02-06.parquet
  size:    654 KB
  rows:    31,365
  symbols: 2,502

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-02-06 06:00:00	AAPL	Stock	3.0089	3.0114	3.0089	3.0114	8400.0
2007-02-06 07:00:00	AAPL	Stock	3.0125	3.0125	3.0096	3.0096	18760.0
2007-02-06 08:00:00	AAPL	Stock	3.0107	3.0171	3.0018	3.0036	1825152.0
2007-02-06 09:00:00	AAPL	Stock	3.0036	3.0168	2.9929	2.9975	83256264.0
2007-02-06 10:00:00	AAPL	Stock	2.9971	3.0161	2.9804	2.9814	138051144.0
2007-02-06 11:00:00	AAPL	Stock	2.9818	3.0039	2.9657	2.9661	114052400.0
2007-02-06 12:00:00	AAPL	Stock	2.9661	3.0007	2.9593	2.9725	98428484.0
2007-02-06 13:00:00	AAPL	Stock	2.9725	2.9829	2.9714	2.9782	62907040.0
2007-02-06 14:00:00	AAPL	Stock	2.9782	2.9839	2.9693	2.9839	65116828.0
2007-02-06 15:00:00	AAPL	Stock	2.9839	3.0161	2.9825	3.0032	288457344.0
2007-02-06 16:00:00	AAPL	Stock	3.0029	3.0114	2.9964	3.0114	4366964.0
2007-02-06 17:00:00	AAPL	Stock	3.0093	3.0139	3.0061	3.0125	1000412.0
2007-02-06 18:00:00	AAPL	Stock	3.0107	3.0129	3.0089	3.0118	428120.0
2007-02-06 19:00:00	AAPL	Stock	3.0096	3.0136	3.0086	3.0129	294924.0
2007-02-06 08:00:00	MSFT	Stock	29.58	29.6	29.5	29.54	25745.0
2007-02-06 09:00:00	MSFT	Stock	29.54	29.75	29.49	29.62	10738821.0
2007-02-06 10:00:00	MSFT	Stock	29.63	29.68	29.51	29.51	13369002.0
2007-02-06 11:00:00	MSFT	Stock	29.52	29.54	29.42	29.42	10333396.0
2007-02-06 12:00:00	MSFT	Stock	29.42	29.49	29.22	29.25	11349670.0
2007-02-06 13:00:00	MSFT	Stock	29.25	29.48	29.24	29.42	10513692.0
2007-02-06 14:00:00	MSFT	Stock	29.43	29.55	29.39	29.52	8929744.0
2007-02-06 15:00:00	MSFT	Stock	29.53	29.6	29.46	29.5	11460864.0
2007-02-06 16:00:00	MSFT	Stock	29.51	29.579	29.45	29.56	320626.0
2007-02-06 17:00:00	MSFT	Stock	29.56	29.58	29.55	29.56	11214.0
2007-02-06 18:00:00	MSFT	Stock	29.56	29.59	29.51	29.56	371100.0
2007-02-06 19:00:00	MSFT	Stock	29.56	29.58	29.56	29.56	6088.0
2007-02-06 08:00:00	NVDA	Stock	0.5488	0.558	0.5473	0.555	1605900.0
2007-02-06 09:00:00	NVDA	Stock	0.5542	0.5657	0.5503	0.559	127026840.0
2007-02-06 10:00:00	NVDA	Stock	0.559	0.5593	0.5435	0.5443	181487700.0
2007-02-06 11:00:00	NVDA	Stock	0.5443	0.5523	0.5437	0.5512	105878160.0
2007-02-06 12:00:00	NVDA	Stock	0.5512	0.5557	0.5509	0.5538	63962160.0
2007-02-06 13:00:00	NVDA	Stock	0.5538	0.5597	0.5535	0.5587	69292080.0
2007-02-06 14:00:00	NVDA	Stock	0.5587	0.5605	0.5547	0.5602	70110960.0
2007-02-06 15:00:00	NVDA	Stock	0.5603	0.5625	0.5578	0.5585	102964320.0
2007-02-06 16:00:00	NVDA	Stock	0.558	0.5603	0.5567	0.5595	643380.0
2007-02-06 17:00:00	NVDA	Stock	0.5595	0.5615	0.5588	0.5615	324000.0
2007-02-06 18:00:00	NVDA	Stock	0.5613	0.5615	0.5613	0.5615	127800.0
2007-02-06 19:00:00	NVDA	Stock	0.5615	0.562	0.5615	0.562	93000.0
2007-02-06 09:00:00	AMZN	Stock	1.8545	1.87	1.8542	1.86	14845660.0
2007-02-06 10:00:00	AMZN	Stock	1.8605	1.872	1.8585	1.862	22439820.0
2007-02-06 11:00:00	AMZN	Stock	1.862	1.8705	1.862	1.864	15092760.0
2007-02-06 12:00:00	AMZN	Stock	1.8645	1.879	1.864	1.877	12394820.0
2007-02-06 13:00:00	AMZN	Stock	1.8775	1.89	1.877	1.8845	15084980.0
2007-02-06 14:00:00	AMZN	Stock	1.8845	1.9	1.881	1.8985	21127980.0
2007-02-06 15:00:00	AMZN	Stock	1.8985	1.9205	1.8965	1.9105	63649560.0
2007-02-06 16:00:00	AMZN	Stock	1.9115	1.92	1.91	1.92	351980.0
2007-02-06 17:00:00	AMZN	Stock	1.92	1.925	1.914	1.9145	275480.0
2007-02-06 18:00:00	AMZN	Stock	1.9155	1.9155	1.9155	1.9155	10000.0
2007-02-06 09:00:00	CL	Stock	33.62	33.865	33.565	33.79	408200.0
2007-02-06 10:00:00	CL	Stock	33.79	33.7945	33.51	33.51	725600.0

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

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