PREVIEW / stock_1hour / 2003-09-26

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-09-26.parquet
  size:    463 KB
  rows:    21,761
  symbols: 1,615

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
2003-09-26 08:00:00	AAPL	Stock	0.3627	0.3627	0.3621	0.3627	128800.0
2003-09-26 09:00:00	AAPL	Stock	0.3627	0.3643	0.3602	0.3616	36842512.0
2003-09-26 10:00:00	AAPL	Stock	0.3616	0.3661	0.3598	0.3632	70987504.0
2003-09-26 11:00:00	AAPL	Stock	0.363	0.3659	0.3625	0.3648	39825296.0
2003-09-26 12:00:00	AAPL	Stock	0.3651	0.3704	0.3646	0.3684	33135816.0
2003-09-26 13:00:00	AAPL	Stock	0.3684	0.3732	0.3684	0.3713	21184352.0
2003-09-26 14:00:00	AAPL	Stock	0.3716	0.3754	0.3696	0.3702	50573544.0
2003-09-26 15:00:00	AAPL	Stock	0.3702	0.3752	0.3684	0.3696	63430808.0
2003-09-26 16:00:00	AAPL	Stock	0.3688	0.3705	0.3684	0.3688	4166400.0
2003-09-26 17:00:00	AAPL	Stock	0.3695	0.3695	0.3688	0.3695	106400.0
2003-09-26 08:00:00	MSFT	Stock	28.18	28.3	28.08	28.3	948165.0
2003-09-26 09:00:00	MSFT	Stock	28.27	28.49	28.21	28.36	7228746.0
2003-09-26 10:00:00	MSFT	Stock	28.368	28.78	28.247	28.56	7728639.0
2003-09-26 11:00:00	MSFT	Stock	28.56	28.65	28.299	28.37	6550338.0
2003-09-26 12:00:00	MSFT	Stock	28.37	28.55	28.28	28.42	4455777.0
2003-09-26 13:00:00	MSFT	Stock	28.42	28.62	28.39	28.46	2878942.0
2003-09-26 14:00:00	MSFT	Stock	28.459	28.58	28.23	28.27	3473666.0
2003-09-26 15:00:00	MSFT	Stock	28.27	28.48	28.18	28.19	7968910.0
2003-09-26 16:00:00	MSFT	Stock	28.19	28.23	28.08	28.19	602917.0
2003-09-26 17:00:00	MSFT	Stock	28.19	28.23	28.18	28.23	20920.0
2003-09-26 18:00:00	MSFT	Stock	28.23	28.23	28.21	28.21	1000.0
2003-09-26 08:00:00	NVDA	Stock	0.1455	0.1459	0.1455	0.1459	288000.0
2003-09-26 09:00:00	NVDA	Stock	0.1458	0.1462	0.1434	0.1453	69674520.0
2003-09-26 10:00:00	NVDA	Stock	0.1453	0.1456	0.1417	0.142	140829360.0
2003-09-26 11:00:00	NVDA	Stock	0.142	0.1431	0.1405	0.1405	118077000.0
2003-09-26 12:00:00	NVDA	Stock	0.1405	0.1426	0.1386	0.1419	125476800.0
2003-09-26 13:00:00	NVDA	Stock	0.1419	0.1431	0.1417	0.1421	63638760.0
2003-09-26 14:00:00	NVDA	Stock	0.142	0.1427	0.141	0.1411	70279080.0
2003-09-26 15:00:00	NVDA	Stock	0.1411	0.1417	0.1392	0.1402	149747040.0
2003-09-26 16:00:00	NVDA	Stock	0.1402	0.1405	0.1391	0.14	5475600.0
2003-09-26 17:00:00	NVDA	Stock	0.14	0.1404	0.1398	0.1404	761640.0
2003-09-26 18:00:00	NVDA	Stock	0.1404	0.1405	0.1404	0.1405	88800.0
2003-09-26 08:00:00	AMZN	Stock	2.4915	2.5025	2.4915	2.5	241500.0
2003-09-26 09:00:00	AMZN	Stock	2.5	2.5185	2.485	2.5	20691200.0
2003-09-26 10:00:00	AMZN	Stock	2.499	2.523	2.4705	2.5055	37965680.0
2003-09-26 11:00:00	AMZN	Stock	2.505	2.515	2.4815	2.482	28920900.0
2003-09-26 12:00:00	AMZN	Stock	2.482	2.4825	2.444	2.4525	44824660.0
2003-09-26 13:00:00	AMZN	Stock	2.4525	2.4585	2.447	2.4508	21082400.0
2003-09-26 14:00:00	AMZN	Stock	2.451	2.4555	2.4155	2.421	35608960.0
2003-09-26 15:00:00	AMZN	Stock	2.419	2.456	2.415	2.428	37452200.0
2003-09-26 16:00:00	AMZN	Stock	2.429	2.441	2.425	2.4305	2303640.0
2003-09-26 17:00:00	AMZN	Stock	2.429	2.4325	2.426	2.4325	256000.0
2003-09-26 18:00:00	AMZN	Stock	2.4285	2.43	2.4285	2.4285	22000.0
2003-09-26 09:00:00	CL	Stock	27.855	27.945	27.72	27.925	363200.0
2003-09-26 10:00:00	CL	Stock	27.935	27.945	27.605	27.7	432400.0
2003-09-26 11:00:00	CL	Stock	27.7	27.705	27.59	27.61	282200.0
2003-09-26 12:00:00	CL	Stock	27.62	27.73	27.54	27.725	242200.0
2003-09-26 13:00:00	CL	Stock	27.72	27.82	27.695	27.705	237000.0
2003-09-26 14:00:00	CL	Stock	27.7	27.76	27.585	27.595	284600.0
2003-09-26 15:00:00	CL	Stock	27.6	27.745	27.58	27.69	348800.0

> showing 50 of 21,761 rows — these rows as CSV

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