PREVIEW / stock_1hour / 2005-12-15

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-12-15.parquet
  size:    585 KB
  rows:    27,683
  symbols: 2,152

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-12-15 06:00:00	AAPL	Stock	2.5786	2.5918	2.5786	2.5918	86800.0
2005-12-15 07:00:00	AAPL	Stock	2.5914	2.6143	2.5875	2.6036	1041488.0
2005-12-15 08:00:00	AAPL	Stock	2.6032	2.6039	2.5836	2.5939	5970020.0
2005-12-15 09:00:00	AAPL	Stock	2.5936	2.6021	2.5679	2.5804	118614720.0
2005-12-15 10:00:00	AAPL	Stock	2.58	2.5861	2.5482	2.5586	141793736.0
2005-12-15 11:00:00	AAPL	Stock	2.5582	2.5789	2.5582	2.5757	76129116.0
2005-12-15 12:00:00	AAPL	Stock	2.5757	2.5786	2.5646	2.5753	42829388.0
2005-12-15 13:00:00	AAPL	Stock	2.5754	2.5818	2.5671	2.5811	35159124.0
2005-12-15 14:00:00	AAPL	Stock	2.5811	2.5839	2.5657	2.5693	49456260.0
2005-12-15 15:00:00	AAPL	Stock	2.5689	2.5779	2.5654	2.5771	67422012.0
2005-12-15 16:00:00	AAPL	Stock	2.5768	2.5779	2.5711	2.575	3600016.0
2005-12-15 17:00:00	AAPL	Stock	2.575	2.5779	2.575	2.5768	166516.0
2005-12-15 18:00:00	AAPL	Stock	2.5754	2.5779	2.5715	2.5743	400736.0
2005-12-15 07:00:00	MSFT	Stock	27.0	27.09	27.0	27.08	3900.0
2005-12-15 08:00:00	MSFT	Stock	27.15	27.15	27.0	27.07	539550.0
2005-12-15 09:00:00	MSFT	Stock	27.07	27.11	26.91	26.91	6051591.0
2005-12-15 10:00:00	MSFT	Stock	26.92	26.95	26.81	26.85	14086831.0
2005-12-15 11:00:00	MSFT	Stock	26.85	26.95	26.81	26.92	11324654.0
2005-12-15 12:00:00	MSFT	Stock	26.93	26.93	26.86	26.9	5748994.0
2005-12-15 13:00:00	MSFT	Stock	26.91	26.92	26.85	26.86	9396017.0
2005-12-15 14:00:00	MSFT	Stock	26.87	26.89	26.83	26.85	7487031.0
2005-12-15 15:00:00	MSFT	Stock	26.851	26.92	26.81	26.9	21451852.0
2005-12-15 16:00:00	MSFT	Stock	26.92	26.93	26.85	26.86	245612.0
2005-12-15 17:00:00	MSFT	Stock	26.86	26.9	26.85	26.89	5000.0
2005-12-15 18:00:00	MSFT	Stock	26.879	26.89	26.864	26.89	12403.0
2005-12-15 09:00:00	NVDA	Stock	0.3083	0.3104	0.3048	0.3058	49776000.0
2005-12-15 10:00:00	NVDA	Stock	0.306	0.3067	0.303	0.3034	56224560.0
2005-12-15 11:00:00	NVDA	Stock	0.3033	0.3052	0.3012	0.305	55268040.0
2005-12-15 12:00:00	NVDA	Stock	0.3051	0.3075	0.3049	0.3067	32109120.0
2005-12-15 13:00:00	NVDA	Stock	0.3067	0.3067	0.3046	0.3062	15445080.0
2005-12-15 14:00:00	NVDA	Stock	0.3062	0.3063	0.3042	0.305	25791240.0
2005-12-15 15:00:00	NVDA	Stock	0.3049	0.3051	0.3032	0.3047	70142280.0
2005-12-15 16:00:00	NVDA	Stock	0.3049	0.3052	0.3034	0.3051	480960.0
2005-12-15 18:00:00	NVDA	Stock	0.3046	0.3048	0.3046	0.3048	120000.0
2005-12-15 08:00:00	AMZN	Stock	2.455	2.474	2.455	2.469	66000.0
2005-12-15 09:00:00	AMZN	Stock	2.4665	2.4975	2.4615	2.4775	19664080.0
2005-12-15 10:00:00	AMZN	Stock	2.4765	2.479	2.4525	2.4705	21153200.0
2005-12-15 11:00:00	AMZN	Stock	2.4695	2.4705	2.4545	2.459	17875900.0
2005-12-15 12:00:00	AMZN	Stock	2.4585	2.4675	2.4575	2.463	8063640.0
2005-12-15 13:00:00	AMZN	Stock	2.463	2.475	2.4575	2.4735	12011840.0
2005-12-15 14:00:00	AMZN	Stock	2.4735	2.474	2.4545	2.4615	12132660.0
2005-12-15 15:00:00	AMZN	Stock	2.4615	2.474	2.46	2.4715	17772760.0
2005-12-15 16:00:00	AMZN	Stock	2.4725	2.475	2.472	2.475	244180.0
2005-12-15 17:00:00	AMZN	Stock	2.4725	2.475	2.4595	2.47	71900.0
2005-12-15 08:00:00	CL	Stock	28.125	28.125	28.125	28.125	4400.0
2005-12-15 09:00:00	CL	Stock	28.1	28.1	27.8875	27.92	352600.0
2005-12-15 10:00:00	CL	Stock	27.92	27.96	27.755	27.755	370400.0
2005-12-15 11:00:00	CL	Stock	27.76	27.96	27.75	27.96	376000.0
2005-12-15 12:00:00	CL	Stock	27.955	27.965	27.895	27.935	271200.0
2005-12-15 13:00:00	CL	Stock	27.935	28.115	27.91	28.115	310000.0

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

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