PREVIEW / stock_1hour / 2004-09-17

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-09-17.parquet
  size:    512 KB
  rows:    23,637
  symbols: 1,823

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
2004-09-17 08:00:00	AAPL	Stock	0.65	0.6552	0.65	0.6548	434000.0
2004-09-17 09:00:00	AAPL	Stock	0.652	0.6588	0.65	0.6514	65705192.0
2004-09-17 10:00:00	AAPL	Stock	0.6511	0.6593	0.6507	0.6584	64011640.0
2004-09-17 11:00:00	AAPL	Stock	0.6584	0.6643	0.6577	0.6629	89311656.0
2004-09-17 12:00:00	AAPL	Stock	0.6629	0.6675	0.6627	0.6643	45390912.0
2004-09-17 13:00:00	AAPL	Stock	0.6643	0.6645	0.6605	0.6627	39782288.0
2004-09-17 14:00:00	AAPL	Stock	0.6627	0.6627	0.6598	0.6604	31354904.0
2004-09-17 15:00:00	AAPL	Stock	0.6605	0.6643	0.6586	0.6632	81382280.0
2004-09-17 16:00:00	AAPL	Stock	0.6632	0.6636	0.6627	0.6629	39670736.0
2004-09-17 17:00:00	AAPL	Stock	0.6632	0.6632	0.6631	0.6631	3102064.0
2004-09-17 18:00:00	AAPL	Stock	0.6631	0.6632	0.6631	0.6632	9312184.0
2004-09-17 08:00:00	MSFT	Stock	27.31	27.34	27.3	27.34	36415.0
2004-09-17 09:00:00	MSFT	Stock	27.33	27.45	27.27	27.3	7872572.0
2004-09-17 10:00:00	MSFT	Stock	27.3	27.38	27.27	27.37	6114237.0
2004-09-17 11:00:00	MSFT	Stock	27.37	27.37	27.28	27.29	4670453.0
2004-09-17 12:00:00	MSFT	Stock	27.29	27.32	27.28	27.319	3308788.0
2004-09-17 13:00:00	MSFT	Stock	27.31	27.35	27.3	27.35	4560839.0
2004-09-17 14:00:00	MSFT	Stock	27.35	27.44	27.32	27.421	7726686.0
2004-09-17 15:00:00	MSFT	Stock	27.43	27.53	27.38	27.5	13456862.0
2004-09-17 16:00:00	MSFT	Stock	27.5	27.5125	27.47	27.48	6621653.0
2004-09-17 17:00:00	MSFT	Stock	27.51	27.51	27.48	27.48	382417.0
2004-09-17 18:00:00	MSFT	Stock	27.505	27.51	27.48	27.48	1705294.0
2004-09-17 08:00:00	NVDA	Stock	0.1175	0.1179	0.1175	0.1179	12456000.0
2004-09-17 09:00:00	NVDA	Stock	0.1184	0.1202	0.1179	0.1179	107400840.0
2004-09-17 10:00:00	NVDA	Stock	0.118	0.1225	0.1175	0.1214	213264480.0
2004-09-17 11:00:00	NVDA	Stock	0.1213	0.1224	0.1202	0.1217	128724120.0
2004-09-17 12:00:00	NVDA	Stock	0.1217	0.1225	0.1209	0.1214	121399800.0
2004-09-17 13:00:00	NVDA	Stock	0.1214	0.1219	0.1211	0.1219	78688080.0
2004-09-17 14:00:00	NVDA	Stock	0.1219	0.1222	0.1216	0.1219	74102640.0
2004-09-17 15:00:00	NVDA	Stock	0.122	0.123	0.1218	0.1224	220939800.0
2004-09-17 16:00:00	NVDA	Stock	0.1224	0.1225	0.122	0.1224	10808880.0
2004-09-17 17:00:00	NVDA	Stock	0.122	0.1224	0.122	0.1223	746160.0
2004-09-17 18:00:00	NVDA	Stock	0.1223	0.1224	0.1218	0.1218	7311840.0
2004-09-17 08:00:00	AMZN	Stock	2.135	2.1525	2.1325	2.146	626500.0
2004-09-17 09:00:00	AMZN	Stock	2.146	2.155	2.1235	2.126	31723280.0
2004-09-17 10:00:00	AMZN	Stock	2.126	2.163	2.1195	2.155	41288340.0
2004-09-17 11:00:00	AMZN	Stock	2.1555	2.1565	2.137	2.151	15930540.0
2004-09-17 12:00:00	AMZN	Stock	2.1505	2.161	2.1475	2.1525	11041640.0
2004-09-17 13:00:00	AMZN	Stock	2.1525	2.156	2.136	2.1455	10836520.0
2004-09-17 14:00:00	AMZN	Stock	2.1465	2.1595	2.14	2.1575	12242040.0
2004-09-17 15:00:00	AMZN	Stock	2.157	2.158	2.1395	2.148	26293620.0
2004-09-17 16:00:00	AMZN	Stock	2.1485	2.1545	2.146	2.1505	3535540.0
2004-09-17 17:00:00	AMZN	Stock	2.1505	2.1505	2.148	2.148	191540.0
2004-09-17 09:00:00	CL	Stock	27.275	27.325	27.225	27.27	672400.0
2004-09-17 10:00:00	CL	Stock	27.24	27.36	27.235	27.335	467200.0
2004-09-17 11:00:00	CL	Stock	27.335	27.365	27.205	27.21	399200.0
2004-09-17 12:00:00	CL	Stock	27.2125	27.255	27.195	27.22	406200.0
2004-09-17 13:00:00	CL	Stock	27.225	27.25	27.195	27.2	377000.0
2004-09-17 14:00:00	CL	Stock	27.2	27.22	27.175	27.19	789400.0
2004-09-17 15:00:00	CL	Stock	27.195	27.215	27.14	27.15	938200.0

> showing 50 of 23,637 rows — these rows as CSV

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