PREVIEW / stock_30min / 2015-03-23

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-03-23.parquet
  size:    1.6 MB
  rows:    82,746
  symbols: 3,507

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
2015-03-23 04:00:00	AAPL	Stock	31.595	31.6425	31.5825	31.5925	24596.0
2015-03-23 04:30:00	AAPL	Stock	31.5925	31.6475	31.575	31.6475	9900.0
2015-03-23 05:00:00	AAPL	Stock	31.6475	31.6625	31.6325	31.6625	12780.0
2015-03-23 05:30:00	AAPL	Stock	31.67	31.685	31.635	31.685	8156.0
2015-03-23 06:00:00	AAPL	Stock	31.66	31.675	31.635	31.645	52844.0
2015-03-23 06:30:00	AAPL	Stock	31.655	31.6725	31.6275	31.6275	66980.0
2015-03-23 07:00:00	AAPL	Stock	31.64	31.655	31.625	31.65	42084.0
2015-03-23 07:30:00	AAPL	Stock	31.655	31.71	31.655	31.7	50252.0
2015-03-23 08:00:00	AAPL	Stock	31.69	31.7325	31.475	31.7125	498544.0
2015-03-23 08:30:00	AAPL	Stock	31.72	31.745	31.6925	31.7425	553744.0
2015-03-23 09:00:00	AAPL	Stock	31.7375	31.785	31.475	31.7475	836376.0
2015-03-23 09:30:00	AAPL	Stock	31.7575	31.8	31.63	31.6615	23022264.0
2015-03-23 10:00:00	AAPL	Stock	31.6612	31.8475	31.6325	31.8038	13578560.0
2015-03-23 10:30:00	AAPL	Stock	31.8038	31.8625	31.7625	31.8125	8567428.0
2015-03-23 11:00:00	AAPL	Stock	31.8125	31.8175	31.6775	31.745	9830588.0
2015-03-23 11:30:00	AAPL	Stock	31.7428	31.835	31.7425	31.815	6550540.0
2015-03-23 12:00:00	AAPL	Stock	31.815	31.83	31.7775	31.81	5375368.0
2015-03-23 12:30:00	AAPL	Stock	31.8125	31.8725	31.8012	31.86	5992320.0
2015-03-23 13:00:00	AAPL	Stock	31.8575	31.9225	31.8375	31.9	6757300.0
2015-03-23 13:30:00	AAPL	Stock	31.8975	31.935	31.8775	31.905	5731292.0
2015-03-23 14:00:00	AAPL	Stock	31.9025	31.9625	31.895	31.9325	5964148.0
2015-03-23 14:30:00	AAPL	Stock	31.9338	31.9525	31.8932	31.91	5177176.0
2015-03-23 15:00:00	AAPL	Stock	31.9125	31.925	31.7775	31.7975	8613664.0
2015-03-23 15:30:00	AAPL	Stock	31.7998	31.865	31.7525	31.8025	14477992.0
2015-03-23 16:00:00	AAPL	Stock	31.804	31.8405	31.7875	31.8025	15343628.0
2015-03-23 16:30:00	AAPL	Stock	31.8075	31.8472	31.7625	31.7725	1268292.0
2015-03-23 17:00:00	AAPL	Stock	31.77	31.8025	31.692	31.75	2114308.0
2015-03-23 17:30:00	AAPL	Stock	31.75	31.8025	31.75	31.7625	144940.0
2015-03-23 18:00:00	AAPL	Stock	31.7625	31.8025	31.7625	31.7875	82424.0
2015-03-23 18:30:00	AAPL	Stock	31.7975	31.8	31.7925	31.795	26816.0
2015-03-23 19:00:00	AAPL	Stock	31.7975	31.8175	31.7975	31.8175	48452.0
2015-03-23 19:30:00	AAPL	Stock	31.8125	31.835	31.805	31.82	91156.0
2015-03-23 08:00:00	MSFT	Stock	42.65	42.79	42.65	42.79	686.0
2015-03-23 08:30:00	MSFT	Stock	42.73	42.73	42.73	42.73	1000.0
2015-03-23 09:00:00	MSFT	Stock	42.78	42.94	42.78	42.9	5426.0
2015-03-23 09:30:00	MSFT	Stock	42.88	43.09	42.785	42.98	2891633.0
2015-03-23 10:00:00	MSFT	Stock	42.98	43.13	42.98	43.03	1690860.0
2015-03-23 10:30:00	MSFT	Stock	43.03	43.09	42.98	42.99	1379869.0
2015-03-23 11:00:00	MSFT	Stock	43.0	43.005	42.91	42.91	1321425.0
2015-03-23 11:30:00	MSFT	Stock	42.91	42.93	42.78	42.84	1304279.0
2015-03-23 12:00:00	MSFT	Stock	42.84	43.03	42.81	43.03	1118556.0
2015-03-23 12:30:00	MSFT	Stock	43.025	43.06	42.96	42.975	953402.0
2015-03-23 13:00:00	MSFT	Stock	42.98	43.0	42.9	42.9	841949.0
2015-03-23 13:30:00	MSFT	Stock	42.9	42.95	42.9	42.92	1153765.0
2015-03-23 14:00:00	MSFT	Stock	42.921	43.03	42.9	43.015	1080803.0
2015-03-23 14:30:00	MSFT	Stock	43.01	43.03	42.97	42.986	1252329.0
2015-03-23 15:00:00	MSFT	Stock	42.985	43.04	42.97	42.99	1587457.0
2015-03-23 15:30:00	MSFT	Stock	42.995	43.03	42.85	42.85	4056885.0
2015-03-23 16:00:00	MSFT	Stock	42.855	42.957	42.855	42.855	4392713.0
2015-03-23 16:30:00	MSFT	Stock	42.88	42.88	42.855	42.86	183938.0

> showing 50 of 82,746 rows — these rows as CSV

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