PREVIEW / stock_30min / 2015-10-09

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-10-09.parquet
  size:    1.5 MB
  rows:    80,173
  symbols: 3,405

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-10-09 04:00:00	AAPL	Stock	27.35	27.35	27.35	27.35	1532.0
2015-10-09 05:30:00	AAPL	Stock	27.395	27.4475	27.395	27.425	6000.0
2015-10-09 06:00:00	AAPL	Stock	27.4175	27.4175	27.4175	27.4175	400.0
2015-10-09 06:30:00	AAPL	Stock	27.4125	27.46	27.4125	27.46	5700.0
2015-10-09 07:00:00	AAPL	Stock	27.4475	27.485	27.425	27.4675	22240.0
2015-10-09 07:30:00	AAPL	Stock	27.4675	27.5175	27.465	27.47	72340.0
2015-10-09 08:00:00	AAPL	Stock	27.4675	27.5075	27.4375	27.49	321864.0
2015-10-09 08:30:00	AAPL	Stock	27.4925	27.5075	27.485	27.485	143508.0
2015-10-09 09:00:00	AAPL	Stock	27.4825	27.5425	27.45	27.525	714832.0
2015-10-09 09:30:00	AAPL	Stock	27.5	27.635	27.3725	27.5825	27929096.0
2015-10-09 10:00:00	AAPL	Stock	27.5848	27.8425	27.565	27.7975	22777104.0
2015-10-09 10:30:00	AAPL	Stock	27.7975	27.9862	27.795	27.9712	23823384.0
2015-10-09 11:00:00	AAPL	Stock	27.9662	27.995	27.8562	27.93	13346876.0
2015-10-09 11:30:00	AAPL	Stock	27.93	27.9325	27.8092	27.9175	10323340.0
2015-10-09 12:00:00	AAPL	Stock	27.9175	27.9225	27.8425	27.8925	7059604.0
2015-10-09 12:30:00	AAPL	Stock	27.8925	27.915	27.8075	27.8828	6643952.0
2015-10-09 13:00:00	AAPL	Stock	27.8825	28.005	27.85	27.9762	13423960.0
2015-10-09 13:30:00	AAPL	Stock	27.9752	27.99	27.87	27.8725	10819968.0
2015-10-09 14:00:00	AAPL	Stock	27.8725	27.985	27.8675	27.985	7195620.0
2015-10-09 14:30:00	AAPL	Stock	27.985	28.0175	27.9575	27.9875	10983872.0
2015-10-09 15:00:00	AAPL	Stock	27.985	28.0375	27.9225	28.011	10069256.0
2015-10-09 15:30:00	AAPL	Stock	28.0125	28.07	27.9952	28.03	20674276.0
2015-10-09 16:00:00	AAPL	Stock	28.03	28.065	27.8	28.01	7502264.0
2015-10-09 16:30:00	AAPL	Stock	28.01	28.0225	27.985	28.01	116044.0
2015-10-09 17:00:00	AAPL	Stock	28.0125	28.0125	28.0025	28.0075	27484.0
2015-10-09 17:30:00	AAPL	Stock	28.01	28.0125	28.0025	28.005	30456.0
2015-10-09 18:00:00	AAPL	Stock	28.0	28.02	28.0	28.015	33496.0
2015-10-09 18:30:00	AAPL	Stock	28.01	28.0125	27.9925	27.9925	29236.0
2015-10-09 19:00:00	AAPL	Stock	28.0	28.01	28.0	28.01	5700.0
2015-10-09 19:30:00	AAPL	Stock	28.01	28.0125	28.0	28.0	55176.0
2015-10-09 05:00:00	MSFT	Stock	47.49	47.49	47.49	47.49	100.0
2015-10-09 06:30:00	MSFT	Stock	47.49	47.49	47.49	47.49	700.0
2015-10-09 07:00:00	MSFT	Stock	47.37	47.5	47.37	47.5	1257.0
2015-10-09 07:30:00	MSFT	Stock	47.5	47.5	47.5	47.5	400.0
2015-10-09 08:00:00	MSFT	Stock	47.55	47.59	47.47	47.57	6000.0
2015-10-09 08:30:00	MSFT	Stock	47.56	47.59	47.5	47.5	2744.0
2015-10-09 09:00:00	MSFT	Stock	47.52	47.52	47.3	47.37	19048.0
2015-10-09 09:30:00	MSFT	Stock	47.45	47.54	47.021	47.03	3113987.0
2015-10-09 10:00:00	MSFT	Stock	47.03	47.3	47.025	47.25	1476571.0
2015-10-09 10:30:00	MSFT	Stock	47.25	47.455	47.23	47.34	1464164.0
2015-10-09 11:00:00	MSFT	Stock	47.34	47.34	47.03	47.055	1679167.0
2015-10-09 11:30:00	MSFT	Stock	47.05	47.1	46.97	47.1	1251608.0
2015-10-09 12:00:00	MSFT	Stock	47.092	47.195	47.01	47.09	914733.0
2015-10-09 12:30:00	MSFT	Stock	47.09	47.17	46.99	47.14	858476.0
2015-10-09 13:00:00	MSFT	Stock	47.14	47.18	46.95	46.962	828408.0
2015-10-09 13:30:00	MSFT	Stock	46.96	47.08	46.92	47.06	833516.0
2015-10-09 14:00:00	MSFT	Stock	47.07	47.18	47.05	47.16	884299.0
2015-10-09 14:30:00	MSFT	Stock	47.15	47.29	47.08	47.29	1253046.0
2015-10-09 15:00:00	MSFT	Stock	47.295	47.39	47.16	47.16	2476853.0
2015-10-09 15:30:00	MSFT	Stock	47.17	47.25	47.1	47.11	5013046.0

> showing 50 of 80,173 rows — these rows as CSV

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