PREVIEW / stock_1hour / 2006-09-15

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-09-15.parquet
  size:    642 KB
  rows:    30,263
  symbols: 2,342

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-15 08:00:00	AAPL	Stock	2.6489	2.6654	2.6489	2.6639	3481576.0
2006-09-15 09:00:00	AAPL	Stock	2.6639	2.6786	2.6496	2.6657	279333068.0
2006-09-15 10:00:00	AAPL	Stock	2.6657	2.6725	2.6293	2.6368	163130632.0
2006-09-15 11:00:00	AAPL	Stock	2.6368	2.6496	2.6175	2.645	136020360.0
2006-09-15 12:00:00	AAPL	Stock	2.645	2.6571	2.6375	2.6429	105330932.0
2006-09-15 13:00:00	AAPL	Stock	2.6429	2.6625	2.6425	2.6579	87880632.0
2006-09-15 14:00:00	AAPL	Stock	2.6579	2.6625	2.65	2.6511	55641348.0
2006-09-15 15:00:00	AAPL	Stock	2.6511	2.6579	2.6421	2.6439	110952044.0
2006-09-15 16:00:00	AAPL	Stock	2.6436	2.6471	2.6429	2.6461	14632632.0
2006-09-15 17:00:00	AAPL	Stock	2.6461	2.6467	2.6432	2.645	1066660.0
2006-09-15 18:00:00	AAPL	Stock	2.6436	2.6464	2.6436	2.6436	221900.0
2006-09-15 06:00:00	MSFT	Stock	26.3	26.35	26.3	26.35	1600.0
2006-09-15 07:00:00	MSFT	Stock	26.38	26.48	26.36	26.48	21075.0
2006-09-15 08:00:00	MSFT	Stock	26.44	26.64	26.43	26.62	965097.0
2006-09-15 09:00:00	MSFT	Stock	26.62	26.8	26.49	26.73	38914899.0
2006-09-15 10:00:00	MSFT	Stock	26.74	26.94	26.55	26.83	16098869.0
2006-09-15 11:00:00	MSFT	Stock	26.84	26.89	26.83	26.86	6066238.0
2006-09-15 12:00:00	MSFT	Stock	26.86	26.9	26.78	26.79	6401599.0
2006-09-15 13:00:00	MSFT	Stock	26.78	26.92	26.78	26.9	10189642.0
2006-09-15 14:00:00	MSFT	Stock	26.9	26.94	26.83	26.91	8006711.0
2006-09-15 15:00:00	MSFT	Stock	26.91	26.92	26.72	26.82	22792096.0
2006-09-15 16:00:00	MSFT	Stock	26.8	26.86	25.94	26.77	3266562.0
2006-09-15 17:00:00	MSFT	Stock	26.831	26.849	26.74	26.74	690177.0
2006-09-15 18:00:00	MSFT	Stock	26.74	26.78	26.74	26.78	4000.0
2006-09-15 08:00:00	NVDA	Stock	0.483	0.4922	0.483	0.4918	433020.0
2006-09-15 09:00:00	NVDA	Stock	0.4925	0.4943	0.4825	0.4877	173348880.0
2006-09-15 10:00:00	NVDA	Stock	0.4877	0.495	0.4855	0.4903	128918640.0
2006-09-15 11:00:00	NVDA	Stock	0.4903	0.4933	0.4873	0.4917	72312300.0
2006-09-15 12:00:00	NVDA	Stock	0.4917	0.4922	0.4877	0.488	59367420.0
2006-09-15 13:00:00	NVDA	Stock	0.4878	0.4937	0.4878	0.4932	52075620.0
2006-09-15 14:00:00	NVDA	Stock	0.4933	0.4947	0.4905	0.4917	43383120.0
2006-09-15 15:00:00	NVDA	Stock	0.4918	0.4938	0.4908	0.4928	91319580.0
2006-09-15 16:00:00	NVDA	Stock	0.4923	0.494	0.4917	0.494	1345140.0
2006-09-15 17:00:00	NVDA	Stock	0.4925	0.4928	0.4925	0.4926	3479880.0
2006-09-15 18:00:00	NVDA	Stock	0.494	0.494	0.494	0.494	24000.0
2006-09-15 08:00:00	AMZN	Stock	1.587	1.6	1.587	1.6	48000.0
2006-09-15 09:00:00	AMZN	Stock	1.5975	1.6125	1.5925	1.602	39914040.0
2006-09-15 10:00:00	AMZN	Stock	1.602	1.62	1.597	1.6	18462100.0
2006-09-15 11:00:00	AMZN	Stock	1.6005	1.6035	1.5802	1.5835	16677100.0
2006-09-15 12:00:00	AMZN	Stock	1.583	1.6015	1.579	1.597	17375160.0
2006-09-15 13:00:00	AMZN	Stock	1.5965	1.621	1.5965	1.616	27413120.0
2006-09-15 14:00:00	AMZN	Stock	1.6165	1.624	1.616	1.618	17214380.0
2006-09-15 15:00:00	AMZN	Stock	1.6185	1.637	1.6185	1.6275	50674680.0
2006-09-15 16:00:00	AMZN	Stock	1.6255	1.6285	1.6225	1.625	1224800.0
2006-09-15 17:00:00	AMZN	Stock	1.6256	1.6258	1.6235	1.6235	1938760.0
2006-09-15 08:00:00	CL	Stock	30.89	30.89	30.89	30.89	133800.0
2006-09-15 09:00:00	CL	Stock	30.95	31.045	30.88	31.025	1150400.0
2006-09-15 10:00:00	CL	Stock	31.0245	31.03	30.875	30.9	640000.0
2006-09-15 11:00:00	CL	Stock	30.9	30.935	30.84	30.92	517000.0
2006-09-15 12:00:00	CL	Stock	30.915	30.97	30.87	30.955	261800.0

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

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