PREVIEW / stock_1hour / 2005-12-01

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-12-01.parquet
  size:    601 KB
  rows:    28,393
  symbols: 2,131

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-01 04:00:00	AAPL	Stock	2.4107	2.4107	2.4107	2.4107	2800.0
2005-12-01 07:00:00	AAPL	Stock	2.4339	2.4443	2.4339	2.4443	98924.0
2005-12-01 08:00:00	AAPL	Stock	2.4432	2.45	2.4393	2.45	2742264.0
2005-12-01 09:00:00	AAPL	Stock	2.45	2.4961	2.4221	2.4875	145572420.0
2005-12-01 10:00:00	AAPL	Stock	2.4875	2.5	2.4811	2.4907	150713136.0
2005-12-01 11:00:00	AAPL	Stock	2.4907	2.4936	2.4782	2.4882	61220516.0
2005-12-01 12:00:00	AAPL	Stock	2.4886	2.4975	2.4861	2.4971	45436860.0
2005-12-01 13:00:00	AAPL	Stock	2.4972	2.4986	2.4843	2.4871	48285860.0
2005-12-01 14:00:00	AAPL	Stock	2.4871	2.4986	2.4846	2.495	57786092.0
2005-12-01 15:00:00	AAPL	Stock	2.4946	2.5614	2.4946	2.5611	278020680.0
2005-12-01 16:00:00	AAPL	Stock	2.5607	2.5635	2.4895	2.5511	9355836.0
2005-12-01 17:00:00	AAPL	Stock	2.55	2.5614	2.5482	2.5571	1540504.0
2005-12-01 18:00:00	AAPL	Stock	2.5589	2.5614	2.5536	2.5571	462616.0
2005-12-01 08:00:00	MSFT	Stock	27.73	27.81	27.73	27.79	45690.0
2005-12-01 09:00:00	MSFT	Stock	27.77	27.88	27.72	27.84	5571819.0
2005-12-01 10:00:00	MSFT	Stock	27.84	27.97	27.82	27.95	9807597.0
2005-12-01 11:00:00	MSFT	Stock	27.95	28.02	27.93	27.98	8661130.0
2005-12-01 12:00:00	MSFT	Stock	27.98	28.09	27.98	28.08	4994174.0
2005-12-01 13:00:00	MSFT	Stock	28.08	28.101	27.99	28.04	6158836.0
2005-12-01 14:00:00	MSFT	Stock	28.03	28.05	27.96	27.99	5585963.0
2005-12-01 15:00:00	MSFT	Stock	27.99	28.05	27.89	27.89	12826379.0
2005-12-01 16:00:00	MSFT	Stock	27.89	27.96	27.8	27.86	5285397.0
2005-12-01 17:00:00	MSFT	Stock	27.86	27.89	27.75	27.86	105031.0
2005-12-01 18:00:00	MSFT	Stock	27.84	27.89	27.79	27.88	25896.0
2005-12-01 08:00:00	NVDA	Stock	0.3042	0.306	0.3042	0.3052	1008000.0
2005-12-01 09:00:00	NVDA	Stock	0.3035	0.3062	0.3023	0.3042	51881880.0
2005-12-01 10:00:00	NVDA	Stock	0.3041	0.3042	0.3005	0.3038	81812760.0
2005-12-01 11:00:00	NVDA	Stock	0.304	0.3047	0.3021	0.3037	61926600.0
2005-12-01 12:00:00	NVDA	Stock	0.3037	0.304	0.3027	0.3038	133083600.0
2005-12-01 13:00:00	NVDA	Stock	0.3039	0.3051	0.3032	0.3035	52218600.0
2005-12-01 14:00:00	NVDA	Stock	0.3035	0.3049	0.303	0.3047	34381560.0
2005-12-01 15:00:00	NVDA	Stock	0.3048	0.3059	0.3029	0.3048	112075920.0
2005-12-01 16:00:00	NVDA	Stock	0.3046	0.3055	0.303	0.3055	6637320.0
2005-12-01 17:00:00	NVDA	Stock	0.3055	0.3055	0.3048	0.3048	146280.0
2005-12-01 18:00:00	NVDA	Stock	0.3054	0.3054	0.3054	0.3054	36000.0
2005-12-01 08:00:00	AMZN	Stock	2.4275	2.4425	2.4275	2.439	416400.0
2005-12-01 09:00:00	AMZN	Stock	2.436	2.47	2.423	2.4614	22400900.0
2005-12-01 10:00:00	AMZN	Stock	2.462	2.466	2.4375	2.4525	26703700.0
2005-12-01 11:00:00	AMZN	Stock	2.453	2.4575	2.4345	2.439	16935760.0
2005-12-01 12:00:00	AMZN	Stock	2.439	2.4525	2.439	2.4525	8448960.0
2005-12-01 13:00:00	AMZN	Stock	2.4525	2.457	2.436	2.4425	22676580.0
2005-12-01 14:00:00	AMZN	Stock	2.442	2.448	2.4315	2.443	19182860.0
2005-12-01 15:00:00	AMZN	Stock	2.443	2.4545	2.443	2.452	34010220.0
2005-12-01 16:00:00	AMZN	Stock	2.451	2.4525	2.443	2.4525	3057160.0
2005-12-01 17:00:00	AMZN	Stock	2.452	2.4535	2.447	2.4475	511000.0
2005-12-01 18:00:00	AMZN	Stock	2.4495	2.452	2.4455	2.45	29620.0
2005-12-01 08:00:00	CL	Stock	27.26	27.26	27.26	27.26	1400.0
2005-12-01 09:00:00	CL	Stock	27.35	27.52	27.35	27.51	653400.0
2005-12-01 10:00:00	CL	Stock	27.5	27.575	27.35	27.395	672000.0
2005-12-01 11:00:00	CL	Stock	27.4	27.595	27.375	27.575	627800.0

> showing 50 of 28,393 rows — these rows as CSV

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