PREVIEW / stock_1hour / 2005-10-14

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-10-14.parquet
  size:    574 KB
  rows:    27,328
  symbols: 2,091

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-14 07:00:00	AAPL	Stock	1.9161	1.9214	1.9161	1.9214	17640.0
2005-10-14 08:00:00	AAPL	Stock	1.9182	1.9361	1.9179	1.9268	6207180.0
2005-10-14 09:00:00	AAPL	Stock	1.9257	1.9411	1.8854	1.8954	197623496.0
2005-10-14 10:00:00	AAPL	Stock	1.8957	1.9389	1.8946	1.9314	271285392.0
2005-10-14 11:00:00	AAPL	Stock	1.9311	1.935	1.9096	1.9243	165866960.0
2005-10-14 12:00:00	AAPL	Stock	1.9242	1.9329	1.9079	1.9093	79571884.0
2005-10-14 13:00:00	AAPL	Stock	1.9093	1.9218	1.8989	1.9143	112588784.0
2005-10-14 14:00:00	AAPL	Stock	1.9139	1.9189	1.9032	1.9143	83833568.0
2005-10-14 15:00:00	AAPL	Stock	1.9146	1.9286	1.9143	1.9279	105536956.0
2005-10-14 16:00:00	AAPL	Stock	1.9286	1.9318	1.9243	1.9293	3326708.0
2005-10-14 17:00:00	AAPL	Stock	1.9293	1.9304	1.9282	1.9286	265888.0
2005-10-14 18:00:00	AAPL	Stock	1.9286	1.9286	1.9279	1.9279	94080.0
2005-10-14 08:00:00	MSFT	Stock	24.62	24.71	24.55	24.7	142599.0
2005-10-14 09:00:00	MSFT	Stock	24.7	24.74	24.51	24.53	7161328.0
2005-10-14 10:00:00	MSFT	Stock	24.54	24.69	24.499	24.52	9200549.0
2005-10-14 11:00:00	MSFT	Stock	24.52	24.62	24.509	24.59	8224007.0
2005-10-14 12:00:00	MSFT	Stock	24.59	24.6	24.52	24.529	5704249.0
2005-10-14 13:00:00	MSFT	Stock	24.529	24.6	24.51	24.55	6415557.0
2005-10-14 14:00:00	MSFT	Stock	24.55	24.63	24.52	24.6	5508416.0
2005-10-14 15:00:00	MSFT	Stock	24.6	24.69	24.58	24.68	9563791.0
2005-10-14 16:00:00	MSFT	Stock	24.68	24.7	24.645	24.69	296722.0
2005-10-14 17:00:00	MSFT	Stock	24.68	24.7	24.55	24.55	112320.0
2005-10-14 18:00:00	MSFT	Stock	24.7	24.75	24.69	24.75	25042.0
2005-10-14 09:00:00	NVDA	Stock	0.2679	0.2722	0.2679	0.2687	55184400.0
2005-10-14 10:00:00	NVDA	Stock	0.2687	0.2705	0.2669	0.2675	52998000.0
2005-10-14 11:00:00	NVDA	Stock	0.2673	0.2677	0.2655	0.2673	32137800.0
2005-10-14 12:00:00	NVDA	Stock	0.2674	0.268	0.2637	0.2637	33960600.0
2005-10-14 13:00:00	NVDA	Stock	0.2637	0.2647	0.2625	0.2642	23676360.0
2005-10-14 14:00:00	NVDA	Stock	0.2642	0.2661	0.2632	0.2647	33212040.0
2005-10-14 15:00:00	NVDA	Stock	0.2647	0.2671	0.2643	0.2668	73627440.0
2005-10-14 16:00:00	NVDA	Stock	0.2667	0.2669	0.2665	0.2669	561600.0
2005-10-14 08:00:00	AMZN	Stock	2.123	2.145	2.123	2.145	24220.0
2005-10-14 09:00:00	AMZN	Stock	2.145	2.1585	2.119	2.1255	9849920.0
2005-10-14 10:00:00	AMZN	Stock	2.1255	2.143	2.117	2.131	15249380.0
2005-10-14 11:00:00	AMZN	Stock	2.1305	2.142	2.125	2.139	9336240.0
2005-10-14 12:00:00	AMZN	Stock	2.14	2.1535	2.1375	2.14	9038920.0
2005-10-14 13:00:00	AMZN	Stock	2.14	2.16	2.134	2.156	8518140.0
2005-10-14 14:00:00	AMZN	Stock	2.156	2.173	2.154	2.169	10686840.0
2005-10-14 15:00:00	AMZN	Stock	2.169	2.1935	2.1665	2.19	26856580.0
2005-10-14 16:00:00	AMZN	Stock	2.189	2.1915	2.189	2.1895	245560.0
2005-10-14 17:00:00	AMZN	Stock	2.1935	2.195	2.19	2.19	46000.0
2005-10-14 18:00:00	AMZN	Stock	2.19	2.19	2.19	2.19	4600.0
2005-10-14 08:00:00	CL	Stock	25.89	25.89	25.89	25.89	1400.0
2005-10-14 09:00:00	CL	Stock	25.89	25.93	25.68	25.74	487200.0
2005-10-14 10:00:00	CL	Stock	25.74	26.005	25.695	25.925	618400.0
2005-10-14 11:00:00	CL	Stock	25.925	26.335	25.87	26.315	641600.0
2005-10-14 12:00:00	CL	Stock	26.325	26.41	26.135	26.145	501400.0
2005-10-14 13:00:00	CL	Stock	26.13	26.155	26.05	26.115	419600.0
2005-10-14 14:00:00	CL	Stock	26.11	26.175	26.055	26.145	273600.0
2005-10-14 15:00:00	CL	Stock	26.135	26.22	26.105	26.185	482200.0

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

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