PREVIEW / stock_1hour / 2005-09-08

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-09-08.parquet
  size:    565 KB
  rows:    27,035
  symbols: 2,062

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-08 07:00:00	AAPL	Stock	1.7768	1.7768	1.7536	1.7643	663180.0
2005-09-08 08:00:00	AAPL	Stock	1.7679	1.7679	1.7529	1.7632	6274632.0
2005-09-08 09:00:00	AAPL	Stock	1.7632	1.79	1.755	1.7818	191903096.0
2005-09-08 10:00:00	AAPL	Stock	1.7818	1.7854	1.7682	1.7814	139025348.0
2005-09-08 11:00:00	AAPL	Stock	1.7814	1.7818	1.7696	1.7768	60148844.0
2005-09-08 12:00:00	AAPL	Stock	1.7768	1.7836	1.775	1.7803	50312360.0
2005-09-08 13:00:00	AAPL	Stock	1.7804	1.7889	1.7779	1.7882	86651040.0
2005-09-08 14:00:00	AAPL	Stock	1.7886	1.7886	1.7768	1.7786	63214200.0
2005-09-08 15:00:00	AAPL	Stock	1.7779	1.7818	1.7739	1.7768	85393756.0
2005-09-08 16:00:00	AAPL	Stock	1.7771	1.7796	1.7757	1.7775	2306948.0
2005-09-08 17:00:00	AAPL	Stock	1.7775	1.7793	1.7768	1.7779	320936.0
2005-09-08 18:00:00	AAPL	Stock	1.78	1.7807	1.7782	1.7786	75292.0
2005-09-08 08:00:00	MSFT	Stock	26.85	26.88	26.8	26.82	5335.0
2005-09-08 09:00:00	MSFT	Stock	26.86	26.87	26.71	26.8	6317883.0
2005-09-08 10:00:00	MSFT	Stock	26.8	26.88	26.76	26.831	7240788.0
2005-09-08 11:00:00	MSFT	Stock	26.83	26.88	26.8	26.81	4788416.0
2005-09-08 12:00:00	MSFT	Stock	26.85	26.85	26.7	26.72	5493423.0
2005-09-08 13:00:00	MSFT	Stock	26.71	26.85	26.69	26.69	4806650.0
2005-09-08 14:00:00	MSFT	Stock	26.69	26.7	26.52	26.57	10317490.0
2005-09-08 15:00:00	MSFT	Stock	26.57	26.63	26.52	26.59	10041187.0
2005-09-08 16:00:00	MSFT	Stock	26.59	26.64	26.55	26.62	204645.0
2005-09-08 17:00:00	MSFT	Stock	26.63	26.64	26.61	26.61	40128.0
2005-09-08 18:00:00	MSFT	Stock	26.63	26.65	26.63	26.65	3164.0
2005-09-08 08:00:00	NVDA	Stock	0.2596	0.2596	0.2596	0.2596	18000.0
2005-09-08 09:00:00	NVDA	Stock	0.2602	0.2665	0.2597	0.2649	98444280.0
2005-09-08 10:00:00	NVDA	Stock	0.2649	0.2681	0.2648	0.2654	181859520.0
2005-09-08 11:00:00	NVDA	Stock	0.2653	0.2677	0.2641	0.2671	92618640.0
2005-09-08 12:00:00	NVDA	Stock	0.267	0.2679	0.2662	0.2669	58019760.0
2005-09-08 13:00:00	NVDA	Stock	0.2671	0.2674	0.2657	0.2662	47798880.0
2005-09-08 14:00:00	NVDA	Stock	0.2662	0.2674	0.2651	0.2666	62704560.0
2005-09-08 15:00:00	NVDA	Stock	0.2665	0.2665	0.2643	0.2649	86280720.0
2005-09-08 16:00:00	NVDA	Stock	0.2649	0.2652	0.2644	0.2647	1331760.0
2005-09-08 17:00:00	NVDA	Stock	0.2648	0.2648	0.2648	0.2648	547320.0
2005-09-08 08:00:00	AMZN	Stock	2.1835	2.1835	2.1835	2.1835	2000.0
2005-09-08 09:00:00	AMZN	Stock	2.182	2.182	2.1495	2.1615	10833100.0
2005-09-08 10:00:00	AMZN	Stock	2.1615	2.1745	2.156	2.1605	11078620.0
2005-09-08 11:00:00	AMZN	Stock	2.1605	2.166	2.16	2.16	4115820.0
2005-09-08 12:00:00	AMZN	Stock	2.16	2.1645	2.1545	2.1625	4195400.0
2005-09-08 13:00:00	AMZN	Stock	2.1625	2.1635	2.15	2.1505	6111760.0
2005-09-08 14:00:00	AMZN	Stock	2.15	2.1535	2.1415	2.1495	23122120.0
2005-09-08 15:00:00	AMZN	Stock	2.1495	2.152	2.145	2.148	16032840.0
2005-09-08 16:00:00	AMZN	Stock	2.149	2.1505	2.148	2.148	1015520.0
2005-09-08 17:00:00	AMZN	Stock	2.148	2.148	2.148	2.148	20200.0
2005-09-08 18:00:00	AMZN	Stock	2.148	2.1585	2.148	2.15	88600.0
2005-09-08 09:00:00	CL	Stock	26.6	26.885	26.57	26.65	671000.0
2005-09-08 10:00:00	CL	Stock	26.655	26.745	26.605	26.66	565200.0
2005-09-08 11:00:00	CL	Stock	26.655	26.765	26.65	26.765	392600.0
2005-09-08 12:00:00	CL	Stock	26.77	26.785	26.63	26.64	403200.0
2005-09-08 13:00:00	CL	Stock	26.635	26.665	26.635	26.64	597200.0
2005-09-08 14:00:00	CL	Stock	26.645	26.7	26.635	26.645	712200.0

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

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