PREVIEW / stock_1hour / 2005-10-11

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-10-11.parquet
  size:    571 KB
  rows:    27,263
  symbols: 2,089

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-11 07:00:00	AAPL	Stock	1.8093	1.8179	1.8093	1.8179	16800.0
2005-10-11 08:00:00	AAPL	Stock	1.8214	1.825	1.8111	1.8243	3509408.0
2005-10-11 09:00:00	AAPL	Stock	1.825	1.8346	1.8	1.8096	126395724.0
2005-10-11 10:00:00	AAPL	Stock	1.8082	1.8436	1.8018	1.8404	167083896.0
2005-10-11 11:00:00	AAPL	Stock	1.8404	1.8525	1.8343	1.8411	122285940.0
2005-10-11 12:00:00	AAPL	Stock	1.8407	1.8418	1.8236	1.8243	107553124.0
2005-10-11 13:00:00	AAPL	Stock	1.8242	1.8304	1.8125	1.8275	101023748.0
2005-10-11 14:00:00	AAPL	Stock	1.8271	1.8407	1.8214	1.8289	120608488.0
2005-10-11 15:00:00	AAPL	Stock	1.8286	1.8436	1.8207	1.8429	155631532.0
2005-10-11 16:00:00	AAPL	Stock	1.8418	1.8529	1.6357	1.6411	236187336.0
2005-10-11 17:00:00	AAPL	Stock	1.6393	1.6536	1.625	1.6511	87646636.0
2005-10-11 18:00:00	AAPL	Stock	1.6511	1.6536	1.645	1.6493	18194708.0
2005-10-11 07:00:00	MSFT	Stock	24.59	24.59	24.59	24.59	2000.0
2005-10-11 08:00:00	MSFT	Stock	24.59	24.59	24.48	24.54	21854.0
2005-10-11 09:00:00	MSFT	Stock	24.53	24.55	24.369	24.44	8525384.0
2005-10-11 10:00:00	MSFT	Stock	24.44	24.47	24.28	24.35	8655340.0
2005-10-11 11:00:00	MSFT	Stock	24.36	24.37	24.29	24.32	9982232.0
2005-10-11 12:00:00	MSFT	Stock	24.33	24.37	24.25	24.321	9285333.0
2005-10-11 13:00:00	MSFT	Stock	24.33	24.35	24.25	24.29	7593290.0
2005-10-11 14:00:00	MSFT	Stock	24.29	24.5	24.25	24.37	14054030.0
2005-10-11 15:00:00	MSFT	Stock	24.35	24.43	24.34	24.41	14921317.0
2005-10-11 16:00:00	MSFT	Stock	24.41	24.42	24.309	24.37	174006.0
2005-10-11 17:00:00	MSFT	Stock	24.34	24.41	24.31	24.31	460680.0
2005-10-11 18:00:00	MSFT	Stock	24.474	24.474	24.31	24.31	20305.0
2005-10-11 09:00:00	NVDA	Stock	0.2708	0.2718	0.266	0.2662	65947200.0
2005-10-11 10:00:00	NVDA	Stock	0.2662	0.2671	0.2636	0.2656	109742640.0
2005-10-11 11:00:00	NVDA	Stock	0.2656	0.2662	0.264	0.2645	41454360.0
2005-10-11 12:00:00	NVDA	Stock	0.2647	0.2649	0.2621	0.263	57775800.0
2005-10-11 13:00:00	NVDA	Stock	0.2629	0.2658	0.2626	0.2647	66242760.0
2005-10-11 14:00:00	NVDA	Stock	0.2646	0.2661	0.2636	0.2654	63706440.0
2005-10-11 15:00:00	NVDA	Stock	0.2652	0.2659	0.2629	0.2651	113966040.0
2005-10-11 16:00:00	NVDA	Stock	0.2649	0.2672	0.2646	0.2652	1926960.0
2005-10-11 17:00:00	NVDA	Stock	0.2636	0.2652	0.2617	0.2652	9272400.0
2005-10-11 08:00:00	AMZN	Stock	2.1925	2.1975	2.1925	2.1975	55600.0
2005-10-11 09:00:00	AMZN	Stock	2.1975	2.2125	2.191	2.1955	7568000.0
2005-10-11 10:00:00	AMZN	Stock	2.196	2.1965	2.1685	2.18	10431260.0
2005-10-11 11:00:00	AMZN	Stock	2.1795	2.1865	2.1725	2.1845	9774160.0
2005-10-11 12:00:00	AMZN	Stock	2.186	2.191	2.179	2.183	9602620.0
2005-10-11 13:00:00	AMZN	Stock	2.1845	2.2025	2.1835	2.189	5292280.0
2005-10-11 14:00:00	AMZN	Stock	2.188	2.216	2.1865	2.19	10933200.0
2005-10-11 15:00:00	AMZN	Stock	2.1895	2.1905	2.1615	2.169	44756480.0
2005-10-11 16:00:00	AMZN	Stock	2.1725	2.173	2.1525	2.16	3867820.0
2005-10-11 17:00:00	AMZN	Stock	2.1625	2.1713	2.1625	2.1713	52000.0
2005-10-11 09:00:00	CL	Stock	26.17	26.25	26.14	26.25	266600.0
2005-10-11 10:00:00	CL	Stock	26.24	26.395	26.16	26.225	276600.0
2005-10-11 11:00:00	CL	Stock	26.225	26.245	26.125	26.245	244000.0
2005-10-11 12:00:00	CL	Stock	26.245	26.315	26.235	26.245	304200.0
2005-10-11 13:00:00	CL	Stock	26.24	26.29	26.22	26.255	435000.0
2005-10-11 14:00:00	CL	Stock	26.255	26.345	26.115	26.125	475400.0
2005-10-11 15:00:00	CL	Stock	26.12	26.16	26.035	26.07	954000.0

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

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