PREVIEW / stock_1hour / 2005-12-30

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-12-30.parquet
  size:    591 KB
  rows:    28,042
  symbols: 2,171

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-30 07:00:00	AAPL	Stock	2.5411	2.5411	2.5411	2.5411	30800.0
2005-12-30 08:00:00	AAPL	Stock	2.5429	2.5446	2.5268	2.5339	2933672.0
2005-12-30 09:00:00	AAPL	Stock	2.5336	2.5418	2.5218	2.5361	73070004.0
2005-12-30 10:00:00	AAPL	Stock	2.5361	2.5361	2.5154	2.5168	92633492.0
2005-12-30 11:00:00	AAPL	Stock	2.5168	2.5239	2.5121	2.5229	75530224.0
2005-12-30 12:00:00	AAPL	Stock	2.5225	2.5457	2.5221	2.5404	74906888.0
2005-12-30 13:00:00	AAPL	Stock	2.5407	2.5868	2.5386	2.5711	111459936.0
2005-12-30 14:00:00	AAPL	Stock	2.5711	2.5821	2.5639	2.5679	66622248.0
2005-12-30 15:00:00	AAPL	Stock	2.5679	2.5814	2.5604	2.5614	106029812.0
2005-12-30 16:00:00	AAPL	Stock	2.5621	2.5707	2.5557	2.5675	5065060.0
2005-12-30 17:00:00	AAPL	Stock	2.5675	2.5686	2.5646	2.5657	269136.0
2005-12-30 18:00:00	AAPL	Stock	2.5657	2.5675	2.5657	2.5657	75600.0
2005-12-30 05:00:00	MSFT	Stock	26.17	26.17	25.75	25.75	650.0
2005-12-30 07:00:00	MSFT	Stock	26.22	26.22	26.22	26.22	1500.0
2005-12-30 08:00:00	MSFT	Stock	26.01	26.27	26.0	26.21	36783.0
2005-12-30 09:00:00	MSFT	Stock	26.2	26.29	26.12	26.28	6029941.0
2005-12-30 10:00:00	MSFT	Stock	26.28	26.29	26.22	26.25	7825057.0
2005-12-30 11:00:00	MSFT	Stock	26.252	26.31	26.22	26.27	6457625.0
2005-12-30 12:00:00	MSFT	Stock	26.27	26.28	26.16	26.18	5484205.0
2005-12-30 13:00:00	MSFT	Stock	26.172	26.2	26.11	26.18	4919858.0
2005-12-30 14:00:00	MSFT	Stock	26.18	26.2	26.1	26.15	3949322.0
2005-12-30 15:00:00	MSFT	Stock	26.15	26.22	26.1	26.11	8545278.0
2005-12-30 16:00:00	MSFT	Stock	26.15	26.15	26.09	26.15	1877852.0
2005-12-30 17:00:00	MSFT	Stock	26.13	26.15	26.03	26.13	4710.0
2005-12-30 18:00:00	MSFT	Stock	26.14	26.14	26.14	26.14	534.0
2005-12-30 08:00:00	NVDA	Stock	0.3114	0.3114	0.3114	0.3114	24960.0
2005-12-30 09:00:00	NVDA	Stock	0.3112	0.3112	0.3058	0.3062	44436240.0
2005-12-30 10:00:00	NVDA	Stock	0.306	0.3067	0.3036	0.3044	48802560.0
2005-12-30 11:00:00	NVDA	Stock	0.3044	0.3051	0.304	0.3045	24895200.0
2005-12-30 12:00:00	NVDA	Stock	0.3044	0.3045	0.3034	0.304	19798440.0
2005-12-30 13:00:00	NVDA	Stock	0.304	0.3052	0.304	0.3049	11846280.0
2005-12-30 14:00:00	NVDA	Stock	0.305	0.3063	0.3047	0.3049	21616680.0
2005-12-30 15:00:00	NVDA	Stock	0.3049	0.3058	0.3042	0.3047	42872640.0
2005-12-30 16:00:00	NVDA	Stock	0.3048	0.3052	0.3045	0.3047	2894160.0
2005-12-30 08:00:00	AMZN	Stock	2.395	2.395	2.395	2.395	14000.0
2005-12-30 09:00:00	AMZN	Stock	2.395	2.41	2.375	2.3845	12346300.0
2005-12-30 10:00:00	AMZN	Stock	2.3845	2.3925	2.3765	2.389	19476780.0
2005-12-30 11:00:00	AMZN	Stock	2.3885	2.3895	2.3785	2.38	5756420.0
2005-12-30 12:00:00	AMZN	Stock	2.38	2.387	2.3745	2.3765	6276280.0
2005-12-30 13:00:00	AMZN	Stock	2.3765	2.384	2.367	2.381	11520380.0
2005-12-30 14:00:00	AMZN	Stock	2.3805	2.383	2.369	2.373	8827140.0
2005-12-30 15:00:00	AMZN	Stock	2.3735	2.374	2.357	2.357	34410520.0
2005-12-30 16:00:00	AMZN	Stock	2.357	2.3755	2.3535	2.3575	4622300.0
2005-12-30 17:00:00	AMZN	Stock	2.3625	2.363	2.3625	2.363	20000.0
2005-12-30 09:00:00	CL	Stock	27.47	27.59	27.45	27.524	197800.0
2005-12-30 10:00:00	CL	Stock	27.525	27.61	27.51	27.59	302800.0
2005-12-30 11:00:00	CL	Stock	27.59	27.615	27.5	27.51	159600.0
2005-12-30 12:00:00	CL	Stock	27.51	27.55	27.5	27.515	192800.0
2005-12-30 13:00:00	CL	Stock	27.515	27.52	27.435	27.451	159600.0
2005-12-30 14:00:00	CL	Stock	27.45	27.5	27.415	27.48	210600.0

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

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