PREVIEW / stock_30min / 2014-07-08

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-07-08.parquet
  size:    1.6 MB
  rows:    83,691
  symbols: 3,576

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-07-08 04:00:00	AAPL	Stock	24.0725	24.075	24.0675	24.0725	21492.0
2014-07-08 04:30:00	AAPL	Stock	24.075	24.1175	24.075	24.0875	6092.0
2014-07-08 05:00:00	AAPL	Stock	24.085	24.085	24.0675	24.0675	11980.0
2014-07-08 05:30:00	AAPL	Stock	24.0775	24.08	24.065	24.065	7600.0
2014-07-08 06:00:00	AAPL	Stock	24.0675	24.0725	24.065	24.065	46160.0
2014-07-08 06:30:00	AAPL	Stock	24.0675	24.1	24.0675	24.1	51120.0
2014-07-08 07:00:00	AAPL	Stock	24.1025	24.1375	24.1025	24.115	239308.0
2014-07-08 07:30:00	AAPL	Stock	24.115	24.1275	24.1	24.1125	283732.0
2014-07-08 08:00:00	AAPL	Stock	24.1125	24.18	23.925	24.145	1012796.0
2014-07-08 08:30:00	AAPL	Stock	24.145	24.1575	24.0725	24.1225	912008.0
2014-07-08 09:00:00	AAPL	Stock	24.1225	24.1225	24.015	24.0525	1033668.0
2014-07-08 09:30:00	AAPL	Stock	24.06	24.2	23.9312	24.04	48678992.0
2014-07-08 10:00:00	AAPL	Stock	24.0398	24.04	23.77	23.7955	29642220.0
2014-07-08 10:30:00	AAPL	Stock	23.7965	23.8275	23.71	23.8263	24551748.0
2014-07-08 11:00:00	AAPL	Stock	23.825	23.845	23.6525	23.6595	15072472.0
2014-07-08 11:30:00	AAPL	Stock	23.6578	23.7	23.48	23.56	23500884.0
2014-07-08 12:00:00	AAPL	Stock	23.56	23.6625	23.5425	23.66	12959860.0
2014-07-08 12:30:00	AAPL	Stock	23.66	23.74	23.64	23.735	11165820.0
2014-07-08 13:00:00	AAPL	Stock	23.735	23.7875	23.665	23.777	10181884.0
2014-07-08 13:30:00	AAPL	Stock	23.7775	23.85	23.7525	23.8275	9882292.0
2014-07-08 14:00:00	AAPL	Stock	23.8275	23.8375	23.78	23.78	7709516.0
2014-07-08 14:30:00	AAPL	Stock	23.7812	23.84	23.7575	23.7805	7495360.0
2014-07-08 15:00:00	AAPL	Stock	23.7825	23.8125	23.7125	23.7815	9136464.0
2014-07-08 15:30:00	AAPL	Stock	23.78	23.85	23.7762	23.8325	17927964.0
2014-07-08 16:00:00	AAPL	Stock	23.8325	23.9618	23.715	23.8525	9721580.0
2014-07-08 16:30:00	AAPL	Stock	23.85	23.85	23.76	23.83	820400.0
2014-07-08 17:00:00	AAPL	Stock	23.83	23.835	23.815	23.83	109848.0
2014-07-08 17:30:00	AAPL	Stock	23.825	23.835	23.8175	23.8275	42076.0
2014-07-08 18:00:00	AAPL	Stock	23.8175	23.8325	23.8075	23.82	135960.0
2014-07-08 18:30:00	AAPL	Stock	23.82	23.8325	23.82	23.825	34260.0
2014-07-08 19:00:00	AAPL	Stock	23.825	23.825	23.8075	23.8075	58600.0
2014-07-08 19:30:00	AAPL	Stock	23.8075	23.8175	23.755	23.7875	116856.0
2014-07-08 08:00:00	MSFT	Stock	41.8	41.8	41.8	41.8	400.0
2014-07-08 08:30:00	MSFT	Stock	42.0	42.0	41.9	41.9	700.0
2014-07-08 09:00:00	MSFT	Stock	41.9	41.9	41.82	41.86	8239.0
2014-07-08 09:30:00	MSFT	Stock	41.87	41.98	41.75	41.84	3841962.0
2014-07-08 10:00:00	MSFT	Stock	41.835	41.845	41.61	41.715	3497817.0
2014-07-08 10:30:00	MSFT	Stock	41.715	41.86	41.67	41.83	1874608.0
2014-07-08 11:00:00	MSFT	Stock	41.835	41.855	41.78	41.82	1536130.0
2014-07-08 11:30:00	MSFT	Stock	41.815	41.88	41.74	41.82	1914261.0
2014-07-08 12:00:00	MSFT	Stock	41.82	41.86	41.8	41.82	1472518.0
2014-07-08 12:30:00	MSFT	Stock	41.83	41.86	41.795	41.855	1147867.0
2014-07-08 13:00:00	MSFT	Stock	41.855	41.92	41.83	41.89	867691.0
2014-07-08 13:30:00	MSFT	Stock	41.888	42.0	41.85	41.94	1428084.0
2014-07-08 14:00:00	MSFT	Stock	41.94	42.0	41.89	41.94	1146594.0
2014-07-08 14:30:00	MSFT	Stock	41.94	41.96	41.9	41.913	922971.0
2014-07-08 15:00:00	MSFT	Stock	41.92	41.93	41.83	41.86	1097447.0
2014-07-08 15:30:00	MSFT	Stock	41.865	41.87	41.75	41.79	4478745.0
2014-07-08 16:00:00	MSFT	Stock	41.78	41.861	41.707	41.8	3194425.0
2014-07-08 16:30:00	MSFT	Stock	41.8	41.876	41.78	41.83	30756.0

> showing 50 of 83,691 rows — these rows as CSV

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