PREVIEW / stock_1hour / 2003-10-23

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-10-23.parquet
  size:    470 KB
  rows:    22,096
  symbols: 1,641

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-23 08:00:00	AAPL	Stock	0.402	0.4061	0.3955	0.4021	546560.0
2003-10-23 09:00:00	AAPL	Stock	0.4032	0.4113	0.4021	0.4113	20295856.0
2003-10-23 10:00:00	AAPL	Stock	0.4107	0.4132	0.4068	0.4104	31679816.0
2003-10-23 11:00:00	AAPL	Stock	0.4107	0.4107	0.4057	0.4084	15278200.0
2003-10-23 12:00:00	AAPL	Stock	0.4086	0.4132	0.4073	0.4111	31767232.0
2003-10-23 13:00:00	AAPL	Stock	0.4109	0.4116	0.4088	0.4111	13406176.0
2003-10-23 14:00:00	AAPL	Stock	0.4107	0.4125	0.4079	0.4091	15977752.0
2003-10-23 15:00:00	AAPL	Stock	0.4091	0.4107	0.4066	0.4095	21325416.0
2003-10-23 16:00:00	AAPL	Stock	0.4094	0.4107	0.4073	0.408	1887200.0
2003-10-23 17:00:00	AAPL	Stock	0.4089	0.4116	0.408	0.4116	1937600.0
2003-10-23 18:00:00	AAPL	Stock	0.4089	0.4089	0.4036	0.4036	548800.0
2003-10-23 08:00:00	MSFT	Stock	28.6	28.68	28.52	28.68	113327.0
2003-10-23 09:00:00	MSFT	Stock	28.89	29.07	28.65	28.98	5270708.0
2003-10-23 10:00:00	MSFT	Stock	28.98	29.08	28.88	28.95	6490992.0
2003-10-23 11:00:00	MSFT	Stock	28.95	29.01	28.79	28.94	5568287.0
2003-10-23 12:00:00	MSFT	Stock	28.93	29.01	28.87	28.95	4258710.0
2003-10-23 13:00:00	MSFT	Stock	28.95	28.97	28.899	28.94	4006448.0
2003-10-23 14:00:00	MSFT	Stock	28.93	29.01	28.8	28.82	6546915.0
2003-10-23 15:00:00	MSFT	Stock	28.82	28.94	28.76	28.93	11449505.0
2003-10-23 16:00:00	MSFT	Stock	28.93	29.53	27.94	28.12	14334813.0
2003-10-23 17:00:00	MSFT	Stock	28.13	28.3	27.8	27.8	1481231.0
2003-10-23 18:00:00	MSFT	Stock	27.8	27.84	27.5	27.54	1700918.0
2003-10-23 08:00:00	NVDA	Stock	0.1425	0.1425	0.1408	0.1411	1929960.0
2003-10-23 09:00:00	NVDA	Stock	0.1411	0.1435	0.1408	0.1432	55832040.0
2003-10-23 10:00:00	NVDA	Stock	0.1432	0.1439	0.1416	0.1427	54728880.0
2003-10-23 11:00:00	NVDA	Stock	0.1426	0.1428	0.1417	0.1422	45583680.0
2003-10-23 12:00:00	NVDA	Stock	0.1422	0.1436	0.1422	0.1432	47159520.0
2003-10-23 13:00:00	NVDA	Stock	0.1432	0.1454	0.143	0.1454	65160480.0
2003-10-23 14:00:00	NVDA	Stock	0.1453	0.1458	0.1437	0.1437	46102680.0
2003-10-23 15:00:00	NVDA	Stock	0.1438	0.1439	0.1425	0.1433	65613360.0
2003-10-23 16:00:00	NVDA	Stock	0.1433	0.1437	0.1422	0.1422	4585560.0
2003-10-23 17:00:00	NVDA	Stock	0.1427	0.1433	0.1426	0.1433	1275600.0
2003-10-23 18:00:00	NVDA	Stock	0.1429	0.1429	0.1423	0.1429	120000.0
2003-10-23 08:00:00	AMZN	Stock	2.65	2.673	2.62	2.6425	1680960.0
2003-10-23 09:00:00	AMZN	Stock	2.645	2.7165	2.641	2.7133	71918840.0
2003-10-23 10:00:00	AMZN	Stock	2.7145	2.7175	2.677	2.6925	53935220.0
2003-10-23 11:00:00	AMZN	Stock	2.6925	2.7	2.67	2.675	31055660.0
2003-10-23 12:00:00	AMZN	Stock	2.675	2.7035	2.6745	2.6955	17187260.0
2003-10-23 13:00:00	AMZN	Stock	2.696	2.7045	2.688	2.702	16332520.0
2003-10-23 14:00:00	AMZN	Stock	2.7025	2.7125	2.6915	2.6935	26019180.0
2003-10-23 15:00:00	AMZN	Stock	2.6935	2.726	2.6924	2.7155	38292400.0
2003-10-23 16:00:00	AMZN	Stock	2.714	2.7275	2.71	2.7135	3190420.0
2003-10-23 17:00:00	AMZN	Stock	2.7135	2.731	2.692	2.7275	1695000.0
2003-10-23 18:00:00	AMZN	Stock	2.73	2.73	2.7105	2.7155	518000.0
2003-10-23 09:00:00	CL	Stock	27.125	28.395	27.125	27.15	2487000.0
2003-10-23 10:00:00	CL	Stock	27.15	27.22	26.58	26.99	3700800.0
2003-10-23 11:00:00	CL	Stock	26.99	27.05	26.8	26.865	2758800.0
2003-10-23 12:00:00	CL	Stock	26.85	26.955	26.84	26.895	1659800.0
2003-10-23 13:00:00	CL	Stock	26.9	27.03	26.875	26.93	1636600.0
2003-10-23 14:00:00	CL	Stock	26.93	27.005	26.735	26.735	2712000.0

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

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