PREVIEW / stock_1hour / 2004-10-18

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-10-18.parquet
  size:    519 KB
  rows:    24,059
  symbols: 1,839

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-10-18 08:00:00	AAPL	Stock	0.8123	0.8125	0.805	0.8116	1621200.0
2004-10-18 09:00:00	AAPL	Stock	0.8071	0.8125	0.7964	0.805	176601712.0
2004-10-18 10:00:00	AAPL	Stock	0.8048	0.8143	0.8025	0.8091	178616032.0
2004-10-18 11:00:00	AAPL	Stock	0.8093	0.8191	0.8071	0.8146	143146192.0
2004-10-18 12:00:00	AAPL	Stock	0.8146	0.8259	0.8138	0.8232	131741568.0
2004-10-18 13:00:00	AAPL	Stock	0.8232	0.833	0.823	0.8282	109170880.0
2004-10-18 14:00:00	AAPL	Stock	0.828	0.8379	0.8259	0.8375	126717920.0
2004-10-18 15:00:00	AAPL	Stock	0.8375	0.8525	0.8357	0.852	284438952.0
2004-10-18 16:00:00	AAPL	Stock	0.852	0.8539	0.8436	0.8527	15974280.0
2004-10-18 17:00:00	AAPL	Stock	0.8539	0.8571	0.8525	0.8545	5915168.0
2004-10-18 18:00:00	AAPL	Stock	0.8541	0.8571	0.8541	0.8564	128576.0
2004-10-18 08:00:00	MSFT	Stock	28.05	28.15	27.99	28.04	40415.0
2004-10-18 09:00:00	MSFT	Stock	28.05	28.14	27.99	28.131	4895241.0
2004-10-18 10:00:00	MSFT	Stock	28.14	28.15	27.98	27.99	7274175.0
2004-10-18 11:00:00	MSFT	Stock	27.99	28.12	27.98	28.11	4259079.0
2004-10-18 12:00:00	MSFT	Stock	28.12	28.4	28.11	28.35	8768893.0
2004-10-18 13:00:00	MSFT	Stock	28.35	28.41	28.26	28.33	6839708.0
2004-10-18 14:00:00	MSFT	Stock	28.33	28.43	28.27	28.4	5358467.0
2004-10-18 15:00:00	MSFT	Stock	28.4	28.45	28.32	28.41	10248254.0
2004-10-18 16:00:00	MSFT	Stock	28.41	28.5	28.36	28.44	529939.0
2004-10-18 17:00:00	MSFT	Stock	28.48	28.54	28.432	28.53	178463.0
2004-10-18 18:00:00	MSFT	Stock	28.53	28.53	28.5	28.52	8198.0
2004-10-18 08:00:00	NVDA	Stock	0.1116	0.1116	0.1116	0.1116	240000.0
2004-10-18 09:00:00	NVDA	Stock	0.1112	0.1117	0.1102	0.1116	43174200.0
2004-10-18 10:00:00	NVDA	Stock	0.1115	0.1118	0.1105	0.1111	73578960.0
2004-10-18 11:00:00	NVDA	Stock	0.111	0.1129	0.1106	0.1129	49679640.0
2004-10-18 12:00:00	NVDA	Stock	0.1128	0.115	0.1127	0.1137	122295000.0
2004-10-18 13:00:00	NVDA	Stock	0.1137	0.1143	0.113	0.1132	68397600.0
2004-10-18 14:00:00	NVDA	Stock	0.1132	0.1143	0.1126	0.1143	67449240.0
2004-10-18 15:00:00	NVDA	Stock	0.1143	0.1146	0.1132	0.1138	132093480.0
2004-10-18 16:00:00	NVDA	Stock	0.1138	0.1141	0.1136	0.1139	8685960.0
2004-10-18 17:00:00	NVDA	Stock	0.1139	0.1156	0.1138	0.1155	1166640.0
2004-10-18 18:00:00	NVDA	Stock	0.115	0.1154	0.115	0.1154	276000.0
2004-10-18 08:00:00	AMZN	Stock	1.914	1.918	1.914	1.915	22000.0
2004-10-18 09:00:00	AMZN	Stock	1.9125	1.9515	1.9095	1.9385	22437160.0
2004-10-18 10:00:00	AMZN	Stock	1.9385	1.947	1.8945	1.9035	28162160.0
2004-10-18 11:00:00	AMZN	Stock	1.903	1.935	1.9	1.933	21533260.0
2004-10-18 12:00:00	AMZN	Stock	1.9335	1.949	1.9305	1.938	16337060.0
2004-10-18 13:00:00	AMZN	Stock	1.938	1.956	1.9375	1.9475	22504480.0
2004-10-18 14:00:00	AMZN	Stock	1.9475	1.9735	1.9455	1.9675	23455420.0
2004-10-18 15:00:00	AMZN	Stock	1.967	1.969	1.957	1.962	22960740.0
2004-10-18 16:00:00	AMZN	Stock	1.962	1.9655	1.961	1.9615	786220.0
2004-10-18 17:00:00	AMZN	Stock	1.9615	1.9675	1.9615	1.9665	729120.0
2004-10-18 18:00:00	AMZN	Stock	1.967	1.9725	1.967	1.9725	44000.0
2004-10-18 09:00:00	CL	Stock	21.855	22.05	21.855	22.0	708000.0
2004-10-18 10:00:00	CL	Stock	22.0	22.015	21.94	21.94	768600.0
2004-10-18 11:00:00	CL	Stock	21.94	21.99	21.925	21.975	623200.0
2004-10-18 12:00:00	CL	Stock	21.98	22.05	21.965	21.985	553800.0
2004-10-18 13:00:00	CL	Stock	21.985	21.985	21.875	21.9	800800.0
2004-10-18 14:00:00	CL	Stock	21.9	21.965	21.885	21.945	567800.0

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

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