PREVIEW / stock_30min / 2015-07-27

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-07-27.parquet
  size:    1.6 MB
  rows:    82,546
  symbols: 3,490

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-07-27 04:00:00	AAPL	Stock	31.125	31.15	31.075	31.1375	11096.0
2015-07-27 04:30:00	AAPL	Stock	31.1125	31.1125	31.0875	31.1	24312.0
2015-07-27 05:00:00	AAPL	Stock	31.07	31.07	31.01	31.01	25152.0
2015-07-27 05:30:00	AAPL	Stock	31.0225	31.0225	30.925	30.925	32668.0
2015-07-27 06:00:00	AAPL	Stock	30.9125	30.915	30.85	30.85	87280.0
2015-07-27 06:30:00	AAPL	Stock	30.85	30.8825	30.8	30.8775	124444.0
2015-07-27 07:00:00	AAPL	Stock	30.8775	30.8825	30.7975	30.81	208680.0
2015-07-27 07:30:00	AAPL	Stock	30.81	30.825	30.6875	30.775	266320.0
2015-07-27 08:00:00	AAPL	Stock	30.765	30.8775	30.7	30.7575	744512.0
2015-07-27 08:30:00	AAPL	Stock	30.7575	30.8	30.7275	30.7375	328668.0
2015-07-27 09:00:00	AAPL	Stock	30.75	30.7825	30.7025	30.7825	605336.0
2015-07-27 09:30:00	AAPL	Stock	30.7725	30.8325	30.53	30.8025	37074612.0
2015-07-27 10:00:00	AAPL	Stock	30.8	30.802	30.595	30.6962	15878072.0
2015-07-27 10:30:00	AAPL	Stock	30.6975	30.89	30.6875	30.8362	12696584.0
2015-07-27 11:00:00	AAPL	Stock	30.8375	30.9025	30.7325	30.7325	9229476.0
2015-07-27 11:30:00	AAPL	Stock	30.7325	30.785	30.69	30.7538	8484532.0
2015-07-27 12:00:00	AAPL	Stock	30.755	30.77	30.7025	30.7275	5568072.0
2015-07-27 12:30:00	AAPL	Stock	30.7275	30.7325	30.651	30.6875	6040820.0
2015-07-27 13:00:00	AAPL	Stock	30.6875	30.7725	30.6775	30.735	5873940.0
2015-07-27 13:30:00	AAPL	Stock	30.735	30.7575	30.6688	30.7525	6792012.0
2015-07-27 14:00:00	AAPL	Stock	30.755	30.8288	30.735	30.765	5647360.0
2015-07-27 14:30:00	AAPL	Stock	30.7675	30.7775	30.6875	30.7075	5846876.0
2015-07-27 15:00:00	AAPL	Stock	30.71	30.7375	30.6525	30.6788	8496504.0
2015-07-27 15:30:00	AAPL	Stock	30.6788	30.73	30.615	30.725	20188144.0
2015-07-27 16:00:00	AAPL	Stock	30.7275	30.775	30.625	30.735	13284624.0
2015-07-27 16:30:00	AAPL	Stock	30.7375	30.75	30.7125	30.735	55460.0
2015-07-27 17:00:00	AAPL	Stock	30.725	30.725	30.71	30.715	40628.0
2015-07-27 17:30:00	AAPL	Stock	30.72	30.72	30.715	30.7168	26924.0
2015-07-27 18:00:00	AAPL	Stock	30.7175	30.7325	30.7125	30.7125	60520.0
2015-07-27 18:30:00	AAPL	Stock	30.7125	30.73	30.71	30.715	38296.0
2015-07-27 19:00:00	AAPL	Stock	30.715	30.72	30.71	30.7125	98132.0
2015-07-27 19:30:00	AAPL	Stock	30.715	30.735	30.715	30.7192	92724.0
2015-07-27 04:00:00	MSFT	Stock	46.3	46.3	46.3	46.3	100.0
2015-07-27 06:00:00	MSFT	Stock	46.1	46.11	46.02	46.02	400.0
2015-07-27 06:30:00	MSFT	Stock	46.15	46.15	46.13	46.13	1000.0
2015-07-27 07:00:00	MSFT	Stock	46.05	46.05	45.91	45.91	900.0
2015-07-27 07:30:00	MSFT	Stock	46.02	46.05	45.93	46.02	2250.0
2015-07-27 08:00:00	MSFT	Stock	46.05	46.05	45.93	46.0	5475.0
2015-07-27 08:30:00	MSFT	Stock	46.0	46.05	45.97	45.99	23539.0
2015-07-27 09:00:00	MSFT	Stock	46.01	46.01	45.8	45.94	33529.0
2015-07-27 09:30:00	MSFT	Stock	45.96	46.01	45.545	45.67	4060545.0
2015-07-27 10:00:00	MSFT	Stock	45.67	45.76	45.6	45.745	2476666.0
2015-07-27 10:30:00	MSFT	Stock	45.74	45.97	45.71	45.77	3250935.0
2015-07-27 11:00:00	MSFT	Stock	45.77	45.86	45.57	45.58	1866491.0
2015-07-27 11:30:00	MSFT	Stock	45.59	45.64	45.48	45.62	1792288.0
2015-07-27 12:00:00	MSFT	Stock	45.62	45.735	45.51	45.729	2203327.0
2015-07-27 12:30:00	MSFT	Stock	45.735	45.75	45.53	45.546	1793787.0
2015-07-27 13:00:00	MSFT	Stock	45.55	45.56	45.385	45.39	1362293.0
2015-07-27 13:30:00	MSFT	Stock	45.39	45.54	45.34	45.445	1592209.0
2015-07-27 14:00:00	MSFT	Stock	45.44	45.58	45.38	45.38	1392200.0

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

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