PREVIEW / stock_1hour / 2007-11-01

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-11-01.parquet
  size:    846 KB
  rows:    42,090
  symbols: 3,193

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
2007-11-01 04:00:00	AAPL	Stock	6.7757	6.7757	6.7757	6.7757	16800.0
2007-11-01 07:00:00	AAPL	Stock	6.7686	6.7686	6.7511	6.7554	238672.0
2007-11-01 08:00:00	AAPL	Stock	6.7554	6.8211	6.7143	6.7243	6634180.0
2007-11-01 09:00:00	AAPL	Stock	6.7271	6.7839	6.7	6.7157	124742632.0
2007-11-01 10:00:00	AAPL	Stock	6.7164	6.7286	6.6643	6.725	138122068.0
2007-11-01 11:00:00	AAPL	Stock	6.7243	6.7404	6.7107	6.72	82153288.0
2007-11-01 12:00:00	AAPL	Stock	6.7193	6.7446	6.7146	6.7404	55455820.0
2007-11-01 13:00:00	AAPL	Stock	6.7411	6.7893	6.7207	6.7325	108983588.0
2007-11-01 14:00:00	AAPL	Stock	6.7307	6.7746	6.7275	6.7686	98214760.0
2007-11-01 15:00:00	AAPL	Stock	6.7689	6.7821	6.4286	6.6978	166533444.0
2007-11-01 16:00:00	AAPL	Stock	6.6979	6.7679	6.6879	6.6964	21032004.0
2007-11-01 17:00:00	AAPL	Stock	6.6943	6.7839	6.6875	6.6946	3462564.0
2007-11-01 18:00:00	AAPL	Stock	6.6961	6.7	6.6946	6.6993	222460.0
2007-11-01 19:00:00	AAPL	Stock	6.6964	6.6982	6.6929	6.6943	405944.0
2007-11-01 07:00:00	MSFT	Stock	36.71	36.71	36.5	36.61	11692.0
2007-11-01 08:00:00	MSFT	Stock	36.68	36.81	36.43	36.43	131821.0
2007-11-01 09:00:00	MSFT	Stock	36.45	36.87	36.4	36.702	15733943.0
2007-11-01 10:00:00	MSFT	Stock	36.71	37.36	36.36	37.33	28613671.0
2007-11-01 11:00:00	MSFT	Stock	37.33	37.49	36.878	37.18	22201814.0
2007-11-01 12:00:00	MSFT	Stock	37.19	37.44	37.17	37.42	11792419.0
2007-11-01 13:00:00	MSFT	Stock	37.41	37.44	37.05	37.11	12012466.0
2007-11-01 14:00:00	MSFT	Stock	37.11	37.2	36.92	37.16	21743542.0
2007-11-01 15:00:00	MSFT	Stock	37.17	37.2	36.99	37.06	33618795.0
2007-11-01 16:00:00	MSFT	Stock	37.066	37.174	36.36	37.1	4095683.0
2007-11-01 17:00:00	MSFT	Stock	37.09	37.09	36.81	37.09	2151859.0
2007-11-01 18:00:00	MSFT	Stock	37.08	37.1	37.03	37.09	37049.0
2007-11-01 19:00:00	MSFT	Stock	37.09	37.09	37.08	37.08	10380.0
2007-11-01 08:00:00	NVDA	Stock	0.896	0.896	0.8725	0.8725	1060080.0
2007-11-01 09:00:00	NVDA	Stock	0.8718	0.883	0.8588	0.8778	75707000.0
2007-11-01 10:00:00	NVDA	Stock	0.8778	0.8805	0.869	0.8798	88241480.0
2007-11-01 11:00:00	NVDA	Stock	0.88	0.8883	0.8766	0.886	65840320.0
2007-11-01 12:00:00	NVDA	Stock	0.8863	0.8895	0.881	0.884	40199960.0
2007-11-01 13:00:00	NVDA	Stock	0.8838	0.8858	0.8715	0.874	44126760.0
2007-11-01 14:00:00	NVDA	Stock	0.874	0.8995	0.8732	0.8988	93655960.0
2007-11-01 15:00:00	NVDA	Stock	0.8988	0.9023	0.8842	0.8845	150298680.0
2007-11-01 16:00:00	NVDA	Stock	0.8845	0.8936	0.8732	0.8845	25354960.0
2007-11-01 17:00:00	NVDA	Stock	0.8845	0.8863	0.877	0.8863	3317320.0
2007-11-01 18:00:00	NVDA	Stock	0.8863	0.8875	0.885	0.8875	160000.0
2007-11-01 19:00:00	NVDA	Stock	0.8825	0.8888	0.8825	0.8845	45000.0
2007-11-01 07:00:00	AMZN	Stock	4.4205	4.4205	4.4125	4.4125	6000.0
2007-11-01 08:00:00	AMZN	Stock	4.4375	4.4375	4.388	4.389	379460.0
2007-11-01 09:00:00	AMZN	Stock	4.3875	4.405	4.325	4.3815	31106020.0
2007-11-01 10:00:00	AMZN	Stock	4.381	4.4315	4.3594	4.4205	21456600.0
2007-11-01 11:00:00	AMZN	Stock	4.42	4.434	4.4025	4.4335	11573800.0
2007-11-01 12:00:00	AMZN	Stock	4.434	4.4458	4.42	4.44	9968700.0
2007-11-01 13:00:00	AMZN	Stock	4.441	4.494	4.375	4.3825	37203980.0
2007-11-01 14:00:00	AMZN	Stock	4.383	4.4355	4.382	4.428	16474940.0
2007-11-01 15:00:00	AMZN	Stock	4.428	4.435	4.3705	4.383	32411040.0
2007-11-01 16:00:00	AMZN	Stock	4.385	4.404	4.3715	4.3715	1802540.0
2007-11-01 17:00:00	AMZN	Stock	4.3825	4.4575	4.3805	4.3825	1163520.0

> showing 50 of 42,090 rows — these rows as CSV

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