PREVIEW / stock_30min / 2015-07-28

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-07-28.parquet
  size:    1.6 MB
  rows:    82,853
  symbols: 3,488

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-07-28 04:00:00	AAPL	Stock	30.8675	30.975	30.8675	30.975	7600.0
2015-07-28 04:30:00	AAPL	Stock	30.9425	30.9425	30.9375	30.9425	2400.0
2015-07-28 05:00:00	AAPL	Stock	30.9425	31.005	30.9425	31.0	7568.0
2015-07-28 05:30:00	AAPL	Stock	31.0175	31.05	31.0175	31.045	11640.0
2015-07-28 06:00:00	AAPL	Stock	31.02	31.075	31.02	31.05	33444.0
2015-07-28 06:30:00	AAPL	Stock	31.0425	31.0425	30.93	30.9525	39532.0
2015-07-28 07:00:00	AAPL	Stock	30.94	30.94	30.88	30.9375	65068.0
2015-07-28 07:30:00	AAPL	Stock	30.9375	30.95	30.8925	30.9025	65856.0
2015-07-28 08:00:00	AAPL	Stock	30.9	31.07	30.875	30.9025	298256.0
2015-07-28 08:30:00	AAPL	Stock	30.9025	30.9425	30.8925	30.9175	195636.0
2015-07-28 09:00:00	AAPL	Stock	30.9175	30.9325	30.8125	30.8125	294440.0
2015-07-28 09:30:00	AAPL	Stock	30.83	30.915	30.7288	30.819	19144540.0
2015-07-28 10:00:00	AAPL	Stock	30.82	30.8325	30.6375	30.6775	13089016.0
2015-07-28 10:30:00	AAPL	Stock	30.68	30.8225	30.6625	30.8075	9754668.0
2015-07-28 11:00:00	AAPL	Stock	30.805	30.885	30.8018	30.83	7689348.0
2015-07-28 11:30:00	AAPL	Stock	30.8325	30.8575	30.785	30.815	5995624.0
2015-07-28 12:00:00	AAPL	Stock	30.815	30.9045	30.79	30.87	6101408.0
2015-07-28 12:30:00	AAPL	Stock	30.87	30.875	30.7885	30.8025	4755536.0
2015-07-28 13:00:00	AAPL	Stock	30.805	30.8888	30.795	30.85	4713300.0
2015-07-28 13:30:00	AAPL	Stock	30.85	30.9025	30.8265	30.8838	4614784.0
2015-07-28 14:00:00	AAPL	Stock	30.8832	30.97	30.865	30.959	7732432.0
2015-07-28 14:30:00	AAPL	Stock	30.9575	30.9775	30.92	30.97	5987888.0
2015-07-28 15:00:00	AAPL	Stock	30.9675	30.9725	30.8128	30.8185	9107352.0
2015-07-28 15:30:00	AAPL	Stock	30.8175	30.8625	30.7925	30.8475	15594372.0
2015-07-28 16:00:00	AAPL	Stock	30.845	30.8675	30.8145	30.8625	10955652.0
2015-07-28 16:30:00	AAPL	Stock	30.855	30.8625	30.835	30.8375	67660.0
2015-07-28 17:00:00	AAPL	Stock	30.8375	30.8592	30.8375	30.8382	33260.0
2015-07-28 17:30:00	AAPL	Stock	30.8375	30.8575	30.8375	30.845	30952.0
2015-07-28 18:00:00	AAPL	Stock	30.84	30.8442	30.825	30.8258	55412.0
2015-07-28 18:30:00	AAPL	Stock	30.8442	30.85	30.825	30.8275	43192.0
2015-07-28 19:00:00	AAPL	Stock	30.8275	30.8375	30.8125	30.8175	19288.0
2015-07-28 19:30:00	AAPL	Stock	30.8175	30.8375	30.7875	30.8	29240.0
2015-07-28 06:30:00	MSFT	Stock	45.65	45.65	45.65	45.65	100.0
2015-07-28 07:00:00	MSFT	Stock	45.65	45.65	45.61	45.61	1276.0
2015-07-28 08:00:00	MSFT	Stock	45.65	45.72	45.61	45.68	11295.0
2015-07-28 08:30:00	MSFT	Stock	45.68	45.72	45.62	45.62	2300.0
2015-07-28 09:00:00	MSFT	Stock	45.63	45.63	45.53	45.6	6520.0
2015-07-28 09:30:00	MSFT	Stock	45.6	45.6	45.155	45.305	3583230.0
2015-07-28 10:00:00	MSFT	Stock	45.305	45.34	44.79	44.83	3835808.0
2015-07-28 10:30:00	MSFT	Stock	44.83	45.15	44.79	45.116	2657121.0
2015-07-28 11:00:00	MSFT	Stock	45.12	45.28	45.07	45.225	1951173.0
2015-07-28 11:30:00	MSFT	Stock	45.23	45.44	45.225	45.345	1752119.0
2015-07-28 12:00:00	MSFT	Stock	45.34	45.49	45.325	45.435	1426976.0
2015-07-28 12:30:00	MSFT	Stock	45.43	45.44	45.265	45.32	1672118.0
2015-07-28 13:00:00	MSFT	Stock	45.32	45.436	45.28	45.384	2165032.0
2015-07-28 13:30:00	MSFT	Stock	45.385	45.46	45.35	45.45	1338780.0
2015-07-28 14:00:00	MSFT	Stock	45.45	45.615	45.39	45.49	1909002.0
2015-07-28 14:30:00	MSFT	Stock	45.495	45.54	45.41	45.53	1888633.0
2015-07-28 15:00:00	MSFT	Stock	45.525	45.639	45.45	45.525	1541374.0
2015-07-28 15:30:00	MSFT	Stock	45.525	45.6	45.32	45.35	4502681.0

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

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