PREVIEW / stock_1hour / 2010-04-08

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-04-08.parquet
  size:    923 KB
  rows:    43,358
  symbols: 3,476

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-04-08 04:00:00	AAPL	Stock	8.5504	8.5732	8.5504	8.5714	67928.0
2010-04-08 05:00:00	AAPL	Stock	8.5679	8.5732	8.5643	8.5732	40404.0
2010-04-08 07:00:00	AAPL	Stock	8.5904	8.5904	8.5675	8.5714	39200.0
2010-04-08 08:00:00	AAPL	Stock	8.5714	8.5929	8.54	8.5686	3144120.0
2010-04-08 09:00:00	AAPL	Stock	8.5704	8.5929	8.5036	8.5099	89300680.0
2010-04-08 10:00:00	AAPL	Stock	8.5106	8.5607	8.5014	8.5382	91399728.0
2010-04-08 11:00:00	AAPL	Stock	8.5379	8.5599	8.5293	8.5482	43971928.0
2010-04-08 12:00:00	AAPL	Stock	8.5489	8.5925	8.5461	8.5921	45456880.0
2010-04-08 13:00:00	AAPL	Stock	8.5921	8.6264	8.5486	8.5768	134958712.0
2010-04-08 14:00:00	AAPL	Stock	8.5768	8.5839	8.5521	8.5746	63022904.0
2010-04-08 15:00:00	AAPL	Stock	8.5714	8.5911	8.5554	8.5696	88061876.0
2010-04-08 16:00:00	AAPL	Stock	8.5696	8.5889	8.5143	8.5725	5232696.0
2010-04-08 17:00:00	AAPL	Stock	8.5721	8.575	8.5714	8.575	179200.0
2010-04-08 18:00:00	AAPL	Stock	8.5718	8.5768	8.5696	8.5714	189616.0
2010-04-08 19:00:00	AAPL	Stock	8.5686	8.5768	8.5686	8.5739	190540.0
2010-04-08 07:00:00	MSFT	Stock	29.22	29.24	29.2	29.21	16000.0
2010-04-08 08:00:00	MSFT	Stock	29.23	29.35	29.23	29.33	31078.0
2010-04-08 09:00:00	MSFT	Stock	29.3	29.55	29.27	29.49	6347106.0
2010-04-08 10:00:00	MSFT	Stock	29.5	29.69	29.47	29.56	10072983.0
2010-04-08 11:00:00	MSFT	Stock	29.55	29.87	29.55	29.835	10868400.0
2010-04-08 12:00:00	MSFT	Stock	29.84	29.94	29.74	29.92	7456747.0
2010-04-08 13:00:00	MSFT	Stock	29.94	29.97	29.82	29.85	6386509.0
2010-04-08 14:00:00	MSFT	Stock	29.85	29.945	29.83	29.932	5110357.0
2010-04-08 15:00:00	MSFT	Stock	29.935	29.975	29.87	29.91	12803426.0
2010-04-08 16:00:00	MSFT	Stock	29.91	29.934	29.516	29.91	2280565.0
2010-04-08 17:00:00	MSFT	Stock	29.92	30.0	29.89	29.99	56330.0
2010-04-08 18:00:00	MSFT	Stock	29.99	30.0	29.92	29.98	27809.0
2010-04-08 19:00:00	MSFT	Stock	29.95	30.0	29.95	30.0	11576.0
2010-04-08 20:00:00	MSFT	Stock	29.68	29.68	29.68	29.68	900.0
2010-04-08 07:00:00	NVDA	Stock	0.4355	0.4355	0.4312	0.4312	168000.0
2010-04-08 08:00:00	NVDA	Stock	0.4312	0.4338	0.4225	0.4278	1872520.0
2010-04-08 09:00:00	NVDA	Stock	0.4278	0.4278	0.421	0.4222	154297640.0
2010-04-08 10:00:00	NVDA	Stock	0.422	0.4294	0.4198	0.4258	219211080.0
2010-04-08 11:00:00	NVDA	Stock	0.4258	0.4265	0.4225	0.4238	80817440.0
2010-04-08 12:00:00	NVDA	Stock	0.424	0.4253	0.423	0.424	90789640.0
2010-04-08 13:00:00	NVDA	Stock	0.424	0.4242	0.4228	0.4228	75450120.0
2010-04-08 14:00:00	NVDA	Stock	0.423	0.4258	0.4225	0.4225	145466800.0
2010-04-08 15:00:00	NVDA	Stock	0.4225	0.4231	0.421	0.4218	233569280.0
2010-04-08 16:00:00	NVDA	Stock	0.4222	0.424	0.4216	0.4222	13768600.0
2010-04-08 17:00:00	NVDA	Stock	0.4232	0.425	0.4232	0.425	224000.0
2010-04-08 18:00:00	NVDA	Stock	0.4242	0.4242	0.4242	0.4242	8000.0
2010-04-08 19:00:00	NVDA	Stock	0.4238	0.4238	0.4238	0.4238	4000.0
2010-04-08 08:00:00	AMZN	Stock	6.7105	6.7425	6.71	6.7425	6000.0
2010-04-08 09:00:00	AMZN	Stock	6.723	6.923	6.7205	6.8818	61459440.0
2010-04-08 10:00:00	AMZN	Stock	6.8805	6.9835	6.87	6.9625	53866360.0
2010-04-08 11:00:00	AMZN	Stock	6.9615	6.9955	6.954	6.9865	20372940.0
2010-04-08 12:00:00	AMZN	Stock	6.987	7.0375	6.9775	7.023	26070240.0
2010-04-08 13:00:00	AMZN	Stock	7.023	7.0365	6.9955	7.0055	20681400.0
2010-04-08 14:00:00	AMZN	Stock	7.0055	7.0575	7.0015	7.053	25446700.0
2010-04-08 15:00:00	AMZN	Stock	7.0525	7.0625	7.027	7.037	39068300.0

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

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