PREVIEW / stock_1min / 2017-08-18

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-08-18.parquet
  size:    14.0 MB
  rows:    1,020,000
  symbols: 2,459

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-18 04:00:00	AAPL	Stock	39.45	39.45	39.45	39.45	1200.0
2017-08-18 04:01:00	AAPL	Stock	39.45	39.45	39.45	39.45	2400.0
2017-08-18 04:06:00	AAPL	Stock	39.4525	39.4525	39.45	39.45	3964.0
2017-08-18 04:40:00	AAPL	Stock	39.5	39.5	39.5	39.5	1908.0
2017-08-18 05:04:00	AAPL	Stock	39.5	39.5	39.5	39.5	608.0
2017-08-18 05:27:00	AAPL	Stock	39.5	39.5	39.5	39.5	800.0
2017-08-18 05:32:00	AAPL	Stock	39.5	39.5	39.5	39.5	896.0
2017-08-18 05:33:00	AAPL	Stock	39.5	39.5	39.5	39.5	800.0
2017-08-18 05:57:00	AAPL	Stock	39.525	39.525	39.525	39.525	784.0
2017-08-18 06:01:00	AAPL	Stock	39.5625	39.5625	39.5625	39.5625	2152.0
2017-08-18 06:03:00	AAPL	Stock	39.6	39.6	39.6	39.6	2000.0
2017-08-18 06:07:00	AAPL	Stock	39.6125	39.6125	39.6125	39.6125	400.0
2017-08-18 06:11:00	AAPL	Stock	39.67	39.675	39.67	39.675	2056.0
2017-08-18 06:12:00	AAPL	Stock	39.65	39.69	39.65	39.69	6784.0
2017-08-18 06:13:00	AAPL	Stock	39.7125	39.7125	39.7125	39.7125	844.0
2017-08-18 06:15:00	AAPL	Stock	39.75	39.75	39.7025	39.7025	2236.0
2017-08-18 06:18:00	AAPL	Stock	39.715	39.715	39.715	39.715	400.0
2017-08-18 06:21:00	AAPL	Stock	39.6925	39.6925	39.6875	39.6875	16120.0
2017-08-18 06:22:00	AAPL	Stock	39.6875	39.6875	39.6875	39.6875	17600.0
2017-08-18 06:23:00	AAPL	Stock	39.6575	39.6575	39.6575	39.6575	1200.0
2017-08-18 06:28:00	AAPL	Stock	39.705	39.705	39.705	39.705	400.0
2017-08-18 06:33:00	AAPL	Stock	39.7	39.705	39.7	39.705	2400.0
2017-08-18 06:35:00	AAPL	Stock	39.7125	39.745	39.7125	39.745	1956.0
2017-08-18 06:36:00	AAPL	Stock	39.7375	39.7375	39.7375	39.7375	1200.0
2017-08-18 06:37:00	AAPL	Stock	39.705	39.705	39.705	39.705	400.0
2017-08-18 06:40:00	AAPL	Stock	39.7075	39.7075	39.7075	39.7075	400.0
2017-08-18 06:42:00	AAPL	Stock	39.7175	39.7175	39.7175	39.7175	1200.0
2017-08-18 06:44:00	AAPL	Stock	39.7125	39.7125	39.705	39.705	2800.0
2017-08-18 06:50:00	AAPL	Stock	39.705	39.705	39.705	39.705	400.0
2017-08-18 06:53:00	AAPL	Stock	39.7	39.7	39.7	39.7	3600.0
2017-08-18 07:00:00	AAPL	Stock	39.7075	39.71	39.7075	39.71	10000.0
2017-08-18 07:01:00	AAPL	Stock	39.675	39.675	39.675	39.675	600.0
2017-08-18 07:02:00	AAPL	Stock	39.675	39.675	39.675	39.675	1332.0
2017-08-18 07:04:00	AAPL	Stock	39.6625	39.675	39.6625	39.675	2800.0
2017-08-18 07:05:00	AAPL	Stock	39.675	39.675	39.675	39.675	1200.0
2017-08-18 07:06:00	AAPL	Stock	39.6975	39.6975	39.6975	39.6975	1200.0
2017-08-18 07:07:00	AAPL	Stock	39.6975	39.6975	39.685	39.685	1000.0
2017-08-18 07:08:00	AAPL	Stock	39.675	39.675	39.675	39.675	800.0
2017-08-18 07:09:00	AAPL	Stock	39.68	39.68	39.64	39.65	10848.0
2017-08-18 07:10:00	AAPL	Stock	39.6425	39.6425	39.625	39.625	6600.0
2017-08-18 07:18:00	AAPL	Stock	39.6625	39.665	39.6575	39.6575	2400.0
2017-08-18 07:19:00	AAPL	Stock	39.6575	39.6575	39.6575	39.6575	580.0
2017-08-18 07:20:00	AAPL	Stock	39.66	39.66	39.66	39.66	536.0
2017-08-18 07:21:00	AAPL	Stock	39.6275	39.6275	39.625	39.625	4128.0
2017-08-18 07:22:00	AAPL	Stock	39.6125	39.6125	39.6125	39.6125	400.0
2017-08-18 07:24:00	AAPL	Stock	39.6025	39.6025	39.6025	39.6025	800.0
2017-08-18 07:29:00	AAPL	Stock	39.605	39.6125	39.6025	39.6125	3980.0
2017-08-18 07:34:00	AAPL	Stock	39.6125	39.6125	39.6125	39.6125	800.0
2017-08-18 07:35:00	AAPL	Stock	39.6125	39.6125	39.6125	39.6125	1964.0
2017-08-18 07:36:00	AAPL	Stock	39.6	39.6225	39.6	39.6225	8252.0

> showing 50 of 1,020,000 rows — these rows as CSV

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