PREVIEW / stock_1hour / 2004-07-13

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-07-13.parquet
  size:    489 KB
  rows:    23,260
  symbols: 1,801

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-13 08:00:00	AAPL	Stock	0.5232	0.5232	0.5218	0.5223	291200.0
2004-07-13 09:00:00	AAPL	Stock	0.5223	0.5279	0.5205	0.5257	39409328.0
2004-07-13 10:00:00	AAPL	Stock	0.5257	0.5268	0.5213	0.5248	39541264.0
2004-07-13 11:00:00	AAPL	Stock	0.5248	0.5255	0.522	0.5241	22471848.0
2004-07-13 12:00:00	AAPL	Stock	0.5241	0.5259	0.5236	0.5248	26574800.0
2004-07-13 13:00:00	AAPL	Stock	0.5246	0.525	0.5207	0.5229	37288888.0
2004-07-13 14:00:00	AAPL	Stock	0.5229	0.5238	0.5182	0.5191	40928608.0
2004-07-13 15:00:00	AAPL	Stock	0.5189	0.5234	0.5189	0.5209	50334536.0
2004-07-13 16:00:00	AAPL	Stock	0.5211	0.5229	0.5082	0.5164	5297656.0
2004-07-13 17:00:00	AAPL	Stock	0.5218	0.5218	0.5161	0.5161	4102168.0
2004-07-13 18:00:00	AAPL	Stock	0.5145	0.5145	0.5145	0.5145	28000.0
2004-07-13 08:00:00	MSFT	Stock	27.93	27.94	27.9	27.93	54935.0
2004-07-13 09:00:00	MSFT	Stock	27.95	27.96	27.82	27.88	3343617.0
2004-07-13 10:00:00	MSFT	Stock	27.89	27.92	27.7	27.71	6216888.0
2004-07-13 11:00:00	MSFT	Stock	27.72	27.74	27.66	27.7	4252907.0
2004-07-13 12:00:00	MSFT	Stock	27.69	27.76	27.65	27.73	4378634.0
2004-07-13 13:00:00	MSFT	Stock	27.73	27.77	27.61	27.73	6353309.0
2004-07-13 14:00:00	MSFT	Stock	27.73	27.75	27.63	27.66	5517810.0
2004-07-13 15:00:00	MSFT	Stock	27.66	27.72	27.61	27.61	8303970.0
2004-07-13 16:00:00	MSFT	Stock	27.61	27.7314	27.32	27.38	1324800.0
2004-07-13 17:00:00	MSFT	Stock	27.4	27.61	27.32	27.34	683873.0
2004-07-13 18:00:00	MSFT	Stock	27.32	27.38	27.3	27.38	74200.0
2004-07-13 08:00:00	NVDA	Stock	0.1383	0.1383	0.1383	0.1383	132000.0
2004-07-13 09:00:00	NVDA	Stock	0.1385	0.1414	0.1379	0.1384	38676240.0
2004-07-13 10:00:00	NVDA	Stock	0.1387	0.1389	0.1369	0.1377	101908800.0
2004-07-13 11:00:00	NVDA	Stock	0.1378	0.1388	0.1377	0.1381	54000720.0
2004-07-13 12:00:00	NVDA	Stock	0.1382	0.1392	0.1379	0.1388	52331040.0
2004-07-13 13:00:00	NVDA	Stock	0.1389	0.139	0.1362	0.1366	73907400.0
2004-07-13 14:00:00	NVDA	Stock	0.1366	0.1374	0.1361	0.1362	34681920.0
2004-07-13 15:00:00	NVDA	Stock	0.1362	0.1377	0.1358	0.1369	119246520.0
2004-07-13 16:00:00	NVDA	Stock	0.1369	0.1388	0.1325	0.1346	17207160.0
2004-07-13 17:00:00	NVDA	Stock	0.1374	0.1374	0.1346	0.135	4686720.0
2004-07-13 18:00:00	NVDA	Stock	0.1347	0.1347	0.1346	0.1346	288000.0
2004-07-13 08:00:00	AMZN	Stock	2.41	2.4695	2.41	2.45	61700.0
2004-07-13 09:00:00	AMZN	Stock	2.455	2.499	2.4525	2.486	9712880.0
2004-07-13 10:00:00	AMZN	Stock	2.4875	2.4895	2.4555	2.4595	12870700.0
2004-07-13 11:00:00	AMZN	Stock	2.46	2.4675	2.4435	2.45	15631860.0
2004-07-13 12:00:00	AMZN	Stock	2.4505	2.4645	2.4455	2.4585	11261620.0
2004-07-13 13:00:00	AMZN	Stock	2.4585	2.469	2.4465	2.465	8987200.0
2004-07-13 14:00:00	AMZN	Stock	2.4655	2.488	2.464	2.4785	13193540.0
2004-07-13 15:00:00	AMZN	Stock	2.479	2.487	2.469	2.4795	18085840.0
2004-07-13 16:00:00	AMZN	Stock	2.4795	2.4825	2.463	2.463	897860.0
2004-07-13 17:00:00	AMZN	Stock	2.4765	2.4765	2.465	2.465	132000.0
2004-07-13 18:00:00	AMZN	Stock	2.468	2.468	2.468	2.468	8000.0
2004-07-13 09:00:00	CL	Stock	28.63	28.82	28.63	28.73	187600.0
2004-07-13 10:00:00	CL	Stock	28.715	28.8	28.705	28.73	217600.0
2004-07-13 11:00:00	CL	Stock	28.725	28.8	28.7	28.77	284600.0
2004-07-13 12:00:00	CL	Stock	28.775	28.8	28.7	28.705	201000.0
2004-07-13 13:00:00	CL	Stock	28.695	28.755	28.635	28.72	300200.0
2004-07-13 14:00:00	CL	Stock	28.715	28.8	28.7	28.7	303200.0

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

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