PREVIEW / stock_30min / 2016-02-08

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-02-08.parquet
  size:    1.6 MB
  rows:    83,607
  symbols: 3,367

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-02-08 04:00:00	AAPL	Stock	23.4525	23.4525	23.275	23.275	7864.0
2016-02-08 04:30:00	AAPL	Stock	23.2525	23.255	23.1625	23.1625	15356.0
2016-02-08 05:00:00	AAPL	Stock	23.0825	23.1575	23.0825	23.105	40364.0
2016-02-08 05:30:00	AAPL	Stock	23.1575	23.1575	23.105	23.105	4464.0
2016-02-08 06:00:00	AAPL	Stock	23.08	23.0975	23.0325	23.0775	24624.0
2016-02-08 06:30:00	AAPL	Stock	23.1	23.1375	23.0775	23.0975	26564.0
2016-02-08 07:00:00	AAPL	Stock	23.08	23.1	23.0125	23.08	185684.0
2016-02-08 07:30:00	AAPL	Stock	23.0975	23.1	23.03	23.07	90152.0
2016-02-08 08:00:00	AAPL	Stock	23.0775	23.1725	23.0325	23.155	436004.0
2016-02-08 08:30:00	AAPL	Stock	23.155	23.2375	23.125	23.2225	202472.0
2016-02-08 09:00:00	AAPL	Stock	23.2225	23.3	23.15	23.2875	779148.0
2016-02-08 09:30:00	AAPL	Stock	23.2875	23.67	23.26	23.645	30485112.0
2016-02-08 10:00:00	AAPL	Stock	23.64	23.6875	23.3625	23.4025	18566900.0
2016-02-08 10:30:00	AAPL	Stock	23.4012	23.6	23.3925	23.495	14241664.0
2016-02-08 11:00:00	AAPL	Stock	23.4975	23.5725	23.37	23.5475	13276104.0
2016-02-08 11:30:00	AAPL	Stock	23.5475	23.621	23.4625	23.621	9905828.0
2016-02-08 12:00:00	AAPL	Stock	23.62	23.6975	23.55	23.63	10106980.0
2016-02-08 12:30:00	AAPL	Stock	23.6288	23.655	23.52	23.56	8189728.0
2016-02-08 13:00:00	AAPL	Stock	23.5588	23.5625	23.4625	23.5225	7031368.0
2016-02-08 13:30:00	AAPL	Stock	23.5225	23.572	23.4325	23.45	9420068.0
2016-02-08 14:00:00	AAPL	Stock	23.4475	23.4975	23.3425	23.3912	12160788.0
2016-02-08 14:30:00	AAPL	Stock	23.3903	23.465	23.35	23.4025	10453812.0
2016-02-08 15:00:00	AAPL	Stock	23.4025	23.665	23.3925	23.6312	14573424.0
2016-02-08 15:30:00	AAPL	Stock	23.63	23.925	23.6275	23.7525	28795460.0
2016-02-08 16:00:00	AAPL	Stock	23.7525	23.835	23.463	23.825	11331200.0
2016-02-08 16:30:00	AAPL	Stock	23.83	23.83	23.5778	23.7925	34536.0
2016-02-08 17:00:00	AAPL	Stock	23.795	23.795	23.75	23.775	79752.0
2016-02-08 17:30:00	AAPL	Stock	23.7625	23.77	23.68	23.7375	287408.0
2016-02-08 18:00:00	AAPL	Stock	23.69	23.73	23.675	23.6775	20004.0
2016-02-08 18:30:00	AAPL	Stock	23.695	23.71	23.6675	23.68	42120.0
2016-02-08 19:00:00	AAPL	Stock	23.68	23.695	23.6675	23.6675	15180.0
2016-02-08 19:30:00	AAPL	Stock	23.695	23.7	23.6625	23.6625	24832.0
2016-02-08 04:00:00	MSFT	Stock	50.11	50.11	49.8	49.8	3775.0
2016-02-08 04:30:00	MSFT	Stock	49.8	49.8	49.5	49.5	483.0
2016-02-08 05:00:00	MSFT	Stock	49.56	49.56	49.56	49.56	800.0
2016-02-08 05:30:00	MSFT	Stock	49.5	49.5	49.5	49.5	200.0
2016-02-08 06:00:00	MSFT	Stock	49.25	49.4	49.25	49.34	2608.0
2016-02-08 06:30:00	MSFT	Stock	49.4	49.51	49.4	49.41	3700.0
2016-02-08 07:00:00	MSFT	Stock	49.4	49.4	49.1	49.1	26923.0
2016-02-08 07:30:00	MSFT	Stock	49.15	49.25	49.09	49.25	48498.0
2016-02-08 08:00:00	MSFT	Stock	49.25	49.41	49.1	49.26	14953.0
2016-02-08 08:30:00	MSFT	Stock	49.3	49.44	49.29	49.44	42718.0
2016-02-08 09:00:00	MSFT	Stock	49.44	50.16	49.27	49.55	23927.0
2016-02-08 09:30:00	MSFT	Stock	49.55	49.57	48.19	48.63	9360580.0
2016-02-08 10:00:00	MSFT	Stock	48.625	48.9	48.45	48.64	5836809.0
2016-02-08 10:30:00	MSFT	Stock	48.63	49.19	48.62	48.8	4702679.0
2016-02-08 11:00:00	MSFT	Stock	48.81	48.91	48.5	48.845	2331381.0
2016-02-08 11:30:00	MSFT	Stock	48.84	49.0	48.71	48.99	2170381.0
2016-02-08 12:00:00	MSFT	Stock	48.99	49.15	48.82	49.03	2717004.0
2016-02-08 12:30:00	MSFT	Stock	49.03	49.26	49.02	49.12	2719711.0

> showing 50 of 83,607 rows — these rows as CSV

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