PREVIEW / stock_1min / 2017-10-17

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-10-17.parquet
  size:    14.0 MB
  rows:    1,006,042
  symbols: 2,439

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-10-17 04:00:00	AAPL	Stock	39.99	39.99	39.99	39.99	476.0
2017-10-17 04:11:00	AAPL	Stock	39.9125	39.9125	39.9125	39.9125	940.0
2017-10-17 04:17:00	AAPL	Stock	39.9075	39.9075	39.9075	39.9075	848.0
2017-10-17 05:16:00	AAPL	Stock	39.9025	39.9025	39.9025	39.9025	932.0
2017-10-17 05:25:00	AAPL	Stock	39.9025	39.9025	39.89	39.89	3580.0
2017-10-17 06:02:00	AAPL	Stock	39.9125	39.9125	39.9125	39.9125	404.0
2017-10-17 06:04:00	AAPL	Stock	39.95	39.95	39.95	39.95	872.0
2017-10-17 06:10:00	AAPL	Stock	39.9475	39.95	39.9475	39.95	12000.0
2017-10-17 06:15:00	AAPL	Stock	39.95	39.95	39.95	39.95	676.0
2017-10-17 06:16:00	AAPL	Stock	39.9525	39.9525	39.9525	39.9525	520.0
2017-10-17 06:19:00	AAPL	Stock	39.9175	39.9175	39.9175	39.9175	760.0
2017-10-17 06:23:00	AAPL	Stock	39.9375	39.9375	39.9375	39.9375	400.0
2017-10-17 06:25:00	AAPL	Stock	39.9175	39.9175	39.9175	39.9175	440.0
2017-10-17 06:28:00	AAPL	Stock	39.91	39.91	39.91	39.91	400.0
2017-10-17 06:39:00	AAPL	Stock	39.95	39.95	39.95	39.95	400.0
2017-10-17 06:59:00	AAPL	Stock	39.95	39.95	39.95	39.95	1820.0
2017-10-17 07:00:00	AAPL	Stock	39.95	39.95	39.95	39.95	4500.0
2017-10-17 07:01:00	AAPL	Stock	39.95	39.95	39.95	39.95	472.0
2017-10-17 07:09:00	AAPL	Stock	39.9375	39.95	39.9375	39.95	1296.0
2017-10-17 07:10:00	AAPL	Stock	39.95	39.95	39.95	39.95	460.0
2017-10-17 07:15:00	AAPL	Stock	39.95	39.95	39.95	39.95	1644.0
2017-10-17 07:18:00	AAPL	Stock	39.95	39.95	39.95	39.95	400.0
2017-10-17 07:20:00	AAPL	Stock	39.9375	39.9375	39.9375	39.9375	400.0
2017-10-17 07:25:00	AAPL	Stock	39.9375	39.9375	39.9375	39.9375	700.0
2017-10-17 07:27:00	AAPL	Stock	39.9375	39.9375	39.9375	39.9375	660.0
2017-10-17 07:28:00	AAPL	Stock	39.925	39.925	39.8875	39.8875	13004.0
2017-10-17 07:30:00	AAPL	Stock	39.89	39.89	39.89	39.89	3996.0
2017-10-17 07:36:00	AAPL	Stock	39.9	39.9	39.9	39.9	1640.0
2017-10-17 07:42:00	AAPL	Stock	39.9	39.9	39.9	39.9	400.0
2017-10-17 07:47:00	AAPL	Stock	39.9125	39.9125	39.9125	39.9125	400.0
2017-10-17 07:49:00	AAPL	Stock	39.905	39.905	39.905	39.905	400.0
2017-10-17 07:57:00	AAPL	Stock	39.915	39.915	39.915	39.915	400.0
2017-10-17 07:58:00	AAPL	Stock	39.925	39.925	39.925	39.925	800.0
2017-10-17 07:59:00	AAPL	Stock	39.93	39.935	39.93	39.9325	6800.0
2017-10-17 08:00:00	AAPL	Stock	39.95	39.9525	39.89	39.9325	18056.0
2017-10-17 08:01:00	AAPL	Stock	39.935	39.935	39.935	39.935	800.0
2017-10-17 08:03:00	AAPL	Stock	39.935	39.935	39.93	39.93	4584.0
2017-10-17 08:04:00	AAPL	Stock	40.06	40.06	40.06	40.06	12000.0
2017-10-17 08:05:00	AAPL	Stock	39.9425	39.9425	39.9425	39.9425	600.0
2017-10-17 08:07:00	AAPL	Stock	39.95	39.95	39.95	39.95	800.0
2017-10-17 08:09:00	AAPL	Stock	39.945	39.945	39.9375	39.9375	5600.0
2017-10-17 08:12:00	AAPL	Stock	39.935	39.935	39.9325	39.9325	3200.0
2017-10-17 08:14:00	AAPL	Stock	39.9325	39.9375	39.9325	39.9375	2560.0
2017-10-17 08:18:00	AAPL	Stock	39.9325	39.9325	39.9275	39.9275	17080.0
2017-10-17 08:19:00	AAPL	Stock	39.92	39.92	39.9175	39.9175	3200.0
2017-10-17 08:20:00	AAPL	Stock	39.915	39.915	39.915	39.915	400.0
2017-10-17 08:23:00	AAPL	Stock	39.9125	39.9125	39.9125	39.9125	800.0
2017-10-17 08:25:00	AAPL	Stock	39.93	39.93	39.93	39.93	400.0
2017-10-17 08:28:00	AAPL	Stock	39.9175	39.9175	39.9175	39.9175	600.0
2017-10-17 08:31:00	AAPL	Stock	39.935	39.935	39.935	39.935	2000.0

> showing 50 of 1,006,042 rows — these rows as CSV

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