PREVIEW / stock_1hour / 2005-06-08

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-06-08.parquet
  size:    549 KB
  rows:    26,038
  symbols: 1,990

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-06-08 07:00:00	AAPL	Stock	1.3071	1.3071	1.3071	1.3071	56000.0
2005-06-08 08:00:00	AAPL	Stock	1.3164	1.3164	1.305	1.3136	855400.0
2005-06-08 09:00:00	AAPL	Stock	1.3136	1.3257	1.305	1.3218	75112772.0
2005-06-08 10:00:00	AAPL	Stock	1.3218	1.3286	1.315	1.3279	77092204.0
2005-06-08 11:00:00	AAPL	Stock	1.3275	1.33	1.3214	1.3286	45240944.0
2005-06-08 12:00:00	AAPL	Stock	1.3282	1.3304	1.3214	1.3289	31285072.0
2005-06-08 13:00:00	AAPL	Stock	1.3289	1.3289	1.3171	1.32	42253792.0
2005-06-08 14:00:00	AAPL	Stock	1.32	1.32	1.3107	1.3143	54545344.0
2005-06-08 15:00:00	AAPL	Stock	1.3139	1.3214	1.3118	1.3189	65373896.0
2005-06-08 16:00:00	AAPL	Stock	1.3189	1.3189	1.315	1.3154	2414468.0
2005-06-08 17:00:00	AAPL	Stock	1.3168	1.3186	1.3161	1.3164	9063880.0
2005-06-08 08:00:00	MSFT	Stock	25.6	25.62	25.51	25.62	60831.0
2005-06-08 09:00:00	MSFT	Stock	25.59	25.62	25.51	25.59	4718833.0
2005-06-08 10:00:00	MSFT	Stock	25.59	25.62	25.46	25.52	6007279.0
2005-06-08 11:00:00	MSFT	Stock	25.52	25.53	25.44	25.46	4561268.0
2005-06-08 12:00:00	MSFT	Stock	25.47	25.54	25.41	25.51	3901830.0
2005-06-08 13:00:00	MSFT	Stock	25.51	25.51	25.42	25.45	5831791.0
2005-06-08 14:00:00	MSFT	Stock	25.45	25.47	25.34	25.43	7743920.0
2005-06-08 15:00:00	MSFT	Stock	25.42	25.51	25.38	25.4	9700392.0
2005-06-08 16:00:00	MSFT	Stock	25.4	25.41	25.37	25.39	563069.0
2005-06-08 17:00:00	MSFT	Stock	25.39	25.51	25.39	25.39	137996.0
2005-06-08 18:00:00	MSFT	Stock	25.39	25.4	25.39	25.4	2100.0
2005-06-08 08:00:00	NVDA	Stock	0.2307	0.2307	0.2279	0.2279	272880.0
2005-06-08 09:00:00	NVDA	Stock	0.2296	0.2312	0.2281	0.2299	58403640.0
2005-06-08 10:00:00	NVDA	Stock	0.23	0.2317	0.2269	0.2302	112559160.0
2005-06-08 11:00:00	NVDA	Stock	0.2302	0.2302	0.2278	0.2282	42799320.0
2005-06-08 12:00:00	NVDA	Stock	0.2282	0.2292	0.2281	0.2287	34126080.0
2005-06-08 13:00:00	NVDA	Stock	0.2286	0.2287	0.2258	0.2262	53275800.0
2005-06-08 14:00:00	NVDA	Stock	0.2262	0.2268	0.2239	0.2244	86954640.0
2005-06-08 15:00:00	NVDA	Stock	0.2244	0.2269	0.2242	0.2262	87518760.0
2005-06-08 16:00:00	NVDA	Stock	0.2263	0.2263	0.2261	0.2263	3858000.0
2005-06-08 17:00:00	NVDA	Stock	0.2257	0.2257	0.2257	0.2257	12000.0
2005-06-08 08:00:00	AMZN	Stock	1.77	1.774	1.769	1.7735	106000.0
2005-06-08 09:00:00	AMZN	Stock	1.774	1.7755	1.7635	1.766	15474940.0
2005-06-08 10:00:00	AMZN	Stock	1.7665	1.769	1.754	1.763	30674820.0
2005-06-08 11:00:00	AMZN	Stock	1.7626	1.764	1.75	1.7565	13566600.0
2005-06-08 12:00:00	AMZN	Stock	1.756	1.7585	1.754	1.7565	5374940.0
2005-06-08 13:00:00	AMZN	Stock	1.756	1.7565	1.746	1.7465	8129920.0
2005-06-08 14:00:00	AMZN	Stock	1.746	1.749	1.7415	1.742	13163380.0
2005-06-08 15:00:00	AMZN	Stock	1.7415	1.75	1.74	1.742	16380840.0
2005-06-08 16:00:00	AMZN	Stock	1.7425	1.745	1.741	1.7425	1287160.0
2005-06-08 17:00:00	AMZN	Stock	1.7415	1.7445	1.7415	1.7435	232000.0
2005-06-08 09:00:00	CL	Stock	24.825	24.845	24.735	24.79	340600.0
2005-06-08 10:00:00	CL	Stock	24.785	24.87	24.77	24.86	412800.0
2005-06-08 11:00:00	CL	Stock	24.86	24.9	24.85	24.9	280800.0
2005-06-08 12:00:00	CL	Stock	24.905	24.95	24.86	24.935	297600.0
2005-06-08 13:00:00	CL	Stock	24.935	24.96	24.925	24.94	493000.0
2005-06-08 14:00:00	CL	Stock	24.945	24.995	24.93	24.965	672000.0
2005-06-08 15:00:00	CL	Stock	24.965	24.995	24.89	24.915	1051400.0
2005-06-08 16:00:00	CL	Stock	24.9	24.9	24.9	24.9	58600.0

> showing 50 of 26,038 rows — these rows as CSV

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