PREVIEW / stock_5min / 2018-01-25

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-01-25.parquet
  size:    5.8 MB
  rows:    366,766
  symbols: 2,888

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
2018-01-25 04:00:00	AAPL	Stock	43.6725	43.6725	43.6725	43.6725	568.0
2018-01-25 04:20:00	AAPL	Stock	43.675	43.675	43.675	43.675	400.0
2018-01-25 04:30:00	AAPL	Stock	43.6725	43.6725	43.6725	43.6725	656.0
2018-01-25 04:35:00	AAPL	Stock	43.64	43.6875	43.64	43.67	12712.0
2018-01-25 04:40:00	AAPL	Stock	43.67	43.67	43.67	43.67	1600.0
2018-01-25 04:45:00	AAPL	Stock	43.6875	43.6875	43.6875	43.6875	2000.0
2018-01-25 04:50:00	AAPL	Stock	43.7125	43.7125	43.7125	43.7125	1136.0
2018-01-25 05:15:00	AAPL	Stock	43.6975	43.6975	43.6975	43.6975	1600.0
2018-01-25 05:30:00	AAPL	Stock	43.7175	43.7175	43.7175	43.7175	1864.0
2018-01-25 05:40:00	AAPL	Stock	43.745	43.745	43.745	43.745	1600.0
2018-01-25 05:45:00	AAPL	Stock	43.7675	43.7675	43.7175	43.7175	6280.0
2018-01-25 05:55:00	AAPL	Stock	43.7625	43.7625	43.7625	43.7625	1600.0
2018-01-25 06:00:00	AAPL	Stock	43.7425	43.775	43.7425	43.775	10192.0
2018-01-25 06:05:00	AAPL	Stock	43.7625	43.7625	43.7375	43.7375	1520.0
2018-01-25 06:10:00	AAPL	Stock	43.7375	43.7375	43.7375	43.7375	1992.0
2018-01-25 06:15:00	AAPL	Stock	43.74	43.7475	43.74	43.7475	2000.0
2018-01-25 06:20:00	AAPL	Stock	43.7475	43.7475	43.7175	43.7175	10396.0
2018-01-25 06:25:00	AAPL	Stock	43.72	43.7475	43.72	43.7475	6720.0
2018-01-25 06:30:00	AAPL	Stock	43.725	43.75	43.725	43.75	2000.0
2018-01-25 06:35:00	AAPL	Stock	43.725	43.725	43.725	43.725	2000.0
2018-01-25 06:40:00	AAPL	Stock	43.725	43.725	43.725	43.725	800.0
2018-01-25 06:45:00	AAPL	Stock	43.7125	43.7225	43.7125	43.7125	4868.0
2018-01-25 07:00:00	AAPL	Stock	43.715	43.7175	43.7	43.7175	22796.0
2018-01-25 07:05:00	AAPL	Stock	43.7175	43.725	43.7025	43.725	11668.0
2018-01-25 07:10:00	AAPL	Stock	43.73	43.73	43.725	43.73	6280.0
2018-01-25 07:15:00	AAPL	Stock	43.7225	43.7225	43.7225	43.7225	1200.0
2018-01-25 07:20:00	AAPL	Stock	43.7275	43.7375	43.7275	43.7375	6700.0
2018-01-25 07:25:00	AAPL	Stock	43.7375	43.7375	43.725	43.725	1196.0
2018-01-25 07:30:00	AAPL	Stock	43.725	43.75	43.72	43.75	13632.0
2018-01-25 07:35:00	AAPL	Stock	43.75	43.775	43.75	43.7625	13420.0
2018-01-25 07:40:00	AAPL	Stock	43.7625	43.78	43.7625	43.78	7360.0
2018-01-25 07:45:00	AAPL	Stock	43.77	43.8075	43.77	43.7775	15416.0
2018-01-25 07:50:00	AAPL	Stock	43.7775	43.7825	43.7775	43.7775	6680.0
2018-01-25 07:55:00	AAPL	Stock	43.7675	43.7675	43.765	43.7675	4836.0
2018-01-25 08:00:00	AAPL	Stock	43.77	43.7875	43.7125	43.725	53448.0
2018-01-25 08:05:00	AAPL	Stock	43.75	43.75	43.73	43.73	14184.0
2018-01-25 08:10:00	AAPL	Stock	43.74	43.7625	43.74	43.7625	7940.0
2018-01-25 08:15:00	AAPL	Stock	43.76	43.765	43.735	43.735	14480.0
2018-01-25 08:20:00	AAPL	Stock	43.7475	43.76	43.735	43.735	29724.0
2018-01-25 08:25:00	AAPL	Stock	43.73	43.7375	43.725	43.7375	7048.0
2018-01-25 08:30:00	AAPL	Stock	43.7375	43.7475	43.735	43.7475	13764.0
2018-01-25 08:35:00	AAPL	Stock	43.74	43.765	43.7375	43.76	46432.0
2018-01-25 08:40:00	AAPL	Stock	43.7575	43.76	43.6925	43.6925	75656.0
2018-01-25 08:45:00	AAPL	Stock	43.6975	43.7225	43.6725	43.71	50156.0
2018-01-25 08:50:00	AAPL	Stock	43.72	43.7375	43.7	43.7375	27220.0
2018-01-25 08:55:00	AAPL	Stock	43.7325	43.75	43.715	43.715	33460.0
2018-01-25 09:00:00	AAPL	Stock	43.7325	43.74	43.715	43.7375	16820.0
2018-01-25 09:05:00	AAPL	Stock	43.7375	43.7375	43.7	43.7125	14048.0
2018-01-25 09:10:00	AAPL	Stock	43.7125	43.7375	43.7125	43.7175	38572.0
2018-01-25 09:15:00	AAPL	Stock	43.7225	43.7375	43.705	43.705	31992.0

> showing 50 of 366,766 rows — these rows as CSV

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