PREVIEW / stock_1hour / 2003-10-15

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-10-15.parquet
  size:    480 KB
  rows:    22,578
  symbols: 1,646

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-15 08:00:00	AAPL	Stock	0.442	0.4464	0.4411	0.4464	744352.0
2003-10-15 09:00:00	AAPL	Stock	0.4455	0.4455	0.4389	0.4429	56650048.0
2003-10-15 10:00:00	AAPL	Stock	0.4429	0.4457	0.4391	0.4455	71430128.0
2003-10-15 11:00:00	AAPL	Stock	0.4455	0.4457	0.4429	0.4455	33825400.0
2003-10-15 12:00:00	AAPL	Stock	0.4454	0.4466	0.4445	0.4463	56163520.0
2003-10-15 13:00:00	AAPL	Stock	0.4459	0.4464	0.4446	0.4457	38055360.0
2003-10-15 14:00:00	AAPL	Stock	0.4459	0.4463	0.4434	0.4441	57667344.0
2003-10-15 15:00:00	AAPL	Stock	0.4439	0.445	0.4425	0.4438	213738280.0
2003-10-15 16:00:00	AAPL	Stock	0.4438	0.4525	0.4234	0.4286	37371040.0
2003-10-15 17:00:00	AAPL	Stock	0.4286	0.4438	0.4216	0.4241	11712288.0
2003-10-15 18:00:00	AAPL	Stock	0.4245	0.425	0.423	0.425	912800.0
2003-10-15 08:00:00	MSFT	Stock	29.0	29.37	28.9	29.15	674136.0
2003-10-15 09:00:00	MSFT	Stock	29.15	29.27	28.95	29.05	9080708.0
2003-10-15 10:00:00	MSFT	Stock	29.05	29.13	28.83	29.12	10015961.0
2003-10-15 11:00:00	MSFT	Stock	29.12	29.19	29.05	29.12	5548059.0
2003-10-15 12:00:00	MSFT	Stock	29.11	29.2	29.097	29.161	3487582.0
2003-10-15 13:00:00	MSFT	Stock	29.16	29.17	29.051	29.1	3342660.0
2003-10-15 14:00:00	MSFT	Stock	29.1	29.15	28.91	28.95	6617601.0
2003-10-15 15:00:00	MSFT	Stock	28.95	29.15	28.88	29.14	7779686.0
2003-10-15 16:00:00	MSFT	Stock	29.13	29.14	28.79	28.9	920052.0
2003-10-15 17:00:00	MSFT	Stock	28.85	29.164	28.84	28.96	1692700.0
2003-10-15 18:00:00	MSFT	Stock	28.97	28.99	28.93	28.94	23030.0
2003-10-15 08:00:00	NVDA	Stock	0.145	0.1466	0.145	0.146	1956000.0
2003-10-15 09:00:00	NVDA	Stock	0.1467	0.1477	0.1437	0.1456	142852920.0
2003-10-15 10:00:00	NVDA	Stock	0.1456	0.146	0.1443	0.1458	134997720.0
2003-10-15 11:00:00	NVDA	Stock	0.1458	0.1464	0.1449	0.1449	86931240.0
2003-10-15 12:00:00	NVDA	Stock	0.1449	0.1458	0.1446	0.1452	46477680.0
2003-10-15 13:00:00	NVDA	Stock	0.1452	0.1452	0.1442	0.1443	61501560.0
2003-10-15 14:00:00	NVDA	Stock	0.1444	0.1445	0.1407	0.1419	103495800.0
2003-10-15 15:00:00	NVDA	Stock	0.1419	0.1428	0.1412	0.1416	82873680.0
2003-10-15 16:00:00	NVDA	Stock	0.1417	0.1418	0.1396	0.1407	5364000.0
2003-10-15 17:00:00	NVDA	Stock	0.1407	0.1415	0.1407	0.141	1368000.0
2003-10-15 18:00:00	NVDA	Stock	0.1407	0.1407	0.1407	0.1407	60000.0
2003-10-15 08:00:00	AMZN	Stock	3.0005	3.036	3.0005	3.018	346000.0
2003-10-15 09:00:00	AMZN	Stock	3.025	3.0264	2.965	2.9825	37756720.0
2003-10-15 10:00:00	AMZN	Stock	2.9837	2.984	2.95	2.969	50923000.0
2003-10-15 11:00:00	AMZN	Stock	2.97	2.9715	2.9425	2.951	24116620.0
2003-10-15 12:00:00	AMZN	Stock	2.951	2.9745	2.9485	2.9655	16518020.0
2003-10-15 13:00:00	AMZN	Stock	2.966	2.966	2.9535	2.9584	9018940.0
2003-10-15 14:00:00	AMZN	Stock	2.9585	2.9655	2.9215	2.933	23419700.0
2003-10-15 15:00:00	AMZN	Stock	2.933	2.9375	2.922	2.9275	22806280.0
2003-10-15 16:00:00	AMZN	Stock	2.9265	2.937	2.9155	2.9155	5080840.0
2003-10-15 17:00:00	AMZN	Stock	2.9175	2.9601	2.9155	2.9225	968000.0
2003-10-15 18:00:00	AMZN	Stock	2.92	2.92	2.9125	2.9125	88000.0
2003-10-15 09:00:00	CL	Stock	29.13	29.36	29.07	29.34	293600.0
2003-10-15 10:00:00	CL	Stock	29.34	29.3405	29.2	29.25	382000.0
2003-10-15 11:00:00	CL	Stock	29.25	29.27	29.175	29.215	342800.0
2003-10-15 12:00:00	CL	Stock	29.215	29.275	29.21	29.24	241800.0
2003-10-15 13:00:00	CL	Stock	29.245	29.245	29.175	29.215	342600.0
2003-10-15 14:00:00	CL	Stock	29.215	29.27	29.165	29.195	360000.0

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

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