PREVIEW / stock_5min / 2017-10-17

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-10-17.parquet
  size:    5.4 MB
  rows:    346,100
  symbols: 2,950

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:10:00	AAPL	Stock	39.9125	39.9125	39.9125	39.9125	940.0
2017-10-17 04:15:00	AAPL	Stock	39.9075	39.9075	39.9075	39.9075	848.0
2017-10-17 05:15: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:00:00	AAPL	Stock	39.9125	39.95	39.9125	39.95	1276.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.9525	39.9175	39.9175	1956.0
2017-10-17 06:20: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.91	39.91	840.0
2017-10-17 06:35:00	AAPL	Stock	39.95	39.95	39.95	39.95	400.0
2017-10-17 06:55: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	4972.0
2017-10-17 07:05: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	2044.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.8875	39.8875	14364.0
2017-10-17 07:30:00	AAPL	Stock	39.89	39.89	39.89	39.89	3996.0
2017-10-17 07:35:00	AAPL	Stock	39.9	39.9	39.9	39.9	1640.0
2017-10-17 07:40:00	AAPL	Stock	39.9	39.9	39.9	39.9	400.0
2017-10-17 07:45:00	AAPL	Stock	39.9125	39.9125	39.905	39.905	800.0
2017-10-17 07:55:00	AAPL	Stock	39.915	39.935	39.915	39.9325	8000.0
2017-10-17 08:00:00	AAPL	Stock	39.95	40.06	39.89	40.06	35440.0
2017-10-17 08:05:00	AAPL	Stock	39.9425	39.95	39.9375	39.9375	7000.0
2017-10-17 08:10:00	AAPL	Stock	39.935	39.9375	39.9325	39.9375	5760.0
2017-10-17 08:15:00	AAPL	Stock	39.9325	39.9325	39.9175	39.9175	20280.0
2017-10-17 08:20:00	AAPL	Stock	39.915	39.915	39.9125	39.9125	1200.0
2017-10-17 08:25:00	AAPL	Stock	39.93	39.93	39.9175	39.9175	1000.0
2017-10-17 08:30:00	AAPL	Stock	39.935	39.935	39.9125	39.9125	5452.0
2017-10-17 08:35:00	AAPL	Stock	39.9325	39.935	39.9125	39.9125	23624.0
2017-10-17 08:40:00	AAPL	Stock	39.935	39.9425	39.925	39.925	8468.0
2017-10-17 08:45:00	AAPL	Stock	39.92	39.92	39.92	39.92	600.0
2017-10-17 08:50:00	AAPL	Stock	39.9375	39.94	39.9375	39.94	10400.0
2017-10-17 08:55:00	AAPL	Stock	39.945	39.945	39.94	39.94	7740.0
2017-10-17 09:00:00	AAPL	Stock	39.94	39.9525	39.9375	39.9525	25416.0
2017-10-17 09:05:00	AAPL	Stock	39.955	39.97	39.95	39.97	17012.0
2017-10-17 09:10:00	AAPL	Stock	39.965	39.965	39.9525	39.9575	38072.0
2017-10-17 09:15:00	AAPL	Stock	39.9525	39.955	39.94	39.94	27972.0
2017-10-17 09:20:00	AAPL	Stock	39.94	39.94	39.935	39.9375	17248.0
2017-10-17 09:25:00	AAPL	Stock	39.9275	39.965	39.9275	39.9475	39396.0
2017-10-17 09:30:00	AAPL	Stock	39.9375	40.05	39.9375	39.99	3555912.0
2017-10-17 09:35:00	AAPL	Stock	39.9875	40.0125	39.84	39.865	2198612.0
2017-10-17 09:40:00	AAPL	Stock	39.87	39.8925	39.8175	39.865	2051992.0
2017-10-17 09:45:00	AAPL	Stock	39.8625	39.8875	39.83	39.8475	1170800.0
2017-10-17 09:50:00	AAPL	Stock	39.8482	39.8875	39.8075	39.8275	1682488.0
2017-10-17 09:55:00	AAPL	Stock	39.825	39.9125	39.825	39.895	1461572.0
2017-10-17 10:00:00	AAPL	Stock	39.8925	39.895	39.8325	39.845	1092472.0
2017-10-17 10:05:00	AAPL	Stock	39.845	39.8938	39.8325	39.8875	1009032.0
2017-10-17 10:10:00	AAPL	Stock	39.8862	39.9225	39.88	39.9075	1121800.0

> showing 50 of 346,100 rows — these rows as CSV

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