PREVIEW / stock_5min / 2017-07-06

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-07-06.parquet
  size:    5.2 MB
  rows:    348,464
  symbols: 2,993

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-07-06 05:25:00	AAPL	Stock	35.895	35.895	35.8875	35.8875	4400.0
2017-07-06 05:40:00	AAPL	Stock	35.855	35.855	35.7625	35.825	8796.0
2017-07-06 05:45:00	AAPL	Stock	35.7875	35.825	35.7875	35.825	2200.0
2017-07-06 05:50:00	AAPL	Stock	35.8	35.8	35.8	35.8	1600.0
2017-07-06 06:05:00	AAPL	Stock	35.7925	35.7925	35.7925	35.7925	2588.0
2017-07-06 06:10:00	AAPL	Stock	35.7575	35.7575	35.7575	35.7575	1424.0
2017-07-06 06:15:00	AAPL	Stock	35.76	35.76	35.76	35.76	2000.0
2017-07-06 06:30:00	AAPL	Stock	35.79	35.79	35.79	35.79	400.0
2017-07-06 06:45:00	AAPL	Stock	35.7775	35.7775	35.775	35.775	2000.0
2017-07-06 06:50:00	AAPL	Stock	35.785	35.79	35.785	35.79	2368.0
2017-07-06 06:55:00	AAPL	Stock	35.8025	35.81	35.8025	35.81	2396.0
2017-07-06 07:00:00	AAPL	Stock	35.81	35.81	35.8	35.8	3196.0
2017-07-06 07:05:00	AAPL	Stock	35.8	35.8	35.8	35.8	3576.0
2017-07-06 07:10:00	AAPL	Stock	35.7925	35.7925	35.7925	35.7925	3760.0
2017-07-06 07:15:00	AAPL	Stock	35.7925	35.7925	35.7925	35.7925	600.0
2017-07-06 07:25:00	AAPL	Stock	35.8	35.81	35.8	35.81	2384.0
2017-07-06 07:30:00	AAPL	Stock	35.795	35.795	35.78	35.78	13936.0
2017-07-06 07:35:00	AAPL	Stock	35.775	35.7925	35.775	35.7925	12024.0
2017-07-06 07:40:00	AAPL	Stock	35.8025	35.8025	35.7725	35.7725	16888.0
2017-07-06 07:45:00	AAPL	Stock	35.775	35.775	35.745	35.745	3200.0
2017-07-06 07:50:00	AAPL	Stock	35.7275	35.7275	35.7	35.725	11672.0
2017-07-06 07:55:00	AAPL	Stock	35.725	35.725	35.7	35.7175	39120.0
2017-07-06 08:00:00	AAPL	Stock	35.7475	35.775	35.7	35.75	53892.0
2017-07-06 08:05:00	AAPL	Stock	35.7675	35.775	35.7525	35.755	40396.0
2017-07-06 08:10:00	AAPL	Stock	35.755	35.785	35.755	35.7725	26072.0
2017-07-06 08:15:00	AAPL	Stock	35.7675	35.7675	35.73	35.73	38048.0
2017-07-06 08:20:00	AAPL	Stock	35.73	35.7625	35.715	35.7475	31300.0
2017-07-06 08:25:00	AAPL	Stock	35.75	35.75	35.7375	35.7375	23352.0
2017-07-06 08:30:00	AAPL	Stock	35.75	35.7625	35.75	35.7625	50244.0
2017-07-06 08:35:00	AAPL	Stock	35.7525	35.775	35.7525	35.775	10880.0
2017-07-06 08:40:00	AAPL	Stock	35.7625	35.775	35.7375	35.7375	14800.0
2017-07-06 08:45:00	AAPL	Stock	35.75	35.75	35.73	35.73	9200.0
2017-07-06 08:50:00	AAPL	Stock	35.7675	35.8	35.7675	35.795	5468.0
2017-07-06 08:55:00	AAPL	Stock	35.81	35.8225	35.795	35.7975	9184.0
2017-07-06 09:00:00	AAPL	Stock	35.7975	35.8225	35.795	35.7975	27560.0
2017-07-06 09:05:00	AAPL	Stock	35.8	35.8225	35.7975	35.7975	15204.0
2017-07-06 09:10:00	AAPL	Stock	35.82	35.82	35.785	35.785	26424.0
2017-07-06 09:15:00	AAPL	Stock	35.785	35.7975	35.76	35.7975	5260.0
2017-07-06 09:20:00	AAPL	Stock	35.8	35.805	35.7875	35.7875	4400.0
2017-07-06 09:25:00	AAPL	Stock	35.78	35.785	35.75	35.7625	117788.0
2017-07-06 09:30:00	AAPL	Stock	35.775	35.875	35.7275	35.825	3508120.0
2017-07-06 09:35:00	AAPL	Stock	35.8225	35.825	35.6875	35.7145	1803020.0
2017-07-06 09:40:00	AAPL	Stock	35.71	35.79	35.6575	35.7625	2346248.0
2017-07-06 09:45:00	AAPL	Stock	35.7625	35.7725	35.665	35.6975	2014356.0
2017-07-06 09:50:00	AAPL	Stock	35.6975	35.77	35.6625	35.7518	1618368.0
2017-07-06 09:55:00	AAPL	Stock	35.749	35.7575	35.675	35.6925	1145496.0
2017-07-06 10:00:00	AAPL	Stock	35.69	35.755	35.6875	35.7	1450732.0
2017-07-06 10:05:00	AAPL	Stock	35.7025	35.7075	35.6025	35.6825	2252876.0
2017-07-06 10:10:00	AAPL	Stock	35.685	35.7212	35.6462	35.715	1115040.0
2017-07-06 10:15:00	AAPL	Stock	35.7175	35.795	35.7	35.725	1149968.0

> showing 50 of 348,464 rows — these rows as CSV

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