PREVIEW / stock_5min / 2017-01-24

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-01-24.parquet
  size:    5.5 MB
  rows:    354,867
  symbols: 3,108

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-01-24 04:00:00	AAPL	Stock	29.875	29.875	29.8375	29.8375	15180.0
2017-01-24 04:05:00	AAPL	Stock	29.8125	29.8125	29.8125	29.8125	800.0
2017-01-24 04:15:00	AAPL	Stock	29.8	29.8	29.8	29.8	800.0
2017-01-24 04:20:00	AAPL	Stock	29.8025	29.8025	29.8	29.8	820.0
2017-01-24 04:25:00	AAPL	Stock	29.8325	29.8325	29.8325	29.8325	400.0
2017-01-24 04:30:00	AAPL	Stock	29.8075	29.8075	29.8075	29.8075	800.0
2017-01-24 04:35:00	AAPL	Stock	29.8	29.82	29.8	29.805	17616.0
2017-01-24 04:40:00	AAPL	Stock	29.81	29.81	29.8	29.8	880.0
2017-01-24 04:45:00	AAPL	Stock	29.81	29.81	29.8075	29.8075	4800.0
2017-01-24 04:50:00	AAPL	Stock	29.805	29.805	29.805	29.805	520.0
2017-01-24 04:55:00	AAPL	Stock	29.79	29.79	29.77	29.78	7680.0
2017-01-24 05:05:00	AAPL	Stock	29.8	29.8	29.8	29.8	3680.0
2017-01-24 05:30:00	AAPL	Stock	29.7725	29.7925	29.77	29.775	11884.0
2017-01-24 05:35:00	AAPL	Stock	29.775	29.775	29.775	29.775	400.0
2017-01-24 05:40:00	AAPL	Stock	29.775	29.775	29.775	29.775	800.0
2017-01-24 05:45:00	AAPL	Stock	29.7775	29.7775	29.7275	29.75	11856.0
2017-01-24 06:00:00	AAPL	Stock	29.7825	29.7825	29.75	29.75	2000.0
2017-01-24 06:05:00	AAPL	Stock	29.7825	29.785	29.7825	29.785	2000.0
2017-01-24 06:15:00	AAPL	Stock	29.785	29.8075	29.785	29.7875	11844.0
2017-01-24 06:20:00	AAPL	Stock	29.79	29.7925	29.765	29.785	3600.0
2017-01-24 06:30:00	AAPL	Stock	29.7875	29.8	29.7875	29.8	3920.0
2017-01-24 06:35:00	AAPL	Stock	29.8075	29.8125	29.8	29.8	59436.0
2017-01-24 06:40:00	AAPL	Stock	29.815	29.815	29.8	29.8075	3600.0
2017-01-24 06:45:00	AAPL	Stock	29.8075	29.8075	29.8075	29.8075	1056.0
2017-01-24 06:50:00	AAPL	Stock	29.8125	29.8125	29.8	29.8	2256.0
2017-01-24 07:00:00	AAPL	Stock	29.8275	29.835	29.8125	29.835	31000.0
2017-01-24 07:05:00	AAPL	Stock	29.835	29.835	29.8125	29.8125	60640.0
2017-01-24 07:10:00	AAPL	Stock	29.8125	29.8375	29.8125	29.8375	5568.0
2017-01-24 07:20:00	AAPL	Stock	29.835	29.835	29.835	29.835	800.0
2017-01-24 07:25:00	AAPL	Stock	29.825	29.825	29.815	29.815	2400.0
2017-01-24 07:30:00	AAPL	Stock	29.825	29.875	29.825	29.84	40784.0
2017-01-24 07:35:00	AAPL	Stock	29.855	29.855	29.825	29.855	19856.0
2017-01-24 07:40:00	AAPL	Stock	29.845	29.8475	29.8425	29.8425	9320.0
2017-01-24 07:50:00	AAPL	Stock	29.85	29.85	29.8425	29.8425	4960.0
2017-01-24 08:00:00	AAPL	Stock	29.825	29.95	29.825	29.8825	123320.0
2017-01-24 08:05:00	AAPL	Stock	29.8925	29.895	29.8825	29.895	15924.0
2017-01-24 08:10:00	AAPL	Stock	29.8875	29.9	29.8875	29.9	19876.0
2017-01-24 08:15:00	AAPL	Stock	29.8775	29.8975	29.8775	29.8775	12160.0
2017-01-24 08:20:00	AAPL	Stock	29.8875	29.8875	29.87	29.875	27220.0
2017-01-24 08:25:00	AAPL	Stock	29.875	29.8825	29.875	29.8825	8792.0
2017-01-24 08:30:00	AAPL	Stock	29.875	29.885	29.875	29.885	4556.0
2017-01-24 08:35:00	AAPL	Stock	29.8775	29.8775	29.85	29.85	21640.0
2017-01-24 08:40:00	AAPL	Stock	29.85	29.865	29.85	29.8575	8664.0
2017-01-24 08:45:00	AAPL	Stock	29.875	29.875	29.865	29.865	14400.0
2017-01-24 08:50:00	AAPL	Stock	29.875	29.875	29.865	29.865	19064.0
2017-01-24 08:55:00	AAPL	Stock	29.865	29.8825	29.8575	29.86	30756.0
2017-01-24 09:00:00	AAPL	Stock	29.8625	29.875	29.8625	29.8625	10660.0
2017-01-24 09:05:00	AAPL	Stock	29.8725	29.875	29.86	29.875	22848.0
2017-01-24 09:10:00	AAPL	Stock	29.8675	29.87	29.8625	29.8625	36900.0
2017-01-24 09:15:00	AAPL	Stock	29.87	29.8725	29.85	29.855	38436.0

> showing 50 of 354,867 rows — these rows as CSV

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