PREVIEW / stock_30min / 2015-02-17

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-02-17.parquet
  size:    1.6 MB
  rows:    83,751
  symbols: 3,536

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-02-17 04:00:00	AAPL	Stock	31.65	32.0	31.65	31.87	77532.0
2015-02-17 04:30:00	AAPL	Stock	31.86	31.9225	31.86	31.9125	50716.0
2015-02-17 05:00:00	AAPL	Stock	31.9075	31.975	31.9025	31.9375	60584.0
2015-02-17 05:30:00	AAPL	Stock	31.9375	32.02	31.9375	32.015	23780.0
2015-02-17 06:00:00	AAPL	Stock	32.0	32.0875	31.9875	32.0875	121884.0
2015-02-17 06:30:00	AAPL	Stock	32.065	32.1175	32.0625	32.085	94408.0
2015-02-17 07:00:00	AAPL	Stock	32.0825	32.0925	32.0	32.0525	183220.0
2015-02-17 07:30:00	AAPL	Stock	32.05	32.0975	32.04	32.09	160788.0
2015-02-17 08:00:00	AAPL	Stock	32.0825	32.095	31.5875	32.0375	919592.0
2015-02-17 08:30:00	AAPL	Stock	32.0375	32.04	31.9225	31.955	902372.0
2015-02-17 09:00:00	AAPL	Stock	31.94	31.9625	31.8375	31.8425	1378144.0
2015-02-17 09:30:00	AAPL	Stock	31.8425	31.9725	31.73	31.9	39051592.0
2015-02-17 10:00:00	AAPL	Stock	31.9	32.115	31.9	32.1098	26930304.0
2015-02-17 10:30:00	AAPL	Stock	32.11	32.22	32.1075	32.13	21969176.0
2015-02-17 11:00:00	AAPL	Stock	32.13	32.1712	32.0075	32.1125	20153888.0
2015-02-17 11:30:00	AAPL	Stock	32.115	32.1422	32.0425	32.111	10270336.0
2015-02-17 12:00:00	AAPL	Stock	32.11	32.1225	31.9725	32.0225	12560916.0
2015-02-17 12:30:00	AAPL	Stock	32.0225	32.0625	31.8175	31.86	16363408.0
2015-02-17 13:00:00	AAPL	Stock	31.8575	31.98	31.8575	31.9525	10986892.0
2015-02-17 13:30:00	AAPL	Stock	31.95	31.9525	31.845	31.9115	10185156.0
2015-02-17 14:00:00	AAPL	Stock	31.91	31.9225	31.835	31.91	8645724.0
2015-02-17 14:30:00	AAPL	Stock	31.9088	31.9438	31.8825	31.9162	8340676.0
2015-02-17 15:00:00	AAPL	Stock	31.9175	32.03	31.905	31.9925	13440728.0
2015-02-17 15:30:00	AAPL	Stock	31.9925	32.0	31.8825	31.955	20697692.0
2015-02-17 16:00:00	AAPL	Stock	31.955	32.1592	31.861	31.9175	8469372.0
2015-02-17 16:30:00	AAPL	Stock	31.9225	31.966	31.92	31.93	107100.0
2015-02-17 17:00:00	AAPL	Stock	31.935	31.9375	31.925	31.9375	73700.0
2015-02-17 17:30:00	AAPL	Stock	31.935	31.9575	31.9275	31.9325	49804.0
2015-02-17 18:00:00	AAPL	Stock	31.9275	31.9575	31.92	31.94	214656.0
2015-02-17 18:30:00	AAPL	Stock	31.94	31.945	31.9275	31.9325	49188.0
2015-02-17 19:00:00	AAPL	Stock	31.9325	31.9325	31.92	31.92	49068.0
2015-02-17 19:30:00	AAPL	Stock	31.91	31.9325	31.905	31.925	172660.0
2015-02-17 04:00:00	MSFT	Stock	43.6	43.6	43.4	43.48	2900.0
2015-02-17 04:30:00	MSFT	Stock	43.48	43.5	43.48	43.5	700.0
2015-02-17 05:30:00	MSFT	Stock	43.52	43.53	43.23	43.53	1600.0
2015-02-17 06:00:00	MSFT	Stock	43.47	43.47	43.47	43.47	200.0
2015-02-17 07:00:00	MSFT	Stock	43.53	43.53	43.5	43.53	2300.0
2015-02-17 07:30:00	MSFT	Stock	43.53	43.53	43.53	43.53	3730.0
2015-02-17 08:00:00	MSFT	Stock	43.65	43.69	43.52	43.56	14131.0
2015-02-17 08:30:00	MSFT	Stock	43.6	43.6	43.51	43.56	8838.0
2015-02-17 09:00:00	MSFT	Stock	43.56	43.98	43.55	43.98	45571.0
2015-02-17 09:30:00	MSFT	Stock	43.97	44.0	43.24	43.33	5438014.0
2015-02-17 10:00:00	MSFT	Stock	43.34	43.35	43.21	43.275	2176134.0
2015-02-17 10:30:00	MSFT	Stock	43.27	43.32	43.22	43.225	1925058.0
2015-02-17 11:00:00	MSFT	Stock	43.227	43.3	43.19	43.3	1751623.0
2015-02-17 11:30:00	MSFT	Stock	43.3	43.33	43.25	43.305	1242730.0
2015-02-17 12:00:00	MSFT	Stock	43.305	43.32	43.22	43.24	1549684.0
2015-02-17 12:30:00	MSFT	Stock	43.24	43.325	43.22	43.312	1365766.0
2015-02-17 13:00:00	MSFT	Stock	43.32	43.445	43.28	43.425	1546450.0
2015-02-17 13:30:00	MSFT	Stock	43.435	43.45	43.35	43.386	1025688.0

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

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