PREVIEW / stock_30min / 2016-09-16

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-09-16.parquet
  size:    1.6 MB
  rows:    82,542
  symbols: 3,231

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
2016-09-16 04:00:00	AAPL	Stock	28.8325	28.8375	28.7575	28.765	9512.0
2016-09-16 04:30:00	AAPL	Stock	28.765	28.8125	28.765	28.8125	7380.0
2016-09-16 05:00:00	AAPL	Stock	28.7675	28.8025	28.7675	28.795	27620.0
2016-09-16 05:30:00	AAPL	Stock	28.7975	28.8	28.7925	28.8	24236.0
2016-09-16 06:00:00	AAPL	Stock	28.8125	28.945	28.8025	28.8475	110308.0
2016-09-16 06:30:00	AAPL	Stock	28.875	28.875	28.84	28.8425	17188.0
2016-09-16 07:00:00	AAPL	Stock	28.8925	28.99	28.825	28.8675	205536.0
2016-09-16 07:30:00	AAPL	Stock	28.8625	28.8875	28.6875	28.7375	292592.0
2016-09-16 08:00:00	AAPL	Stock	28.8875	28.9875	28.6875	28.775	846220.0
2016-09-16 08:30:00	AAPL	Stock	28.7675	28.8	28.73	28.7625	461096.0
2016-09-16 09:00:00	AAPL	Stock	28.77	28.9	28.7075	28.7925	1637536.0
2016-09-16 09:30:00	AAPL	Stock	28.7925	29.0325	28.7	28.7562	85294176.0
2016-09-16 10:00:00	AAPL	Stock	28.755	28.8275	28.6925	28.7325	22540616.0
2016-09-16 10:30:00	AAPL	Stock	28.7325	28.8475	28.7	28.745	16990744.0
2016-09-16 11:00:00	AAPL	Stock	28.75	28.77	28.7	28.7428	10508292.0
2016-09-16 11:30:00	AAPL	Stock	28.7425	28.7775	28.6662	28.7025	11717124.0
2016-09-16 12:00:00	AAPL	Stock	28.7025	28.7325	28.64	28.656	8034564.0
2016-09-16 12:30:00	AAPL	Stock	28.6575	28.6775	28.5125	28.5765	15005788.0
2016-09-16 13:00:00	AAPL	Stock	28.5755	28.6575	28.5575	28.565	8880632.0
2016-09-16 13:30:00	AAPL	Stock	28.565	28.5988	28.51	28.585	10286092.0
2016-09-16 14:00:00	AAPL	Stock	28.5825	28.705	28.5525	28.696	9898416.0
2016-09-16 14:30:00	AAPL	Stock	28.6975	28.7612	28.6875	28.69	11859160.0
2016-09-16 15:00:00	AAPL	Stock	28.688	28.7625	28.6875	28.7288	9628124.0
2016-09-16 15:30:00	AAPL	Stock	28.73	28.78	28.7212	28.7275	19961172.0
2016-09-16 16:00:00	AAPL	Stock	28.7275	28.768	28.579	28.755	52394000.0
2016-09-16 16:30:00	AAPL	Stock	28.7525	28.7575	28.73	28.755	234708.0
2016-09-16 17:00:00	AAPL	Stock	28.755	28.755	28.745	28.75	84308.0
2016-09-16 17:30:00	AAPL	Stock	28.7475	28.75	28.725	28.73	77392.0
2016-09-16 18:00:00	AAPL	Stock	28.73	28.7375	28.725	28.725	41212.0
2016-09-16 18:30:00	AAPL	Stock	28.725	28.735	28.72	28.735	211340.0
2016-09-16 19:00:00	AAPL	Stock	28.73	28.7375	28.7275	28.7275	29104.0
2016-09-16 19:30:00	AAPL	Stock	28.73	28.7375	28.7275	28.735	75900.0
2016-09-16 06:00:00	MSFT	Stock	57.19	57.19	57.19	57.19	100.0
2016-09-16 07:30:00	MSFT	Stock	56.78	56.78	56.78	56.78	100.0
2016-09-16 08:00:00	MSFT	Stock	57.02	57.02	57.02	57.02	1000.0
2016-09-16 08:30:00	MSFT	Stock	57.03	57.03	57.02	57.02	1860.0
2016-09-16 09:00:00	MSFT	Stock	57.09	57.8	57.09	57.47	133898.0
2016-09-16 09:30:00	MSFT	Stock	57.44	57.63	56.75	57.29	16717051.0
2016-09-16 10:00:00	MSFT	Stock	57.29	57.32	57.035	57.11	2074942.0
2016-09-16 10:30:00	MSFT	Stock	57.1	57.33	57.035	57.195	1625977.0
2016-09-16 11:00:00	MSFT	Stock	57.19	57.22	57.04	57.08	1327064.0
2016-09-16 11:30:00	MSFT	Stock	57.072	57.17	57.04	57.12	756824.0
2016-09-16 12:00:00	MSFT	Stock	57.12	57.23	57.07	57.155	764976.0
2016-09-16 12:30:00	MSFT	Stock	57.16	57.18	57.05	57.05	569076.0
2016-09-16 13:00:00	MSFT	Stock	57.05	57.136	57.05	57.08	733491.0
2016-09-16 13:30:00	MSFT	Stock	57.08	57.12	57.01	57.095	971259.0
2016-09-16 14:00:00	MSFT	Stock	57.09	57.155	57.04	57.075	643133.0
2016-09-16 14:30:00	MSFT	Stock	57.07	57.185	57.05	57.055	856490.0
2016-09-16 15:00:00	MSFT	Stock	57.06	57.12	57.045	57.095	1282486.0
2016-09-16 15:30:00	MSFT	Stock	57.1	57.31	57.099	57.24	3723340.0

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

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