PREVIEW / stock_1hour / 2005-08-10

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-08-10.parquet
  size:    574 KB
  rows:    26,912
  symbols: 2,057

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-08-10 08:00:00	AAPL	Stock	1.5661	1.575	1.5661	1.5725	847980.0
2005-08-10 09:00:00	AAPL	Stock	1.5725	1.5793	1.5646	1.5793	54078080.0
2005-08-10 10:00:00	AAPL	Stock	1.5793	1.5854	1.5593	1.5607	91811692.0
2005-08-10 11:00:00	AAPL	Stock	1.5607	1.5696	1.56	1.5689	28994532.0
2005-08-10 12:00:00	AAPL	Stock	1.5689	1.5707	1.5554	1.5575	41533436.0
2005-08-10 13:00:00	AAPL	Stock	1.5575	1.5618	1.5521	1.5589	34758808.0
2005-08-10 14:00:00	AAPL	Stock	1.5589	1.5625	1.5504	1.5596	34857788.0
2005-08-10 15:00:00	AAPL	Stock	1.5596	1.5607	1.5468	1.5507	64394764.0
2005-08-10 16:00:00	AAPL	Stock	1.55	1.5589	1.5464	1.5511	2489844.0
2005-08-10 17:00:00	AAPL	Stock	1.5507	1.57	1.5493	1.57	2604000.0
2005-08-10 18:00:00	AAPL	Stock	1.5518	1.5521	1.5518	1.5518	25200.0
2005-08-10 08:00:00	MSFT	Stock	27.43	27.43	27.37	27.4	29074.0
2005-08-10 09:00:00	MSFT	Stock	27.4	27.49	27.37	27.48	5455615.0
2005-08-10 10:00:00	MSFT	Stock	27.48	27.5	27.26	27.31	10763285.0
2005-08-10 11:00:00	MSFT	Stock	27.31	27.35	27.17	27.25	7686895.0
2005-08-10 12:00:00	MSFT	Stock	27.241	27.26	27.08	27.17	6721068.0
2005-08-10 13:00:00	MSFT	Stock	27.17	27.19	27.08	27.12	6165363.0
2005-08-10 14:00:00	MSFT	Stock	27.119	27.13	27.0	27.06	9122720.0
2005-08-10 15:00:00	MSFT	Stock	27.06	27.06	26.85	26.94	14244310.0
2005-08-10 16:00:00	MSFT	Stock	26.95	27.07	26.93	26.99	451434.0
2005-08-10 17:00:00	MSFT	Stock	26.98	27.162	26.93	26.99	1484320.0
2005-08-10 18:00:00	MSFT	Stock	26.99	27.0	26.97	26.99	2900.0
2005-08-10 08:00:00	NVDA	Stock	0.2358	0.2358	0.2358	0.2358	24000.0
2005-08-10 09:00:00	NVDA	Stock	0.2357	0.2382	0.2356	0.2367	62926800.0
2005-08-10 10:00:00	NVDA	Stock	0.2367	0.2371	0.2353	0.237	62650080.0
2005-08-10 11:00:00	NVDA	Stock	0.237	0.2378	0.2367	0.237	48432960.0
2005-08-10 12:00:00	NVDA	Stock	0.237	0.2371	0.2347	0.2347	34643280.0
2005-08-10 13:00:00	NVDA	Stock	0.2348	0.2352	0.2325	0.233	69454920.0
2005-08-10 14:00:00	NVDA	Stock	0.2328	0.2335	0.2317	0.2319	60191760.0
2005-08-10 15:00:00	NVDA	Stock	0.2319	0.2322	0.2297	0.2322	93481200.0
2005-08-10 16:00:00	NVDA	Stock	0.2322	0.2325	0.2313	0.2322	3410280.0
2005-08-10 17:00:00	NVDA	Stock	0.2322	0.2344	0.2311	0.2313	4206000.0
2005-08-10 18:00:00	NVDA	Stock	0.2321	0.2322	0.2321	0.2321	168000.0
2005-08-10 07:00:00	AMZN	Stock	2.2695	2.2695	2.26	2.2695	8000.0
2005-08-10 08:00:00	AMZN	Stock	2.27	2.275	2.259	2.265	714600.0
2005-08-10 09:00:00	AMZN	Stock	2.265	2.276	2.246	2.2565	32323860.0
2005-08-10 10:00:00	AMZN	Stock	2.2565	2.264	2.248	2.255	28439420.0
2005-08-10 11:00:00	AMZN	Stock	2.255	2.2655	2.251	2.262	18100440.0
2005-08-10 12:00:00	AMZN	Stock	2.262	2.2785	2.261	2.263	20590680.0
2005-08-10 13:00:00	AMZN	Stock	2.262	2.2696	2.258	2.259	13564220.0
2005-08-10 14:00:00	AMZN	Stock	2.259	2.2595	2.236	2.238	38563020.0
2005-08-10 15:00:00	AMZN	Stock	2.238	2.245	2.2295	2.237	44323660.0
2005-08-10 16:00:00	AMZN	Stock	2.239	2.24	2.2335	2.236	550220.0
2005-08-10 17:00:00	AMZN	Stock	2.2375	2.2517	2.2374	2.2375	4885400.0
2005-08-10 18:00:00	AMZN	Stock	2.2375	2.2375	2.234	2.2345	12000.0
2005-08-10 09:00:00	CL	Stock	26.485	26.5	26.44	26.445	535200.0
2005-08-10 10:00:00	CL	Stock	26.45	26.61	26.44	26.54	657200.0
2005-08-10 11:00:00	CL	Stock	26.54	26.62	26.52	26.62	430400.0
2005-08-10 12:00:00	CL	Stock	26.61	26.615	26.415	26.45	364600.0
2005-08-10 13:00:00	CL	Stock	26.45	26.545	26.4	26.43	272400.0

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

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