PREVIEW / stock_30min / 2016-02-09

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-02-09.parquet
  size:    1.6 MB
  rows:    82,987
  symbols: 3,347

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-09 04:00:00	AAPL	Stock	23.6875	23.75	23.6875	23.75	16108.0
2016-02-09 05:00:00	AAPL	Stock	23.6875	23.69	23.6875	23.69	800.0
2016-02-09 05:30:00	AAPL	Stock	23.75	23.75	23.69	23.69	4400.0
2016-02-09 06:00:00	AAPL	Stock	23.69	23.69	23.65	23.65	6200.0
2016-02-09 07:00:00	AAPL	Stock	23.6	23.6	23.575	23.58	23172.0
2016-02-09 07:30:00	AAPL	Stock	23.5925	23.6125	23.5275	23.56	40640.0
2016-02-09 08:00:00	AAPL	Stock	23.58	23.6	23.525	23.55	335300.0
2016-02-09 08:30:00	AAPL	Stock	23.555	23.6125	23.5375	23.5875	327980.0
2016-02-09 09:00:00	AAPL	Stock	23.5875	23.6	23.5375	23.5725	238800.0
2016-02-09 09:30:00	AAPL	Stock	23.5725	23.845	23.5175	23.695	23377856.0
2016-02-09 10:00:00	AAPL	Stock	23.695	23.82	23.5875	23.63	16649616.0
2016-02-09 10:30:00	AAPL	Stock	23.63	23.635	23.4825	23.5575	12839196.0
2016-02-09 11:00:00	AAPL	Stock	23.56	23.7575	23.555	23.7375	10583444.0
2016-02-09 11:30:00	AAPL	Stock	23.7375	23.7675	23.6325	23.6748	8925100.0
2016-02-09 12:00:00	AAPL	Stock	23.6725	23.76	23.62	23.665	7284452.0
2016-02-09 12:30:00	AAPL	Stock	23.665	23.7125	23.61	23.665	6071208.0
2016-02-09 13:00:00	AAPL	Stock	23.6622	23.6725	23.5625	23.6	7701912.0
2016-02-09 13:30:00	AAPL	Stock	23.6	23.7125	23.57	23.6875	7657264.0
2016-02-09 14:00:00	AAPL	Stock	23.6875	23.8375	23.6752	23.7623	10827876.0
2016-02-09 14:30:00	AAPL	Stock	23.7625	23.94	23.755	23.9125	13924376.0
2016-02-09 15:00:00	AAPL	Stock	23.9125	23.985	23.7325	23.765	14432732.0
2016-02-09 15:30:00	AAPL	Stock	23.765	23.8738	23.7125	23.755	14926432.0
2016-02-09 16:00:00	AAPL	Stock	23.7475	23.7625	23.695	23.7475	6976224.0
2016-02-09 16:30:00	AAPL	Stock	23.725	23.725	23.6875	23.7	43172.0
2016-02-09 17:00:00	AAPL	Stock	23.7475	23.7475	23.6975	23.6975	29448.0
2016-02-09 17:30:00	AAPL	Stock	23.7	23.725	23.7	23.71	35544.0
2016-02-09 18:00:00	AAPL	Stock	23.735	23.76	23.735	23.76	11520.0
2016-02-09 18:30:00	AAPL	Stock	23.76	23.805	23.76	23.805	25340.0
2016-02-09 19:00:00	AAPL	Stock	23.7925	23.805	23.7675	23.7675	29476.0
2016-02-09 19:30:00	AAPL	Stock	23.7725	23.775	23.7575	23.775	39972.0
2016-02-09 07:00:00	MSFT	Stock	49.05	49.05	49.03	49.05	9303.0
2016-02-09 07:30:00	MSFT	Stock	49.16	49.16	49.03	49.14	14016.0
2016-02-09 08:00:00	MSFT	Stock	49.07	49.2	49.07	49.11	7252.0
2016-02-09 08:30:00	MSFT	Stock	49.02	49.05	48.76	48.8	18923.0
2016-02-09 09:00:00	MSFT	Stock	48.74	49.02	48.74	49.01	45495.0
2016-02-09 09:30:00	MSFT	Stock	49.01	49.7	48.86	49.56	4975782.0
2016-02-09 10:00:00	MSFT	Stock	49.56	50.24	49.53	49.975	4740731.0
2016-02-09 10:30:00	MSFT	Stock	49.975	49.975	49.5	49.57	2109167.0
2016-02-09 11:00:00	MSFT	Stock	49.56	50.04	49.52	49.98	2215344.0
2016-02-09 11:30:00	MSFT	Stock	49.97	50.07	49.581	49.625	2030400.0
2016-02-09 12:00:00	MSFT	Stock	49.625	49.79	49.07	49.19	3240135.0
2016-02-09 12:30:00	MSFT	Stock	49.19	49.28	48.94	49.015	2327014.0
2016-02-09 13:00:00	MSFT	Stock	49.01	49.06	48.67	48.79	2777549.0
2016-02-09 13:30:00	MSFT	Stock	48.79	49.08	48.76	48.995	2260479.0
2016-02-09 14:00:00	MSFT	Stock	49.0	49.29	48.885	48.945	3815225.0
2016-02-09 14:30:00	MSFT	Stock	48.955	49.68	48.93	49.51	2954619.0
2016-02-09 15:00:00	MSFT	Stock	49.51	49.97	49.37	49.46	2956842.0
2016-02-09 15:30:00	MSFT	Stock	49.45	49.69	49.19	49.28	4188164.0
2016-02-09 16:00:00	MSFT	Stock	49.28	49.36	49.26	49.28	1952921.0
2016-02-09 16:30:00	MSFT	Stock	49.27	49.28	49.16	49.25	266554.0

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

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