PREVIEW / stock_1hour / 2010-03-05

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-03-05.parquet
  size:    945 KB
  rows:    45,654
  symbols: 3,458

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
2010-03-05 05:00:00	AAPL	Stock	7.5871	7.6	7.5871	7.6	25200.0
2010-03-05 06:00:00	AAPL	Stock	7.5929	7.5932	7.5929	7.5932	16800.0
2010-03-05 07:00:00	AAPL	Stock	7.6061	7.6232	7.5975	7.6029	560140.0
2010-03-05 08:00:00	AAPL	Stock	7.6071	7.6975	7.5964	7.6929	16861516.0
2010-03-05 09:00:00	AAPL	Stock	7.6929	7.7661	7.6654	7.7611	209541892.0
2010-03-05 10:00:00	AAPL	Stock	7.7604	7.7818	7.7436	7.7775	145404000.0
2010-03-05 11:00:00	AAPL	Stock	7.7776	7.8104	7.775	7.8068	119335412.0
2010-03-05 12:00:00	AAPL	Stock	7.8065	7.8296	7.7932	7.8296	81435368.0
2010-03-05 13:00:00	AAPL	Stock	7.8296	7.8464	7.8068	7.8204	102644920.0
2010-03-05 14:00:00	AAPL	Stock	7.8204	7.8396	7.8143	7.8239	65019612.0
2010-03-05 15:00:00	AAPL	Stock	7.8236	7.8361	7.8036	7.8214	137672276.0
2010-03-05 16:00:00	AAPL	Stock	7.8214	7.8268	7.5254	7.8261	14919296.0
2010-03-05 17:00:00	AAPL	Stock	7.8246	7.8257	7.7484	7.8214	1030652.0
2010-03-05 18:00:00	AAPL	Stock	7.8214	7.8246	7.8196	7.8246	343252.0
2010-03-05 19:00:00	AAPL	Stock	7.8232	7.8246	7.8193	7.8207	354788.0
2010-03-05 08:00:00	MSFT	Stock	28.74	28.9	28.69	28.82	88577.0
2010-03-05 09:00:00	MSFT	Stock	28.81	28.83	28.46	28.508	7721347.0
2010-03-05 10:00:00	MSFT	Stock	28.51	28.67	28.48	28.57	10262943.0
2010-03-05 11:00:00	MSFT	Stock	28.56	28.63	28.52	28.52	7134368.0
2010-03-05 12:00:00	MSFT	Stock	28.52	28.57	28.42	28.49	5685646.0
2010-03-05 13:00:00	MSFT	Stock	28.49	28.51	28.45	28.45	3710984.0
2010-03-05 14:00:00	MSFT	Stock	28.46	28.56	28.43	28.531	5545892.0
2010-03-05 15:00:00	MSFT	Stock	28.54	28.6	28.5	28.59	11565338.0
2010-03-05 16:00:00	MSFT	Stock	28.59	28.643	28.48	28.58	3020883.0
2010-03-05 17:00:00	MSFT	Stock	28.567	28.59	28.481	28.55	174058.0
2010-03-05 18:00:00	MSFT	Stock	28.58	28.58	28.53	28.58	2446.0
2010-03-05 19:00:00	MSFT	Stock	28.58	28.59	28.55	28.55	2264.0
2010-03-05 08:00:00	NVDA	Stock	0.4213	0.4213	0.4175	0.4175	186560.0
2010-03-05 09:00:00	NVDA	Stock	0.4175	0.426	0.4135	0.4258	70920080.0
2010-03-05 10:00:00	NVDA	Stock	0.426	0.4288	0.4236	0.4285	121214200.0
2010-03-05 11:00:00	NVDA	Stock	0.4285	0.4295	0.4278	0.4285	71841760.0
2010-03-05 12:00:00	NVDA	Stock	0.4285	0.4311	0.4285	0.4308	69159080.0
2010-03-05 13:00:00	NVDA	Stock	0.431	0.4322	0.4293	0.4315	74796560.0
2010-03-05 14:00:00	NVDA	Stock	0.4312	0.4315	0.4298	0.4306	66459080.0
2010-03-05 15:00:00	NVDA	Stock	0.4305	0.4308	0.4285	0.429	128187320.0
2010-03-05 16:00:00	NVDA	Stock	0.4295	0.4319	0.4283	0.4319	16138880.0
2010-03-05 17:00:00	NVDA	Stock	0.429	0.4298	0.429	0.4298	117600.0
2010-03-05 18:00:00	NVDA	Stock	0.429	0.429	0.429	0.429	3798280.0
2010-03-05 19:00:00	NVDA	Stock	0.429	0.4302	0.4288	0.4288	68000.0
2010-03-05 05:00:00	AMZN	Stock	6.435	6.435	6.435	6.435	6000.0
2010-03-05 07:00:00	AMZN	Stock	6.4255	6.43	6.4255	6.43	8000.0
2010-03-05 08:00:00	AMZN	Stock	6.4375	6.465	6.425	6.46	544820.0
2010-03-05 09:00:00	AMZN	Stock	6.4595	6.474	6.3535	6.459	33900900.0
2010-03-05 10:00:00	AMZN	Stock	6.4595	6.4625	6.3875	6.393	27052220.0
2010-03-05 11:00:00	AMZN	Stock	6.393	6.437	6.377	6.406	19061740.0
2010-03-05 12:00:00	AMZN	Stock	6.405	6.44	6.4045	6.433	7921000.0
2010-03-05 13:00:00	AMZN	Stock	6.4326	6.4475	6.41	6.437	10544320.0
2010-03-05 14:00:00	AMZN	Stock	6.438	6.44	6.425	6.435	9570860.0
2010-03-05 15:00:00	AMZN	Stock	6.4355	6.4515	6.4265	6.4425	23089440.0
2010-03-05 16:00:00	AMZN	Stock	6.444	6.45	6.42	6.437	653920.0

> showing 50 of 45,654 rows — these rows as CSV

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