PREVIEW / stock_5min / 2017-06-09

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-06-09.parquet
  size:    5.5 MB
  rows:    354,376
  symbols: 3,041

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-06-09 04:30:00	AAPL	Stock	38.75	38.75	38.75	38.75	460.0
2017-06-09 05:10:00	AAPL	Stock	38.7975	38.7975	38.7975	38.7975	628.0
2017-06-09 05:35:00	AAPL	Stock	38.825	38.825	38.825	38.825	2000.0
2017-06-09 05:40:00	AAPL	Stock	38.825	38.825	38.8125	38.825	3308.0
2017-06-09 05:45:00	AAPL	Stock	38.8	38.8	38.8	38.8	2236.0
2017-06-09 05:50:00	AAPL	Stock	38.81	38.81	38.81	38.81	2000.0
2017-06-09 05:55:00	AAPL	Stock	38.8	38.8375	38.8	38.8375	2440.0
2017-06-09 06:10:00	AAPL	Stock	38.7875	38.7875	38.7875	38.7875	756.0
2017-06-09 06:35:00	AAPL	Stock	38.795	38.795	38.795	38.795	2000.0
2017-06-09 06:55:00	AAPL	Stock	38.7875	38.7875	38.7875	38.7875	2164.0
2017-06-09 07:00:00	AAPL	Stock	38.7825	38.7825	38.7825	38.7825	2600.0
2017-06-09 07:05:00	AAPL	Stock	38.7825	38.7825	38.7825	38.7825	2948.0
2017-06-09 07:10:00	AAPL	Stock	38.7875	38.7875	38.7875	38.7875	640.0
2017-06-09 07:15:00	AAPL	Stock	38.7875	38.7875	38.7875	38.7875	4000.0
2017-06-09 07:30:00	AAPL	Stock	38.7875	38.7875	38.7825	38.7825	4000.0
2017-06-09 07:35:00	AAPL	Stock	38.7825	38.7825	38.7825	38.7825	5248.0
2017-06-09 07:40:00	AAPL	Stock	38.775	38.775	38.775	38.775	6556.0
2017-06-09 07:50:00	AAPL	Stock	38.775	38.775	38.775	38.775	3276.0
2017-06-09 07:55:00	AAPL	Stock	38.7875	38.7875	38.7875	38.7875	400.0
2017-06-09 08:00:00	AAPL	Stock	38.7875	38.805	38.75	38.8	56504.0
2017-06-09 08:05:00	AAPL	Stock	38.8	38.81	38.8	38.8075	4608.0
2017-06-09 08:10:00	AAPL	Stock	38.8075	38.8175	38.8075	38.815	13484.0
2017-06-09 08:15:00	AAPL	Stock	38.815	38.815	38.8125	38.8125	5320.0
2017-06-09 08:20:00	AAPL	Stock	38.8125	38.8125	38.81	38.81	22560.0
2017-06-09 08:25:00	AAPL	Stock	38.8	38.8	38.8	38.8	2412.0
2017-06-09 08:30:00	AAPL	Stock	38.8	38.8	38.795	38.8	9660.0
2017-06-09 08:35:00	AAPL	Stock	38.8025	38.8025	38.8025	38.8025	1600.0
2017-06-09 08:40:00	AAPL	Stock	38.795	38.805	38.7925	38.7925	5960.0
2017-06-09 08:45:00	AAPL	Stock	38.7925	38.7925	38.7925	38.7925	1940.0
2017-06-09 08:50:00	AAPL	Stock	38.7925	38.8	38.7925	38.8	800.0
2017-06-09 08:55:00	AAPL	Stock	38.8025	38.8025	38.8025	38.8025	800.0
2017-06-09 09:00:00	AAPL	Stock	38.795	38.795	38.795	38.795	452.0
2017-06-09 09:05:00	AAPL	Stock	38.7975	38.7975	38.795	38.795	1800.0
2017-06-09 09:10:00	AAPL	Stock	38.7925	38.7925	38.7925	38.7925	1880.0
2017-06-09 09:15:00	AAPL	Stock	38.7975	38.8	38.7925	38.8	21328.0
2017-06-09 09:20:00	AAPL	Stock	38.79	38.7925	38.79	38.79	12400.0
2017-06-09 09:25:00	AAPL	Stock	38.79	38.79	38.79	38.79	3600.0
2017-06-09 09:30:00	AAPL	Stock	38.7975	38.7975	38.675	38.6975	2917456.0
2017-06-09 09:35:00	AAPL	Stock	38.7	38.7225	38.6025	38.621	1865716.0
2017-06-09 09:40:00	AAPL	Stock	38.621	38.6925	38.6175	38.655	1539592.0
2017-06-09 09:45:00	AAPL	Stock	38.6525	38.75	38.65	38.74	1533448.0
2017-06-09 09:50:00	AAPL	Stock	38.7375	38.745	38.665	38.675	1286344.0
2017-06-09 09:55:00	AAPL	Stock	38.675	38.745	38.6625	38.71	956684.0
2017-06-09 10:00:00	AAPL	Stock	38.71	38.745	38.6725	38.745	860776.0
2017-06-09 10:05:00	AAPL	Stock	38.7442	38.765	38.7175	38.7525	1247760.0
2017-06-09 10:10:00	AAPL	Stock	38.7548	38.775	38.7375	38.7675	1121532.0
2017-06-09 10:15:00	AAPL	Stock	38.7675	38.7875	38.755	38.7825	939032.0
2017-06-09 10:20:00	AAPL	Stock	38.7775	38.7955	38.7575	38.77	750868.0
2017-06-09 10:25:00	AAPL	Stock	38.7682	38.775	38.7425	38.7525	574616.0
2017-06-09 10:30:00	AAPL	Stock	38.754	38.7875	38.728	38.75	1092296.0

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

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