PREVIEW / stock_30min / 2014-12-31

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-12-31.parquet
  size:    1.6 MB
  rows:    83,321
  symbols: 3,560

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
2014-12-31 04:00:00	AAPL	Stock	28.2225	28.2225	28.2225	28.2225	2800.0
2014-12-31 04:30:00	AAPL	Stock	28.2225	28.2225	28.2225	28.2225	1200.0
2014-12-31 07:00:00	AAPL	Stock	28.2125	28.2125	28.1875	28.2	7200.0
2014-12-31 07:30:00	AAPL	Stock	28.2	28.2125	28.1975	28.2125	23484.0
2014-12-31 08:00:00	AAPL	Stock	28.2125	28.2425	28.1825	28.215	155724.0
2014-12-31 08:30:00	AAPL	Stock	28.2275	28.28	28.2275	28.2675	151228.0
2014-12-31 09:00:00	AAPL	Stock	28.2625	28.265	28.1675	28.2125	329384.0
2014-12-31 09:30:00	AAPL	Stock	28.205	28.2825	28.1325	28.1925	12187152.0
2014-12-31 10:00:00	AAPL	Stock	28.1925	28.2025	28.0875	28.1275	6703536.0
2014-12-31 10:30:00	AAPL	Stock	28.1275	28.175	28.095	28.1748	6054980.0
2014-12-31 11:00:00	AAPL	Stock	28.1725	28.1798	28.0275	28.03	8103760.0
2014-12-31 11:30:00	AAPL	Stock	28.0322	28.0475	27.9225	27.9775	12387576.0
2014-12-31 12:00:00	AAPL	Stock	27.9775	27.9825	27.7925	27.835	14685956.0
2014-12-31 12:30:00	AAPL	Stock	27.835	27.9125	27.8125	27.8215	8792404.0
2014-12-31 13:00:00	AAPL	Stock	27.82	27.895	27.8125	27.8575	6053616.0
2014-12-31 13:30:00	AAPL	Stock	27.8562	27.88	27.8	27.825	6575832.0
2014-12-31 14:00:00	AAPL	Stock	27.8225	27.8255	27.7	27.7625	11936356.0
2014-12-31 14:30:00	AAPL	Stock	27.7625	27.8	27.64	27.6675	10528788.0
2014-12-31 15:00:00	AAPL	Stock	27.67	27.745	27.6025	27.7125	12017256.0
2014-12-31 15:30:00	AAPL	Stock	27.7125	27.7325	27.5525	27.5975	25634276.0
2014-12-31 16:00:00	AAPL	Stock	27.605	27.863	27.594	27.63	14303428.0
2014-12-31 16:30:00	AAPL	Stock	27.645	27.9192	27.0695	27.6575	95100.0
2014-12-31 17:00:00	AAPL	Stock	27.66	27.6975	27.645	27.645	74072.0
2014-12-31 17:30:00	AAPL	Stock	27.65	27.6925	27.595	27.675	182116.0
2014-12-31 18:00:00	AAPL	Stock	27.685	27.695	27.6625	27.6775	63976.0
2014-12-31 18:30:00	AAPL	Stock	27.685	27.69	27.6625	27.6875	36328.0
2014-12-31 19:00:00	AAPL	Stock	27.6875	27.69	27.675	27.69	30176.0
2014-12-31 19:30:00	AAPL	Stock	27.69	27.7	27.67	27.675	53488.0
2014-12-31 08:00:00	MSFT	Stock	47.05	47.2	47.05	47.2	1100.0
2014-12-31 08:30:00	MSFT	Stock	47.01	47.2	47.0	47.2	1700.0
2014-12-31 09:00:00	MSFT	Stock	47.2	47.2	46.75	46.75	180412.0
2014-12-31 09:30:00	MSFT	Stock	46.73	47.15	46.71	47.07	2263445.0
2014-12-31 10:00:00	MSFT	Stock	47.075	47.17	46.98	47.17	996923.0
2014-12-31 10:30:00	MSFT	Stock	47.17	47.44	47.15	47.38	1015443.0
2014-12-31 11:00:00	MSFT	Stock	47.385	47.4	47.2	47.215	534085.0
2014-12-31 11:30:00	MSFT	Stock	47.215	47.29	47.19	47.23	654182.0
2014-12-31 12:00:00	MSFT	Stock	47.24	47.27	46.89	46.94	996222.0
2014-12-31 12:30:00	MSFT	Stock	46.934	46.97	46.83	46.9	684530.0
2014-12-31 13:00:00	MSFT	Stock	46.905	47.02	46.875	46.95	571250.0
2014-12-31 13:30:00	MSFT	Stock	46.96	47.0	46.91	46.97	540667.0
2014-12-31 14:00:00	MSFT	Stock	46.97	46.98	46.68	46.724	840183.0
2014-12-31 14:30:00	MSFT	Stock	46.74	46.81	46.7	46.74	1316219.0
2014-12-31 15:00:00	MSFT	Stock	46.74	46.74	46.61	46.685	886512.0
2014-12-31 15:30:00	MSFT	Stock	46.69	46.71	46.46	46.46	5141602.0
2014-12-31 16:00:00	MSFT	Stock	46.45	47.111	46.41	46.45	3778261.0
2014-12-31 16:30:00	MSFT	Stock	46.45	46.787	46.45	46.45	18667.0
2014-12-31 17:00:00	MSFT	Stock	46.48	46.48	46.48	46.48	800.0
2014-12-31 18:00:00	MSFT	Stock	46.48	46.48	46.48	46.48	100.0
2014-12-31 18:30:00	MSFT	Stock	46.5	46.54	46.47	46.47	764.0
2014-12-31 19:30:00	MSFT	Stock	46.57	46.57	46.57	46.57	300.0

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

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