PREVIEW / stock_30min / 2016-11-16

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-11-16.parquet
  size:    1.6 MB
  rows:    83,216
  symbols: 3,184

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-11-16 04:00:00	AAPL	Stock	26.7775	26.8525	26.75	26.8525	4228.0
2016-11-16 04:30:00	AAPL	Stock	26.7525	26.79	26.73	26.73	3580.0
2016-11-16 05:00:00	AAPL	Stock	26.715	26.715	26.715	26.715	1212.0
2016-11-16 05:30:00	AAPL	Stock	26.7125	26.7125	26.7125	26.7125	1216.0
2016-11-16 06:00:00	AAPL	Stock	26.7125	26.7375	26.7125	26.7225	7476.0
2016-11-16 06:30:00	AAPL	Stock	26.7225	26.7225	26.7125	26.7125	8084.0
2016-11-16 07:00:00	AAPL	Stock	26.7025	26.7025	26.625	26.625	20908.0
2016-11-16 07:30:00	AAPL	Stock	26.6275	26.6625	26.625	26.64	5800.0
2016-11-16 08:00:00	AAPL	Stock	26.665	26.7125	26.625	26.65	69980.0
2016-11-16 08:30:00	AAPL	Stock	26.6475	26.65	26.575	26.585	66124.0
2016-11-16 09:00:00	AAPL	Stock	26.575	26.7125	26.575	26.71	162916.0
2016-11-16 09:30:00	AAPL	Stock	26.675	27.0725	26.65	26.9362	22983312.0
2016-11-16 10:00:00	AAPL	Stock	26.9362	27.24	26.9275	27.155	14756264.0
2016-11-16 10:30:00	AAPL	Stock	27.155	27.3025	27.1525	27.2838	11697472.0
2016-11-16 11:00:00	AAPL	Stock	27.2812	27.329	27.191	27.3275	9856920.0
2016-11-16 11:30:00	AAPL	Stock	27.325	27.435	27.305	27.3688	11213568.0
2016-11-16 12:00:00	AAPL	Stock	27.3688	27.4925	27.33	27.49	8030124.0
2016-11-16 12:30:00	AAPL	Stock	27.4912	27.5225	27.4375	27.4385	10972816.0
2016-11-16 13:00:00	AAPL	Stock	27.4378	27.4512	27.3375	27.4215	7300088.0
2016-11-16 13:30:00	AAPL	Stock	27.4225	27.4875	27.4212	27.4525	4879332.0
2016-11-16 14:00:00	AAPL	Stock	27.45	27.47	27.4112	27.4525	4983792.0
2016-11-16 14:30:00	AAPL	Stock	27.45	27.4938	27.435	27.4675	5605176.0
2016-11-16 15:00:00	AAPL	Stock	27.4662	27.5575	27.4612	27.4875	10088136.0
2016-11-16 15:30:00	AAPL	Stock	27.4875	27.5175	27.44	27.5025	14127800.0
2016-11-16 16:00:00	AAPL	Stock	27.5025	27.525	27.1658	27.5	6876120.0
2016-11-16 16:30:00	AAPL	Stock	27.5	27.5	27.4525	27.4625	70708.0
2016-11-16 17:00:00	AAPL	Stock	27.4675	27.49	27.4675	27.475	11468.0
2016-11-16 17:30:00	AAPL	Stock	27.4825	27.49	27.475	27.49	5380.0
2016-11-16 18:00:00	AAPL	Stock	27.4875	27.4875	27.4825	27.4825	11932.0
2016-11-16 18:30:00	AAPL	Stock	27.4825	27.495	27.4775	27.48	26704.0
2016-11-16 19:00:00	AAPL	Stock	27.48	27.5	27.48	27.5	9020.0
2016-11-16 19:30:00	AAPL	Stock	27.4975	27.5	27.4825	27.4975	53996.0
2016-11-16 04:00:00	MSFT	Stock	58.87	58.87	58.87	58.87	100.0
2016-11-16 07:00:00	MSFT	Stock	58.9	58.9	58.87	58.87	2300.0
2016-11-16 07:30:00	MSFT	Stock	58.8	58.8	58.71	58.71	1766.0
2016-11-16 08:00:00	MSFT	Stock	58.76	58.9	58.76	58.8	2888.0
2016-11-16 08:30:00	MSFT	Stock	58.8	58.85	58.71	58.71	8095.0
2016-11-16 09:00:00	MSFT	Stock	58.72	58.94	58.7	58.94	13538.0
2016-11-16 09:30:00	MSFT	Stock	58.94	59.56	58.81	59.085	3892285.0
2016-11-16 10:00:00	MSFT	Stock	59.09	59.29	59.06	59.125	1546120.0
2016-11-16 10:30:00	MSFT	Stock	59.12	59.37	59.02	59.18	2005095.0
2016-11-16 11:00:00	MSFT	Stock	59.18	59.32	58.995	59.32	1911049.0
2016-11-16 11:30:00	MSFT	Stock	59.32	59.44	59.2	59.31	1103017.0
2016-11-16 12:00:00	MSFT	Stock	59.31	59.35	59.18	59.259	1137729.0
2016-11-16 12:30:00	MSFT	Stock	59.26	59.39	59.245	59.34	906339.0
2016-11-16 13:00:00	MSFT	Stock	59.33	59.378	59.14	59.255	666207.0
2016-11-16 13:30:00	MSFT	Stock	59.26	59.33	59.22	59.293	522540.0
2016-11-16 14:00:00	MSFT	Stock	59.295	59.37	59.24	59.325	792426.0
2016-11-16 14:30:00	MSFT	Stock	59.325	59.53	59.285	59.515	1066184.0
2016-11-16 15:00:00	MSFT	Stock	59.515	59.6	59.51	59.55	1965551.0

> showing 50 of 83,216 rows — these rows as CSV

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