PREVIEW / stock_1hour / 2016-04-28

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-04-28.parquet
  size:    1.0 MB
  rows:    48,395
  symbols: 3,323

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
2016-04-28 04:00:00	AAPL	Stock	24.5	24.5	24.275	24.32	16944.0
2016-04-28 05:00:00	AAPL	Stock	24.3	24.35	24.275	24.35	17624.0
2016-04-28 06:00:00	AAPL	Stock	24.33	24.3725	24.325	24.34	27536.0
2016-04-28 07:00:00	AAPL	Stock	24.3575	24.375	24.3075	24.325	88584.0
2016-04-28 08:00:00	AAPL	Stock	24.35	24.525	24.3125	24.3925	416636.0
2016-04-28 09:00:00	AAPL	Stock	24.3925	24.45	24.1475	24.3102	34366452.0
2016-04-28 10:00:00	AAPL	Stock	24.31	24.47	24.2275	24.4475	33418732.0
2016-04-28 11:00:00	AAPL	Stock	24.4475	24.46	24.3075	24.3108	19905220.0
2016-04-28 12:00:00	AAPL	Stock	24.311	24.3425	24.2262	24.232	16946552.0
2016-04-28 13:00:00	AAPL	Stock	24.23	24.3075	24.1875	24.205	19511956.0
2016-04-28 14:00:00	AAPL	Stock	24.2055	24.2375	23.8625	23.8912	81080228.0
2016-04-28 15:00:00	AAPL	Stock	23.8925	23.9075	23.5625	23.705	89388996.0
2016-04-28 16:00:00	AAPL	Stock	23.7075	24.2535	23.6875	23.7825	9921228.0
2016-04-28 17:00:00	AAPL	Stock	23.7875	23.8	23.76	23.785	181468.0
2016-04-28 18:00:00	AAPL	Stock	23.7775	23.7875	23.75	23.7675	179336.0
2016-04-28 19:00:00	AAPL	Stock	23.7575	23.79	23.755	23.77	135040.0
2016-04-28 04:00:00	MSFT	Stock	50.67	50.67	50.67	50.67	100.0
2016-04-28 06:00:00	MSFT	Stock	50.6	50.6	50.55	50.58	4346.0
2016-04-28 07:00:00	MSFT	Stock	50.59	50.72	50.58	50.61	7751.0
2016-04-28 08:00:00	MSFT	Stock	50.67	50.78	50.6	50.78	32673.0
2016-04-28 09:00:00	MSFT	Stock	50.77	50.77	50.36	50.58	3869635.0
2016-04-28 10:00:00	MSFT	Stock	50.575	50.61	50.3	50.5	4386940.0
2016-04-28 11:00:00	MSFT	Stock	50.5	50.66	50.49	50.57	2332321.0
2016-04-28 12:00:00	MSFT	Stock	50.56	50.62	50.26	50.285	3266894.0
2016-04-28 13:00:00	MSFT	Stock	50.29	50.31	50.09	50.15	4378504.0
2016-04-28 14:00:00	MSFT	Stock	50.155	50.26	49.95	50.07	4600811.0
2016-04-28 15:00:00	MSFT	Stock	50.075	50.085	49.56	49.89	14251024.0
2016-04-28 16:00:00	MSFT	Stock	49.9	50.15	49.842	50.09	2997235.0
2016-04-28 17:00:00	MSFT	Stock	50.08	50.1	50.0	50.0	9530.0
2016-04-28 18:00:00	MSFT	Stock	50.02	50.07	49.97	50.07	5517.0
2016-04-28 19:00:00	MSFT	Stock	49.99	50.08	49.97	50.06	7339.0
2016-04-28 08:00:00	NVDA	Stock	0.9258	0.9295	0.9258	0.9295	10560.0
2016-04-28 09:00:00	NVDA	Stock	0.928	0.9325	0.9162	0.9248	27849960.0
2016-04-28 10:00:00	NVDA	Stock	0.925	0.9314	0.9241	0.9314	56769720.0
2016-04-28 11:00:00	NVDA	Stock	0.9314	0.9315	0.9268	0.9285	34240840.0
2016-04-28 12:00:00	NVDA	Stock	0.9283	0.93	0.9213	0.9232	31741960.0
2016-04-28 13:00:00	NVDA	Stock	0.9235	0.9235	0.9152	0.9162	39239680.0
2016-04-28 14:00:00	NVDA	Stock	0.9162	0.9168	0.91	0.9115	42886520.0
2016-04-28 15:00:00	NVDA	Stock	0.9115	0.9123	0.9028	0.905	125288160.0
2016-04-28 16:00:00	NVDA	Stock	0.905	0.9088	0.9038	0.9088	4815040.0
2016-04-28 17:00:00	NVDA	Stock	0.911	0.911	0.906	0.906	15200.0
2016-04-28 18:00:00	NVDA	Stock	0.9105	0.9105	0.9105	0.9105	4320.0
2016-04-28 04:00:00	AMZN	Stock	30.5	30.5	30.5	30.5	3000.0
2016-04-28 07:00:00	AMZN	Stock	30.7	30.745	30.665	30.73	154700.0
2016-04-28 08:00:00	AMZN	Stock	30.733	30.81	30.7005	30.75	223700.0
2016-04-28 09:00:00	AMZN	Stock	30.7255	31.34	30.71	31.041	16501880.0
2016-04-28 10:00:00	AMZN	Stock	31.039	31.222	30.99	31.1255	9594020.0
2016-04-28 11:00:00	AMZN	Stock	31.127	31.145	30.9795	31.0346	7225760.0
2016-04-28 12:00:00	AMZN	Stock	31.0425	31.095	30.8156	30.884	7832840.0
2016-04-28 13:00:00	AMZN	Stock	30.8826	30.886	30.5825	30.605	10487520.0

> showing 50 of 48,395 rows — these rows as CSV

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