PREVIEW / stock_1hour / 2003-04-17

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-04-17.parquet
  size:    416 KB
  rows:    20,619
  symbols: 1,561

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-17 08:00:00	AAPL	Stock	0.2373	0.2393	0.2361	0.2368	2123520.0
2003-04-17 09:00:00	AAPL	Stock	0.2368	0.237	0.2271	0.2295	144715760.0
2003-04-17 10:00:00	AAPL	Stock	0.2295	0.2328	0.228	0.2325	124304264.0
2003-04-17 11:00:00	AAPL	Stock	0.2325	0.2354	0.2321	0.2345	64480864.0
2003-04-17 12:00:00	AAPL	Stock	0.2346	0.2357	0.2341	0.2345	30352728.0
2003-04-17 13:00:00	AAPL	Stock	0.2345	0.2355	0.2343	0.2352	44241568.0
2003-04-17 14:00:00	AAPL	Stock	0.2352	0.2359	0.2339	0.2348	38792656.0
2003-04-17 15:00:00	AAPL	Stock	0.2348	0.2354	0.2323	0.2343	114665152.0
2003-04-17 16:00:00	AAPL	Stock	0.2341	0.2354	0.2323	0.2354	1837528.0
2003-04-17 17:00:00	AAPL	Stock	0.2343	0.2343	0.2339	0.2339	1271200.0
2003-04-17 18:00:00	AAPL	Stock	0.2336	0.2352	0.2336	0.2352	61600.0
2003-04-17 08:00:00	MSFT	Stock	25.0	25.35	24.92	24.969	143586.0
2003-04-17 09:00:00	MSFT	Stock	24.96	25.1	24.74	24.97	9076748.0
2003-04-17 10:00:00	MSFT	Stock	24.96	25.15	24.916	25.06	8741130.0
2003-04-17 11:00:00	MSFT	Stock	25.07	25.16	25.03	25.1	5285753.0
2003-04-17 12:00:00	MSFT	Stock	25.1	25.35	25.089	25.35	7492107.0
2003-04-17 13:00:00	MSFT	Stock	25.351	25.494	25.31	25.48	6870431.0
2003-04-17 14:00:00	MSFT	Stock	25.49	25.5	25.279	25.39	5118561.0
2003-04-17 15:00:00	MSFT	Stock	25.3889	25.54	25.33	25.53	8449991.0
2003-04-17 16:00:00	MSFT	Stock	25.52	25.65	25.49	25.55	1222051.0
2003-04-17 17:00:00	MSFT	Stock	25.531	25.64	25.5	25.55	187485.0
2003-04-17 18:00:00	MSFT	Stock	25.59	25.62	25.54	25.58	16264.0
2003-04-17 08:00:00	NVDA	Stock	0.1117	0.1117	0.1117	0.1117	84000.0
2003-04-17 09:00:00	NVDA	Stock	0.1117	0.1126	0.1102	0.1113	47328960.0
2003-04-17 10:00:00	NVDA	Stock	0.1113	0.1123	0.1107	0.112	49371360.0
2003-04-17 11:00:00	NVDA	Stock	0.112	0.1129	0.112	0.1127	61066920.0
2003-04-17 12:00:00	NVDA	Stock	0.1127	0.1136	0.1125	0.1129	100938120.0
2003-04-17 13:00:00	NVDA	Stock	0.1129	0.1134	0.1127	0.1129	71019600.0
2003-04-17 14:00:00	NVDA	Stock	0.1129	0.1134	0.1127	0.1133	51667320.0
2003-04-17 15:00:00	NVDA	Stock	0.1134	0.1141	0.1132	0.1139	95928000.0
2003-04-17 16:00:00	NVDA	Stock	0.1139	0.1142	0.1136	0.1141	6862200.0
2003-04-17 17:00:00	NVDA	Stock	0.1139	0.1142	0.1137	0.1141	1188000.0
2003-04-17 18:00:00	NVDA	Stock	0.1141	0.1141	0.1136	0.1136	1035000.0
2003-04-17 08:00:00	AMZN	Stock	1.22	1.22	1.2195	1.2195	226300.0
2003-04-17 09:00:00	AMZN	Stock	1.219	1.233	1.2175	1.229	19255100.0
2003-04-17 10:00:00	AMZN	Stock	1.229	1.238	1.2275	1.238	22103200.0
2003-04-17 11:00:00	AMZN	Stock	1.238	1.242	1.2361	1.239	12500820.0
2003-04-17 12:00:00	AMZN	Stock	1.2385	1.2445	1.2375	1.244	9149480.0
2003-04-17 13:00:00	AMZN	Stock	1.244	1.25	1.24	1.2475	12873380.0
2003-04-17 14:00:00	AMZN	Stock	1.2475	1.2505	1.2435	1.2475	15912220.0
2003-04-17 15:00:00	AMZN	Stock	1.248	1.25	1.2465	1.2495	29851460.0
2003-04-17 16:00:00	AMZN	Stock	1.2495	1.2495	1.2485	1.249	1568620.0
2003-04-17 17:00:00	AMZN	Stock	1.249	1.2495	1.249	1.249	880000.0
2003-04-17 18:00:00	AMZN	Stock	1.2485	1.2485	1.2485	1.2485	10000.0
2003-04-17 08:00:00	CL	Stock	28.175	28.175	27.975	27.975	600.0
2003-04-17 09:00:00	CL	Stock	27.8	28.055	27.495	27.72	1261800.0
2003-04-17 10:00:00	CL	Stock	27.695	27.74	27.425	27.68	1583400.0
2003-04-17 11:00:00	CL	Stock	27.685	27.725	27.545	27.705	974400.0
2003-04-17 12:00:00	CL	Stock	27.705	27.8	27.685	27.79	636400.0
2003-04-17 13:00:00	CL	Stock	27.79	27.805	27.69	27.8	959200.0

> showing 50 of 20,619 rows — these rows as CSV

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