PREVIEW / stock_5min / 2017-08-02

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-08-02.parquet
  size:    5.4 MB
  rows:    349,500
  symbols: 2,989

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-02 04:00:00	AAPL	Stock	39.805	39.825	39.7625	39.775	40004.0
2017-08-02 04:05:00	AAPL	Stock	39.775	39.8	39.775	39.8	18664.0
2017-08-02 04:10:00	AAPL	Stock	39.8	39.875	39.8	39.875	76924.0
2017-08-02 04:15:00	AAPL	Stock	39.865	39.8825	39.865	39.875	10964.0
2017-08-02 04:20:00	AAPL	Stock	39.875	39.8875	39.875	39.8775	9756.0
2017-08-02 04:25:00	AAPL	Stock	39.8875	39.8875	39.855	39.8575	7688.0
2017-08-02 04:30:00	AAPL	Stock	39.835	39.835	39.835	39.835	400.0
2017-08-02 04:35:00	AAPL	Stock	39.835	39.835	39.8	39.8	980.0
2017-08-02 04:40:00	AAPL	Stock	39.7975	39.8875	39.775	39.8875	55544.0
2017-08-02 04:45:00	AAPL	Stock	39.895	39.9375	39.8225	39.8225	49440.0
2017-08-02 04:55:00	AAPL	Stock	39.8275	39.8275	39.8275	39.8275	600.0
2017-08-02 05:00:00	AAPL	Stock	39.8275	39.8275	39.8	39.8	10764.0
2017-08-02 05:05:00	AAPL	Stock	39.8375	39.8375	39.8025	39.8375	19936.0
2017-08-02 05:10:00	AAPL	Stock	39.825	39.825	39.8175	39.8175	1600.0
2017-08-02 05:15:00	AAPL	Stock	39.8175	39.8375	39.8175	39.8175	4900.0
2017-08-02 05:20:00	AAPL	Stock	39.8125	39.85	39.8125	39.8325	16004.0
2017-08-02 05:25:00	AAPL	Stock	39.87	39.875	39.87	39.875	5004.0
2017-08-02 05:30:00	AAPL	Stock	39.875	39.8825	39.875	39.8825	14880.0
2017-08-02 05:45:00	AAPL	Stock	39.845	39.845	39.8325	39.8325	14000.0
2017-08-02 05:50:00	AAPL	Stock	39.8125	39.8125	39.8125	39.8125	1972.0
2017-08-02 05:55:00	AAPL	Stock	39.8125	39.8375	39.8025	39.825	6000.0
2017-08-02 06:00:00	AAPL	Stock	39.8	39.825	39.775	39.775	43528.0
2017-08-02 06:05:00	AAPL	Stock	39.775	39.8	39.7075	39.7375	58580.0
2017-08-02 06:10:00	AAPL	Stock	39.745	39.845	39.745	39.775	106620.0
2017-08-02 06:15:00	AAPL	Stock	39.765	39.8025	39.7525	39.755	47780.0
2017-08-02 06:20:00	AAPL	Stock	39.75	39.775	39.6625	39.6625	79116.0
2017-08-02 06:25:00	AAPL	Stock	39.675	39.745	39.6575	39.7	62304.0
2017-08-02 06:30:00	AAPL	Stock	39.6875	39.6875	39.6575	39.6575	20996.0
2017-08-02 06:35:00	AAPL	Stock	39.7	39.7	39.6375	39.6875	58152.0
2017-08-02 06:40:00	AAPL	Stock	39.7	39.7	39.6375	39.675	40884.0
2017-08-02 06:45:00	AAPL	Stock	39.65	39.6775	39.6375	39.66	21712.0
2017-08-02 06:50:00	AAPL	Stock	39.6475	39.66	39.585	39.585	86540.0
2017-08-02 06:55:00	AAPL	Stock	39.5875	39.6725	39.5125	39.5875	150028.0
2017-08-02 07:00:00	AAPL	Stock	39.61	39.8	39.61	39.8	181324.0
2017-08-02 07:05:00	AAPL	Stock	39.755	39.825	39.735	39.735	92480.0
2017-08-02 07:10:00	AAPL	Stock	39.745	39.775	39.7125	39.7125	55772.0
2017-08-02 07:15:00	AAPL	Stock	39.7225	39.7475	39.6875	39.7	52084.0
2017-08-02 07:20:00	AAPL	Stock	39.7125	39.75	39.7	39.7	87032.0
2017-08-02 07:25:00	AAPL	Stock	39.7	39.7025	39.585	39.625	117768.0
2017-08-02 07:30:00	AAPL	Stock	39.6175	39.6675	39.585	39.6125	176292.0
2017-08-02 07:35:00	AAPL	Stock	39.6125	39.7125	39.5725	39.6875	117972.0
2017-08-02 07:40:00	AAPL	Stock	39.695	39.7375	39.65	39.6625	77196.0
2017-08-02 07:45:00	AAPL	Stock	39.6725	39.7125	39.625	39.65	76208.0
2017-08-02 07:50:00	AAPL	Stock	39.64	39.6875	39.5875	39.6125	87164.0
2017-08-02 07:55:00	AAPL	Stock	39.6175	39.71	39.565	39.71	160872.0
2017-08-02 08:00:00	AAPL	Stock	39.7025	39.875	39.54	39.85	1498380.0
2017-08-02 08:05:00	AAPL	Stock	39.85	39.945	39.8425	39.895	453652.0
2017-08-02 08:10:00	AAPL	Stock	39.89	39.995	39.84	39.995	750356.0
2017-08-02 08:15:00	AAPL	Stock	39.9875	40.0	39.93	39.9625	471584.0
2017-08-02 08:20:00	AAPL	Stock	39.97	39.985	39.8825	39.91	269328.0

> showing 50 of 349,500 rows — these rows as CSV

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