PREVIEW / stock_30min / 2014-12-18

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-12-18.parquet
  size:    1.7 MB
  rows:    88,161
  symbols: 3,577

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-18 04:00:00	AAPL	Stock	27.265	27.735	27.265	27.715	22928.0
2014-12-18 04:30:00	AAPL	Stock	27.725	27.75	27.725	27.75	14600.0
2014-12-18 05:00:00	AAPL	Stock	27.75	27.8275	27.75	27.825	35120.0
2014-12-18 05:30:00	AAPL	Stock	27.825	27.9375	27.825	27.925	96120.0
2014-12-18 06:00:00	AAPL	Stock	27.91	27.91	27.8275	27.8425	29452.0
2014-12-18 06:30:00	AAPL	Stock	27.8275	27.8275	27.7075	27.75	62384.0
2014-12-18 07:00:00	AAPL	Stock	27.75	27.775	27.7	27.775	167748.0
2014-12-18 07:30:00	AAPL	Stock	27.785	27.85	27.775	27.8125	290272.0
2014-12-18 08:00:00	AAPL	Stock	27.815	27.8825	27.7	27.8225	1103576.0
2014-12-18 08:30:00	AAPL	Stock	27.8225	27.8375	27.805	27.825	468560.0
2014-12-18 09:00:00	AAPL	Stock	27.83	27.9875	27.8025	27.955	1688824.0
2014-12-18 09:30:00	AAPL	Stock	27.955	27.975	27.68	27.7975	38815636.0
2014-12-18 10:00:00	AAPL	Stock	27.8	27.9125	27.7825	27.8352	19555864.0
2014-12-18 10:30:00	AAPL	Stock	27.8325	27.845	27.715	27.78	12823576.0
2014-12-18 11:00:00	AAPL	Stock	27.78	27.8125	27.665	27.7725	12599396.0
2014-12-18 11:30:00	AAPL	Stock	27.7875	27.8325	27.73	27.8125	8460048.0
2014-12-18 12:00:00	AAPL	Stock	27.81	27.8425	27.77	27.815	7880328.0
2014-12-18 12:30:00	AAPL	Stock	27.815	27.92	27.8025	27.9125	8632844.0
2014-12-18 13:00:00	AAPL	Stock	27.913	27.9975	27.8825	27.985	9762436.0
2014-12-18 13:30:00	AAPL	Stock	27.985	28.07	27.965	28.0338	12828308.0
2014-12-18 14:00:00	AAPL	Stock	28.0325	28.0375	27.9175	27.935	10474560.0
2014-12-18 14:30:00	AAPL	Stock	27.9372	27.995	27.8775	27.9588	9656724.0
2014-12-18 15:00:00	AAPL	Stock	27.96	28.0298	27.925	28.0238	11502076.0
2014-12-18 15:30:00	AAPL	Stock	28.0225	28.1625	28.01	28.1625	29638692.0
2014-12-18 16:00:00	AAPL	Stock	28.1625	28.1625	27.7878	28.1375	18020344.0
2014-12-18 16:30:00	AAPL	Stock	28.135	28.168	27.9972	28.1275	473868.0
2014-12-18 17:00:00	AAPL	Stock	28.14	28.1625	27.88	28.16	90440.0
2014-12-18 17:30:00	AAPL	Stock	28.155	28.1625	28.155	28.1575	409540.0
2014-12-18 18:00:00	AAPL	Stock	28.155	28.17	28.1375	28.17	209640.0
2014-12-18 18:30:00	AAPL	Stock	28.1675	28.1775	28.1625	28.17	36328.0
2014-12-18 19:00:00	AAPL	Stock	28.1775	28.195	28.165	28.1875	80428.0
2014-12-18 19:30:00	AAPL	Stock	28.1875	28.2175	28.18	28.1975	121372.0
2014-12-18 05:30:00	MSFT	Stock	46.29	46.32	46.29	46.32	200.0
2014-12-18 06:30:00	MSFT	Stock	46.35	46.35	46.35	46.35	950.0
2014-12-18 07:00:00	MSFT	Stock	46.2	46.24	46.18	46.24	3300.0
2014-12-18 07:30:00	MSFT	Stock	46.24	46.27	46.24	46.27	1750.0
2014-12-18 08:00:00	MSFT	Stock	46.17	46.27	46.17	46.2	2450.0
2014-12-18 08:30:00	MSFT	Stock	46.21	46.4	46.21	46.3	7209.0
2014-12-18 09:00:00	MSFT	Stock	46.3	46.56	46.3	46.55	37974.0
2014-12-18 09:30:00	MSFT	Stock	46.58	46.73	46.339	46.695	4238931.0
2014-12-18 10:00:00	MSFT	Stock	46.69	47.04	46.65	46.89	3463556.0
2014-12-18 10:30:00	MSFT	Stock	46.895	47.19	46.83	47.095	2211298.0
2014-12-18 11:00:00	MSFT	Stock	47.09	47.09	46.79	46.914	1978441.0
2014-12-18 11:30:00	MSFT	Stock	46.91	47.09	46.86	47.08	1596438.0
2014-12-18 12:00:00	MSFT	Stock	47.08	47.08	46.97	47.045	1450346.0
2014-12-18 12:30:00	MSFT	Stock	47.05	47.2	47.01	47.18	1373590.0
2014-12-18 13:00:00	MSFT	Stock	47.185	47.28	46.85	47.217	1876551.0
2014-12-18 13:30:00	MSFT	Stock	47.21	47.3	47.18	47.27	1308407.0
2014-12-18 14:00:00	MSFT	Stock	47.26	47.35	47.17	47.32	1376667.0
2014-12-18 14:30:00	MSFT	Stock	47.315	47.37	47.16	47.23	1773682.0

> showing 50 of 88,161 rows — these rows as CSV

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