PREVIEW / stock_1hour / 2012-03-06

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-03-06.parquet
  size:    960 KB
  rows:    45,475
  symbols: 3,513

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
2012-03-06 04:00:00	AAPL	Stock	18.9543	18.9643	18.9286	18.9464	63700.0
2012-03-06 05:00:00	AAPL	Stock	18.9286	18.9286	18.8796	18.8857	148540.0
2012-03-06 06:00:00	AAPL	Stock	18.8754	18.8754	18.7518	18.7714	411908.0
2012-03-06 07:00:00	AAPL	Stock	18.7786	18.8929	18.7786	18.8768	1511580.0
2012-03-06 08:00:00	AAPL	Stock	18.8786	18.9089	18.8518	18.8654	5691252.0
2012-03-06 09:00:00	AAPL	Stock	18.8664	18.8696	18.4365	18.6257	183152256.0
2012-03-06 10:00:00	AAPL	Stock	18.6279	18.7943	18.5625	18.7556	126967708.0
2012-03-06 11:00:00	AAPL	Stock	18.7532	19.0604	18.7393	18.9286	174109460.0
2012-03-06 12:00:00	AAPL	Stock	18.9311	18.9857	18.8079	18.8589	88597264.0
2012-03-06 13:00:00	AAPL	Stock	18.8625	18.9382	18.8171	18.8621	64705228.0
2012-03-06 14:00:00	AAPL	Stock	18.8611	18.9086	18.8036	18.8382	51111396.0
2012-03-06 15:00:00	AAPL	Stock	18.8371	18.9729	18.8361	18.9375	89760524.0
2012-03-06 16:00:00	AAPL	Stock	18.9379	18.9439	18.7965	18.9196	10330880.0
2012-03-06 17:00:00	AAPL	Stock	18.9154	18.9286	18.915	18.9214	477540.0
2012-03-06 18:00:00	AAPL	Stock	18.9229	18.925	18.9179	18.9214	150332.0
2012-03-06 19:00:00	AAPL	Stock	18.9214	18.9636	18.92	18.9636	984004.0
2012-03-06 07:00:00	MSFT	Stock	31.62	31.67	31.51	31.51	4100.0
2012-03-06 08:00:00	MSFT	Stock	31.6	31.6	31.45	31.45	43533.0
2012-03-06 09:00:00	MSFT	Stock	31.45	31.98	31.33	31.84	10434676.0
2012-03-06 10:00:00	MSFT	Stock	31.845	31.88	31.61	31.71	9517956.0
2012-03-06 11:00:00	MSFT	Stock	31.71	31.78	31.55	31.605	6148529.0
2012-03-06 12:00:00	MSFT	Stock	31.61	31.625	31.49	31.59	4795867.0
2012-03-06 13:00:00	MSFT	Stock	31.585	31.7	31.58	31.655	3638665.0
2012-03-06 14:00:00	MSFT	Stock	31.655	31.68	31.52	31.572	4951451.0
2012-03-06 15:00:00	MSFT	Stock	31.57	31.63	31.515	31.56	9137353.0
2012-03-06 16:00:00	MSFT	Stock	31.56	31.676	31.396	31.56	2726840.0
2012-03-06 17:00:00	MSFT	Stock	31.55	31.55	31.55	31.55	380.0
2012-03-06 18:00:00	MSFT	Stock	31.58	31.67	31.53	31.67	107799.0
2012-03-06 19:00:00	MSFT	Stock	31.65	31.65	31.59	31.6	1900.0
2012-03-06 05:00:00	NVDA	Stock	0.3688	0.3688	0.3655	0.3655	40000.0
2012-03-06 08:00:00	NVDA	Stock	0.3675	0.3685	0.365	0.3655	710160.0
2012-03-06 09:00:00	NVDA	Stock	0.3662	0.3678	0.3618	0.3648	70204440.0
2012-03-06 10:00:00	NVDA	Stock	0.3646	0.3658	0.3615	0.3652	82417360.0
2012-03-06 11:00:00	NVDA	Stock	0.365	0.3682	0.3645	0.3665	66779400.0
2012-03-06 12:00:00	NVDA	Stock	0.3665	0.3668	0.3652	0.366	37745520.0
2012-03-06 13:00:00	NVDA	Stock	0.3662	0.3685	0.3652	0.3682	37306000.0
2012-03-06 14:00:00	NVDA	Stock	0.368	0.3703	0.3672	0.3678	62347400.0
2012-03-06 15:00:00	NVDA	Stock	0.3678	0.3688	0.3655	0.3678	98706960.0
2012-03-06 16:00:00	NVDA	Stock	0.367	0.3684	0.3652	0.3683	3497480.0
2012-03-06 17:00:00	NVDA	Stock	0.366	0.366	0.366	0.366	80000.0
2012-03-06 18:00:00	NVDA	Stock	0.3655	0.3668	0.3655	0.3668	54400.0
2012-03-06 19:00:00	NVDA	Stock	0.3668	0.3668	0.3668	0.3668	12000.0
2012-03-06 04:00:00	AMZN	Stock	9.006	9.0215	8.834	8.8855	32600.0
2012-03-06 08:00:00	AMZN	Stock	8.9415	8.9925	8.925	8.925	175460.0
2012-03-06 09:00:00	AMZN	Stock	8.9255	9.055	8.87	9.0026	17653800.0
2012-03-06 10:00:00	AMZN	Stock	9.0058	9.175	8.9535	9.11	28350920.0
2012-03-06 11:00:00	AMZN	Stock	9.108	9.1475	9.0525	9.066	14911600.0
2012-03-06 12:00:00	AMZN	Stock	9.0655	9.094	9.05	9.081	9348540.0
2012-03-06 13:00:00	AMZN	Stock	9.0805	9.107	9.0295	9.0435	10002900.0
2012-03-06 14:00:00	AMZN	Stock	9.042	9.0435	8.977	8.9855	11959100.0

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

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