PREVIEW / stock_30min / 2016-09-19

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-09-19.parquet
  size:    1.6 MB
  rows:    81,237
  symbols: 3,223

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-19 04:00:00	AAPL	Stock	28.7625	28.8625	28.7625	28.8575	11840.0
2016-09-19 05:00:00	AAPL	Stock	28.8325	28.8425	28.8325	28.8375	54300.0
2016-09-19 05:30:00	AAPL	Stock	28.8375	28.8375	28.8375	28.8375	11184.0
2016-09-19 06:00:00	AAPL	Stock	28.825	28.8575	28.8125	28.8125	73576.0
2016-09-19 06:30:00	AAPL	Stock	28.8125	28.8125	28.7875	28.7925	56424.0
2016-09-19 07:00:00	AAPL	Stock	28.8125	28.85	28.61	28.6675	219348.0
2016-09-19 07:30:00	AAPL	Stock	28.65	28.7375	28.65	28.705	106192.0
2016-09-19 08:00:00	AAPL	Stock	28.72	28.8575	28.625	28.8375	777872.0
2016-09-19 08:30:00	AAPL	Stock	28.8375	28.9025	28.82	28.86	779820.0
2016-09-19 09:00:00	AAPL	Stock	28.86	28.8625	28.7775	28.8125	1419128.0
2016-09-19 09:30:00	AAPL	Stock	28.8125	29.045	28.76	28.7825	34108472.0
2016-09-19 10:00:00	AAPL	Stock	28.78	28.807	28.6188	28.65	19395552.0
2016-09-19 10:30:00	AAPL	Stock	28.6525	28.6725	28.4625	28.5028	16744904.0
2016-09-19 11:00:00	AAPL	Stock	28.5025	28.5975	28.48	28.56	11002248.0
2016-09-19 11:30:00	AAPL	Stock	28.5578	28.6075	28.55	28.58	6124804.0
2016-09-19 12:00:00	AAPL	Stock	28.58	28.5925	28.325	28.4075	15878544.0
2016-09-19 12:30:00	AAPL	Stock	28.405	28.46	28.36	28.37	9111784.0
2016-09-19 13:00:00	AAPL	Stock	28.3685	28.4625	28.345	28.3802	5662248.0
2016-09-19 13:30:00	AAPL	Stock	28.38	28.4025	28.3125	28.3962	8611268.0
2016-09-19 14:00:00	AAPL	Stock	28.395	28.4922	28.3925	28.4738	7163152.0
2016-09-19 14:30:00	AAPL	Stock	28.4735	28.5325	28.4525	28.5045	7088976.0
2016-09-19 15:00:00	AAPL	Stock	28.505	28.5075	28.4112	28.4575	6844536.0
2016-09-19 15:30:00	AAPL	Stock	28.4575	28.4675	28.345	28.3825	17007464.0
2016-09-19 16:00:00	AAPL	Stock	28.395	28.6625	28.3425	28.3925	8636880.0
2016-09-19 16:30:00	AAPL	Stock	28.3925	28.3925	28.3825	28.39	43720.0
2016-09-19 17:00:00	AAPL	Stock	28.3925	28.3925	28.385	28.385	15792.0
2016-09-19 17:30:00	AAPL	Stock	28.3925	28.3925	28.385	28.385	24200.0
2016-09-19 18:00:00	AAPL	Stock	28.39	28.3925	28.385	28.3875	12480.0
2016-09-19 18:30:00	AAPL	Stock	28.39	28.39	28.3775	28.3775	32348.0
2016-09-19 19:00:00	AAPL	Stock	28.3775	28.3875	28.36	28.3675	139648.0
2016-09-19 19:30:00	AAPL	Stock	28.375	28.38	28.35	28.35	49612.0
2016-09-19 08:30:00	MSFT	Stock	57.47	57.47	57.44	57.47	1235.0
2016-09-19 09:00:00	MSFT	Stock	57.39	57.39	57.27	57.27	14606.0
2016-09-19 09:30:00	MSFT	Stock	57.27	57.75	57.26	57.745	2386927.0
2016-09-19 10:00:00	MSFT	Stock	57.75	57.75	57.51	57.51	1169624.0
2016-09-19 10:30:00	MSFT	Stock	57.515	57.6	57.44	57.465	910735.0
2016-09-19 11:00:00	MSFT	Stock	57.47	57.57	57.37	57.375	1125417.0
2016-09-19 11:30:00	MSFT	Stock	57.38	57.457	57.33	57.37	1224766.0
2016-09-19 12:00:00	MSFT	Stock	57.36	57.38	57.02	57.13	1644056.0
2016-09-19 12:30:00	MSFT	Stock	57.13	57.17	57.05	57.059	596413.0
2016-09-19 13:00:00	MSFT	Stock	57.05	57.176	57.01	57.04	809410.0
2016-09-19 13:30:00	MSFT	Stock	57.04	57.04	56.85	56.99	968959.0
2016-09-19 14:00:00	MSFT	Stock	56.98	57.115	56.97	57.06	787208.0
2016-09-19 14:30:00	MSFT	Stock	57.06	57.25	57.045	57.22	819412.0
2016-09-19 15:00:00	MSFT	Stock	57.223	57.24	57.02	57.02	1230642.0
2016-09-19 15:30:00	MSFT	Stock	57.02	57.08	56.91	56.93	2668764.0
2016-09-19 16:00:00	MSFT	Stock	56.93	57.216	56.93	57.216	2665223.0
2016-09-19 16:30:00	MSFT	Stock	56.95	57.1	56.93	57.1	36976.0
2016-09-19 17:00:00	MSFT	Stock	56.96	57.08	56.96	57.08	800.0
2016-09-19 18:00:00	MSFT	Stock	56.98	57.07	56.98	57.07	3145.0

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

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