PREVIEW / stock_5min / 2017-12-20

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-12-20.parquet
  size:    5.7 MB
  rows:    369,584
  symbols: 2,930

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-12-20 04:45:00	AAPL	Stock	43.775	43.775	43.775	43.775	1200.0
2017-12-20 05:10:00	AAPL	Stock	43.8	43.8125	43.8	43.8125	8000.0
2017-12-20 05:20:00	AAPL	Stock	43.81	43.8125	43.81	43.8125	5092.0
2017-12-20 05:25:00	AAPL	Stock	43.8075	43.8075	43.8075	43.8075	532.0
2017-12-20 06:00:00	AAPL	Stock	43.8	43.8	43.8	43.8	400.0
2017-12-20 06:05:00	AAPL	Stock	43.7525	43.775	43.7525	43.775	1400.0
2017-12-20 06:30:00	AAPL	Stock	43.775	43.7825	43.7725	43.7825	2820.0
2017-12-20 06:40:00	AAPL	Stock	43.76	43.76	43.75	43.75	2052.0
2017-12-20 06:45:00	AAPL	Stock	43.7725	43.775	43.7725	43.775	5716.0
2017-12-20 06:55:00	AAPL	Stock	43.795	43.795	43.7675	43.7675	2000.0
2017-12-20 07:00:00	AAPL	Stock	43.7625	43.7875	43.75	43.7875	27744.0
2017-12-20 07:05:00	AAPL	Stock	43.7875	43.7925	43.775	43.78	16936.0
2017-12-20 07:10:00	AAPL	Stock	43.775	43.795	43.775	43.7925	16256.0
2017-12-20 07:15:00	AAPL	Stock	43.7925	43.7925	43.75	43.775	38540.0
2017-12-20 07:20:00	AAPL	Stock	43.7775	43.7875	43.7775	43.7875	11796.0
2017-12-20 07:25:00	AAPL	Stock	43.78	43.78	43.78	43.78	7468.0
2017-12-20 07:35:00	AAPL	Stock	43.765	43.775	43.755	43.755	12352.0
2017-12-20 07:40:00	AAPL	Stock	43.7625	43.775	43.75	43.75	10084.0
2017-12-20 07:45:00	AAPL	Stock	43.75	43.75	43.75	43.75	10088.0
2017-12-20 07:50:00	AAPL	Stock	43.75	43.77	43.75	43.7575	7600.0
2017-12-20 07:55:00	AAPL	Stock	43.7675	43.7675	43.755	43.755	4000.0
2017-12-20 08:00:00	AAPL	Stock	43.8	43.8	43.7225	43.7825	93100.0
2017-12-20 08:05:00	AAPL	Stock	43.7825	43.7875	43.78	43.7825	28224.0
2017-12-20 08:10:00	AAPL	Stock	43.7825	43.785	43.7625	43.775	15184.0
2017-12-20 08:15:00	AAPL	Stock	43.775	43.775	43.775	43.775	9160.0
2017-12-20 08:20:00	AAPL	Stock	43.775	43.7825	43.775	43.775	10360.0
2017-12-20 08:25:00	AAPL	Stock	43.7725	43.785	43.75	43.7525	35344.0
2017-12-20 08:30:00	AAPL	Stock	43.77	43.7725	43.7525	43.7725	1800.0
2017-12-20 08:35:00	AAPL	Stock	43.7725	43.7725	43.76	43.76	22820.0
2017-12-20 08:40:00	AAPL	Stock	43.7625	43.7625	43.75	43.755	25492.0
2017-12-20 08:45:00	AAPL	Stock	43.76	43.77	43.7375	43.7375	15832.0
2017-12-20 08:50:00	AAPL	Stock	43.7425	43.7675	43.7425	43.7675	25400.0
2017-12-20 08:55:00	AAPL	Stock	43.77	43.775	43.75	43.75	76288.0
2017-12-20 09:00:00	AAPL	Stock	43.7425	43.7625	43.7425	43.7625	2128.0
2017-12-20 09:05:00	AAPL	Stock	43.755	43.755	43.7125	43.7125	37992.0
2017-12-20 09:10:00	AAPL	Stock	43.7475	43.7475	43.74	43.7475	15992.0
2017-12-20 09:15:00	AAPL	Stock	43.7475	43.7475	43.7475	43.7475	5692.0
2017-12-20 09:20:00	AAPL	Stock	43.725	43.7425	43.71	43.725	18164.0
2017-12-20 09:25:00	AAPL	Stock	43.73	43.75	43.675	43.725	54292.0
2017-12-20 09:30:00	AAPL	Stock	43.72	43.855	43.6925	43.8125	5563996.0
2017-12-20 09:35:00	AAPL	Stock	43.8125	43.813	43.7025	43.705	2522000.0
2017-12-20 09:40:00	AAPL	Stock	43.7	43.75	43.4975	43.51	3610224.0
2017-12-20 09:45:00	AAPL	Stock	43.505	43.5188	43.4015	43.4175	2851972.0
2017-12-20 09:50:00	AAPL	Stock	43.4175	43.485	43.355	43.3713	2592128.0
2017-12-20 09:55:00	AAPL	Stock	43.37	43.52	43.365	43.5075	1687624.0
2017-12-20 10:00:00	AAPL	Stock	43.51	43.5375	43.4525	43.4775	1462584.0
2017-12-20 10:05:00	AAPL	Stock	43.4775	43.495	43.435	43.4775	1200520.0
2017-12-20 10:10:00	AAPL	Stock	43.4775	43.5725	43.475	43.5272	1543148.0
2017-12-20 10:15:00	AAPL	Stock	43.5275	43.5325	43.45	43.4512	1292600.0
2017-12-20 10:20:00	AAPL	Stock	43.452	43.455	43.4075	43.41	1359384.0

> showing 50 of 369,584 rows — these rows as CSV

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