PREVIEW / stock_30min / 2015-09-09

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-09-09.parquet
  size:    1.6 MB
  rows:    82,783
  symbols: 3,443

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-09-09 04:00:00	AAPL	Stock	28.1675	28.53	28.1675	28.48	37952.0
2015-09-09 04:30:00	AAPL	Stock	28.475	28.495	28.35	28.4375	27256.0
2015-09-09 05:00:00	AAPL	Stock	28.4575	28.4675	28.375	28.375	11336.0
2015-09-09 05:30:00	AAPL	Stock	28.3675	28.4175	28.355	28.355	72620.0
2015-09-09 06:00:00	AAPL	Stock	28.38	28.4075	28.35	28.405	86004.0
2015-09-09 06:30:00	AAPL	Stock	28.395	28.4025	28.3375	28.3375	41844.0
2015-09-09 07:00:00	AAPL	Stock	28.3625	28.4475	28.35	28.4	231784.0
2015-09-09 07:30:00	AAPL	Stock	28.4	28.4375	28.3375	28.425	177880.0
2015-09-09 08:00:00	AAPL	Stock	28.4375	28.475	28.3375	28.3675	1230728.0
2015-09-09 08:30:00	AAPL	Stock	28.375	28.4475	28.3675	28.41	651096.0
2015-09-09 09:00:00	AAPL	Stock	28.4125	28.45	28.355	28.4425	926496.0
2015-09-09 09:30:00	AAPL	Stock	28.44	28.45	27.925	28.0475	37512624.0
2015-09-09 10:00:00	AAPL	Stock	28.0475	28.145	27.965	28.1175	19972520.0
2015-09-09 10:30:00	AAPL	Stock	28.1175	28.2395	28.0175	28.0738	15919524.0
2015-09-09 11:00:00	AAPL	Stock	28.0725	28.17	28.0275	28.0425	9395484.0
2015-09-09 11:30:00	AAPL	Stock	28.0412	28.145	28.0325	28.1375	8743196.0
2015-09-09 12:00:00	AAPL	Stock	28.1425	28.23	28.115	28.2262	9804852.0
2015-09-09 12:30:00	AAPL	Stock	28.2275	28.28	28.1525	28.2012	11691232.0
2015-09-09 13:00:00	AAPL	Stock	28.2025	28.505	28.1375	28.1798	42656096.0
2015-09-09 13:30:00	AAPL	Stock	28.175	28.2225	27.975	28.035	31844744.0
2015-09-09 14:00:00	AAPL	Stock	28.0375	28.1175	27.815	27.905	27127612.0
2015-09-09 14:30:00	AAPL	Stock	27.9072	27.9525	27.6775	27.8962	26547828.0
2015-09-09 15:00:00	AAPL	Stock	27.8925	27.945	27.7175	27.755	23380904.0
2015-09-09 15:30:00	AAPL	Stock	27.7528	27.773	27.4425	27.5365	34563500.0
2015-09-09 16:00:00	AAPL	Stock	27.525	28.157	27.4825	27.5125	7323308.0
2015-09-09 16:30:00	AAPL	Stock	27.5125	27.5875	27.5125	27.555	310872.0
2015-09-09 17:00:00	AAPL	Stock	27.5575	27.56	27.525	27.545	168752.0
2015-09-09 17:30:00	AAPL	Stock	27.5525	27.61	27.55	27.595	154256.0
2015-09-09 18:00:00	AAPL	Stock	27.605	27.61	27.49	27.49	276452.0
2015-09-09 18:30:00	AAPL	Stock	27.5	27.5125	27.475	27.495	130904.0
2015-09-09 19:00:00	AAPL	Stock	27.5	27.5375	27.5	27.5	74740.0
2015-09-09 19:30:00	AAPL	Stock	27.4875	27.495	27.445	27.4625	136828.0
2015-09-09 04:00:00	MSFT	Stock	44.46	44.46	44.46	44.46	100.0
2015-09-09 06:00:00	MSFT	Stock	44.22	44.22	44.22	44.22	365.0
2015-09-09 06:30:00	MSFT	Stock	44.22	44.25	44.22	44.25	5080.0
2015-09-09 07:30:00	MSFT	Stock	44.3	44.3	44.23	44.27	3810.0
2015-09-09 08:00:00	MSFT	Stock	44.28	44.33	44.23	44.31	13800.0
2015-09-09 08:30:00	MSFT	Stock	44.31	44.35	44.28	44.35	7400.0
2015-09-09 09:00:00	MSFT	Stock	44.37	44.43	44.19	44.22	26949.0
2015-09-09 09:30:00	MSFT	Stock	44.22	44.4	44.185	44.27	3111542.0
2015-09-09 10:00:00	MSFT	Stock	44.28	44.3	43.97	44.09	2230870.0
2015-09-09 10:30:00	MSFT	Stock	44.09	44.14	43.86	43.9	1719052.0
2015-09-09 11:00:00	MSFT	Stock	43.9	43.96	43.75	43.795	1077529.0
2015-09-09 11:30:00	MSFT	Stock	43.795	43.83	43.69	43.795	1330445.0
2015-09-09 12:00:00	MSFT	Stock	43.79	43.94	43.75	43.91	1158998.0
2015-09-09 12:30:00	MSFT	Stock	43.91	43.92	43.66	43.695	727312.0
2015-09-09 13:00:00	MSFT	Stock	43.7	43.94	43.67	43.86	1380833.0
2015-09-09 13:30:00	MSFT	Stock	43.84	43.85	43.49	43.52	1464739.0
2015-09-09 14:00:00	MSFT	Stock	43.52	43.62	43.39	43.462	1374161.0
2015-09-09 14:30:00	MSFT	Stock	43.47	43.48	43.26	43.39	1575530.0

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

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