PREVIEW / stock_1hour / 2006-08-24

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-08-24.parquet
  size:    590 KB
  rows:    28,398
  symbols: 2,321

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
2006-08-24 04:00:00	AAPL	Stock	2.4036	2.4036	2.4036	2.4036	6440.0
2006-08-24 08:00:00	AAPL	Stock	2.4143	2.4196	2.4089	2.4179	1292900.0
2006-08-24 09:00:00	AAPL	Stock	2.4179	2.4304	2.4114	2.4207	50152032.0
2006-08-24 10:00:00	AAPL	Stock	2.4204	2.4354	2.4129	2.4211	104704040.0
2006-08-24 11:00:00	AAPL	Stock	2.4211	2.4243	2.4018	2.4036	52428852.0
2006-08-24 12:00:00	AAPL	Stock	2.4036	2.4104	2.3957	2.4075	51035180.0
2006-08-24 13:00:00	AAPL	Stock	2.4071	2.4093	2.3668	2.405	197549996.0
2006-08-24 14:00:00	AAPL	Stock	2.405	2.4268	2.4018	2.4254	100597644.0
2006-08-24 15:00:00	AAPL	Stock	2.4254	2.4261	2.4121	2.4218	85891568.0
2006-08-24 16:00:00	AAPL	Stock	2.4218	2.4268	2.4204	2.4243	2073820.0
2006-08-24 17:00:00	AAPL	Stock	2.4261	2.4261	2.4232	2.425	442540.0
2006-08-24 18:00:00	AAPL	Stock	2.4246	2.4261	2.4246	2.4257	46060.0
2006-08-24 06:00:00	MSFT	Stock	25.75	28.0	25.75	28.0	1400.0
2006-08-24 08:00:00	MSFT	Stock	25.7	25.8	25.7	25.79	39300.0
2006-08-24 09:00:00	MSFT	Stock	25.8	25.86	25.73	25.74	3329878.0
2006-08-24 10:00:00	MSFT	Stock	25.75	25.85	25.68	25.71	5636085.0
2006-08-24 11:00:00	MSFT	Stock	25.72	25.8	25.56	25.61	4715071.0
2006-08-24 12:00:00	MSFT	Stock	25.6	25.64	25.5	25.59	6377903.0
2006-08-24 13:00:00	MSFT	Stock	25.6	25.7	25.58	25.67	2616409.0
2006-08-24 14:00:00	MSFT	Stock	25.66	25.77	25.65	25.76	3909833.0
2006-08-24 15:00:00	MSFT	Stock	25.76	25.79	25.65	25.74	6615469.0
2006-08-24 16:00:00	MSFT	Stock	25.75	25.85	25.73	25.74	39836.0
2006-08-24 17:00:00	MSFT	Stock	25.74	25.79	25.74	25.79	4870.0
2006-08-24 09:00:00	NVDA	Stock	0.4388	0.4425	0.4355	0.4363	27981000.0
2006-08-24 10:00:00	NVDA	Stock	0.4362	0.4403	0.4333	0.4358	60713340.0
2006-08-24 11:00:00	NVDA	Stock	0.4358	0.4375	0.4333	0.4342	27559440.0
2006-08-24 12:00:00	NVDA	Stock	0.434	0.4358	0.4323	0.4345	26994840.0
2006-08-24 13:00:00	NVDA	Stock	0.4345	0.4402	0.434	0.4393	24859680.0
2006-08-24 14:00:00	NVDA	Stock	0.4393	0.445	0.4393	0.4432	41893080.0
2006-08-24 15:00:00	NVDA	Stock	0.4432	0.4432	0.4388	0.4425	39233280.0
2006-08-24 16:00:00	NVDA	Stock	0.4425	0.4427	0.4418	0.4423	3057000.0
2006-08-24 09:00:00	AMZN	Stock	1.412	1.4125	1.388	1.3885	10702000.0
2006-08-24 10:00:00	AMZN	Stock	1.388	1.3985	1.377	1.3855	20137380.0
2006-08-24 11:00:00	AMZN	Stock	1.3855	1.3935	1.383	1.3865	11344280.0
2006-08-24 12:00:00	AMZN	Stock	1.3855	1.3865	1.3775	1.381	11057260.0
2006-08-24 13:00:00	AMZN	Stock	1.38	1.389	1.3775	1.3885	10477500.0
2006-08-24 14:00:00	AMZN	Stock	1.3886	1.393	1.386	1.3915	9504300.0
2006-08-24 15:00:00	AMZN	Stock	1.3915	1.3995	1.3885	1.3995	14589620.0
2006-08-24 16:00:00	AMZN	Stock	1.399	1.399	1.388	1.3985	215180.0
2006-08-24 18:00:00	AMZN	Stock	1.398	1.398	1.398	1.398	4000.0
2006-08-24 09:00:00	CL	Stock	29.645	29.675	29.535	29.665	189600.0
2006-08-24 10:00:00	CL	Stock	29.67	29.72	29.63	29.72	369000.0
2006-08-24 11:00:00	CL	Stock	29.725	29.725	29.625	29.64	193000.0
2006-08-24 12:00:00	CL	Stock	29.635	29.66	29.62	29.635	133800.0
2006-08-24 13:00:00	CL	Stock	29.645	29.67	29.6	29.625	163400.0
2006-08-24 14:00:00	CL	Stock	29.63	29.695	29.585	29.625	200800.0
2006-08-24 15:00:00	CL	Stock	29.625	29.65	29.58	29.585	367400.0
2006-08-24 16:00:00	CL	Stock	29.58	29.58	29.58	29.58	200.0

> showing 48 of 28,398 rows — these rows as CSV

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