PREVIEW / stock_1hour / 2003-10-17

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-10-17.parquet
  size:    470 KB
  rows:    22,226
  symbols: 1,644

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-10-17 08:00:00	AAPL	Stock	0.4127	0.4163	0.412	0.4163	162400.0
2003-10-17 09:00:00	AAPL	Stock	0.4161	0.4195	0.4083	0.4086	51259656.0
2003-10-17 10:00:00	AAPL	Stock	0.4086	0.4093	0.4029	0.405	67727184.0
2003-10-17 11:00:00	AAPL	Stock	0.405	0.4084	0.4005	0.4075	59321080.0
2003-10-17 12:00:00	AAPL	Stock	0.4079	0.4107	0.4059	0.4102	37137352.0
2003-10-17 13:00:00	AAPL	Stock	0.4102	0.4107	0.408	0.4098	18444496.0
2003-10-17 14:00:00	AAPL	Stock	0.41	0.4109	0.4066	0.4082	21550200.0
2003-10-17 15:00:00	AAPL	Stock	0.4082	0.4098	0.4059	0.4061	48547968.0
2003-10-17 16:00:00	AAPL	Stock	0.4059	0.4064	0.4036	0.4041	11866400.0
2003-10-17 17:00:00	AAPL	Stock	0.4073	0.4073	0.4054	0.4059	2503200.0
2003-10-17 08:00:00	MSFT	Stock	29.19	29.34	29.19	29.33	67292.0
2003-10-17 09:00:00	MSFT	Stock	29.33	29.35	29.04	29.06	6197476.0
2003-10-17 10:00:00	MSFT	Stock	29.07	29.1	28.8899	28.95	7868975.0
2003-10-17 11:00:00	MSFT	Stock	28.95	29.01	28.87	28.98	4648178.0
2003-10-17 12:00:00	MSFT	Stock	28.98	29.05	28.9	29.041	3429920.0
2003-10-17 13:00:00	MSFT	Stock	29.04	29.05	28.9	29.021	2242942.0
2003-10-17 14:00:00	MSFT	Stock	29.03	29.03	28.86	28.86	3903143.0
2003-10-17 15:00:00	MSFT	Stock	28.87	28.98	28.8	28.95	9954619.0
2003-10-17 16:00:00	MSFT	Stock	28.95	29.23	28.86	28.93	1043482.0
2003-10-17 17:00:00	MSFT	Stock	28.94	28.95	28.9212	28.93	1174700.0
2003-10-17 18:00:00	MSFT	Stock	28.93	28.94	28.93	28.94	3792.0
2003-10-17 08:00:00	NVDA	Stock	0.1437	0.1437	0.1437	0.1437	60000.0
2003-10-17 09:00:00	NVDA	Stock	0.1432	0.1452	0.1425	0.1425	41990280.0
2003-10-17 10:00:00	NVDA	Stock	0.1425	0.1425	0.14	0.1412	133913280.0
2003-10-17 11:00:00	NVDA	Stock	0.1413	0.1417	0.1402	0.1411	40666680.0
2003-10-17 12:00:00	NVDA	Stock	0.1411	0.1412	0.1401	0.1403	42596640.0
2003-10-17 13:00:00	NVDA	Stock	0.1402	0.1405	0.1397	0.1404	43908000.0
2003-10-17 14:00:00	NVDA	Stock	0.1403	0.1405	0.1392	0.1392	52630920.0
2003-10-17 15:00:00	NVDA	Stock	0.1392	0.1398	0.1387	0.1387	76092240.0
2003-10-17 16:00:00	NVDA	Stock	0.1389	0.1393	0.1387	0.1388	5400360.0
2003-10-17 17:00:00	NVDA	Stock	0.1391	0.1391	0.1387	0.1387	2352000.0
2003-10-17 18:00:00	NVDA	Stock	0.1391	0.1391	0.1391	0.1391	14400.0
2003-10-17 08:00:00	AMZN	Stock	2.911	2.993	2.908	2.949	1218000.0
2003-10-17 09:00:00	AMZN	Stock	2.949	2.995	2.9445	2.965	39789120.0
2003-10-17 10:00:00	AMZN	Stock	2.965	2.965	2.9325	2.947	43661840.0
2003-10-17 11:00:00	AMZN	Stock	2.9463	2.956	2.934	2.946	24277640.0
2003-10-17 12:00:00	AMZN	Stock	2.9455	2.9565	2.943	2.9545	14609900.0
2003-10-17 13:00:00	AMZN	Stock	2.9545	2.969	2.95	2.969	22787720.0
2003-10-17 14:00:00	AMZN	Stock	2.969	2.9715	2.9535	2.9535	22566000.0
2003-10-17 15:00:00	AMZN	Stock	2.953	2.9885	2.953	2.988	47316400.0
2003-10-17 16:00:00	AMZN	Stock	2.988	2.9885	2.975	2.988	4966420.0
2003-10-17 17:00:00	AMZN	Stock	2.979	2.988	2.9615	2.9795	488000.0
2003-10-17 18:00:00	AMZN	Stock	2.98	2.98	2.98	2.98	36000.0
2003-10-17 09:00:00	CL	Stock	28.85	28.89	28.8	28.81	540600.0
2003-10-17 10:00:00	CL	Stock	28.81	28.815	28.6	28.695	567200.0
2003-10-17 11:00:00	CL	Stock	28.685	28.685	28.555	28.6	406800.0
2003-10-17 12:00:00	CL	Stock	28.605	28.66	28.5	28.66	522200.0
2003-10-17 13:00:00	CL	Stock	28.66	28.675	28.59	28.665	349800.0
2003-10-17 14:00:00	CL	Stock	28.665	28.715	28.61	28.645	379600.0
2003-10-17 15:00:00	CL	Stock	28.625	28.7205	28.605	28.67	739600.0

> showing 50 of 22,226 rows — these rows as CSV

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