PREVIEW / stock_1hour / 2006-10-19

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-10-19.parquet
  size:    613 KB
  rows:    29,358
  symbols: 2,400

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-10-19 04:00:00	AAPL	Stock	2.7696	2.7696	2.7696	2.7696	2800.0
2006-10-19 07:00:00	AAPL	Stock	2.7714	2.7929	2.7714	2.7811	1021216.0
2006-10-19 08:00:00	AAPL	Stock	2.7839	2.8282	2.7814	2.8229	35199724.0
2006-10-19 09:00:00	AAPL	Stock	2.8239	2.8521	2.7914	2.8239	422742684.0
2006-10-19 10:00:00	AAPL	Stock	2.8229	2.8554	2.8221	2.8289	355070548.0
2006-10-19 11:00:00	AAPL	Stock	2.8286	2.855	2.8125	2.8211	181583220.0
2006-10-19 12:00:00	AAPL	Stock	2.8211	2.8293	2.8018	2.81	143691912.0
2006-10-19 13:00:00	AAPL	Stock	2.81	2.825	2.8075	2.8161	95747680.0
2006-10-19 14:00:00	AAPL	Stock	2.8221	2.8354	2.8143	2.8268	113381324.0
2006-10-19 15:00:00	AAPL	Stock	2.8264	2.8314	2.8171	2.8218	149749068.0
2006-10-19 16:00:00	AAPL	Stock	2.8221	2.8321	2.8143	2.8214	4065824.0
2006-10-19 17:00:00	AAPL	Stock	2.8211	2.8257	2.8211	2.825	1550052.0
2006-10-19 18:00:00	AAPL	Stock	2.8246	2.825	2.8218	2.825	302316.0
2006-10-19 19:00:00	AAPL	Stock	2.8232	2.8232	2.8161	2.8161	173348.0
2006-10-19 07:00:00	MSFT	Stock	28.53	28.53	28.53	28.53	1500.0
2006-10-19 08:00:00	MSFT	Stock	28.48	28.54	28.47	28.47	10240.0
2006-10-19 09:00:00	MSFT	Stock	28.46	28.49	28.26	28.31	6760363.0
2006-10-19 10:00:00	MSFT	Stock	28.32	28.451	28.26	28.33	6837509.0
2006-10-19 11:00:00	MSFT	Stock	28.34	28.34	28.18	28.2	8274707.0
2006-10-19 12:00:00	MSFT	Stock	28.2	28.28	28.14	28.18	5434937.0
2006-10-19 13:00:00	MSFT	Stock	28.21	28.24	28.12	28.16	3617354.0
2006-10-19 14:00:00	MSFT	Stock	28.151	28.23	28.14	28.22	3608659.0
2006-10-19 15:00:00	MSFT	Stock	28.22	28.33	28.18	28.32	8182271.0
2006-10-19 16:00:00	MSFT	Stock	28.32	28.36	28.28	28.33	579553.0
2006-10-19 17:00:00	MSFT	Stock	28.32	28.37	28.28	28.37	7327.0
2006-10-19 18:00:00	MSFT	Stock	28.35	28.38	28.33	28.33	6115.0
2006-10-19 19:00:00	MSFT	Stock	28.36	28.4	28.36	28.37	7400.0
2006-10-19 08:00:00	NVDA	Stock	0.5242	0.5278	0.5233	0.5267	241200.0
2006-10-19 09:00:00	NVDA	Stock	0.5267	0.5355	0.5198	0.5325	61635540.0
2006-10-19 10:00:00	NVDA	Stock	0.5324	0.54	0.5302	0.5327	129962760.0
2006-10-19 11:00:00	NVDA	Stock	0.533	0.5333	0.527	0.5315	46586460.0
2006-10-19 12:00:00	NVDA	Stock	0.5313	0.5347	0.5243	0.5268	62282820.0
2006-10-19 13:00:00	NVDA	Stock	0.5268	0.5323	0.524	0.5312	40026300.0
2006-10-19 14:00:00	NVDA	Stock	0.5313	0.5373	0.5302	0.5372	41631060.0
2006-10-19 15:00:00	NVDA	Stock	0.5373	0.5378	0.5333	0.5367	73490100.0
2006-10-19 16:00:00	NVDA	Stock	0.5365	0.5378	0.5358	0.5362	761340.0
2006-10-19 17:00:00	NVDA	Stock	0.536	0.5375	0.5358	0.5358	80640.0
2006-10-19 08:00:00	AMZN	Stock	1.6125	1.6125	1.6075	1.6075	6000.0
2006-10-19 09:00:00	AMZN	Stock	1.605	1.632	1.6015	1.632	11489220.0
2006-10-19 10:00:00	AMZN	Stock	1.632	1.642	1.6275	1.634	13841680.0
2006-10-19 11:00:00	AMZN	Stock	1.634	1.634	1.6235	1.6325	9159380.0
2006-10-19 12:00:00	AMZN	Stock	1.6315	1.632	1.6175	1.622	8097380.0
2006-10-19 13:00:00	AMZN	Stock	1.622	1.626	1.62	1.624	8904580.0
2006-10-19 14:00:00	AMZN	Stock	1.6235	1.6235	1.6175	1.6215	7344240.0
2006-10-19 15:00:00	AMZN	Stock	1.6215	1.632	1.6185	1.626	18383880.0
2006-10-19 16:00:00	AMZN	Stock	1.624	1.6395	1.624	1.633	649780.0
2006-10-19 17:00:00	AMZN	Stock	1.6325	1.633	1.6325	1.633	48000.0
2006-10-19 18:00:00	AMZN	Stock	1.63	1.633	1.63	1.633	14000.0
2006-10-19 19:00:00	AMZN	Stock	1.633	1.633	1.633	1.633	2000.0
2006-10-19 09:00:00	CL	Stock	30.175	30.175	30.11	30.165	518800.0

> showing 50 of 29,358 rows — these rows as CSV

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