PREVIEW / stock_1min / 2017-06-12

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-06-12.parquet
  size:    15.5 MB
  rows:    1,123,816
  symbols: 2,507

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
2017-06-12 04:00:00	AAPL	Stock	36.9725	36.9825	36.92	36.92	2584.0
2017-06-12 04:01:00	AAPL	Stock	36.9	36.9	36.875	36.875	2800.0
2017-06-12 04:03:00	AAPL	Stock	36.9	36.9	36.875	36.9	2600.0
2017-06-12 04:04:00	AAPL	Stock	36.9	36.9	36.9	36.9	3408.0
2017-06-12 04:05:00	AAPL	Stock	36.9	36.915	36.9	36.915	952.0
2017-06-12 04:07:00	AAPL	Stock	36.915	36.915	36.915	36.915	3200.0
2017-06-12 04:09:00	AAPL	Stock	36.915	36.915	36.915	36.915	800.0
2017-06-12 04:11:00	AAPL	Stock	36.8825	36.8825	36.875	36.875	6168.0
2017-06-12 04:12:00	AAPL	Stock	36.86	36.86	36.86	36.86	2000.0
2017-06-12 04:13:00	AAPL	Stock	36.86	36.86	36.85	36.85	1492.0
2017-06-12 04:14:00	AAPL	Stock	36.84	36.84	36.84	36.84	2788.0
2017-06-12 04:15:00	AAPL	Stock	36.84	36.84	36.84	36.84	1328.0
2017-06-12 04:17:00	AAPL	Stock	36.84	36.8475	36.8375	36.8475	6428.0
2017-06-12 04:20:00	AAPL	Stock	36.845	36.845	36.845	36.845	400.0
2017-06-12 04:21:00	AAPL	Stock	36.835	36.835	36.7925	36.7925	7956.0
2017-06-12 04:22:00	AAPL	Stock	36.7925	36.7925	36.575	36.625	44636.0
2017-06-12 04:23:00	AAPL	Stock	36.625	36.625	36.625	36.625	11428.0
2017-06-12 04:24:00	AAPL	Stock	36.625	36.625	36.625	36.625	1296.0
2017-06-12 04:25:00	AAPL	Stock	36.665	36.665	36.605	36.605	7272.0
2017-06-12 04:26:00	AAPL	Stock	36.6075	36.6075	36.6075	36.6075	1612.0
2017-06-12 04:28:00	AAPL	Stock	36.605	36.605	36.5925	36.5925	2008.0
2017-06-12 04:29:00	AAPL	Stock	36.5625	36.5625	36.5625	36.5625	1640.0
2017-06-12 04:31:00	AAPL	Stock	36.525	36.525	36.525	36.525	400.0
2017-06-12 04:32:00	AAPL	Stock	36.525	36.525	36.5	36.5	4920.0
2017-06-12 04:33:00	AAPL	Stock	36.5	36.5	36.475	36.5	8340.0
2017-06-12 04:34:00	AAPL	Stock	36.45	36.5625	36.425	36.425	11660.0
2017-06-12 04:35:00	AAPL	Stock	36.4275	36.4275	36.375	36.4	14008.0
2017-06-12 04:36:00	AAPL	Stock	36.35	36.35	36.3	36.3	10248.0
2017-06-12 04:37:00	AAPL	Stock	36.3	36.3	36.275	36.275	6040.0
2017-06-12 04:38:00	AAPL	Stock	36.275	36.3375	36.275	36.3375	5280.0
2017-06-12 04:39:00	AAPL	Stock	36.35	36.365	36.3375	36.365	23960.0
2017-06-12 04:40:00	AAPL	Stock	36.385	36.385	36.385	36.385	800.0
2017-06-12 04:42:00	AAPL	Stock	36.3375	36.3375	36.3375	36.3375	15644.0
2017-06-12 04:45:00	AAPL	Stock	36.33	36.33	36.33	36.33	400.0
2017-06-12 04:46:00	AAPL	Stock	36.305	36.305	36.305	36.305	468.0
2017-06-12 04:48:00	AAPL	Stock	36.33	36.33	36.33	36.33	2668.0
2017-06-12 04:49:00	AAPL	Stock	36.375	36.375	36.375	36.375	536.0
2017-06-12 04:53:00	AAPL	Stock	36.3025	36.3025	36.3025	36.3025	400.0
2017-06-12 04:57:00	AAPL	Stock	36.3	36.3	36.3	36.3	400.0
2017-06-12 04:59:00	AAPL	Stock	36.325	36.325	36.325	36.325	976.0
2017-06-12 05:01:00	AAPL	Stock	36.3425	36.3425	36.325	36.325	3600.0
2017-06-12 05:05:00	AAPL	Stock	36.3525	36.355	36.3525	36.355	1276.0
2017-06-12 05:06:00	AAPL	Stock	36.3775	36.38	36.3775	36.38	2400.0
2017-06-12 05:07:00	AAPL	Stock	36.38	36.385	36.38	36.385	18692.0
2017-06-12 05:08:00	AAPL	Stock	36.41	36.41	36.41	36.41	400.0
2017-06-12 05:09:00	AAPL	Stock	36.3775	36.3775	36.3775	36.3775	400.0
2017-06-12 05:11:00	AAPL	Stock	36.425	36.425	36.425	36.425	400.0
2017-06-12 05:12:00	AAPL	Stock	36.425	36.425	36.425	36.425	1260.0
2017-06-12 05:23:00	AAPL	Stock	36.4475	36.4475	36.4475	36.4475	400.0
2017-06-12 05:26:00	AAPL	Stock	36.4425	36.4475	36.4425	36.4475	2000.0

> showing 50 of 1,123,816 rows — these rows as CSV

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