PREVIEW / stock_5min / 2017-10-30

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-10-30.parquet
  size:    5.5 MB
  rows:    356,409
  symbols: 2,927

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-30 04:00:00	AAPL	Stock	40.875	40.875	40.825	40.825	3176.0
2017-10-30 04:05:00	AAPL	Stock	40.8675	40.8675	40.85	40.85	11196.0
2017-10-30 04:15:00	AAPL	Stock	40.8	40.8675	40.8	40.8625	6428.0
2017-10-30 04:25:00	AAPL	Stock	40.8575	40.8575	40.8575	40.8575	552.0
2017-10-30 04:35:00	AAPL	Stock	40.8575	40.8575	40.8575	40.8575	480.0
2017-10-30 04:40:00	AAPL	Stock	40.85	40.8625	40.85	40.8625	8304.0
2017-10-30 04:45:00	AAPL	Stock	40.855	40.855	40.855	40.855	1200.0
2017-10-30 05:00:00	AAPL	Stock	40.875	40.875	40.875	40.875	4000.0
2017-10-30 05:05:00	AAPL	Stock	40.855	40.855	40.85	40.85	16256.0
2017-10-30 05:35:00	AAPL	Stock	40.825	40.825	40.825	40.825	400.0
2017-10-30 05:55:00	AAPL	Stock	40.8175	40.82	40.8175	40.82	4068.0
2017-10-30 06:00:00	AAPL	Stock	40.825	40.845	40.825	40.825	3204.0
2017-10-30 06:05:00	AAPL	Stock	40.825	40.825	40.805	40.825	7328.0
2017-10-30 06:15:00	AAPL	Stock	40.805	40.805	40.8	40.8	6200.0
2017-10-30 06:25:00	AAPL	Stock	40.785	40.805	40.785	40.805	11132.0
2017-10-30 06:30:00	AAPL	Stock	40.8	40.805	40.8	40.8	10540.0
2017-10-30 06:35:00	AAPL	Stock	40.8125	40.8225	40.8125	40.8225	836.0
2017-10-30 06:45:00	AAPL	Stock	40.825	40.825	40.825	40.825	2800.0
2017-10-30 06:50:00	AAPL	Stock	40.85	40.8975	40.85	40.8975	14872.0
2017-10-30 06:55:00	AAPL	Stock	40.88	40.88	40.875	40.875	3600.0
2017-10-30 07:00:00	AAPL	Stock	40.875	40.885	40.875	40.875	52304.0
2017-10-30 07:05:00	AAPL	Stock	40.875	40.8875	40.875	40.8775	23004.0
2017-10-30 07:10:00	AAPL	Stock	40.88	40.9475	40.8625	40.9	58316.0
2017-10-30 07:15:00	AAPL	Stock	40.9125	40.9425	40.88	40.9425	39184.0
2017-10-30 07:20:00	AAPL	Stock	40.915	40.925	40.9	40.9	2400.0
2017-10-30 07:25:00	AAPL	Stock	40.9025	40.9025	40.8875	40.8875	3860.0
2017-10-30 07:30:00	AAPL	Stock	40.9	40.94	40.9	40.925	7600.0
2017-10-30 07:35:00	AAPL	Stock	40.9125	40.9425	40.905	40.905	17052.0
2017-10-30 07:40:00	AAPL	Stock	40.905	40.905	40.9025	40.9025	3716.0
2017-10-30 07:45:00	AAPL	Stock	40.9025	40.925	40.9025	40.905	7416.0
2017-10-30 07:50:00	AAPL	Stock	40.92	40.92	40.9125	40.9125	2392.0
2017-10-30 07:55:00	AAPL	Stock	40.905	40.905	40.89	40.8925	14528.0
2017-10-30 08:00:00	AAPL	Stock	40.9	40.95	40.845	40.875	82336.0
2017-10-30 08:05:00	AAPL	Stock	40.875	40.91	40.8625	40.91	47480.0
2017-10-30 08:10:00	AAPL	Stock	40.9125	40.925	40.91	40.9225	23592.0
2017-10-30 08:15:00	AAPL	Stock	40.9225	40.9225	40.9125	40.9175	10200.0
2017-10-30 08:20:00	AAPL	Stock	40.9175	40.9225	40.8875	40.8875	57704.0
2017-10-30 08:25:00	AAPL	Stock	40.8875	40.95	40.8875	40.9475	40344.0
2017-10-30 08:30:00	AAPL	Stock	40.9475	41.0375	40.9375	41.025	88336.0
2017-10-30 08:35:00	AAPL	Stock	41.0125	41.08	41.0	41.0125	215588.0
2017-10-30 08:40:00	AAPL	Stock	41.0125	41.0375	41.0125	41.025	109016.0
2017-10-30 08:45:00	AAPL	Stock	41.025	41.0375	41.0225	41.03	93380.0
2017-10-30 08:50:00	AAPL	Stock	41.03	41.045	41.03	41.045	67644.0
2017-10-30 08:55:00	AAPL	Stock	41.0475	41.0875	41.0475	41.0825	152104.0
2017-10-30 09:00:00	AAPL	Stock	41.0825	41.0825	41.05	41.075	155312.0
2017-10-30 09:05:00	AAPL	Stock	41.0625	41.075	41.0625	41.0725	53068.0
2017-10-30 09:10:00	AAPL	Stock	41.0725	41.0725	41.0275	41.0325	89776.0
2017-10-30 09:15:00	AAPL	Stock	41.0325	41.05	41.005	41.005	85012.0
2017-10-30 09:20:00	AAPL	Stock	41.0125	41.025	40.9775	41.0125	78920.0
2017-10-30 09:25:00	AAPL	Stock	40.9975	41.0125	40.96	40.965	172968.0

> showing 50 of 356,409 rows — these rows as CSV

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