PREVIEW / stock_30min / 2015-05-27

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-05-27.parquet
  size:    1.6 MB
  rows:    82,727
  symbols: 3,521

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-05-27 04:00:00	AAPL	Stock	32.4625	32.5	32.4625	32.485	22764.0
2015-05-27 04:30:00	AAPL	Stock	32.495	32.495	32.4625	32.4875	12164.0
2015-05-27 05:00:00	AAPL	Stock	32.4875	32.51	32.4875	32.51	25576.0
2015-05-27 06:00:00	AAPL	Stock	32.5	32.5	32.475	32.475	39496.0
2015-05-27 06:30:00	AAPL	Stock	32.4625	32.4925	32.4625	32.4925	16000.0
2015-05-27 07:00:00	AAPL	Stock	32.4825	32.5025	32.4725	32.48	39412.0
2015-05-27 07:30:00	AAPL	Stock	32.475	32.4975	32.445	32.47	60136.0
2015-05-27 08:00:00	AAPL	Stock	32.47	32.575	32.47	32.5275	595772.0
2015-05-27 08:30:00	AAPL	Stock	32.5175	32.535	32.5025	32.5075	166092.0
2015-05-27 09:00:00	AAPL	Stock	32.5025	32.5825	32.4875	32.53	460216.0
2015-05-27 09:30:00	AAPL	Stock	32.57	32.7975	32.5125	32.7425	32014884.0
2015-05-27 10:00:00	AAPL	Stock	32.7475	32.825	32.7125	32.76	17056872.0
2015-05-27 10:30:00	AAPL	Stock	32.7575	32.87	32.74	32.8628	12851532.0
2015-05-27 11:00:00	AAPL	Stock	32.8625	32.8975	32.8475	32.8625	10978112.0
2015-05-27 11:30:00	AAPL	Stock	32.8625	32.9775	32.8425	32.9628	10381784.0
2015-05-27 12:00:00	AAPL	Stock	32.965	32.9875	32.945	32.9525	6884160.0
2015-05-27 12:30:00	AAPL	Stock	32.9545	32.97	32.8862	32.9475	8504428.0
2015-05-27 13:00:00	AAPL	Stock	32.95	33.0625	32.925	33.0375	10711664.0
2015-05-27 13:30:00	AAPL	Stock	33.035	33.0475	33.0075	33.0238	7131228.0
2015-05-27 14:00:00	AAPL	Stock	33.0245	33.025	32.955	32.996	8593092.0
2015-05-27 14:30:00	AAPL	Stock	32.9975	33.0275	32.97	33.0275	5562932.0
2015-05-27 15:00:00	AAPL	Stock	33.0258	33.065	33.005	33.0425	9310644.0
2015-05-27 15:30:00	AAPL	Stock	33.0425	33.0575	32.9938	33.0025	16337172.0
2015-05-27 16:00:00	AAPL	Stock	33.0112	33.015	32.6782	33.0025	15638064.0
2015-05-27 16:30:00	AAPL	Stock	32.9975	33.0	32.9875	32.9875	23680.0
2015-05-27 17:00:00	AAPL	Stock	32.9825	32.9875	32.97	32.975	31548.0
2015-05-27 17:30:00	AAPL	Stock	32.975	32.9875	32.97	32.9775	57512.0
2015-05-27 18:00:00	AAPL	Stock	32.9775	32.9875	32.975	32.985	39040.0
2015-05-27 18:30:00	AAPL	Stock	32.98	32.9875	32.975	32.985	24864.0
2015-05-27 19:00:00	AAPL	Stock	32.975	32.9925	32.975	32.9802	39260.0
2015-05-27 19:30:00	AAPL	Stock	32.985	33.005	32.975	32.975	65064.0
2015-05-27 08:00:00	MSFT	Stock	46.69	46.79	46.69	46.79	1639.0
2015-05-27 08:30:00	MSFT	Stock	46.71	46.72	46.71	46.72	1500.0
2015-05-27 09:00:00	MSFT	Stock	46.7	46.89	46.66	46.75	12409.0
2015-05-27 09:30:00	MSFT	Stock	46.76	47.3	46.62	47.25	3281794.0
2015-05-27 10:00:00	MSFT	Stock	47.25	47.38	47.21	47.255	1692496.0
2015-05-27 10:30:00	MSFT	Stock	47.255	47.49	47.25	47.445	1600836.0
2015-05-27 11:00:00	MSFT	Stock	47.44	47.49	47.25	47.25	1406313.0
2015-05-27 11:30:00	MSFT	Stock	47.25	47.29	47.16	47.24	1559911.0
2015-05-27 12:00:00	MSFT	Stock	47.24	47.365	47.21	47.345	820763.0
2015-05-27 12:30:00	MSFT	Stock	47.345	47.38	47.27	47.36	993205.0
2015-05-27 13:00:00	MSFT	Stock	47.37	47.57	47.36	47.55	1822735.0
2015-05-27 13:30:00	MSFT	Stock	47.55	47.65	47.54	47.6	1552107.0
2015-05-27 14:00:00	MSFT	Stock	47.6	47.69	47.595	47.635	1245528.0
2015-05-27 14:30:00	MSFT	Stock	47.635	47.72	47.63	47.675	1447169.0
2015-05-27 15:00:00	MSFT	Stock	47.68	47.76	47.655	47.705	1633435.0
2015-05-27 15:30:00	MSFT	Stock	47.7	47.77	47.61	47.62	3237583.0
2015-05-27 16:00:00	MSFT	Stock	47.61	47.64	47.6	47.6	2091451.0
2015-05-27 16:30:00	MSFT	Stock	47.55	47.6	47.55	47.6	500.0
2015-05-27 18:00:00	MSFT	Stock	47.6	47.6	47.56	47.56	1100.0

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

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