PREVIEW / stock_30min / 2016-09-08

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-09-08.parquet
  size:    1.6 MB
  rows:    82,453
  symbols: 3,245

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-09-08 04:00:00	AAPL	Stock	27.0525	27.06	26.95	26.97	25200.0
2016-09-08 04:30:00	AAPL	Stock	26.9875	26.9875	26.9875	26.9875	400.0
2016-09-08 05:00:00	AAPL	Stock	26.975	26.9875	26.9625	26.975	24488.0
2016-09-08 05:30:00	AAPL	Stock	26.9425	26.9425	26.8975	26.9	59648.0
2016-09-08 06:00:00	AAPL	Stock	26.9075	26.9625	26.9	26.93	48812.0
2016-09-08 06:30:00	AAPL	Stock	26.96	26.96	26.9375	26.9375	4000.0
2016-09-08 07:00:00	AAPL	Stock	26.9375	27.0375	26.93	27.015	149768.0
2016-09-08 07:30:00	AAPL	Stock	27.0375	27.0625	27.0	27.0	123336.0
2016-09-08 08:00:00	AAPL	Stock	27.0025	27.0625	26.9	26.9675	408908.0
2016-09-08 08:30:00	AAPL	Stock	26.97	27.01	26.94	26.95	398616.0
2016-09-08 09:00:00	AAPL	Stock	26.9575	26.9575	26.7775	26.7775	993256.0
2016-09-08 09:30:00	AAPL	Stock	26.8075	26.8175	26.455	26.5425	45699292.0
2016-09-08 10:00:00	AAPL	Stock	26.5402	26.56	26.4425	26.5075	17649236.0
2016-09-08 10:30:00	AAPL	Stock	26.5075	26.55	26.41	26.45	15151912.0
2016-09-08 11:00:00	AAPL	Stock	26.45	26.525	26.4225	26.455	11831832.0
2016-09-08 11:30:00	AAPL	Stock	26.4575	26.5175	26.445	26.515	7585924.0
2016-09-08 12:00:00	AAPL	Stock	26.515	26.5325	26.4185	26.429	7124432.0
2016-09-08 12:30:00	AAPL	Stock	26.425	26.4425	26.3875	26.4212	6095132.0
2016-09-08 13:00:00	AAPL	Stock	26.42	26.4325	26.38	26.3825	5735464.0
2016-09-08 13:30:00	AAPL	Stock	26.385	26.3975	26.31	26.3512	11543180.0
2016-09-08 14:00:00	AAPL	Stock	26.35	26.4775	26.339	26.4225	17622860.0
2016-09-08 14:30:00	AAPL	Stock	26.4225	26.4425	26.3775	26.4275	8921880.0
2016-09-08 15:00:00	AAPL	Stock	26.428	26.4425	26.3625	26.38	8235808.0
2016-09-08 15:30:00	AAPL	Stock	26.38	26.4025	26.33	26.3775	19507060.0
2016-09-08 16:00:00	AAPL	Stock	26.3775	26.397	26.335	26.38	8573660.0
2016-09-08 16:30:00	AAPL	Stock	26.375	26.4772	26.365	26.365	1066988.0
2016-09-08 17:00:00	AAPL	Stock	26.365	26.3825	26.35	26.3725	40300.0
2016-09-08 17:30:00	AAPL	Stock	26.3575	26.3775	26.3575	26.3625	27968.0
2016-09-08 18:00:00	AAPL	Stock	26.3775	26.3775	26.375	26.375	13260.0
2016-09-08 18:30:00	AAPL	Stock	26.375	26.38	26.37	26.38	13160.0
2016-09-08 19:00:00	AAPL	Stock	26.38	26.38	26.37	26.375	24924.0
2016-09-08 19:30:00	AAPL	Stock	26.375	26.38	26.3575	26.3575	41160.0
2016-09-08 07:30:00	MSFT	Stock	57.57	57.57	57.57	57.57	100.0
2016-09-08 08:00:00	MSFT	Stock	57.57	57.57	57.57	57.57	239.0
2016-09-08 08:30:00	MSFT	Stock	57.57	57.57	57.57	57.57	500.0
2016-09-08 09:00:00	MSFT	Stock	57.5	57.71	57.5	57.7	21207.0
2016-09-08 09:30:00	MSFT	Stock	57.62	57.79	57.41	57.43	2674756.0
2016-09-08 10:00:00	MSFT	Stock	57.422	57.565	57.355	57.522	1247788.0
2016-09-08 10:30:00	MSFT	Stock	57.53	57.64	57.514	57.59	1153138.0
2016-09-08 11:00:00	MSFT	Stock	57.59	57.66	57.51	57.53	1255458.0
2016-09-08 11:30:00	MSFT	Stock	57.535	57.55	57.45	57.465	954287.0
2016-09-08 12:00:00	MSFT	Stock	57.465	57.5	57.38	57.415	815205.0
2016-09-08 12:30:00	MSFT	Stock	57.41	57.415	57.32	57.335	846159.0
2016-09-08 13:00:00	MSFT	Stock	57.33	57.38	57.29	57.291	816089.0
2016-09-08 13:30:00	MSFT	Stock	57.291	57.32	57.18	57.315	986061.0
2016-09-08 14:00:00	MSFT	Stock	57.31	57.364	57.25	57.295	675008.0
2016-09-08 14:30:00	MSFT	Stock	57.29	57.4	57.25	57.39	812348.0
2016-09-08 15:00:00	MSFT	Stock	57.397	57.5	57.37	57.445	1539418.0
2016-09-08 15:30:00	MSFT	Stock	57.447	57.49	57.41	57.42	1838133.0
2016-09-08 16:00:00	MSFT	Stock	57.43	57.43	57.33	57.43	1492700.0

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

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