PREVIEW / stock_30min / 2016-07-27

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-07-27.parquet
  size:    1.6 MB
  rows:    82,592
  symbols: 3,275

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
2016-07-27 04:00:00	AAPL	Stock	25.465	25.7975	25.465	25.7175	204440.0
2016-07-27 04:30:00	AAPL	Stock	25.71	25.71	25.62	25.62	75096.0
2016-07-27 05:00:00	AAPL	Stock	25.625	25.65	25.56	25.575	109660.0
2016-07-27 05:30:00	AAPL	Stock	25.6075	25.6375	25.57	25.6375	86676.0
2016-07-27 06:00:00	AAPL	Stock	25.6375	25.8375	25.6375	25.8275	584204.0
2016-07-27 06:30:00	AAPL	Stock	25.8125	25.825	25.775	25.7975	127096.0
2016-07-27 07:00:00	AAPL	Stock	25.8	25.9175	25.7875	25.8525	600084.0
2016-07-27 07:30:00	AAPL	Stock	25.8675	25.9875	25.785	25.9375	1968284.0
2016-07-27 08:00:00	AAPL	Stock	25.9375	25.975	25.6125	25.9725	4639500.0
2016-07-27 08:30:00	AAPL	Stock	25.9675	26.0925	25.955	26.025	5799168.0
2016-07-27 09:00:00	AAPL	Stock	26.025	26.17	26.0175	26.0675	8932136.0
2016-07-27 09:30:00	AAPL	Stock	26.07	26.0875	25.89	25.9938	94701080.0
2016-07-27 10:00:00	AAPL	Stock	25.995	26.05	25.8575	25.8812	35521560.0
2016-07-27 10:30:00	AAPL	Stock	25.88	25.8925	25.765	25.7752	24353320.0
2016-07-27 11:00:00	AAPL	Stock	25.7775	25.7875	25.6875	25.7462	21186780.0
2016-07-27 11:30:00	AAPL	Stock	25.7462	25.7725	25.695	25.7377	13483816.0
2016-07-27 12:00:00	AAPL	Stock	25.7375	25.78	25.72	25.7498	12031708.0
2016-07-27 12:30:00	AAPL	Stock	25.7485	25.7775	25.7425	25.751	8888916.0
2016-07-27 13:00:00	AAPL	Stock	25.7512	25.8	25.75	25.7825	9017204.0
2016-07-27 13:30:00	AAPL	Stock	25.7825	25.835	25.745	25.8122	11166984.0
2016-07-27 14:00:00	AAPL	Stock	25.81	25.925	25.7475	25.88	16383916.0
2016-07-27 14:30:00	AAPL	Stock	25.8788	25.9425	25.855	25.9025	11289336.0
2016-07-27 15:00:00	AAPL	Stock	25.9025	25.95	25.9	25.935	12150516.0
2016-07-27 15:30:00	AAPL	Stock	25.9375	25.94	25.6875	25.7425	29414196.0
2016-07-27 16:00:00	AAPL	Stock	25.7375	25.99	25.7375	25.8325	11482928.0
2016-07-27 16:30:00	AAPL	Stock	25.7375	25.825	25.7375	25.79	348220.0
2016-07-27 17:00:00	AAPL	Stock	25.7875	25.85	25.7375	25.7925	4454952.0
2016-07-27 17:30:00	AAPL	Stock	25.795	25.825	25.7875	25.8125	45852.0
2016-07-27 18:00:00	AAPL	Stock	25.8125	25.835	25.805	25.835	88560.0
2016-07-27 18:30:00	AAPL	Stock	25.8225	25.825	25.78	25.8	59456.0
2016-07-27 19:00:00	AAPL	Stock	25.8	25.8425	25.8	25.8325	57972.0
2016-07-27 19:30:00	AAPL	Stock	25.8375	25.8625	25.8225	25.8575	95816.0
2016-07-27 05:00:00	MSFT	Stock	56.95	56.96	56.95	56.96	879.0
2016-07-27 06:30:00	MSFT	Stock	56.8	56.8	56.74	56.74	689.0
2016-07-27 07:00:00	MSFT	Stock	56.75	56.85	56.74	56.85	6008.0
2016-07-27 07:30:00	MSFT	Stock	56.95	56.95	56.94	56.94	605.0
2016-07-27 08:00:00	MSFT	Stock	56.93	56.93	56.85	56.87	660.0
2016-07-27 08:30:00	MSFT	Stock	56.8	56.87	56.74	56.74	10774.0
2016-07-27 09:00:00	MSFT	Stock	56.76	56.78	56.61	56.61	35419.0
2016-07-27 09:30:00	MSFT	Stock	56.61	56.8	56.3	56.59	3825808.0
2016-07-27 10:00:00	MSFT	Stock	56.585	56.585	56.24	56.39	2568522.0
2016-07-27 10:30:00	MSFT	Stock	56.39	56.5	56.34	56.375	1937728.0
2016-07-27 11:00:00	MSFT	Stock	56.38	56.49	56.32	56.46	1368237.0
2016-07-27 11:30:00	MSFT	Stock	56.46	56.46	56.33	56.34	1122631.0
2016-07-27 12:00:00	MSFT	Stock	56.33	56.42	56.31	56.42	959645.0
2016-07-27 12:30:00	MSFT	Stock	56.42	56.45	56.32	56.355	985357.0
2016-07-27 13:00:00	MSFT	Stock	56.35	56.37	56.185	56.25	1304939.0
2016-07-27 13:30:00	MSFT	Stock	56.25	56.37	56.18	56.298	1645692.0
2016-07-27 14:00:00	MSFT	Stock	56.3	56.44	56.11	56.305	2875891.0
2016-07-27 14:30:00	MSFT	Stock	56.3	56.495	56.29	56.44	2326053.0

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

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