PREVIEW / stock_30min / 2014-11-13

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-11-13.parquet
  size:    1.6 MB
  rows:    83,432
  symbols: 3,538

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-11-13 04:00:00	AAPL	Stock	27.875	27.9125	27.875	27.9125	19836.0
2014-11-13 04:30:00	AAPL	Stock	27.9125	27.925	27.91	27.925	3436.0
2014-11-13 05:00:00	AAPL	Stock	27.9525	27.9525	27.9325	27.9325	2000.0
2014-11-13 05:30:00	AAPL	Stock	27.95	27.95	27.9125	27.925	16792.0
2014-11-13 06:00:00	AAPL	Stock	27.95	27.9825	27.9275	27.9475	33272.0
2014-11-13 06:30:00	AAPL	Stock	27.945	27.945	27.9075	27.9075	30096.0
2014-11-13 07:00:00	AAPL	Stock	27.925	27.9425	27.9075	27.91	141420.0
2014-11-13 07:30:00	AAPL	Stock	27.9075	27.93	27.9075	27.9125	75100.0
2014-11-13 08:00:00	AAPL	Stock	27.9075	27.9375	27.62	27.85	445292.0
2014-11-13 08:30:00	AAPL	Stock	27.8525	27.9075	27.8375	27.9025	286588.0
2014-11-13 09:00:00	AAPL	Stock	27.905	27.9625	27.8775	27.95	857424.0
2014-11-13 09:30:00	AAPL	Stock	27.95	28.175	27.9	28.16	35664788.0
2014-11-13 10:00:00	AAPL	Stock	28.16	28.27	28.1025	28.2675	20581796.0
2014-11-13 10:30:00	AAPL	Stock	28.2665	28.3625	28.2525	28.315	22235260.0
2014-11-13 11:00:00	AAPL	Stock	28.3125	28.32	28.1525	28.2638	22161128.0
2014-11-13 11:30:00	AAPL	Stock	28.2638	28.315	28.185	28.27	15159868.0
2014-11-13 12:00:00	AAPL	Stock	28.27	28.285	28.2175	28.2725	9988696.0
2014-11-13 12:30:00	AAPL	Stock	28.2712	28.28	28.25	28.27	7062352.0
2014-11-13 13:00:00	AAPL	Stock	28.27	28.275	28.1125	28.155	16713024.0
2014-11-13 13:30:00	AAPL	Stock	28.155	28.1675	28.045	28.1325	13152476.0
2014-11-13 14:00:00	AAPL	Stock	28.1325	28.18	28.0575	28.1155	8053616.0
2014-11-13 14:30:00	AAPL	Stock	28.1148	28.2175	28.11	28.175	8818692.0
2014-11-13 15:00:00	AAPL	Stock	28.1758	28.3075	28.1625	28.2225	12918828.0
2014-11-13 15:30:00	AAPL	Stock	28.2238	28.25	28.1575	28.205	21634048.0
2014-11-13 16:00:00	AAPL	Stock	28.205	28.2448	28.0825	28.1925	6028540.0
2014-11-13 16:30:00	AAPL	Stock	28.2	28.21	28.19	28.2	129480.0
2014-11-13 17:00:00	AAPL	Stock	28.2025	28.205	28.19	28.2	203600.0
2014-11-13 17:30:00	AAPL	Stock	28.195	28.21	28.1875	28.2	129912.0
2014-11-13 18:00:00	AAPL	Stock	28.1925	28.1975	28.185	28.1875	40440.0
2014-11-13 18:30:00	AAPL	Stock	28.1875	28.2125	28.1875	28.2125	74780.0
2014-11-13 19:00:00	AAPL	Stock	28.2125	28.23	28.2125	28.23	58088.0
2014-11-13 19:30:00	AAPL	Stock	28.23	28.245	28.23	28.245	95520.0
2014-11-13 05:30:00	MSFT	Stock	48.95	48.97	48.95	48.97	540.0
2014-11-13 06:00:00	MSFT	Stock	48.97	48.97	48.97	48.97	2000.0
2014-11-13 06:30:00	MSFT	Stock	48.97	48.97	48.97	48.97	100.0
2014-11-13 07:00:00	MSFT	Stock	48.93	48.93	48.93	48.93	100.0
2014-11-13 08:00:00	MSFT	Stock	48.95	48.95	48.8	48.8	300.0
2014-11-13 08:30:00	MSFT	Stock	48.82	48.82	48.82	48.82	1900.0
2014-11-13 09:00:00	MSFT	Stock	48.86	48.88	48.86	48.87	2700.0
2014-11-13 09:30:00	MSFT	Stock	48.81	49.15	48.705	49.135	2963834.0
2014-11-13 10:00:00	MSFT	Stock	49.135	49.35	49.08	49.31	2605016.0
2014-11-13 10:30:00	MSFT	Stock	49.315	49.456	49.25	49.345	1851025.0
2014-11-13 11:00:00	MSFT	Stock	49.34	49.46	49.16	49.39	2084503.0
2014-11-13 11:30:00	MSFT	Stock	49.39	49.42	49.29	49.34	1150169.0
2014-11-13 12:00:00	MSFT	Stock	49.34	49.5	49.31	49.49	1037876.0
2014-11-13 12:30:00	MSFT	Stock	49.485	49.58	49.48	49.5	1091587.0
2014-11-13 13:00:00	MSFT	Stock	49.505	49.52	49.37	49.405	1114963.0
2014-11-13 13:30:00	MSFT	Stock	49.406	49.41	49.27	49.38	1401314.0
2014-11-13 14:00:00	MSFT	Stock	49.38	49.43	49.32	49.39	1018447.0
2014-11-13 14:30:00	MSFT	Stock	49.39	49.55	49.36	49.504	1352011.0

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

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