PREVIEW / stock_1hour / 2005-09-12

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-09-12.parquet
  size:    567 KB
  rows:    27,236
  symbols: 2,070

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-09-12 08:00:00	AAPL	Stock	1.8339	1.8339	1.8221	1.8293	1318212.0
2005-09-12 09:00:00	AAPL	Stock	1.8296	1.8375	1.8161	1.8225	102327708.0
2005-09-12 10:00:00	AAPL	Stock	1.8225	1.8314	1.8175	1.8207	76726636.0
2005-09-12 11:00:00	AAPL	Stock	1.8211	1.8214	1.8064	1.8154	70344708.0
2005-09-12 12:00:00	AAPL	Stock	1.8157	1.8354	1.8143	1.8271	46493944.0
2005-09-12 13:00:00	AAPL	Stock	1.8275	1.8304	1.8218	1.8221	21742504.0
2005-09-12 14:00:00	AAPL	Stock	1.8221	1.8332	1.8196	1.8329	35388108.0
2005-09-12 15:00:00	AAPL	Stock	1.8329	1.8439	1.8293	1.8357	88354056.0
2005-09-12 16:00:00	AAPL	Stock	1.8357	1.8375	1.8339	1.8361	815108.0
2005-09-12 17:00:00	AAPL	Stock	1.8357	1.8357	1.8357	1.8357	2800.0
2005-09-12 18:00:00	AAPL	Stock	1.8354	1.8375	1.8354	1.8375	420308.0
2005-09-12 08:00:00	MSFT	Stock	26.5	26.63	26.5	26.6	35044.0
2005-09-12 09:00:00	MSFT	Stock	26.59	26.73	26.55	26.63	4927084.0
2005-09-12 10:00:00	MSFT	Stock	26.64	26.7	26.62	26.7	4166104.0
2005-09-12 11:00:00	MSFT	Stock	26.7	26.75	26.55	26.56	4656908.0
2005-09-12 12:00:00	MSFT	Stock	26.56	26.66	26.53	26.58	6766031.0
2005-09-12 13:00:00	MSFT	Stock	26.57	26.61	26.52	26.52	4335208.0
2005-09-12 14:00:00	MSFT	Stock	26.53	26.66	26.519	26.65	6151497.0
2005-09-12 15:00:00	MSFT	Stock	26.65	26.66	26.6	26.61	7864705.0
2005-09-12 16:00:00	MSFT	Stock	26.6	26.62	26.55	26.57	311764.0
2005-09-12 17:00:00	MSFT	Stock	26.57	26.62	26.57	26.61	9351.0
2005-09-12 18:00:00	MSFT	Stock	26.61	26.62	26.61	26.62	157016.0
2005-09-12 09:00:00	NVDA	Stock	0.2685	0.2693	0.2663	0.2687	52665240.0
2005-09-12 10:00:00	NVDA	Stock	0.2688	0.269	0.2667	0.2678	140378760.0
2005-09-12 11:00:00	NVDA	Stock	0.2678	0.268	0.2652	0.2654	68896800.0
2005-09-12 12:00:00	NVDA	Stock	0.2654	0.2687	0.2652	0.2659	57553800.0
2005-09-12 13:00:00	NVDA	Stock	0.266	0.2661	0.2652	0.2652	35575680.0
2005-09-12 14:00:00	NVDA	Stock	0.2652	0.2664	0.2642	0.2662	67326600.0
2005-09-12 15:00:00	NVDA	Stock	0.2663	0.2679	0.2652	0.2673	113352840.0
2005-09-12 16:00:00	NVDA	Stock	0.2673	0.2675	0.2672	0.2672	14220600.0
2005-09-12 17:00:00	NVDA	Stock	0.2672	0.2672	0.2672	0.2672	240000.0
2005-09-12 18:00:00	NVDA	Stock	0.2673	0.2673	0.2673	0.2673	312720.0
2005-09-12 08:00:00	AMZN	Stock	2.1475	2.15	2.1475	2.15	77000.0
2005-09-12 09:00:00	AMZN	Stock	2.1455	2.204	2.125	2.203	32106600.0
2005-09-12 10:00:00	AMZN	Stock	2.203	2.2035	2.1695	2.197	19906720.0
2005-09-12 11:00:00	AMZN	Stock	2.1975	2.2065	2.1865	2.192	20446020.0
2005-09-12 12:00:00	AMZN	Stock	2.1915	2.205	2.189	2.2005	10610720.0
2005-09-12 13:00:00	AMZN	Stock	2.2005	2.233	2.2005	2.216	31487700.0
2005-09-12 14:00:00	AMZN	Stock	2.2155	2.244	2.207	2.244	24872060.0
2005-09-12 15:00:00	AMZN	Stock	2.244	2.248	2.2195	2.2245	33077080.0
2005-09-12 16:00:00	AMZN	Stock	2.225	2.24	2.2	2.225	971780.0
2005-09-12 18:00:00	AMZN	Stock	2.218	2.225	2.218	2.225	21000.0
2005-09-12 08:00:00	CL	Stock	26.67	26.67	26.67	26.67	4000.0
2005-09-12 09:00:00	CL	Stock	26.625	26.685	26.5	26.52	323400.0
2005-09-12 10:00:00	CL	Stock	26.52	26.575	26.455	26.57	496200.0
2005-09-12 11:00:00	CL	Stock	26.57	26.63	26.5315	26.55	278800.0
2005-09-12 12:00:00	CL	Stock	26.55	26.605	26.52	26.54	193800.0
2005-09-12 13:00:00	CL	Stock	26.54	26.6	26.505	26.505	185800.0
2005-09-12 14:00:00	CL	Stock	26.5	26.58	26.5	26.57	238800.0
2005-09-12 15:00:00	CL	Stock	26.575	26.6	26.535	26.54	514400.0

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

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