PREVIEW / stock_30min / 2014-09-15

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-09-15.parquet
  size:    1.6 MB
  rows:    83,980
  symbols: 3,592

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
2014-09-15 04:00:00	AAPL	Stock	25.42	25.4575	25.4025	25.4225	15600.0
2014-09-15 04:30:00	AAPL	Stock	25.4475	25.4575	25.4475	25.4475	9040.0
2014-09-15 05:00:00	AAPL	Stock	25.4475	25.46	25.425	25.425	175108.0
2014-09-15 05:30:00	AAPL	Stock	25.425	25.4375	25.425	25.4375	5200.0
2014-09-15 06:00:00	AAPL	Stock	25.48	25.5	25.44	25.47	9288.0
2014-09-15 06:30:00	AAPL	Stock	25.485	25.49	25.475	25.475	7200.0
2014-09-15 07:00:00	AAPL	Stock	25.48	25.5125	25.4525	25.495	156024.0
2014-09-15 07:30:00	AAPL	Stock	25.4925	25.55	25.4825	25.535	173864.0
2014-09-15 08:00:00	AAPL	Stock	25.53	25.6025	25.4575	25.5875	1273724.0
2014-09-15 08:30:00	AAPL	Stock	25.585	25.7225	25.4475	25.7125	3583588.0
2014-09-15 09:00:00	AAPL	Stock	25.71	25.865	25.6875	25.71	3190248.0
2014-09-15 09:30:00	AAPL	Stock	25.71	25.7625	25.409	25.48	52895304.0
2014-09-15 10:00:00	AAPL	Stock	25.48	25.6	25.4275	25.56	19840188.0
2014-09-15 10:30:00	AAPL	Stock	25.5625	25.5875	25.4825	25.545	14891860.0
2014-09-15 11:00:00	AAPL	Stock	25.5425	25.665	25.5315	25.6075	22263084.0
2014-09-15 11:30:00	AAPL	Stock	25.6062	25.62	25.4925	25.5075	11658432.0
2014-09-15 12:00:00	AAPL	Stock	25.51	25.55	25.4425	25.5275	12678280.0
2014-09-15 12:30:00	AAPL	Stock	25.5325	25.5875	25.505	25.575	8521992.0
2014-09-15 13:00:00	AAPL	Stock	25.575	25.59	25.45	25.46	12460404.0
2014-09-15 13:30:00	AAPL	Stock	25.46	25.4975	25.4	25.42	11228072.0
2014-09-15 14:00:00	AAPL	Stock	25.4205	25.4975	25.4	25.4925	9946928.0
2014-09-15 14:30:00	AAPL	Stock	25.4925	25.5375	25.4275	25.4475	11499796.0
2014-09-15 15:00:00	AAPL	Stock	25.4468	25.4975	25.4402	25.49	8668064.0
2014-09-15 15:30:00	AAPL	Stock	25.49	25.5	25.36	25.4025	20543908.0
2014-09-15 16:00:00	AAPL	Stock	25.4075	25.5712	25.4	25.4075	4712236.0
2014-09-15 16:30:00	AAPL	Stock	25.425	26.0165	25.4105	25.4325	597616.0
2014-09-15 17:00:00	AAPL	Stock	25.4425	25.47	25.4075	25.45	293732.0
2014-09-15 17:30:00	AAPL	Stock	25.445	25.46	25.425	25.4425	127088.0
2014-09-15 18:00:00	AAPL	Stock	25.4475	25.4475	25.4075	25.4175	66384.0
2014-09-15 18:30:00	AAPL	Stock	25.4175	25.445	25.4075	25.4175	151620.0
2014-09-15 19:00:00	AAPL	Stock	25.4175	25.4275	25.415	25.425	58308.0
2014-09-15 19:30:00	AAPL	Stock	25.42	25.4425	25.415	25.4375	83984.0
2014-09-15 07:00:00	MSFT	Stock	46.55	46.55	46.55	46.55	1722.0
2014-09-15 08:00:00	MSFT	Stock	46.5	46.5	46.5	46.5	125.0
2014-09-15 08:30:00	MSFT	Stock	46.57	46.58	46.57	46.57	2021.0
2014-09-15 09:00:00	MSFT	Stock	46.6	46.66	46.54	46.54	31718.0
2014-09-15 09:30:00	MSFT	Stock	46.54	46.71	46.24	46.409	4816053.0
2014-09-15 10:00:00	MSFT	Stock	46.41	46.47	46.34	46.38	2642099.0
2014-09-15 10:30:00	MSFT	Stock	46.39	46.395	46.23	46.25	2650796.0
2014-09-15 11:00:00	MSFT	Stock	46.24	46.38	46.19	46.3	2784566.0
2014-09-15 11:30:00	MSFT	Stock	46.305	46.31	46.25	46.28	1339874.0
2014-09-15 12:00:00	MSFT	Stock	46.285	46.35	46.25	46.314	2414678.0
2014-09-15 12:30:00	MSFT	Stock	46.315	46.35	46.27	46.3	1306437.0
2014-09-15 13:00:00	MSFT	Stock	46.29	46.32	46.225	46.23	1826695.0
2014-09-15 13:30:00	MSFT	Stock	46.23	46.3	46.12	46.169	1879125.0
2014-09-15 14:00:00	MSFT	Stock	46.16	46.21	46.14	46.205	1417460.0
2014-09-15 14:30:00	MSFT	Stock	46.205	46.27	46.18	46.205	2377356.0
2014-09-15 15:00:00	MSFT	Stock	46.206	46.23	46.1	46.17	2809065.0
2014-09-15 15:30:00	MSFT	Stock	46.18	46.24	46.16	46.24	4119417.0
2014-09-15 16:00:00	MSFT	Stock	46.24	46.37	46.196	46.24	2084486.0

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

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