PREVIEW / stock_1hour / 2005-08-05

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-08-05.parquet
  size:    567 KB
  rows:    26,833
  symbols: 2,048

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-05 08:00:00	AAPL	Stock	1.5232	1.5243	1.5164	1.5207	821800.0
2005-08-05 09:00:00	AAPL	Stock	1.5182	1.5486	1.5007	1.5425	62328448.0
2005-08-05 10:00:00	AAPL	Stock	1.5418	1.5425	1.5307	1.5346	47913684.0
2005-08-05 11:00:00	AAPL	Stock	1.5343	1.5368	1.5304	1.5311	15838480.0
2005-08-05 12:00:00	AAPL	Stock	1.5311	1.5393	1.5307	1.5371	20058836.0
2005-08-05 13:00:00	AAPL	Stock	1.5368	1.5479	1.5364	1.5404	32094188.0
2005-08-05 14:00:00	AAPL	Stock	1.5404	1.5429	1.5357	1.5379	20476624.0
2005-08-05 15:00:00	AAPL	Stock	1.5382	1.5418	1.5346	1.5357	33344724.0
2005-08-05 16:00:00	AAPL	Stock	1.5357	1.5407	1.5086	1.5293	2784544.0
2005-08-05 17:00:00	AAPL	Stock	1.5314	1.5314	1.5286	1.5286	61600.0
2005-08-05 18:00:00	AAPL	Stock	1.5289	1.5289	1.5286	1.5286	19600.0
2005-08-05 08:00:00	MSFT	Stock	27.35	27.44	27.3	27.34	73950.0
2005-08-05 09:00:00	MSFT	Stock	27.34	27.54	27.25	27.43	12288115.0
2005-08-05 10:00:00	MSFT	Stock	27.43	27.56	27.35	27.51	12196068.0
2005-08-05 11:00:00	MSFT	Stock	27.5	27.56	27.45	27.54	8183226.0
2005-08-05 12:00:00	MSFT	Stock	27.53	27.6	27.529	27.6	6676723.0
2005-08-05 13:00:00	MSFT	Stock	27.59	27.75	27.58	27.66	12599278.0
2005-08-05 14:00:00	MSFT	Stock	27.66	27.82	27.64	27.75	11186258.0
2005-08-05 15:00:00	MSFT	Stock	27.75	27.94	27.61	27.77	16881206.0
2005-08-05 16:00:00	MSFT	Stock	27.76	27.82	27.48	27.75	791248.0
2005-08-05 17:00:00	MSFT	Stock	27.76	27.77	27.7	27.76	4740.0
2005-08-05 18:00:00	MSFT	Stock	27.76	27.8	27.75	27.8	3330.0
2005-08-05 08:00:00	NVDA	Stock	0.2296	0.2317	0.2293	0.2293	366000.0
2005-08-05 09:00:00	NVDA	Stock	0.2292	0.2326	0.2277	0.2316	74457600.0
2005-08-05 10:00:00	NVDA	Stock	0.2315	0.233	0.23	0.2327	161628720.0
2005-08-05 11:00:00	NVDA	Stock	0.2327	0.2332	0.2317	0.2321	66170280.0
2005-08-05 12:00:00	NVDA	Stock	0.2321	0.234	0.2317	0.233	61259160.0
2005-08-05 13:00:00	NVDA	Stock	0.233	0.2338	0.2321	0.2324	34075800.0
2005-08-05 14:00:00	NVDA	Stock	0.2324	0.2342	0.2321	0.2341	71499000.0
2005-08-05 15:00:00	NVDA	Stock	0.2341	0.2359	0.2337	0.2354	202606680.0
2005-08-05 16:00:00	NVDA	Stock	0.2357	0.2358	0.235	0.235	1546800.0
2005-08-05 17:00:00	NVDA	Stock	0.2351	0.2351	0.2351	0.2351	24000.0
2005-08-05 18:00:00	NVDA	Stock	0.2357	0.2357	0.2357	0.2357	13200.0
2005-08-05 08:00:00	AMZN	Stock	2.2775	2.28	2.2735	2.275	140000.0
2005-08-05 09:00:00	AMZN	Stock	2.2725	2.2755	2.261	2.2705	16161540.0
2005-08-05 10:00:00	AMZN	Stock	2.2705	2.2705	2.2585	2.2635	18566580.0
2005-08-05 11:00:00	AMZN	Stock	2.264	2.2855	2.264	2.264	16154920.0
2005-08-05 12:00:00	AMZN	Stock	2.2635	2.269	2.26	2.2625	11809620.0
2005-08-05 13:00:00	AMZN	Stock	2.263	2.2795	2.2625	2.271	12282020.0
2005-08-05 14:00:00	AMZN	Stock	2.271	2.271	2.264	2.2695	7014940.0
2005-08-05 15:00:00	AMZN	Stock	2.27	2.2745	2.264	2.264	15303940.0
2005-08-05 16:00:00	AMZN	Stock	2.264	2.272	2.2625	2.267	233380.0
2005-08-05 17:00:00	AMZN	Stock	2.267	2.267	2.2645	2.2645	50000.0
2005-08-05 18:00:00	AMZN	Stock	2.269	2.269	2.269	2.269	8000.0
2005-08-05 09:00:00	CL	Stock	26.2	26.245	26.125	26.155	216600.0
2005-08-05 10:00:00	CL	Stock	26.155	26.37	26.125	26.305	408000.0
2005-08-05 11:00:00	CL	Stock	26.305	26.315	26.235	26.24	358600.0
2005-08-05 12:00:00	CL	Stock	26.24	26.335	26.235	26.32	236800.0
2005-08-05 13:00:00	CL	Stock	26.315	26.375	26.31	26.325	274000.0
2005-08-05 14:00:00	CL	Stock	26.325	26.34	26.275	26.305	370400.0

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

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