PREVIEW / stock_1hour / 2004-07-12

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-07-12.parquet
  size:    490 KB
  rows:    23,894
  symbols: 1,810

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-07-12 09:00:00	AAPL	Stock	0.5375	0.5375	0.5279	0.528	41759200.0
2004-07-12 10:00:00	AAPL	Stock	0.528	0.5291	0.5239	0.5268	88243960.0
2004-07-12 11:00:00	AAPL	Stock	0.5268	0.5288	0.5188	0.5216	88055016.0
2004-07-12 12:00:00	AAPL	Stock	0.5218	0.5225	0.5188	0.5221	65356816.0
2004-07-12 13:00:00	AAPL	Stock	0.5223	0.5234	0.5166	0.5196	51923032.0
2004-07-12 14:00:00	AAPL	Stock	0.5196	0.5232	0.5188	0.5214	56353136.0
2004-07-12 15:00:00	AAPL	Stock	0.5214	0.5218	0.5179	0.5202	90992720.0
2004-07-12 16:00:00	AAPL	Stock	0.5195	0.5377	0.5186	0.5221	7815976.0
2004-07-12 17:00:00	AAPL	Stock	0.5204	0.5204	0.5204	0.5204	15904.0
2004-07-12 18:00:00	AAPL	Stock	0.5225	0.5225	0.5225	0.5225	11200.0
2004-07-12 08:00:00	MSFT	Stock	27.79	27.79	27.74	27.74	24600.0
2004-07-12 09:00:00	MSFT	Stock	27.74	27.88	27.66	27.83	3454722.0
2004-07-12 10:00:00	MSFT	Stock	27.84	27.84	27.65	27.72	6572707.0
2004-07-12 11:00:00	MSFT	Stock	27.72	27.76	27.66	27.72	5771255.0
2004-07-12 12:00:00	MSFT	Stock	27.72	27.81	27.7	27.79	3763924.0
2004-07-12 13:00:00	MSFT	Stock	27.79	27.8	27.68	27.71	3767387.0
2004-07-12 14:00:00	MSFT	Stock	27.7	27.99	27.7	27.89	9080771.0
2004-07-12 15:00:00	MSFT	Stock	27.9	28.001	27.89	27.93	9191380.0
2004-07-12 16:00:00	MSFT	Stock	27.93	27.95	27.84	27.89	2155616.0
2004-07-12 17:00:00	MSFT	Stock	27.89	27.92	27.89	27.92	15546.0
2004-07-12 08:00:00	NVDA	Stock	0.1387	0.1401	0.1387	0.1393	1098000.0
2004-07-12 09:00:00	NVDA	Stock	0.139	0.1408	0.1365	0.1367	124624920.0
2004-07-12 10:00:00	NVDA	Stock	0.1369	0.1381	0.1361	0.1371	130361400.0
2004-07-12 11:00:00	NVDA	Stock	0.1371	0.1379	0.1364	0.1367	63009960.0
2004-07-12 12:00:00	NVDA	Stock	0.1368	0.1372	0.1365	0.1369	20274240.0
2004-07-12 13:00:00	NVDA	Stock	0.1368	0.1372	0.1357	0.1361	57081240.0
2004-07-12 14:00:00	NVDA	Stock	0.136	0.1375	0.1358	0.1366	118861200.0
2004-07-12 15:00:00	NVDA	Stock	0.1366	0.1377	0.1364	0.1377	115283760.0
2004-07-12 16:00:00	NVDA	Stock	0.1377	0.1385	0.1372	0.1385	15528840.0
2004-07-12 17:00:00	NVDA	Stock	0.1378	0.1383	0.1378	0.138	68880.0
2004-07-12 18:00:00	NVDA	Stock	0.138	0.138	0.138	0.138	18000.0
2004-07-12 08:00:00	AMZN	Stock	2.4	2.41	2.4	2.41	64000.0
2004-07-12 09:00:00	AMZN	Stock	2.4065	2.445	2.4015	2.4355	18912140.0
2004-07-12 10:00:00	AMZN	Stock	2.436	2.4405	2.41	2.4275	21607440.0
2004-07-12 11:00:00	AMZN	Stock	2.4275	2.4674	2.423	2.4495	29141540.0
2004-07-12 12:00:00	AMZN	Stock	2.4495	2.45	2.4325	2.4355	8126820.0
2004-07-12 13:00:00	AMZN	Stock	2.435	2.436	2.426	2.428	7011420.0
2004-07-12 14:00:00	AMZN	Stock	2.428	2.4645	2.427	2.446	24102880.0
2004-07-12 15:00:00	AMZN	Stock	2.445	2.4675	2.445	2.455	24237040.0
2004-07-12 16:00:00	AMZN	Stock	2.4555	2.458	2.4422	2.4422	2150200.0
2004-07-12 17:00:00	AMZN	Stock	2.4545	2.4545	2.4525	2.4525	146240.0
2004-07-12 09:00:00	CL	Stock	28.825	28.925	28.75	28.79	134600.0
2004-07-12 10:00:00	CL	Stock	28.79	28.79	28.655	28.705	305600.0
2004-07-12 11:00:00	CL	Stock	28.71	28.75	28.665	28.695	186200.0
2004-07-12 12:00:00	CL	Stock	28.685	28.73	28.665	28.69	81400.0
2004-07-12 13:00:00	CL	Stock	28.685	28.71	28.665	28.685	70000.0
2004-07-12 14:00:00	CL	Stock	28.68	28.84	28.68	28.785	394600.0
2004-07-12 15:00:00	CL	Stock	28.785	28.885	28.785	28.815	241400.0
2004-07-12 16:00:00	CL	Stock	28.83	28.83	28.83	28.83	18200.0
2004-07-12 17:00:00	CL	Stock	28.83	28.83	28.83	28.83	600.0

> showing 50 of 23,894 rows — these rows as CSV

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