PREVIEW / stock_30min / 2015-01-13

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-01-13.parquet
  size:    1.6 MB
  rows:    84,412
  symbols: 3,523

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-01-13 04:00:00	AAPL	Stock	27.435	27.69	27.36	27.6875	92760.0
2015-01-13 04:30:00	AAPL	Stock	27.6625	27.7125	27.64	27.64	27760.0
2015-01-13 05:00:00	AAPL	Stock	27.68	27.7	27.6375	27.6375	43800.0
2015-01-13 05:30:00	AAPL	Stock	27.6725	27.675	27.645	27.645	26000.0
2015-01-13 06:00:00	AAPL	Stock	27.6375	27.7025	27.6375	27.6775	63092.0
2015-01-13 06:30:00	AAPL	Stock	27.6875	27.7125	27.6675	27.71	77192.0
2015-01-13 07:00:00	AAPL	Stock	27.6925	27.695	27.625	27.6375	245740.0
2015-01-13 07:30:00	AAPL	Stock	27.6325	27.6925	27.6325	27.6925	267284.0
2015-01-13 08:00:00	AAPL	Stock	27.6925	27.6925	27.605	27.6225	622624.0
2015-01-13 08:30:00	AAPL	Stock	27.6225	27.67	27.615	27.67	393468.0
2015-01-13 09:00:00	AAPL	Stock	27.67	27.875	27.665	27.84	1278880.0
2015-01-13 09:30:00	AAPL	Stock	27.8575	28.0075	27.79	27.995	38436796.0
2015-01-13 10:00:00	AAPL	Stock	27.9962	28.11	27.97	28.0625	20305160.0
2015-01-13 10:30:00	AAPL	Stock	28.0625	28.2	28.04	28.1738	19349632.0
2015-01-13 11:00:00	AAPL	Stock	28.175	28.175	28.005	28.0675	16971424.0
2015-01-13 11:30:00	AAPL	Stock	28.0675	28.085	27.9525	27.9925	10102416.0
2015-01-13 12:00:00	AAPL	Stock	27.9948	28.0025	27.83	27.8372	12826616.0
2015-01-13 12:30:00	AAPL	Stock	27.8352	27.8375	27.73	27.825	13545632.0
2015-01-13 13:00:00	AAPL	Stock	27.8225	27.8675	27.635	27.6775	11078656.0
2015-01-13 13:30:00	AAPL	Stock	27.6775	27.68	27.43	27.5052	21478264.0
2015-01-13 14:00:00	AAPL	Stock	27.505	27.5225	27.2275	27.4555	23510168.0
2015-01-13 14:30:00	AAPL	Stock	27.455	27.5675	27.4312	27.435	15750392.0
2015-01-13 15:00:00	AAPL	Stock	27.4375	27.6125	27.3775	27.52	17346260.0
2015-01-13 15:30:00	AAPL	Stock	27.5225	27.7225	27.4975	27.5562	21818764.0
2015-01-13 16:00:00	AAPL	Stock	27.555	28.171	27.25	27.575	8881284.0
2015-01-13 16:30:00	AAPL	Stock	27.575	27.5975	27.555	27.5975	286312.0
2015-01-13 17:00:00	AAPL	Stock	27.5975	27.61	27.565	27.5675	48860.0
2015-01-13 17:30:00	AAPL	Stock	27.5825	27.8035	27.57	27.6	50572.0
2015-01-13 18:00:00	AAPL	Stock	27.5875	27.595	27.555	27.575	269436.0
2015-01-13 18:30:00	AAPL	Stock	27.5825	27.61	27.575	27.59	65168.0
2015-01-13 19:00:00	AAPL	Stock	27.6	27.6	27.5775	27.5775	25564.0
2015-01-13 19:30:00	AAPL	Stock	27.5925	27.5925	27.5625	27.575	53612.0
2015-01-13 04:30:00	MSFT	Stock	46.63	46.63	46.63	46.63	100.0
2015-01-13 05:00:00	MSFT	Stock	46.7	46.7	46.7	46.7	169.0
2015-01-13 06:30:00	MSFT	Stock	46.8	46.8	46.8	46.8	1000.0
2015-01-13 07:30:00	MSFT	Stock	46.85	46.93	46.85	46.85	10402.0
2015-01-13 08:00:00	MSFT	Stock	46.85	46.91	46.72	46.79	11548.0
2015-01-13 08:30:00	MSFT	Stock	46.75	46.81	46.68	46.8	31890.0
2015-01-13 09:00:00	MSFT	Stock	46.79	47.01	46.79	47.01	25748.0
2015-01-13 09:30:00	MSFT	Stock	46.97	47.91	46.94	47.85	5242373.0
2015-01-13 10:00:00	MSFT	Stock	47.85	47.9	47.62	47.63	2415210.0
2015-01-13 10:30:00	MSFT	Stock	47.63	47.79	47.6	47.67	2151081.0
2015-01-13 11:00:00	MSFT	Stock	47.675	47.73	47.35	47.5	1807761.0
2015-01-13 11:30:00	MSFT	Stock	47.5	47.56	47.42	47.45	1430520.0
2015-01-13 12:00:00	MSFT	Stock	47.455	47.515	47.19	47.26	1572410.0
2015-01-13 12:30:00	MSFT	Stock	47.26	47.27	47.12	47.23	1096411.0
2015-01-13 13:00:00	MSFT	Stock	47.23	47.27	46.88	46.94	1425871.0
2015-01-13 13:30:00	MSFT	Stock	46.93	46.935	46.39	46.55	2380406.0
2015-01-13 14:00:00	MSFT	Stock	46.545	46.555	46.21	46.41	3330228.0
2015-01-13 14:30:00	MSFT	Stock	46.41	46.55	46.12	46.13	2152149.0

> showing 50 of 84,412 rows — these rows as CSV

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