PREVIEW / stock_1min / 2017-06-23

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-06-23.parquet
  size:    14.5 MB
  rows:    1,058,183
  symbols: 2,482

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-23 06:17:00	AAPL	Stock	36.4875	36.4875	36.4875	36.4875	1600.0
2017-06-23 06:26:00	AAPL	Stock	36.425	36.425	36.42	36.42	3200.0
2017-06-23 06:27:00	AAPL	Stock	36.42	36.42	36.4125	36.4125	1600.0
2017-06-23 06:36:00	AAPL	Stock	36.4	36.4	36.4	36.4	1188.0
2017-06-23 06:45:00	AAPL	Stock	36.38	36.38	36.3775	36.3775	1200.0
2017-06-23 06:46:00	AAPL	Stock	36.38	36.38	36.365	36.365	2400.0
2017-06-23 06:57:00	AAPL	Stock	36.38	36.38	36.38	36.38	400.0
2017-06-23 07:00:00	AAPL	Stock	36.365	36.365	36.365	36.365	1000.0
2017-06-23 07:01:00	AAPL	Stock	36.365	36.365	36.365	36.365	1000.0
2017-06-23 07:02:00	AAPL	Stock	36.365	36.365	36.365	36.365	400.0
2017-06-23 07:07:00	AAPL	Stock	36.38	36.3875	36.38	36.3875	1444.0
2017-06-23 07:12:00	AAPL	Stock	36.3925	36.3925	36.3875	36.3875	5664.0
2017-06-23 07:13:00	AAPL	Stock	36.375	36.375	36.375	36.375	1200.0
2017-06-23 07:18:00	AAPL	Stock	36.3875	36.3875	36.3875	36.3875	2000.0
2017-06-23 07:27:00	AAPL	Stock	36.375	36.3775	36.3675	36.3675	1800.0
2017-06-23 07:28:00	AAPL	Stock	36.3625	36.3675	36.3625	36.3675	3200.0
2017-06-23 07:38:00	AAPL	Stock	36.3675	36.3675	36.3675	36.3675	868.0
2017-06-23 07:47:00	AAPL	Stock	36.3675	36.3675	36.3675	36.3675	1780.0
2017-06-23 07:49:00	AAPL	Stock	36.3675	36.3675	36.3675	36.3675	800.0
2017-06-23 07:55:00	AAPL	Stock	36.3575	36.3575	36.355	36.355	4000.0
2017-06-23 08:00:00	AAPL	Stock	36.3625	36.3875	36.3625	36.3675	5092.0
2017-06-23 08:01:00	AAPL	Stock	36.3675	36.3675	36.3675	36.3675	1200.0
2017-06-23 08:02:00	AAPL	Stock	36.3675	36.3675	36.3675	36.3675	4560.0
2017-06-23 08:03:00	AAPL	Stock	36.3625	36.3625	36.3625	36.3625	400.0
2017-06-23 08:04:00	AAPL	Stock	36.3625	36.3675	36.3625	36.3675	1200.0
2017-06-23 08:07:00	AAPL	Stock	36.3675	36.3675	36.3675	36.3675	10000.0
2017-06-23 08:09:00	AAPL	Stock	36.3675	36.3675	36.3675	36.3675	12000.0
2017-06-23 08:11:00	AAPL	Stock	36.3675	36.3675	36.3675	36.3675	800.0
2017-06-23 08:14:00	AAPL	Stock	36.3525	36.3525	36.3525	36.3525	5300.0
2017-06-23 08:18:00	AAPL	Stock	36.3675	36.3675	36.3675	36.3675	2800.0
2017-06-23 08:23:00	AAPL	Stock	36.3675	36.3675	36.3675	36.3675	1200.0
2017-06-23 08:25:00	AAPL	Stock	36.3575	36.3575	36.3575	36.3575	600.0
2017-06-23 08:30:00	AAPL	Stock	36.3575	36.3575	36.3575	36.3575	444.0
2017-06-23 08:33:00	AAPL	Stock	36.35	36.3575	36.325	36.325	14464.0
2017-06-23 08:39:00	AAPL	Stock	36.335	36.335	36.335	36.335	800.0
2017-06-23 08:40:00	AAPL	Stock	36.335	36.335	36.335	36.335	1992.0
2017-06-23 08:41:00	AAPL	Stock	36.3375	36.3375	36.3375	36.3375	1200.0
2017-06-23 08:48:00	AAPL	Stock	36.345	36.345	36.345	36.345	2400.0
2017-06-23 08:49:00	AAPL	Stock	36.345	36.345	36.345	36.345	4800.0
2017-06-23 08:50:00	AAPL	Stock	36.345	36.345	36.345	36.345	400.0
2017-06-23 08:53:00	AAPL	Stock	36.345	36.345	36.345	36.345	1000.0
2017-06-23 08:54:00	AAPL	Stock	36.345	36.345	36.345	36.345	400.0
2017-06-23 08:55:00	AAPL	Stock	36.345	36.345	36.345	36.345	6448.0
2017-06-23 08:56:00	AAPL	Stock	36.345	36.345	36.345	36.345	1200.0
2017-06-23 08:57:00	AAPL	Stock	36.345	36.345	36.345	36.345	7600.0
2017-06-23 08:58:00	AAPL	Stock	36.345	36.345	36.3375	36.3375	6228.0
2017-06-23 08:59:00	AAPL	Stock	36.38	36.38	36.38	36.38	588.0
2017-06-23 09:01:00	AAPL	Stock	36.38	36.38	36.38	36.38	4800.0
2017-06-23 09:02:00	AAPL	Stock	36.3525	36.3525	36.3525	36.3525	400.0
2017-06-23 09:03:00	AAPL	Stock	36.3525	36.3525	36.3525	36.3525	400.0

> showing 50 of 1,058,183 rows — these rows as CSV

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