PREVIEW / stock_1hour / 2004-11-24

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-11-24.parquet
  size:    516 KB
  rows:    24,356
  symbols: 1,873

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-11-24 08:00:00	AAPL	Stock	1.0946	1.1089	1.0946	1.1027	1583064.0
2004-11-24 09:00:00	AAPL	Stock	1.1027	1.1071	1.0982	1.1018	112378784.0
2004-11-24 10:00:00	AAPL	Stock	1.1023	1.1325	1.1011	1.1245	285180056.0
2004-11-24 11:00:00	AAPL	Stock	1.1243	1.1311	1.118	1.1293	158995928.0
2004-11-24 12:00:00	AAPL	Stock	1.1293	1.1304	1.1241	1.1284	74127592.0
2004-11-24 13:00:00	AAPL	Stock	1.1282	1.1327	1.1264	1.1304	65743272.0
2004-11-24 14:00:00	AAPL	Stock	1.13	1.1643	1.1295	1.1504	354660376.0
2004-11-24 15:00:00	AAPL	Stock	1.1505	1.1554	1.1379	1.1429	290102904.0
2004-11-24 16:00:00	AAPL	Stock	1.143	1.1441	1.1414	1.1427	8950928.0
2004-11-24 17:00:00	AAPL	Stock	1.1442	1.1442	1.142	1.1429	1064000.0
2004-11-24 18:00:00	AAPL	Stock	1.1429	1.1443	1.1429	1.1443	229600.0
2004-11-24 08:00:00	MSFT	Stock	26.61	26.64	26.6	26.6	13343.0
2004-11-24 09:00:00	MSFT	Stock	26.6	26.66	26.5	26.62	6553418.0
2004-11-24 10:00:00	MSFT	Stock	26.62	26.73	26.59	26.67	9073797.0
2004-11-24 11:00:00	MSFT	Stock	26.68	26.69	26.62	26.67	5648820.0
2004-11-24 12:00:00	MSFT	Stock	26.68	26.71	26.64	26.67	17455430.0
2004-11-24 13:00:00	MSFT	Stock	26.67	26.71	26.62	26.69	3578534.0
2004-11-24 14:00:00	MSFT	Stock	26.7	26.7	26.65	26.66	5306852.0
2004-11-24 15:00:00	MSFT	Stock	26.66	26.69	26.62	26.64	5419097.0
2004-11-24 16:00:00	MSFT	Stock	26.64	26.72	26.52	26.64	5398891.0
2004-11-24 17:00:00	MSFT	Stock	26.65	26.65	26.63	26.63	44326.0
2004-11-24 18:00:00	MSFT	Stock	26.65	26.65	26.65	26.65	1800.0
2004-11-24 08:00:00	NVDA	Stock	0.1642	0.165	0.1642	0.165	314400.0
2004-11-24 09:00:00	NVDA	Stock	0.1647	0.1665	0.1626	0.1647	81799080.0
2004-11-24 10:00:00	NVDA	Stock	0.1647	0.1649	0.1634	0.1644	68884920.0
2004-11-24 11:00:00	NVDA	Stock	0.1644	0.1652	0.1642	0.1648	46357440.0
2004-11-24 12:00:00	NVDA	Stock	0.1647	0.1648	0.1631	0.164	56235720.0
2004-11-24 13:00:00	NVDA	Stock	0.164	0.1647	0.1638	0.1646	44312760.0
2004-11-24 14:00:00	NVDA	Stock	0.1647	0.1652	0.1639	0.1642	47902560.0
2004-11-24 15:00:00	NVDA	Stock	0.1642	0.1645	0.1635	0.1641	71951640.0
2004-11-24 16:00:00	NVDA	Stock	0.1641	0.1642	0.1632	0.1638	5729160.0
2004-11-24 17:00:00	NVDA	Stock	0.164	0.164	0.1639	0.1639	488400.0
2004-11-24 08:00:00	AMZN	Stock	1.9365	1.965	1.931	1.931	164000.0
2004-11-24 09:00:00	AMZN	Stock	1.933	1.944	1.92	1.9315	17542980.0
2004-11-24 10:00:00	AMZN	Stock	1.9305	1.934	1.905	1.92	23624420.0
2004-11-24 11:00:00	AMZN	Stock	1.921	1.943	1.918	1.9325	19681140.0
2004-11-24 12:00:00	AMZN	Stock	1.932	1.9395	1.928	1.9335	8020840.0
2004-11-24 13:00:00	AMZN	Stock	1.934	1.9475	1.9335	1.9405	9229780.0
2004-11-24 14:00:00	AMZN	Stock	1.9405	1.958	1.9405	1.956	13105980.0
2004-11-24 15:00:00	AMZN	Stock	1.9555	1.956	1.9355	1.9375	21545700.0
2004-11-24 16:00:00	AMZN	Stock	1.9375	1.94	1.9155	1.9365	2543120.0
2004-11-24 17:00:00	AMZN	Stock	1.941	1.941	1.936	1.936	180860.0
2004-11-24 18:00:00	AMZN	Stock	1.936	1.936	1.936	1.936	39020.0
2004-11-24 09:00:00	CL	Stock	22.95	23.05	22.95	22.98	523200.0
2004-11-24 10:00:00	CL	Stock	22.98	23.05	22.96	23.02	537200.0
2004-11-24 11:00:00	CL	Stock	23.02	23.03	22.925	22.97	675600.0
2004-11-24 12:00:00	CL	Stock	22.963	22.97	22.925	22.97	478800.0
2004-11-24 13:00:00	CL	Stock	22.97	23.08	22.945	23.02	360400.0
2004-11-24 14:00:00	CL	Stock	23.025	23.045	22.905	22.92	634800.0
2004-11-24 15:00:00	CL	Stock	22.92	22.945	22.8	22.9	1208600.0

> showing 50 of 24,356 rows — these rows as CSV

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