PREVIEW / stock_1min / 2017-08-14

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-08-14.parquet
  size:    14.1 MB
  rows:    1,028,116
  symbols: 2,472

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-08-14 04:00:00	AAPL	Stock	39.65	39.65	39.65	39.65	400.0
2017-08-14 04:07:00	AAPL	Stock	39.6625	39.6625	39.65	39.65	17276.0
2017-08-14 04:19:00	AAPL	Stock	39.65	39.65	39.65	39.65	1852.0
2017-08-14 04:20:00	AAPL	Stock	39.65	39.65	39.65	39.65	804.0
2017-08-14 04:21:00	AAPL	Stock	39.65	39.65	39.65	39.65	2800.0
2017-08-14 04:28:00	AAPL	Stock	39.65	39.65	39.65	39.65	6852.0
2017-08-14 04:34:00	AAPL	Stock	39.65	39.65	39.65	39.65	3100.0
2017-08-14 04:36:00	AAPL	Stock	39.5875	39.5875	39.5875	39.5875	800.0
2017-08-14 04:37:00	AAPL	Stock	39.605	39.605	39.6	39.6	7596.0
2017-08-14 04:45:00	AAPL	Stock	39.625	39.625	39.625	39.625	3176.0
2017-08-14 04:47:00	AAPL	Stock	39.625	39.625	39.625	39.625	400.0
2017-08-14 04:52:00	AAPL	Stock	39.65	39.65	39.65	39.65	768.0
2017-08-14 04:53:00	AAPL	Stock	39.625	39.625	39.625	39.625	11580.0
2017-08-14 04:54:00	AAPL	Stock	39.6175	39.6175	39.6175	39.6175	2800.0
2017-08-14 04:56:00	AAPL	Stock	39.6125	39.6125	39.6	39.6	1036.0
2017-08-14 04:59:00	AAPL	Stock	39.645	39.65	39.645	39.65	7600.0
2017-08-14 05:01:00	AAPL	Stock	39.6525	39.6525	39.6525	39.6525	400.0
2017-08-14 05:08:00	AAPL	Stock	39.6725	39.6725	39.6725	39.6725	2000.0
2017-08-14 05:09:00	AAPL	Stock	39.65	39.65	39.65	39.65	400.0
2017-08-14 05:10:00	AAPL	Stock	39.6625	39.6625	39.6625	39.6625	400.0
2017-08-14 05:13:00	AAPL	Stock	39.6725	39.6725	39.6725	39.6725	400.0
2017-08-14 05:18:00	AAPL	Stock	39.6625	39.6625	39.6625	39.6625	800.0
2017-08-14 05:23:00	AAPL	Stock	39.6625	39.6625	39.6625	39.6625	5900.0
2017-08-14 05:24:00	AAPL	Stock	39.6725	39.6725	39.6725	39.6725	1200.0
2017-08-14 05:26:00	AAPL	Stock	39.6625	39.6625	39.6625	39.6625	1988.0
2017-08-14 05:32:00	AAPL	Stock	39.675	39.675	39.675	39.675	1560.0
2017-08-14 05:36:00	AAPL	Stock	39.6925	39.6925	39.6925	39.6925	400.0
2017-08-14 05:40:00	AAPL	Stock	39.7225	39.7225	39.7225	39.7225	800.0
2017-08-14 05:41:00	AAPL	Stock	39.6875	39.6875	39.6875	39.6875	400.0
2017-08-14 05:45:00	AAPL	Stock	39.725	39.725	39.725	39.725	3600.0
2017-08-14 05:56:00	AAPL	Stock	39.7075	39.7075	39.7075	39.7075	8380.0
2017-08-14 05:57:00	AAPL	Stock	39.7075	39.7075	39.7075	39.7075	3200.0
2017-08-14 06:01:00	AAPL	Stock	39.7	39.7	39.6875	39.6875	6652.0
2017-08-14 06:02:00	AAPL	Stock	39.6775	39.7325	39.6775	39.725	7736.0
2017-08-14 06:03:00	AAPL	Stock	39.68	39.68	39.6725	39.6725	12172.0
2017-08-14 06:04:00	AAPL	Stock	39.6725	39.6725	39.6725	39.6725	800.0
2017-08-14 06:05:00	AAPL	Stock	39.6725	39.6725	39.6725	39.6725	1764.0
2017-08-14 06:06:00	AAPL	Stock	39.6725	39.6725	39.6725	39.6725	800.0
2017-08-14 06:27:00	AAPL	Stock	39.7	39.725	39.7	39.725	1000.0
2017-08-14 06:29:00	AAPL	Stock	39.6875	39.6875	39.6875	39.6875	4000.0
2017-08-14 06:31:00	AAPL	Stock	39.7	39.7	39.7	39.7	1600.0
2017-08-14 06:44:00	AAPL	Stock	39.7125	39.7125	39.7125	39.7125	800.0
2017-08-14 06:45:00	AAPL	Stock	39.7125	39.72	39.7125	39.72	1200.0
2017-08-14 06:46:00	AAPL	Stock	39.715	39.715	39.715	39.715	400.0
2017-08-14 06:51:00	AAPL	Stock	39.715	39.715	39.7125	39.7125	880.0
2017-08-14 06:58:00	AAPL	Stock	39.7075	39.7075	39.705	39.705	2536.0
2017-08-14 06:59:00	AAPL	Stock	39.705	39.705	39.7	39.705	7600.0
2017-08-14 07:00:00	AAPL	Stock	39.7125	39.7225	39.7125	39.7125	4800.0
2017-08-14 07:01:00	AAPL	Stock	39.7125	39.7225	39.7125	39.7225	9728.0
2017-08-14 07:02:00	AAPL	Stock	39.7225	39.7225	39.7225	39.7225	6000.0

> showing 50 of 1,028,116 rows — these rows as CSV

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