PREVIEW / stock_1hour / 2005-10-13

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-10-13.parquet
  size:    561 KB
  rows:    26,473
  symbols: 2,087

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
2005-10-13 07:00:00	AAPL	Stock	1.7589	1.7589	1.7589	1.7589	2800.0
2005-10-13 08:00:00	AAPL	Stock	1.7682	1.7775	1.7621	1.7664	2088688.0
2005-10-13 09:00:00	AAPL	Stock	1.7632	1.7896	1.7586	1.775	141996652.0
2005-10-13 10:00:00	AAPL	Stock	1.7746	1.8336	1.7657	1.8214	318904432.0
2005-10-13 11:00:00	AAPL	Stock	1.8214	1.84	1.8196	1.8375	208771136.0
2005-10-13 12:00:00	AAPL	Stock	1.8368	1.8775	1.8361	1.8604	274427608.0
2005-10-13 13:00:00	AAPL	Stock	1.86	1.8825	1.8393	1.8818	179802896.0
2005-10-13 14:00:00	AAPL	Stock	1.8818	1.92	1.875	1.9043	368000304.0
2005-10-13 15:00:00	AAPL	Stock	1.9057	1.9268	1.8929	1.9189	351209040.0
2005-10-13 16:00:00	AAPL	Stock	1.9161	1.9257	1.8199	1.9218	8848084.0
2005-10-13 17:00:00	AAPL	Stock	1.9221	1.9239	1.9132	1.9196	1529584.0
2005-10-13 18:00:00	AAPL	Stock	1.9196	1.9232	1.9154	1.9218	592760.0
2005-10-13 08:00:00	MSFT	Stock	24.35	24.37	24.31	24.34	5160.0
2005-10-13 09:00:00	MSFT	Stock	24.35	24.49	24.268	24.45	8942806.0
2005-10-13 10:00:00	MSFT	Stock	24.46	24.58	24.42	24.52	10098633.0
2005-10-13 11:00:00	MSFT	Stock	24.52	24.62	24.44	24.49	10415844.0
2005-10-13 12:00:00	MSFT	Stock	24.49	24.61	24.44	24.6	8372179.0
2005-10-13 13:00:00	MSFT	Stock	24.6	24.65	24.53	24.6	7602097.0
2005-10-13 14:00:00	MSFT	Stock	24.6	24.73	24.59	24.6	10379137.0
2005-10-13 15:00:00	MSFT	Stock	24.6	24.71	24.57	24.59	12552667.0
2005-10-13 16:00:00	MSFT	Stock	24.59	24.635	24.55	24.59	153987.0
2005-10-13 17:00:00	MSFT	Stock	24.59	24.6	24.58	24.58	194430.0
2005-10-13 18:00:00	MSFT	Stock	24.58	24.58	24.58	24.58	737.0
2005-10-13 08:00:00	NVDA	Stock	0.2675	0.2677	0.2667	0.2677	240000.0
2005-10-13 09:00:00	NVDA	Stock	0.2677	0.2677	0.2605	0.2618	85592040.0
2005-10-13 10:00:00	NVDA	Stock	0.262	0.2642	0.2612	0.2638	65195640.0
2005-10-13 11:00:00	NVDA	Stock	0.2638	0.2643	0.2607	0.2609	27928920.0
2005-10-13 12:00:00	NVDA	Stock	0.2609	0.2623	0.2567	0.2622	90502680.0
2005-10-13 13:00:00	NVDA	Stock	0.2624	0.2625	0.2592	0.2611	32795880.0
2005-10-13 14:00:00	NVDA	Stock	0.2611	0.2657	0.2609	0.2647	91208160.0
2005-10-13 15:00:00	NVDA	Stock	0.2647	0.2682	0.2646	0.2671	110007480.0
2005-10-13 16:00:00	NVDA	Stock	0.2669	0.2678	0.2669	0.2678	376560.0
2005-10-13 17:00:00	NVDA	Stock	0.2675	0.2675	0.2675	0.2675	93000.0
2005-10-13 08:00:00	AMZN	Stock	2.13	2.136	2.13	2.13	54000.0
2005-10-13 09:00:00	AMZN	Stock	2.1285	2.147	2.1065	2.1138	13214060.0
2005-10-13 10:00:00	AMZN	Stock	2.1135	2.138	2.1115	2.1355	13505400.0
2005-10-13 11:00:00	AMZN	Stock	2.1355	2.137	2.1075	2.1095	8541260.0
2005-10-13 12:00:00	AMZN	Stock	2.109	2.119	2.095	2.113	9488460.0
2005-10-13 13:00:00	AMZN	Stock	2.113	2.125	2.1035	2.1205	6178280.0
2005-10-13 14:00:00	AMZN	Stock	2.121	2.149	2.1205	2.134	11910360.0
2005-10-13 15:00:00	AMZN	Stock	2.1335	2.1445	2.1265	2.1315	12455720.0
2005-10-13 16:00:00	AMZN	Stock	2.1305	2.142	2.129	2.131	143300.0
2005-10-13 09:00:00	CL	Stock	25.855	26.07	25.85	26.03	215600.0
2005-10-13 10:00:00	CL	Stock	26.03	26.05	25.835	26.025	494600.0
2005-10-13 11:00:00	CL	Stock	26.03	26.04	25.785	25.8	658600.0
2005-10-13 12:00:00	CL	Stock	25.81	25.995	25.805	25.965	305000.0
2005-10-13 13:00:00	CL	Stock	25.98	25.98	25.84	25.92	173400.0
2005-10-13 14:00:00	CL	Stock	25.925	26.05	25.865	25.935	424600.0
2005-10-13 15:00:00	CL	Stock	25.925	25.98	25.88	25.905	470400.0
2005-10-13 16:00:00	CL	Stock	25.9	25.9	25.89	25.89	2600.0

> showing 50 of 26,473 rows — these rows as CSV

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