PREVIEW / stock_30min / 2015-05-08

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-05-08.parquet
  size:    1.6 MB
  rows:    82,622
  symbols: 3,494

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-08 04:00:00	AAPL	Stock	31.505	31.505	31.375	31.5	5192.0
2015-05-08 04:30:00	AAPL	Stock	31.4275	31.4475	31.425	31.4375	7600.0
2015-05-08 05:00:00	AAPL	Stock	31.4475	31.4475	31.4475	31.4475	800.0
2015-05-08 05:30:00	AAPL	Stock	31.4825	31.575	31.4825	31.5325	41748.0
2015-05-08 06:00:00	AAPL	Stock	31.5125	31.5225	31.5125	31.5225	3460.0
2015-05-08 06:30:00	AAPL	Stock	31.4525	31.4975	31.45	31.4925	7876.0
2015-05-08 07:00:00	AAPL	Stock	31.475	31.475	31.455	31.4625	39352.0
2015-05-08 07:30:00	AAPL	Stock	31.4625	31.4625	31.4125	31.4375	95816.0
2015-05-08 08:00:00	AAPL	Stock	31.44	31.475	31.38	31.4	407748.0
2015-05-08 08:30:00	AAPL	Stock	31.4	31.6475	31.4	31.625	1351084.0
2015-05-08 09:00:00	AAPL	Stock	31.6375	31.675	31.5625	31.62	537752.0
2015-05-08 09:30:00	AAPL	Stock	31.6225	31.795	31.5275	31.7352	35596156.0
2015-05-08 10:00:00	AAPL	Stock	31.74	31.76	31.6	31.64	14765696.0
2015-05-08 10:30:00	AAPL	Stock	31.6425	31.7225	31.6402	31.7125	7980092.0
2015-05-08 11:00:00	AAPL	Stock	31.7125	31.8175	31.7	31.7675	12062788.0
2015-05-08 11:30:00	AAPL	Stock	31.7688	31.8775	31.7475	31.835	10894604.0
2015-05-08 12:00:00	AAPL	Stock	31.835	31.8675	31.7675	31.817	6930204.0
2015-05-08 12:30:00	AAPL	Stock	31.8152	31.8475	31.7575	31.8012	7337544.0
2015-05-08 13:00:00	AAPL	Stock	31.8	31.8825	31.78	31.846	9487076.0
2015-05-08 13:30:00	AAPL	Stock	31.845	31.8962	31.805	31.81	7587576.0
2015-05-08 14:00:00	AAPL	Stock	31.81	31.8425	31.8038	31.8185	4884876.0
2015-05-08 14:30:00	AAPL	Stock	31.8188	31.85	31.77	31.8425	7640316.0
2015-05-08 15:00:00	AAPL	Stock	31.8435	31.86	31.8038	31.8242	8394644.0
2015-05-08 15:30:00	AAPL	Stock	31.825	31.905	31.815	31.9	21130368.0
2015-05-08 16:00:00	AAPL	Stock	31.9	31.935	31.791	31.8725	20950940.0
2015-05-08 16:30:00	AAPL	Stock	31.8725	31.875	31.8525	31.875	104640.0
2015-05-08 17:00:00	AAPL	Stock	31.8575	31.875	31.855	31.875	116144.0
2015-05-08 17:30:00	AAPL	Stock	31.865	31.875	31.8625	31.8625	25940.0
2015-05-08 18:00:00	AAPL	Stock	31.8652	31.875	31.8625	31.865	54520.0
2015-05-08 18:30:00	AAPL	Stock	31.8625	31.875	31.8575	31.86	53436.0
2015-05-08 19:00:00	AAPL	Stock	31.865	31.8725	31.855	31.865	54752.0
2015-05-08 19:30:00	AAPL	Stock	31.865	31.87	31.855	31.86	73396.0
2015-05-08 07:30:00	MSFT	Stock	47.01	47.01	46.88	46.88	1300.0
2015-05-08 08:00:00	MSFT	Stock	46.9	46.99	46.9	46.96	10225.0
2015-05-08 08:30:00	MSFT	Stock	46.99	47.45	46.99	47.4	65863.0
2015-05-08 09:00:00	MSFT	Stock	47.43	47.65	47.33	47.56	63625.0
2015-05-08 09:30:00	MSFT	Stock	47.56	47.98	47.52	47.76	6410933.0
2015-05-08 10:00:00	MSFT	Stock	47.76	47.81	47.59	47.76	2731042.0
2015-05-08 10:30:00	MSFT	Stock	47.755	47.83	47.64	47.71	2157827.0
2015-05-08 11:00:00	MSFT	Stock	47.7	47.745	47.565	47.61	1607317.0
2015-05-08 11:30:00	MSFT	Stock	47.61	47.8	47.59	47.78	1753734.0
2015-05-08 12:00:00	MSFT	Stock	47.77	47.83	47.63	47.68	1286871.0
2015-05-08 12:30:00	MSFT	Stock	47.69	47.73	47.64	47.706	1259298.0
2015-05-08 13:00:00	MSFT	Stock	47.705	47.73	47.67	47.705	1229643.0
2015-05-08 13:30:00	MSFT	Stock	47.7	47.78	47.69	47.715	1050265.0
2015-05-08 14:00:00	MSFT	Stock	47.71	47.74	47.69	47.7	1218419.0
2015-05-08 14:30:00	MSFT	Stock	47.7	47.74	47.63	47.73	1565801.0
2015-05-08 15:00:00	MSFT	Stock	47.72	47.75	47.66	47.68	1501709.0
2015-05-08 15:30:00	MSFT	Stock	47.685	47.84	47.675	47.72	4080317.0
2015-05-08 16:00:00	MSFT	Stock	47.75	47.76	47.67	47.76	4654511.0

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

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