PREVIEW / stock_1hour / 2014-09-18

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-09-18.parquet
  size:    1.0 MB
  rows:    48,995
  symbols: 3,582

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-18 04:00:00	AAPL	Stock	25.33	25.405	25.33	25.405	7448.0
2014-09-18 05:00:00	AAPL	Stock	25.4325	25.48	25.4225	25.48	13584.0
2014-09-18 06:00:00	AAPL	Stock	25.4775	25.5475	25.4775	25.5275	146576.0
2014-09-18 07:00:00	AAPL	Stock	25.5275	25.6775	25.5275	25.575	634552.0
2014-09-18 08:00:00	AAPL	Stock	25.575	25.6325	25.515	25.5525	684376.0
2014-09-18 09:00:00	AAPL	Stock	25.5525	25.61	25.455	25.5338	25021940.0
2014-09-18 10:00:00	AAPL	Stock	25.5325	25.555	25.4675	25.5197	24835632.0
2014-09-18 11:00:00	AAPL	Stock	25.5175	25.535	25.4875	25.5062	12652044.0
2014-09-18 12:00:00	AAPL	Stock	25.5075	25.525	25.49	25.5052	9968976.0
2014-09-18 13:00:00	AAPL	Stock	25.5075	25.5225	25.455	25.4828	12987172.0
2014-09-18 14:00:00	AAPL	Stock	25.4825	25.5175	25.4675	25.4775	12942016.0
2014-09-18 15:00:00	AAPL	Stock	25.475	25.4825	25.39	25.446	28848644.0
2014-09-18 16:00:00	AAPL	Stock	25.4475	25.4975	25.395	25.46	9867196.0
2014-09-18 17:00:00	AAPL	Stock	25.46	25.4625	25.445	25.4475	592844.0
2014-09-18 18:00:00	AAPL	Stock	25.445	25.47	25.4375	25.46	1182280.0
2014-09-18 19:00:00	AAPL	Stock	25.46	25.4675	25.445	25.45	90076.0
2014-09-18 04:00:00	MSFT	Stock	46.52	46.52	46.52	46.52	100.0
2014-09-18 08:00:00	MSFT	Stock	46.635	46.7	46.635	46.67	2074.0
2014-09-18 09:00:00	MSFT	Stock	46.69	46.7	46.46	46.61	3668778.0
2014-09-18 10:00:00	MSFT	Stock	46.61	46.62	46.51	46.55	4416917.0
2014-09-18 11:00:00	MSFT	Stock	46.56	46.6	46.51	46.53	3260901.0
2014-09-18 12:00:00	MSFT	Stock	46.53	46.63	46.5	46.59	2856366.0
2014-09-18 13:00:00	MSFT	Stock	46.595	46.63	46.54	46.595	3019392.0
2014-09-18 14:00:00	MSFT	Stock	46.599	46.81	46.59	46.8	3533683.0
2014-09-18 15:00:00	MSFT	Stock	46.8	46.83	46.66	46.68	9034516.0
2014-09-18 16:00:00	MSFT	Stock	46.68	46.72	46.4	46.6	4648215.0
2014-09-18 17:00:00	MSFT	Stock	46.59	46.68	46.53	46.68	31802.0
2014-09-18 18:00:00	MSFT	Stock	46.51	46.78	46.51	46.78	21763.0
2014-09-18 19:00:00	MSFT	Stock	46.79	46.79	46.79	46.79	15000.0
2014-09-18 07:00:00	NVDA	Stock	0.48	0.48	0.48	0.48	8000.0
2014-09-18 09:00:00	NVDA	Stock	0.4788	0.4848	0.4788	0.4846	33278800.0
2014-09-18 10:00:00	NVDA	Stock	0.4845	0.4852	0.482	0.483	37425320.0
2014-09-18 11:00:00	NVDA	Stock	0.483	0.4855	0.483	0.4843	21020920.0
2014-09-18 12:00:00	NVDA	Stock	0.4843	0.486	0.484	0.4855	13854400.0
2014-09-18 13:00:00	NVDA	Stock	0.4855	0.4858	0.4834	0.4836	12030240.0
2014-09-18 14:00:00	NVDA	Stock	0.4836	0.4852	0.4836	0.4843	13394840.0
2014-09-18 15:00:00	NVDA	Stock	0.4843	0.4865	0.4835	0.4861	61144920.0
2014-09-18 16:00:00	NVDA	Stock	0.486	0.4878	0.4854	0.4861	12006120.0
2014-09-18 18:00:00	NVDA	Stock	0.484	0.484	0.484	0.484	16000.0
2014-09-18 08:00:00	AMZN	Stock	16.272	16.2985	16.225	16.251	40380.0
2014-09-18 09:00:00	AMZN	Stock	16.2725	16.335	16.1855	16.2715	8915320.0
2014-09-18 10:00:00	AMZN	Stock	16.272	16.355	16.245	16.324	8675720.0
2014-09-18 11:00:00	AMZN	Stock	16.3225	16.349	16.2825	16.3045	4479780.0
2014-09-18 12:00:00	AMZN	Stock	16.301	16.329	16.275	16.285	4060060.0
2014-09-18 13:00:00	AMZN	Stock	16.288	16.296	16.2426	16.2675	3467620.0
2014-09-18 14:00:00	AMZN	Stock	16.2735	16.294	16.2275	16.254	3773940.0
2014-09-18 15:00:00	AMZN	Stock	16.2521	16.274	16.233	16.25	11244260.0
2014-09-18 16:00:00	AMZN	Stock	16.25	16.3208	16.2	16.287	3485060.0
2014-09-18 17:00:00	AMZN	Stock	16.25	16.2875	16.25	16.2875	14120.0
2014-09-18 18:00:00	AMZN	Stock	16.2855	16.2875	16.2855	16.2865	18660.0

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

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