PREVIEW / stock_1min / 2017-08-28

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-08-28.parquet
  size:    13.6 MB
  rows:    986,395
  symbols: 2,477

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-28 06:23:00	AAPL	Stock	39.94	39.94	39.94	39.94	400.0
2017-08-28 06:35:00	AAPL	Stock	39.9125	39.9125	39.9125	39.9125	400.0
2017-08-28 06:47:00	AAPL	Stock	39.95	39.95	39.95	39.95	1140.0
2017-08-28 06:48:00	AAPL	Stock	39.9525	39.9525	39.95	39.95	6000.0
2017-08-28 06:54:00	AAPL	Stock	39.9525	39.9525	39.9525	39.9525	400.0
2017-08-28 06:55:00	AAPL	Stock	39.95	39.95	39.95	39.95	400.0
2017-08-28 07:00:00	AAPL	Stock	39.95	39.95	39.95	39.95	756.0
2017-08-28 07:01:00	AAPL	Stock	39.93	39.93	39.93	39.93	400.0
2017-08-28 07:02:00	AAPL	Stock	39.93	39.93	39.93	39.93	400.0
2017-08-28 07:11:00	AAPL	Stock	39.9425	39.9425	39.9425	39.9425	400.0
2017-08-28 07:18:00	AAPL	Stock	39.9725	39.9725	39.9725	39.9725	400.0
2017-08-28 07:19:00	AAPL	Stock	39.975	40.0	39.975	40.0	7388.0
2017-08-28 07:24:00	AAPL	Stock	40.05	40.05	40.05	40.05	1180.0
2017-08-28 07:26:00	AAPL	Stock	40.05	40.05	40.05	40.05	968.0
2017-08-28 07:27:00	AAPL	Stock	40.05	40.05	40.045	40.045	800.0
2017-08-28 07:33:00	AAPL	Stock	40.0025	40.0025	40.0	40.0	4920.0
2017-08-28 07:43:00	AAPL	Stock	40.025	40.025	40.025	40.025	400.0
2017-08-28 07:48:00	AAPL	Stock	40.0375	40.0375	40.0375	40.0375	400.0
2017-08-28 07:49:00	AAPL	Stock	40.025	40.025	40.025	40.025	3200.0
2017-08-28 07:58:00	AAPL	Stock	40.0125	40.0125	40.0125	40.0125	1204.0
2017-08-28 08:00:00	AAPL	Stock	40.045	40.045	39.9275	40.0375	12568.0
2017-08-28 08:01:00	AAPL	Stock	40.0375	40.0375	40.0375	40.0375	600.0
2017-08-28 08:02:00	AAPL	Stock	40.035	40.04	40.035	40.035	18400.0
2017-08-28 08:03:00	AAPL	Stock	40.0375	40.045	40.025	40.045	5700.0
2017-08-28 08:04:00	AAPL	Stock	40.025	40.025	40.025	40.025	2000.0
2017-08-28 08:08:00	AAPL	Stock	40.025	40.025	40.025	40.025	400.0
2017-08-28 08:09:00	AAPL	Stock	40.025	40.025	40.0125	40.0125	4056.0
2017-08-28 08:11:00	AAPL	Stock	40.045	40.045	40.0175	40.0175	800.0
2017-08-28 08:15:00	AAPL	Stock	40.025	40.0425	40.0225	40.04	7424.0
2017-08-28 08:16:00	AAPL	Stock	40.0275	40.0275	40.0275	40.0275	2000.0
2017-08-28 08:17:00	AAPL	Stock	40.03	40.03	40.03	40.03	2000.0
2017-08-28 08:18:00	AAPL	Stock	40.03	40.03	40.03	40.03	4000.0
2017-08-28 08:19:00	AAPL	Stock	40.035	40.045	40.035	40.045	1564.0
2017-08-28 08:20:00	AAPL	Stock	40.045	40.045	40.045	40.045	6400.0
2017-08-28 08:23:00	AAPL	Stock	40.0425	40.0425	40.0425	40.0425	400.0
2017-08-28 08:24:00	AAPL	Stock	40.05	40.05	40.05	40.05	1988.0
2017-08-28 08:25:00	AAPL	Stock	40.05	40.05	40.05	40.05	400.0
2017-08-28 08:28:00	AAPL	Stock	40.045	40.045	40.0425	40.0425	1832.0
2017-08-28 08:29:00	AAPL	Stock	40.0425	40.0425	40.0425	40.0425	10568.0
2017-08-28 08:30:00	AAPL	Stock	40.05	40.05	40.05	40.05	400.0
2017-08-28 08:31:00	AAPL	Stock	40.06	40.06	40.06	40.06	400.0
2017-08-28 08:32:00	AAPL	Stock	40.0625	40.0625	40.0625	40.0625	800.0
2017-08-28 08:34:00	AAPL	Stock	40.05	40.05	40.05	40.05	400.0
2017-08-28 08:35:00	AAPL	Stock	40.0425	40.0425	40.04	40.04	4000.0
2017-08-28 08:36:00	AAPL	Stock	40.06	40.06	40.06	40.06	400.0
2017-08-28 08:41:00	AAPL	Stock	40.0625	40.0625	40.0625	40.0625	400.0
2017-08-28 08:42:00	AAPL	Stock	40.0625	40.075	40.0625	40.075	10020.0
2017-08-28 08:43:00	AAPL	Stock	40.075	40.075	40.075	40.075	8152.0
2017-08-28 08:44:00	AAPL	Stock	40.075	40.075	40.075	40.075	1600.0
2017-08-28 08:45:00	AAPL	Stock	40.075	40.075	40.075	40.075	1200.0

> showing 50 of 986,395 rows — these rows as CSV

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