PREVIEW / stock_1hour / 2004-09-28

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-09-28.parquet
  size:    511 KB
  rows:    24,413
  symbols: 1,838

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-28 08:00:00	AAPL	Stock	0.6701	0.6713	0.667	0.6713	296800.0
2004-09-28 09:00:00	AAPL	Stock	0.6702	0.6773	0.6688	0.6745	23007880.0
2004-09-28 10:00:00	AAPL	Stock	0.6745	0.6798	0.6734	0.6777	64811432.0
2004-09-28 11:00:00	AAPL	Stock	0.6779	0.6838	0.6775	0.6814	68721912.0
2004-09-28 12:00:00	AAPL	Stock	0.6814	0.6823	0.6788	0.6789	29608376.0
2004-09-28 13:00:00	AAPL	Stock	0.6791	0.6804	0.6766	0.6775	55058192.0
2004-09-28 14:00:00	AAPL	Stock	0.6773	0.6805	0.677	0.6788	39318328.0
2004-09-28 15:00:00	AAPL	Stock	0.6789	0.6816	0.678	0.678	58277352.0
2004-09-28 16:00:00	AAPL	Stock	0.6788	0.6805	0.6779	0.6789	4921336.0
2004-09-28 17:00:00	AAPL	Stock	0.6789	0.6796	0.6789	0.6796	235200.0
2004-09-28 08:00:00	MSFT	Stock	27.25	27.25	27.19	27.21	13140.0
2004-09-28 09:00:00	MSFT	Stock	27.23	27.26	27.14	27.15	11056030.0
2004-09-28 10:00:00	MSFT	Stock	27.15	27.18	27.04	27.13	12457190.0
2004-09-28 11:00:00	MSFT	Stock	27.13	27.28	27.12	27.25	8742590.0
2004-09-28 12:00:00	MSFT	Stock	27.25	27.3	27.18	27.249	5572530.0
2004-09-28 13:00:00	MSFT	Stock	27.25	27.29	27.15	27.26	3928731.0
2004-09-28 14:00:00	MSFT	Stock	27.269	27.31	27.23	27.272	5718665.0
2004-09-28 15:00:00	MSFT	Stock	27.28	27.36	27.24	27.27	11060379.0
2004-09-28 16:00:00	MSFT	Stock	27.27	27.334	27.206	27.27	1046011.0
2004-09-28 17:00:00	MSFT	Stock	27.27	27.31	27.26	27.3	27435.0
2004-09-28 18:00:00	MSFT	Stock	27.31	27.31	27.31	27.31	600.0
2004-09-28 08:00:00	NVDA	Stock	0.1126	0.1149	0.1125	0.1149	405000.0
2004-09-28 09:00:00	NVDA	Stock	0.1149	0.1157	0.1132	0.1136	65221440.0
2004-09-28 10:00:00	NVDA	Stock	0.1137	0.115	0.1133	0.1144	82947600.0
2004-09-28 11:00:00	NVDA	Stock	0.1145	0.1159	0.1145	0.1158	63574080.0
2004-09-28 12:00:00	NVDA	Stock	0.1158	0.116	0.1149	0.1152	31948560.0
2004-09-28 13:00:00	NVDA	Stock	0.1153	0.1157	0.1148	0.1154	43377120.0
2004-09-28 14:00:00	NVDA	Stock	0.1154	0.1165	0.1149	0.1164	56401080.0
2004-09-28 15:00:00	NVDA	Stock	0.1163	0.1177	0.1161	0.1167	121233240.0
2004-09-28 16:00:00	NVDA	Stock	0.1167	0.1167	0.1162	0.1166	5093880.0
2004-09-28 17:00:00	NVDA	Stock	0.1167	0.1167	0.1167	0.1167	147000.0
2004-09-28 08:00:00	AMZN	Stock	2.0015	2.013	2.0015	2.0115	102000.0
2004-09-28 09:00:00	AMZN	Stock	2.0065	2.0165	1.971	1.98	23105060.0
2004-09-28 10:00:00	AMZN	Stock	1.9795	1.9985	1.9635	1.964	41544220.0
2004-09-28 11:00:00	AMZN	Stock	1.9635	2.005	1.963	2.0	26910800.0
2004-09-28 12:00:00	AMZN	Stock	2.001	2.001	1.985	1.9935	14653420.0
2004-09-28 13:00:00	AMZN	Stock	1.992	1.995	1.9485	1.9565	55780400.0
2004-09-28 14:00:00	AMZN	Stock	1.957	1.97	1.9485	1.968	28639860.0
2004-09-28 15:00:00	AMZN	Stock	1.9685	1.982	1.9605	1.972	41111740.0
2004-09-28 16:00:00	AMZN	Stock	1.972	1.975	1.97	1.97	1554280.0
2004-09-28 17:00:00	AMZN	Stock	1.9715	1.9715	1.95	1.9605	105000.0
2004-09-28 18:00:00	AMZN	Stock	1.964	1.964	1.9565	1.9575	21000.0
2004-09-28 08:00:00	CL	Stock	22.8	22.8	22.8	22.8	200.0
2004-09-28 09:00:00	CL	Stock	22.65	22.77	22.625	22.665	1295200.0
2004-09-28 10:00:00	CL	Stock	22.675	22.825	22.665	22.735	1859000.0
2004-09-28 11:00:00	CL	Stock	22.735	22.825	22.73	22.8	1285600.0
2004-09-28 12:00:00	CL	Stock	22.785	22.815	22.715	22.725	1244400.0
2004-09-28 13:00:00	CL	Stock	22.73	22.74	22.6	22.605	1170600.0
2004-09-28 14:00:00	CL	Stock	22.605	22.645	22.6	22.64	1493000.0
2004-09-28 15:00:00	CL	Stock	22.64	22.675	22.625	22.665	1832800.0

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

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