PREVIEW / stock_1hour / 2005-08-08

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-08-08.parquet
  size:    558 KB
  rows:    26,553
  symbols: 2,050

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-08 08:00:00	AAPL	Stock	1.5346	1.5464	1.5332	1.5425	453880.0
2005-08-08 09:00:00	AAPL	Stock	1.5421	1.5429	1.5232	1.5407	31655792.0
2005-08-08 10:00:00	AAPL	Stock	1.5407	1.5446	1.5254	1.5293	32177432.0
2005-08-08 11:00:00	AAPL	Stock	1.5296	1.5357	1.5279	1.5336	18540676.0
2005-08-08 12:00:00	AAPL	Stock	1.5329	1.5364	1.5304	1.5329	11425148.0
2005-08-08 13:00:00	AAPL	Stock	1.5332	1.5357	1.53	1.5332	14138656.0
2005-08-08 14:00:00	AAPL	Stock	1.5329	1.5332	1.5218	1.5279	29558396.0
2005-08-08 15:00:00	AAPL	Stock	1.5279	1.5311	1.5232	1.5254	26707324.0
2005-08-08 16:00:00	AAPL	Stock	1.5246	1.5479	1.5071	1.5246	4259808.0
2005-08-08 17:00:00	AAPL	Stock	1.5218	1.525	1.5218	1.5239	52472.0
2005-08-08 18:00:00	AAPL	Stock	1.5221	1.5254	1.5221	1.5254	170996.0
2005-08-08 08:00:00	MSFT	Stock	27.8	27.9	27.75	27.88	112808.0
2005-08-08 09:00:00	MSFT	Stock	27.87	27.9	27.36	27.5	12091456.0
2005-08-08 10:00:00	MSFT	Stock	27.51	27.56	27.26	27.32	12674479.0
2005-08-08 11:00:00	MSFT	Stock	27.33	27.42	27.28	27.312	7507268.0
2005-08-08 12:00:00	MSFT	Stock	27.31	27.53	27.2	27.23	7295542.0
2005-08-08 13:00:00	MSFT	Stock	27.24	27.332	27.09	27.16	10831090.0
2005-08-08 14:00:00	MSFT	Stock	27.16	27.26	27.08	27.25	7789665.0
2005-08-08 15:00:00	MSFT	Stock	27.25	27.291	27.1	27.13	16073162.0
2005-08-08 16:00:00	MSFT	Stock	27.12	27.17	27.12	27.15	297702.0
2005-08-08 17:00:00	MSFT	Stock	27.13	27.16	27.12	27.15	16066.0
2005-08-08 18:00:00	MSFT	Stock	27.14	27.18	27.11	27.17	76950.0
2005-08-08 08:00:00	NVDA	Stock	0.2354	0.2387	0.2354	0.2375	483000.0
2005-08-08 09:00:00	NVDA	Stock	0.2377	0.2414	0.2359	0.2407	169661520.0
2005-08-08 10:00:00	NVDA	Stock	0.2407	0.2411	0.2379	0.2382	121610640.0
2005-08-08 11:00:00	NVDA	Stock	0.2383	0.2386	0.2374	0.2382	75520200.0
2005-08-08 12:00:00	NVDA	Stock	0.2382	0.2382	0.2361	0.2374	65462160.0
2005-08-08 13:00:00	NVDA	Stock	0.2374	0.2374	0.2361	0.2367	46502640.0
2005-08-08 14:00:00	NVDA	Stock	0.2368	0.2375	0.2364	0.2371	90489240.0
2005-08-08 15:00:00	NVDA	Stock	0.2371	0.2372	0.2346	0.2362	135299160.0
2005-08-08 16:00:00	NVDA	Stock	0.2359	0.2366	0.2359	0.2366	575280.0
2005-08-08 17:00:00	NVDA	Stock	0.2366	0.2383	0.2366	0.2383	734160.0
2005-08-08 18:00:00	NVDA	Stock	0.2362	0.2362	0.2362	0.2362	134280.0
2005-08-08 09:00:00	AMZN	Stock	2.2675	2.2765	2.263	2.273	8872540.0
2005-08-08 10:00:00	AMZN	Stock	2.273	2.28	2.2635	2.2665	20860740.0
2005-08-08 11:00:00	AMZN	Stock	2.267	2.272	2.2645	2.2685	6615320.0
2005-08-08 12:00:00	AMZN	Stock	2.2684	2.282	2.2658	2.2815	6494440.0
2005-08-08 13:00:00	AMZN	Stock	2.281	2.2885	2.281	2.2845	9359220.0
2005-08-08 14:00:00	AMZN	Stock	2.2845	2.2865	2.27	2.2855	8236760.0
2005-08-08 15:00:00	AMZN	Stock	2.285	2.295	2.282	2.283	21965600.0
2005-08-08 16:00:00	AMZN	Stock	2.2835	2.288	2.2825	2.2875	319460.0
2005-08-08 17:00:00	AMZN	Stock	2.2875	2.29	2.2875	2.29	13080.0
2005-08-08 18:00:00	AMZN	Stock	2.2885	2.2885	2.283	2.283	23400.0
2005-08-08 09:00:00	CL	Stock	26.31	26.455	26.31	26.415	327400.0
2005-08-08 10:00:00	CL	Stock	26.415	26.44	26.32	26.32	567200.0
2005-08-08 11:00:00	CL	Stock	26.32	26.33	26.205	26.255	363200.0
2005-08-08 12:00:00	CL	Stock	26.255	26.305	26.225	26.305	180600.0
2005-08-08 13:00:00	CL	Stock	26.305	26.31	26.255	26.265	205000.0
2005-08-08 14:00:00	CL	Stock	26.265	26.265	26.225	26.26	257000.0
2005-08-08 15:00:00	CL	Stock	26.26	26.305	26.24	26.29	386800.0

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

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