PREVIEW / stock_1hour / 2003-04-07

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-04-07.parquet
  size:    423 KB
  rows:    21,259
  symbols: 1,570

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-04-07 08:00:00	AAPL	Stock	0.2616	0.2652	0.2616	0.2643	131712.0
2003-04-07 09:00:00	AAPL	Stock	0.265	0.2661	0.2605	0.2661	21506800.0
2003-04-07 10:00:00	AAPL	Stock	0.2661	0.267	0.2641	0.2641	28497392.0
2003-04-07 11:00:00	AAPL	Stock	0.2641	0.2661	0.2641	0.2654	13042176.0
2003-04-07 12:00:00	AAPL	Stock	0.2654	0.2659	0.2643	0.265	8071560.0
2003-04-07 13:00:00	AAPL	Stock	0.265	0.2659	0.2648	0.2652	4102504.0
2003-04-07 14:00:00	AAPL	Stock	0.2652	0.2657	0.2609	0.2611	27574456.0
2003-04-07 15:00:00	AAPL	Stock	0.2613	0.2616	0.2573	0.2577	55038424.0
2003-04-07 16:00:00	AAPL	Stock	0.2579	0.2595	0.2577	0.2588	12716536.0
2003-04-07 17:00:00	AAPL	Stock	0.258	0.2595	0.258	0.2591	56000.0
2003-04-07 08:00:00	MSFT	Stock	26.25	26.32	25.35	26.11	872028.0
2003-04-07 09:00:00	MSFT	Stock	26.08	26.43	26.012	26.19	12105652.0
2003-04-07 10:00:00	MSFT	Stock	26.19	26.27	25.95	25.99	10790379.0
2003-04-07 11:00:00	MSFT	Stock	25.99	26.15	25.98	26.11	5967795.0
2003-04-07 12:00:00	MSFT	Stock	26.11	26.14	25.96	25.98	5425792.0
2003-04-07 13:00:00	MSFT	Stock	25.98	26.1	25.97	26.039	4040258.0
2003-04-07 14:00:00	MSFT	Stock	26.04	26.1	25.76	25.77	5580582.0
2003-04-07 15:00:00	MSFT	Stock	25.762	25.8	25.171	25.261	13041445.0
2003-04-07 16:00:00	MSFT	Stock	25.19	25.95	25.1	25.12	1134940.0
2003-04-07 17:00:00	MSFT	Stock	25.12	25.2	25.11	25.18	71001.0
2003-04-07 18:00:00	MSFT	Stock	25.18	25.23	25.15	25.23	20150.0
2003-04-07 08:00:00	NVDA	Stock	0.1167	0.1199	0.1167	0.1179	5702880.0
2003-04-07 09:00:00	NVDA	Stock	0.1179	0.12	0.1155	0.1164	162951000.0
2003-04-07 10:00:00	NVDA	Stock	0.1164	0.1171	0.1147	0.1152	126369480.0
2003-04-07 11:00:00	NVDA	Stock	0.1152	0.1157	0.1147	0.1155	56304600.0
2003-04-07 12:00:00	NVDA	Stock	0.1157	0.1157	0.1147	0.1152	25912920.0
2003-04-07 13:00:00	NVDA	Stock	0.1151	0.116	0.1151	0.116	41220000.0
2003-04-07 14:00:00	NVDA	Stock	0.116	0.1163	0.1148	0.1148	53881920.0
2003-04-07 15:00:00	NVDA	Stock	0.1148	0.1148	0.1121	0.1128	120245640.0
2003-04-07 16:00:00	NVDA	Stock	0.1127	0.1183	0.1122	0.1125	27152280.0
2003-04-07 17:00:00	NVDA	Stock	0.1122	0.1127	0.112	0.1127	1188000.0
2003-04-07 18:00:00	NVDA	Stock	0.1121	0.1139	0.1121	0.1139	1836000.0
2003-04-07 08:00:00	AMZN	Stock	1.35	1.3675	1.35	1.3525	179200.0
2003-04-07 09:00:00	AMZN	Stock	1.3525	1.378	1.3505	1.3675	30278560.0
2003-04-07 10:00:00	AMZN	Stock	1.3671	1.3705	1.358	1.3605	23959840.0
2003-04-07 11:00:00	AMZN	Stock	1.3595	1.3685	1.3585	1.366	15006280.0
2003-04-07 12:00:00	AMZN	Stock	1.3665	1.3685	1.362	1.366	8102540.0
2003-04-07 13:00:00	AMZN	Stock	1.366	1.3685	1.363	1.3645	9208880.0
2003-04-07 14:00:00	AMZN	Stock	1.365	1.369	1.356	1.3565	15791120.0
2003-04-07 15:00:00	AMZN	Stock	1.3561	1.359	1.3375	1.342	26824780.0
2003-04-07 16:00:00	AMZN	Stock	1.342	1.343	1.339	1.3395	1126720.0
2003-04-07 17:00:00	AMZN	Stock	1.342	1.3425	1.339	1.339	400000.0
2003-04-07 18:00:00	AMZN	Stock	1.343	1.343	1.343	1.343	10000.0
2003-04-07 09:00:00	CL	Stock	27.875	27.925	27.705	27.83	495800.0
2003-04-07 10:00:00	CL	Stock	27.83	27.975	27.705	27.725	524600.0
2003-04-07 11:00:00	CL	Stock	27.725	27.795	27.62	27.73	359000.0
2003-04-07 12:00:00	CL	Stock	27.73	27.825	27.665	27.735	376800.0
2003-04-07 13:00:00	CL	Stock	27.73	27.855	27.69	27.695	277800.0
2003-04-07 14:00:00	CL	Stock	27.695	27.715	27.525	27.55	651400.0
2003-04-07 15:00:00	CL	Stock	27.55	27.6	27.42	27.47	791800.0

> showing 50 of 21,259 rows — these rows as CSV

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