PREVIEW / stock_1hour / 2000-06-01

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-06-01.parquet
  size:    290 KB
  rows:    14,888
  symbols: 1,165

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
2000-06-01 08:00:00	AAPL	Stock	0.7503	0.769	0.7238	0.7254	6585600.0
2000-06-01 09:00:00	AAPL	Stock	0.7254	0.7411	0.7143	0.7232	159230400.0
2000-06-01 10:00:00	AAPL	Stock	0.7232	0.7718	0.7221	0.7522	205844800.0
2000-06-01 11:00:00	AAPL	Stock	0.7522	0.7645	0.7506	0.764	100284800.0
2000-06-01 12:00:00	AAPL	Stock	0.7634	0.7896	0.7617	0.7868	98828800.0
2000-06-01 13:00:00	AAPL	Stock	0.7868	0.7966	0.7824	0.7846	90294400.0
2000-06-01 14:00:00	AAPL	Stock	0.784	0.7907	0.7773	0.7857	87696000.0
2000-06-01 15:00:00	AAPL	Stock	0.7852	0.7997	0.7768	0.7958	104563200.0
2000-06-01 16:00:00	AAPL	Stock	0.7958	0.7958	0.7243	0.7958	16004800.0
2000-06-01 17:00:00	AAPL	Stock	0.7969	0.8036	0.7969	0.8013	145600.0
2000-06-01 18:00:00	AAPL	Stock	0.798	0.798	0.7969	0.7969	33600.0
2000-06-01 08:00:00	MSFT	Stock	31.2656	32.5	31.25	32.125	679800.0
2000-06-01 09:00:00	MSFT	Stock	32.125	32.6562	31.2812	32.625	18345400.0
2000-06-01 10:00:00	MSFT	Stock	32.625	32.9375	32.4375	32.5625	17042200.0
2000-06-01 11:00:00	MSFT	Stock	32.5312	32.8438	32.2812	32.8125	10775400.0
2000-06-01 12:00:00	MSFT	Stock	32.8125	32.9375	32.6562	32.7812	8485600.0
2000-06-01 13:00:00	MSFT	Stock	32.7812	33.0	32.0625	32.25	6824400.0
2000-06-01 14:00:00	MSFT	Stock	32.375	32.5312	31.9062	32.0312	12482400.0
2000-06-01 15:00:00	MSFT	Stock	32.0625	32.375	31.9375	32.2812	17119400.0
2000-06-01 16:00:00	MSFT	Stock	32.25	32.625	32.0	32.25	1621800.0
2000-06-01 17:00:00	MSFT	Stock	32.875	32.9062	32.1562	32.3438	141800.0
2000-06-01 18:00:00	MSFT	Stock	32.3438	32.3438	32.1875	32.25	6600.0
2000-06-01 08:00:00	NVDA	Stock	0.2398	0.2398	0.2396	0.2398	288000.0
2000-06-01 09:00:00	NVDA	Stock	0.2418	0.2469	0.2391	0.2417	107232000.0
2000-06-01 10:00:00	NVDA	Stock	0.2417	0.2427	0.2406	0.2417	62400000.0
2000-06-01 11:00:00	NVDA	Stock	0.2415	0.2465	0.2411	0.2451	63648000.0
2000-06-01 12:00:00	NVDA	Stock	0.2461	0.2461	0.2405	0.2428	41760000.0
2000-06-01 13:00:00	NVDA	Stock	0.2424	0.2434	0.2414	0.2421	26976000.0
2000-06-01 14:00:00	NVDA	Stock	0.2415	0.243	0.2383	0.2391	40848000.0
2000-06-01 15:00:00	NVDA	Stock	0.2395	0.2458	0.2391	0.2444	64848000.0
2000-06-01 16:00:00	NVDA	Stock	0.2444	0.2445	0.2423	0.2423	3600000.0
2000-06-01 17:00:00	NVDA	Stock	0.2435	0.2437	0.2396	0.2396	720000.0
2000-06-01 08:00:00	AMZN	Stock	2.45	2.45	2.4094	2.4219	100000.0
2000-06-01 09:00:00	AMZN	Stock	2.4219	2.4563	2.3281	2.3313	18074000.0
2000-06-01 10:00:00	AMZN	Stock	2.3313	2.4031	2.3188	2.3812	30814000.0
2000-06-01 11:00:00	AMZN	Stock	2.3844	2.4375	2.375	2.4375	11510000.0
2000-06-01 12:00:00	AMZN	Stock	2.4375	2.4875	2.4125	2.4781	14288000.0
2000-06-01 13:00:00	AMZN	Stock	2.4812	2.5188	2.4625	2.4938	14808000.0
2000-06-01 14:00:00	AMZN	Stock	2.4938	2.5563	2.475	2.5062	28482000.0
2000-06-01 15:00:00	AMZN	Stock	2.5031	2.5438	2.4812	2.5062	27788000.0
2000-06-01 16:00:00	AMZN	Stock	2.5078	2.5219	2.35	2.5094	3022000.0
2000-06-01 17:00:00	AMZN	Stock	2.5094	2.5188	2.5	2.5031	24000.0
2000-06-01 09:00:00	CL	Stock	27.0625	27.125	26.8125	26.875	983400.0
2000-06-01 10:00:00	CL	Stock	26.8438	27.3125	26.7812	27.1875	712600.0
2000-06-01 11:00:00	CL	Stock	27.1875	27.4688	27.0938	27.125	562400.0
2000-06-01 12:00:00	CL	Stock	27.1562	27.1562	26.9375	27.0	408800.0
2000-06-01 13:00:00	CL	Stock	27.0312	27.0312	26.9062	26.9375	439000.0
2000-06-01 14:00:00	CL	Stock	26.9375	26.9688	26.25	26.75	964400.0
2000-06-01 15:00:00	CL	Stock	26.75	26.875	26.6562	26.6562	781800.0
2000-06-01 16:00:00	CL	Stock	26.6562	26.6562	26.625	26.6562	253000.0

> showing 50 of 14,888 rows — these rows as CSV

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