PREVIEW / stock_1hour / 2014-06-11

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-06-11.parquet
  size:    1.0 MB
  rows:    49,896
  symbols: 3,531

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
2014-06-11 04:00:00	AAPL	Stock	23.54	23.555	23.515	23.515	7168.0
2014-06-11 05:00:00	AAPL	Stock	23.515	23.515	23.405	23.4375	10788.0
2014-06-11 06:00:00	AAPL	Stock	23.435	23.4475	23.4025	23.4125	25336.0
2014-06-11 07:00:00	AAPL	Stock	23.435	23.45	23.3375	23.375	506484.0
2014-06-11 08:00:00	AAPL	Stock	23.3825	23.495	23.3475	23.3875	778628.0
2014-06-11 09:00:00	AAPL	Stock	23.3925	23.635	23.3925	23.6325	34403564.0
2014-06-11 10:00:00	AAPL	Stock	23.632	23.69	23.5275	23.58	33855364.0
2014-06-11 11:00:00	AAPL	Stock	23.5822	23.6125	23.5375	23.5975	16767676.0
2014-06-11 12:00:00	AAPL	Stock	23.595	23.6075	23.545	23.5988	10969684.0
2014-06-11 13:00:00	AAPL	Stock	23.5988	23.6	23.43	23.43	16157968.0
2014-06-11 14:00:00	AAPL	Stock	23.43	23.5	23.3675	23.4502	24846152.0
2014-06-11 15:00:00	AAPL	Stock	23.45	23.4972	23.425	23.4675	21820928.0
2014-06-11 16:00:00	AAPL	Stock	23.4675	23.57	23.4375	23.4625	7992872.0
2014-06-11 17:00:00	AAPL	Stock	23.4625	23.4625	23.45	23.45	155248.0
2014-06-11 18:00:00	AAPL	Stock	23.455	23.4675	23.4525	23.465	87856.0
2014-06-11 19:00:00	AAPL	Stock	23.465	23.475	23.465	23.465	89892.0
2014-06-11 06:00:00	MSFT	Stock	41.05	41.05	41.05	41.05	100.0
2014-06-11 07:00:00	MSFT	Stock	40.99	40.99	40.9	40.91	6500.0
2014-06-11 08:00:00	MSFT	Stock	40.9	40.91	40.8	40.82	26139.0
2014-06-11 09:00:00	MSFT	Stock	40.88	41.07	40.77	41.005	2880330.0
2014-06-11 10:00:00	MSFT	Stock	41.01	41.06	40.8	40.9	2479826.0
2014-06-11 11:00:00	MSFT	Stock	40.91	40.99	40.9	40.955	1226930.0
2014-06-11 12:00:00	MSFT	Stock	40.96	40.965	40.893	40.94	933373.0
2014-06-11 13:00:00	MSFT	Stock	40.94	40.96	40.855	40.875	869992.0
2014-06-11 14:00:00	MSFT	Stock	40.87	40.9	40.81	40.83	2180626.0
2014-06-11 15:00:00	MSFT	Stock	40.84	40.86	40.765	40.85	3655107.0
2014-06-11 16:00:00	MSFT	Stock	40.86	40.908	40.84	40.86	1967269.0
2014-06-11 17:00:00	MSFT	Stock	40.85	40.85	40.85	40.85	940.0
2014-06-11 18:00:00	MSFT	Stock	40.85	40.86	40.85	40.86	798100.0
2014-06-11 19:00:00	MSFT	Stock	40.89	40.9	40.89	40.9	5420.0
2014-06-11 09:00:00	NVDA	Stock	0.477	0.485	0.477	0.4825	39331560.0
2014-06-11 10:00:00	NVDA	Stock	0.4826	0.484	0.4808	0.481	48162320.0
2014-06-11 11:00:00	NVDA	Stock	0.481	0.4828	0.481	0.482	20876080.0
2014-06-11 12:00:00	NVDA	Stock	0.4821	0.4855	0.4819	0.4855	27552280.0
2014-06-11 13:00:00	NVDA	Stock	0.4855	0.486	0.4838	0.4838	20325840.0
2014-06-11 14:00:00	NVDA	Stock	0.484	0.4848	0.483	0.4841	19679960.0
2014-06-11 15:00:00	NVDA	Stock	0.4843	0.4861	0.484	0.4852	49797240.0
2014-06-11 16:00:00	NVDA	Stock	0.485	0.4851	0.4848	0.4848	7032440.0
2014-06-11 04:00:00	AMZN	Stock	16.5995	16.625	16.5995	16.625	4000.0
2014-06-11 05:00:00	AMZN	Stock	16.6585	16.825	16.6585	16.775	202080.0
2014-06-11 06:00:00	AMZN	Stock	16.767	16.775	16.701	16.701	61660.0
2014-06-11 07:00:00	AMZN	Stock	16.7485	16.7985	16.7205	16.797	228140.0
2014-06-11 08:00:00	AMZN	Stock	16.775	16.8275	16.575	16.79	961100.0
2014-06-11 09:00:00	AMZN	Stock	16.79	16.99	16.778	16.95	23567740.0
2014-06-11 10:00:00	AMZN	Stock	16.9585	17.036	16.858	16.921	16284840.0
2014-06-11 11:00:00	AMZN	Stock	16.921	16.9585	16.8773	16.943	6073380.0
2014-06-11 12:00:00	AMZN	Stock	16.937	16.9425	16.837	16.871	5714480.0
2014-06-11 13:00:00	AMZN	Stock	16.87	16.889	16.7205	16.7418	6232140.0
2014-06-11 14:00:00	AMZN	Stock	16.7325	16.7745	16.6938	16.7355	9036220.0
2014-06-11 15:00:00	AMZN	Stock	16.7345	16.7875	16.723	16.7585	11054760.0

> showing 50 of 49,896 rows — these rows as CSV

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