PREVIEW / stock_1hour / 2014-09-08

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-09-08.parquet
  size:    1.0 MB
  rows:    48,921
  symbols: 3,591

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-09-08 04:00:00	AAPL	Stock	24.8725	24.88	24.8325	24.835	20248.0
2014-09-08 05:00:00	AAPL	Stock	24.8025	24.8425	24.8025	24.84	16572.0
2014-09-08 06:00:00	AAPL	Stock	24.8425	24.8625	24.8125	24.8475	7200.0
2014-09-08 07:00:00	AAPL	Stock	24.8475	24.865	24.815	24.8225	271476.0
2014-09-08 08:00:00	AAPL	Stock	24.8225	24.9825	24.7425	24.7775	1079752.0
2014-09-08 09:00:00	AAPL	Stock	24.78	24.8325	23.3368	24.7375	33750008.0
2014-09-08 10:00:00	AAPL	Stock	24.735	24.7475	24.66	24.734	26733832.0
2014-09-08 11:00:00	AAPL	Stock	24.734	24.775	24.6875	24.696	19986720.0
2014-09-08 12:00:00	AAPL	Stock	24.695	24.72	24.6625	24.6915	12268756.0
2014-09-08 13:00:00	AAPL	Stock	24.6915	24.7175	24.5275	24.55	22513396.0
2014-09-08 14:00:00	AAPL	Stock	24.5475	24.595	24.5125	24.5812	17768592.0
2014-09-08 15:00:00	AAPL	Stock	24.5825	24.605	24.5375	24.585	29599748.0
2014-09-08 16:00:00	AAPL	Stock	24.59	24.7425	24.5	24.6125	8351572.0
2014-09-08 17:00:00	AAPL	Stock	24.6125	24.645	24.59	24.63	377992.0
2014-09-08 18:00:00	AAPL	Stock	24.63	24.6375	24.59	24.6375	259480.0
2014-09-08 19:00:00	AAPL	Stock	24.6375	24.645	24.6125	24.6125	171932.0
2014-09-08 04:00:00	MSFT	Stock	46.14	46.15	46.14	46.15	2600.0
2014-09-08 05:00:00	MSFT	Stock	46.09	46.09	46.07	46.07	984.0
2014-09-08 06:00:00	MSFT	Stock	46.07	46.18	46.05	46.18	3184.0
2014-09-08 07:00:00	MSFT	Stock	46.15	46.28	46.14	46.28	57115.0
2014-09-08 08:00:00	MSFT	Stock	46.17	46.29	46.13	46.18	116705.0
2014-09-08 09:00:00	MSFT	Stock	46.16	46.75	45.99	46.665	9615403.0
2014-09-08 10:00:00	MSFT	Stock	46.67	46.8	46.47	46.54	8550679.0
2014-09-08 11:00:00	MSFT	Stock	46.54	46.555	46.38	46.459	4658506.0
2014-09-08 12:00:00	MSFT	Stock	46.45	46.55	46.45	46.539	3546081.0
2014-09-08 13:00:00	MSFT	Stock	46.54	46.55	46.39	46.39	4960497.0
2014-09-08 14:00:00	MSFT	Stock	46.4	46.45	46.36	46.42	3434366.0
2014-09-08 15:00:00	MSFT	Stock	46.425	46.5	46.41	46.47	6303929.0
2014-09-08 16:00:00	MSFT	Stock	46.46	46.53	46.455	46.524	3048038.0
2014-09-08 17:00:00	MSFT	Stock	46.47	46.51	46.47	46.51	2143.0
2014-09-08 18:00:00	MSFT	Stock	46.47	46.52	46.47	46.48	24317.0
2014-09-08 19:00:00	MSFT	Stock	46.48	46.48	46.47	46.47	524.0
2014-09-08 09:00:00	NVDA	Stock	0.4988	0.4998	0.4975	0.4992	23929480.0
2014-09-08 10:00:00	NVDA	Stock	0.4994	0.4998	0.4951	0.4965	46890880.0
2014-09-08 11:00:00	NVDA	Stock	0.4965	0.4975	0.4948	0.4958	32069440.0
2014-09-08 12:00:00	NVDA	Stock	0.4955	0.497	0.495	0.4961	16103040.0
2014-09-08 13:00:00	NVDA	Stock	0.496	0.496	0.4928	0.493	33315240.0
2014-09-08 14:00:00	NVDA	Stock	0.493	0.4952	0.4928	0.4935	50143960.0
2014-09-08 15:00:00	NVDA	Stock	0.4935	0.4963	0.493	0.4948	62744600.0
2014-09-08 16:00:00	NVDA	Stock	0.4948	0.4955	0.4948	0.4948	8136640.0
2014-09-08 08:00:00	AMZN	Stock	17.2875	17.2915	17.2875	17.2915	8000.0
2014-09-08 09:00:00	AMZN	Stock	17.2925	17.2925	17.144	17.1825	6980560.0
2014-09-08 10:00:00	AMZN	Stock	17.1895	17.199	17.0755	17.172	9219000.0
2014-09-08 11:00:00	AMZN	Stock	17.174	17.21	17.08	17.0835	4973440.0
2014-09-08 12:00:00	AMZN	Stock	17.0862	17.0945	16.9855	17.0685	8522560.0
2014-09-08 13:00:00	AMZN	Stock	17.0775	17.1035	16.955	16.9884	5557200.0
2014-09-08 14:00:00	AMZN	Stock	16.9855	17.035	16.952	17.0045	5372740.0
2014-09-08 15:00:00	AMZN	Stock	17.0065	17.124	17.0065	17.1175	9384020.0
2014-09-08 16:00:00	AMZN	Stock	17.116	17.117	17.0266	17.1	511740.0
2014-09-08 17:00:00	AMZN	Stock	17.1	17.1	17.092	17.092	19000.0

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

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