PREVIEW / stock_30min / 2016-08-08

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-08-08.parquet
  size:    1.6 MB
  rows:    82,345
  symbols: 3,260

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-08-08 04:00:00	AAPL	Stock	26.895	26.895	26.895	26.895	880.0
2016-08-08 04:30:00	AAPL	Stock	26.9125	26.9125	26.885	26.885	6476.0
2016-08-08 05:30:00	AAPL	Stock	26.89	26.9225	26.89	26.9225	2000.0
2016-08-08 06:00:00	AAPL	Stock	26.89	26.8975	26.89	26.8975	4840.0
2016-08-08 06:30:00	AAPL	Stock	26.97	26.98	26.9375	26.95	4556.0
2016-08-08 07:00:00	AAPL	Stock	26.94	26.9725	26.925	26.945	39096.0
2016-08-08 07:30:00	AAPL	Stock	26.9375	26.9625	26.9325	26.9375	27104.0
2016-08-08 08:00:00	AAPL	Stock	26.9375	26.97	26.9325	26.955	196060.0
2016-08-08 08:30:00	AAPL	Stock	26.955	26.9575	26.915	26.915	218556.0
2016-08-08 09:00:00	AAPL	Stock	26.925	26.94	26.875	26.8775	252364.0
2016-08-08 09:30:00	AAPL	Stock	26.8875	26.99	26.79	26.8552	21249460.0
2016-08-08 10:00:00	AAPL	Stock	26.8562	26.925	26.85	26.865	8325868.0
2016-08-08 10:30:00	AAPL	Stock	26.865	26.9325	26.8625	26.9238	6607844.0
2016-08-08 11:00:00	AAPL	Stock	26.9248	26.9675	26.915	26.9625	5351804.0
2016-08-08 11:30:00	AAPL	Stock	26.9625	27.0	26.95	26.9925	7099724.0
2016-08-08 12:00:00	AAPL	Stock	26.9925	27.015	26.98	27.0072	5263132.0
2016-08-08 12:30:00	AAPL	Stock	27.0075	27.0238	26.9825	27.0025	3680724.0
2016-08-08 13:00:00	AAPL	Stock	27.005	27.0375	26.9775	27.025	4083764.0
2016-08-08 13:30:00	AAPL	Stock	27.025	27.045	27.01	27.0328	3629172.0
2016-08-08 14:00:00	AAPL	Stock	27.0332	27.0332	26.98	26.9875	4975264.0
2016-08-08 14:30:00	AAPL	Stock	26.985	27.0225	26.9725	27.0188	3134388.0
2016-08-08 15:00:00	AAPL	Stock	27.0198	27.07	27.0125	27.0675	4814268.0
2016-08-08 15:30:00	AAPL	Stock	27.07	27.0925	27.055	27.0925	10224396.0
2016-08-08 16:00:00	AAPL	Stock	27.0925	27.1075	26.9405	27.0875	15060344.0
2016-08-08 16:30:00	AAPL	Stock	27.0875	27.1025	27.0875	27.0975	21684.0
2016-08-08 17:00:00	AAPL	Stock	27.0975	27.0975	27.0875	27.0925	312028.0
2016-08-08 17:30:00	AAPL	Stock	27.095	27.1025	27.0925	27.0925	10432.0
2016-08-08 18:00:00	AAPL	Stock	27.0925	27.0925	27.09	27.09	31336.0
2016-08-08 18:30:00	AAPL	Stock	27.1	27.1	27.0875	27.0975	8788.0
2016-08-08 19:00:00	AAPL	Stock	27.0975	27.0975	27.0875	27.0875	9176.0
2016-08-08 19:30:00	AAPL	Stock	27.0925	27.0925	27.0775	27.0925	21460.0
2016-08-08 04:30:00	MSFT	Stock	58.0	58.0	58.0	58.0	240.0
2016-08-08 07:00:00	MSFT	Stock	58.01	58.01	58.0	58.0	600.0
2016-08-08 07:30:00	MSFT	Stock	58.16	58.16	58.01	58.01	500.0
2016-08-08 08:00:00	MSFT	Stock	58.01	58.1	58.01	58.1	3642.0
2016-08-08 08:30:00	MSFT	Stock	58.1	58.1	58.05	58.1	768.0
2016-08-08 09:00:00	MSFT	Stock	58.1	58.11	57.89	58.03	66737.0
2016-08-08 09:30:00	MSFT	Stock	58.05	58.08	57.81	57.875	2195714.0
2016-08-08 10:00:00	MSFT	Stock	57.88	57.99	57.85	57.92	1552611.0
2016-08-08 10:30:00	MSFT	Stock	57.92	58.02	57.91	58.0	1323217.0
2016-08-08 11:00:00	MSFT	Stock	58.0	58.06	57.89	57.921	1252021.0
2016-08-08 11:30:00	MSFT	Stock	57.93	57.95	57.88	57.906	621529.0
2016-08-08 12:00:00	MSFT	Stock	57.91	57.93	57.78	57.847	632934.0
2016-08-08 12:30:00	MSFT	Stock	57.845	57.95	57.84	57.86	680071.0
2016-08-08 13:00:00	MSFT	Stock	57.851	57.91	57.83	57.895	453120.0
2016-08-08 13:30:00	MSFT	Stock	57.89	57.92	57.81	57.915	575780.0
2016-08-08 14:00:00	MSFT	Stock	57.91	57.92	57.82	57.855	1378243.0
2016-08-08 14:30:00	MSFT	Stock	57.85	57.99	57.845	57.95	835740.0
2016-08-08 15:00:00	MSFT	Stock	57.955	58.02	57.95	57.99	1077916.0
2016-08-08 15:30:00	MSFT	Stock	57.99	58.085	57.98	58.06	3407446.0

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

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