PREVIEW / stock_30min / 2016-07-18

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-07-18.parquet
  size:    1.6 MB
  rows:    81,601
  symbols: 3,276

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-07-18 04:00:00	AAPL	Stock	24.6925	24.75	24.6925	24.75	1960.0
2016-07-18 04:30:00	AAPL	Stock	24.75	24.75	24.745	24.745	820.0
2016-07-18 05:00:00	AAPL	Stock	24.7375	24.7375	24.7375	24.7375	400.0
2016-07-18 06:00:00	AAPL	Stock	24.7375	24.7375	24.7075	24.7225	2068.0
2016-07-18 06:30:00	AAPL	Stock	24.7175	24.7225	24.7075	24.7125	9900.0
2016-07-18 07:00:00	AAPL	Stock	24.7225	24.7325	24.7225	24.73	7092.0
2016-07-18 07:30:00	AAPL	Stock	24.7325	24.755	24.7325	24.755	19324.0
2016-07-18 08:00:00	AAPL	Stock	24.7425	24.77	24.7125	24.75	162520.0
2016-07-18 08:30:00	AAPL	Stock	24.7525	24.765	24.745	24.745	115468.0
2016-07-18 09:00:00	AAPL	Stock	24.735	24.77	24.6775	24.6775	316416.0
2016-07-18 09:30:00	AAPL	Stock	24.675	24.8725	24.65	24.8725	18834972.0
2016-07-18 10:00:00	AAPL	Stock	24.8725	24.99	24.8675	24.989	14258128.0
2016-07-18 10:30:00	AAPL	Stock	24.9888	25.02	24.9625	25.0062	16564896.0
2016-07-18 11:00:00	AAPL	Stock	25.006	25.0325	24.98	24.98	10687896.0
2016-07-18 11:30:00	AAPL	Stock	24.98	25.0225	24.9525	24.9985	8606612.0
2016-07-18 12:00:00	AAPL	Stock	24.9975	25.0	24.965	24.9762	5969108.0
2016-07-18 12:30:00	AAPL	Stock	24.9768	24.9775	24.9525	24.9628	5668892.0
2016-07-18 13:00:00	AAPL	Stock	24.9638	24.9912	24.945	24.9775	6497292.0
2016-07-18 13:30:00	AAPL	Stock	24.9775	24.99	24.9575	24.966	4364264.0
2016-07-18 14:00:00	AAPL	Stock	24.965	24.9725	24.905	24.9608	7735556.0
2016-07-18 14:30:00	AAPL	Stock	24.9625	24.99	24.945	24.985	7771384.0
2016-07-18 15:00:00	AAPL	Stock	24.985	24.9875	24.955	24.9738	7599004.0
2016-07-18 15:30:00	AAPL	Stock	24.9738	24.9875	24.955	24.9575	12894020.0
2016-07-18 16:00:00	AAPL	Stock	24.9575	24.9925	24.915	24.9925	7617496.0
2016-07-18 16:30:00	AAPL	Stock	24.9775	24.9775	24.925	24.94	37320.0
2016-07-18 17:00:00	AAPL	Stock	24.935	24.9575	24.9125	24.9275	116240.0
2016-07-18 17:30:00	AAPL	Stock	24.92	24.925	24.92	24.92	3600.0
2016-07-18 18:00:00	AAPL	Stock	24.925	24.94	24.925	24.9375	23492.0
2016-07-18 18:30:00	AAPL	Stock	24.9375	24.94	24.9375	24.94	4136.0
2016-07-18 19:00:00	AAPL	Stock	24.94	24.94	24.9325	24.9325	2800.0
2016-07-18 19:30:00	AAPL	Stock	24.9325	24.9525	24.9325	24.945	8664.0
2016-07-18 06:00:00	MSFT	Stock	53.68	53.68	53.68	53.68	100.0
2016-07-18 07:30:00	MSFT	Stock	53.79	53.8	53.79	53.8	3303.0
2016-07-18 08:00:00	MSFT	Stock	53.7	53.95	53.7	53.95	6050.0
2016-07-18 08:30:00	MSFT	Stock	53.93	53.95	53.78	53.79	4200.0
2016-07-18 09:00:00	MSFT	Stock	53.81	53.81	53.7	53.7	450.0
2016-07-18 09:30:00	MSFT	Stock	53.7	54.0	53.55	53.97	3018026.0
2016-07-18 10:00:00	MSFT	Stock	53.96	54.11	53.94	54.1	1971260.0
2016-07-18 10:30:00	MSFT	Stock	54.1	54.22	54.09	54.125	2056255.0
2016-07-18 11:00:00	MSFT	Stock	54.125	54.27	54.11	54.2	1674473.0
2016-07-18 11:30:00	MSFT	Stock	54.2	54.34	54.17	54.22	1789415.0
2016-07-18 12:00:00	MSFT	Stock	54.215	54.25	54.14	54.175	1129872.0
2016-07-18 12:30:00	MSFT	Stock	54.18	54.2	54.1	54.18	891696.0
2016-07-18 13:00:00	MSFT	Stock	54.175	54.245	54.085	54.12	1245548.0
2016-07-18 13:30:00	MSFT	Stock	54.11	54.24	54.1	54.185	882279.0
2016-07-18 14:00:00	MSFT	Stock	54.18	54.22	54.075	54.09	2001177.0
2016-07-18 14:30:00	MSFT	Stock	54.09	54.095	53.96	54.05	2025918.0
2016-07-18 15:00:00	MSFT	Stock	54.05	54.075	53.92	53.93	1765925.0
2016-07-18 15:30:00	MSFT	Stock	53.935	54.08	53.93	53.97	3945776.0
2016-07-18 16:00:00	MSFT	Stock	53.98	54.112	53.93	53.98	2722519.0

> showing 50 of 81,601 rows — these rows as CSV

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