PREVIEW / stock_30min / 2014-07-22

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-07-22.parquet
  size:    1.6 MB
  rows:    81,642
  symbols: 3,572

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-22 04:00:00	AAPL	Stock	23.625	23.625	23.625	23.625	3200.0
2014-07-22 04:30:00	AAPL	Stock	23.6475	23.65	23.6375	23.65	41304.0
2014-07-22 05:00:00	AAPL	Stock	23.6825	23.7	23.6825	23.69	15320.0
2014-07-22 05:30:00	AAPL	Stock	23.6875	23.7125	23.6875	23.7	32676.0
2014-07-22 06:00:00	AAPL	Stock	23.7	23.7075	23.69	23.7	18272.0
2014-07-22 06:30:00	AAPL	Stock	23.7075	23.7075	23.6875	23.6875	42628.0
2014-07-22 07:00:00	AAPL	Stock	23.695	23.7	23.665	23.6925	405456.0
2014-07-22 07:30:00	AAPL	Stock	23.7	23.71	23.6525	23.6525	202588.0
2014-07-22 08:00:00	AAPL	Stock	23.665	23.71	23.6075	23.6575	601224.0
2014-07-22 08:30:00	AAPL	Stock	23.66	23.67	23.625	23.6475	458908.0
2014-07-22 09:00:00	AAPL	Stock	23.6475	23.6925	23.6425	23.67	500852.0
2014-07-22 09:30:00	AAPL	Stock	23.67	23.7175	23.5375	23.5675	26112464.0
2014-07-22 10:00:00	AAPL	Stock	23.568	23.645	23.5625	23.59	14301480.0
2014-07-22 10:30:00	AAPL	Stock	23.5878	23.5925	23.5425	23.582	11426276.0
2014-07-22 11:00:00	AAPL	Stock	23.58	23.6025	23.5425	23.5438	10990672.0
2014-07-22 11:30:00	AAPL	Stock	23.5438	23.585	23.53	23.5538	10086368.0
2014-07-22 12:00:00	AAPL	Stock	23.5538	23.5925	23.55	23.57	8397112.0
2014-07-22 12:30:00	AAPL	Stock	23.57	23.59	23.5675	23.5825	5212880.0
2014-07-22 13:00:00	AAPL	Stock	23.5812	23.625	23.58	23.605	7346132.0
2014-07-22 13:30:00	AAPL	Stock	23.6048	23.6075	23.5675	23.6	7484280.0
2014-07-22 14:00:00	AAPL	Stock	23.6	23.6125	23.5875	23.5925	6511372.0
2014-07-22 14:30:00	AAPL	Stock	23.5912	23.595	23.535	23.5925	12610768.0
2014-07-22 15:00:00	AAPL	Stock	23.5918	23.6775	23.58	23.674	13990732.0
2014-07-22 15:30:00	AAPL	Stock	23.6737	23.7225	23.605	23.675	30569352.0
2014-07-22 16:00:00	AAPL	Stock	23.675	23.8175	23.5112	23.7425	7648456.0
2014-07-22 16:30:00	AAPL	Stock	23.725	23.805	23.2	23.6	16329476.0
2014-07-22 17:00:00	AAPL	Stock	23.605	23.68	23.575	23.5875	3346164.0
2014-07-22 17:30:00	AAPL	Stock	23.595	23.6	23.5	23.525	1194944.0
2014-07-22 18:00:00	AAPL	Stock	23.52	23.68	23.5025	23.575	739344.0
2014-07-22 18:30:00	AAPL	Stock	23.5725	23.5925	23.55	23.55	366824.0
2014-07-22 19:00:00	AAPL	Stock	23.545	23.56	23.5375	23.5425	358408.0
2014-07-22 19:30:00	AAPL	Stock	23.54	23.555	23.5375	23.5375	530500.0
2014-07-22 05:00:00	MSFT	Stock	44.74	44.74	44.74	44.74	100.0
2014-07-22 05:30:00	MSFT	Stock	44.74	44.74	44.74	44.74	100.0
2014-07-22 06:00:00	MSFT	Stock	44.78	44.78	44.78	44.78	100.0
2014-07-22 06:30:00	MSFT	Stock	45.0	45.0	45.0	45.0	1112.0
2014-07-22 07:00:00	MSFT	Stock	44.9	44.98	44.9	44.98	2500.0
2014-07-22 07:30:00	MSFT	Stock	44.99	45.06	44.99	45.06	4300.0
2014-07-22 08:00:00	MSFT	Stock	44.93	45.1	44.93	45.05	17065.0
2014-07-22 08:30:00	MSFT	Stock	45.1	45.1	45.02	45.04	6230.0
2014-07-22 09:00:00	MSFT	Stock	45.04	45.1	44.95	45.04	26782.0
2014-07-22 09:30:00	MSFT	Stock	45.04	45.12	44.82	45.08	4212524.0
2014-07-22 10:00:00	MSFT	Stock	45.085	45.15	44.93	44.94	2579390.0
2014-07-22 10:30:00	MSFT	Stock	44.937	45.07	44.88	44.89	5346488.0
2014-07-22 11:00:00	MSFT	Stock	44.9	44.96	44.83	44.95	3131849.0
2014-07-22 11:30:00	MSFT	Stock	44.94	44.96	44.86	44.915	1957647.0
2014-07-22 12:00:00	MSFT	Stock	44.915	45.0	44.91	44.953	1333590.0
2014-07-22 12:30:00	MSFT	Stock	44.951	45.035	44.9	44.905	1306829.0
2014-07-22 13:00:00	MSFT	Stock	44.905	44.95	44.87	44.905	1192186.0
2014-07-22 13:30:00	MSFT	Stock	44.91	44.94	44.765	44.765	1456724.0

> showing 50 of 81,642 rows — these rows as CSV

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