PREVIEW / stock_30min / 2014-01-31

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-01-31.parquet
  size:    1.6 MB
  rows:    84,782
  symbols: 3,534

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-01-31 04:30:00	AAPL	Stock	17.7821	17.7857	17.7821	17.7857	50568.0
2014-01-31 05:00:00	AAPL	Stock	17.7786	17.7786	17.7	17.7	25200.0
2014-01-31 05:30:00	AAPL	Stock	17.7	17.7543	17.6875	17.6875	30660.0
2014-01-31 06:00:00	AAPL	Stock	17.7529	17.7679	17.7529	17.7679	30800.0
2014-01-31 06:30:00	AAPL	Stock	17.7571	17.7571	17.6875	17.6989	176260.0
2014-01-31 07:00:00	AAPL	Stock	17.7268	17.7714	17.7039	17.7714	135576.0
2014-01-31 07:30:00	AAPL	Stock	17.7607	17.7643	17.7054	17.7143	333676.0
2014-01-31 08:00:00	AAPL	Stock	17.75	17.75	17.6875	17.6943	1394400.0
2014-01-31 08:30:00	AAPL	Stock	17.6961	17.7225	17.6875	17.7214	771960.0
2014-01-31 09:00:00	AAPL	Stock	17.7271	17.7654	17.6786	17.6786	1402716.0
2014-01-31 09:30:00	AAPL	Stock	17.6868	17.7982	17.6789	17.6904	54582276.0
2014-01-31 10:00:00	AAPL	Stock	17.6925	17.7579	17.6825	17.6914	26935580.0
2014-01-31 10:30:00	AAPL	Stock	17.6921	17.7032	17.6268	17.6729	31841880.0
2014-01-31 11:00:00	AAPL	Stock	17.6718	17.7282	17.6689	17.7282	15286264.0
2014-01-31 11:30:00	AAPL	Stock	17.7232	17.775	17.7211	17.7734	15914976.0
2014-01-31 12:00:00	AAPL	Stock	17.7732	17.88	17.7732	17.8479	28307104.0
2014-01-31 12:30:00	AAPL	Stock	17.8482	17.8521	17.7768	17.7996	15178800.0
2014-01-31 13:00:00	AAPL	Stock	17.7957	17.85	17.7914	17.8346	12711244.0
2014-01-31 13:30:00	AAPL	Stock	17.8346	17.9068	17.8271	17.8929	18410644.0
2014-01-31 14:00:00	AAPL	Stock	17.8939	17.9096	17.8579	17.8961	17151484.0
2014-01-31 14:30:00	AAPL	Stock	17.8932	17.9118	17.8454	17.8482	14522788.0
2014-01-31 15:00:00	AAPL	Stock	17.8482	17.8807	17.8246	17.8596	20804616.0
2014-01-31 15:30:00	AAPL	Stock	17.8596	17.8786	17.8496	17.8782	36329636.0
2014-01-31 16:00:00	AAPL	Stock	17.8786	17.8818	17.7915	17.8696	20759900.0
2014-01-31 16:30:00	AAPL	Stock	17.8661	17.8821	17.7017	17.8821	722876.0
2014-01-31 17:00:00	AAPL	Stock	17.8764	17.8825	17.8725	17.8818	161140.0
2014-01-31 17:30:00	AAPL	Stock	17.8768	17.8868	17.8768	17.8839	45192.0
2014-01-31 18:00:00	AAPL	Stock	17.8875	17.8875	17.8814	17.8875	65828.0
2014-01-31 18:30:00	AAPL	Stock	17.8843	17.8889	17.8786	17.8786	81872.0
2014-01-31 19:00:00	AAPL	Stock	17.8871	17.8886	17.875	17.8825	104076.0
2014-01-31 19:30:00	AAPL	Stock	17.8875	17.9011	17.8875	17.8929	116424.0
2014-01-31 04:00:00	MSFT	Stock	36.9	36.93	36.81	36.93	700.0
2014-01-31 04:30:00	MSFT	Stock	36.93	37.1	36.93	37.1	8600.0
2014-01-31 05:00:00	MSFT	Stock	36.93	37.0	36.93	37.0	3200.0
2014-01-31 05:30:00	MSFT	Stock	37.04	37.05	36.97	37.0	4200.0
2014-01-31 06:00:00	MSFT	Stock	37.0	37.01	37.0	37.0	4240.0
2014-01-31 06:30:00	MSFT	Stock	37.0	37.29	37.0	37.18	19214.0
2014-01-31 07:00:00	MSFT	Stock	36.86	37.33	36.86	37.31	17402.0
2014-01-31 07:30:00	MSFT	Stock	37.21	37.29	37.05	37.2	40649.0
2014-01-31 08:00:00	MSFT	Stock	37.2	37.24	37.0	37.1	167993.0
2014-01-31 08:30:00	MSFT	Stock	37.09	37.27	37.09	37.25	123897.0
2014-01-31 09:00:00	MSFT	Stock	37.23	37.36	36.64	36.95	681528.0
2014-01-31 09:30:00	MSFT	Stock	36.95	37.54	36.89	37.05	11597233.0
2014-01-31 10:00:00	MSFT	Stock	37.05	37.07	36.56	36.65	6103361.0
2014-01-31 10:30:00	MSFT	Stock	36.655	37.01	36.65	36.895	4462633.0
2014-01-31 11:00:00	MSFT	Stock	36.89	37.1	36.88	37.098	3306709.0
2014-01-31 11:30:00	MSFT	Stock	37.09	37.16	37.01	37.16	3342649.0
2014-01-31 12:00:00	MSFT	Stock	37.155	37.49	37.15	37.42	3528844.0
2014-01-31 12:30:00	MSFT	Stock	37.415	37.81	37.41	37.78	6272488.0
2014-01-31 13:00:00	MSFT	Stock	37.78	37.78	37.49	37.577	3875935.0

> showing 50 of 84,782 rows — these rows as CSV

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