PREVIEW / etf_5min / 2018-07-09

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-07-09.parquet
  size:    1.3 MB
  rows:    59,224

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-07-09 04:00:00	SPY	ETF	276.52	276.62	276.42	276.62	1272.0
2018-07-09 04:10:00	SPY	ETF	276.49	276.49	276.49	276.49	302.0
2018-07-09 04:15:00	SPY	ETF	276.48	276.48	276.48	276.48	102.0
2018-07-09 04:20:00	SPY	ETF	276.5	276.5	276.5	276.5	397.0
2018-07-09 04:25:00	SPY	ETF	276.46	276.46	276.46	276.46	233.0
2018-07-09 04:30:00	SPY	ETF	276.49	276.49	276.49	276.49	150.0
2018-07-09 04:40:00	SPY	ETF	276.36	276.36	276.36	276.36	100.0
2018-07-09 04:45:00	SPY	ETF	276.36	276.36	276.36	276.36	313.0
2018-07-09 04:50:00	SPY	ETF	276.28	276.28	276.28	276.28	100.0
2018-07-09 05:00:00	SPY	ETF	276.35	276.35	276.35	276.35	112.0
2018-07-09 05:05:00	SPY	ETF	276.4	276.4	276.4	276.4	200.0
2018-07-09 05:10:00	SPY	ETF	276.4	276.4	276.4	276.4	250.0
2018-07-09 05:15:00	SPY	ETF	276.46	276.46	276.46	276.46	180.0
2018-07-09 05:30:00	SPY	ETF	276.5	276.55	276.5	276.54	1065.0
2018-07-09 05:35:00	SPY	ETF	276.54	276.54	276.5	276.5	4500.0
2018-07-09 05:40:00	SPY	ETF	276.5	276.5	276.5	276.5	100.0
2018-07-09 05:55:00	SPY	ETF	276.59	276.62	276.59	276.62	525.0
2018-07-09 06:20:00	SPY	ETF	276.6	276.6	276.6	276.6	150.0
2018-07-09 06:30:00	SPY	ETF	276.57	276.57	276.54	276.54	600.0
2018-07-09 06:35:00	SPY	ETF	276.54	276.54	276.52	276.52	300.0
2018-07-09 06:40:00	SPY	ETF	276.51	276.6	276.5	276.6	900.0
2018-07-09 06:50:00	SPY	ETF	276.6	276.6	276.6	276.6	2500.0
2018-07-09 06:55:00	SPY	ETF	276.55	276.6	276.55	276.6	2200.0
2018-07-09 07:00:00	SPY	ETF	276.6	276.6	276.5	276.6	3912.0
2018-07-09 07:05:00	SPY	ETF	276.6	276.72	276.6	276.72	16864.0
2018-07-09 07:10:00	SPY	ETF	276.74	276.74	276.6	276.61	51756.0
2018-07-09 07:15:00	SPY	ETF	276.65	276.65	276.57	276.57	5140.0
2018-07-09 07:20:00	SPY	ETF	276.57	276.57	276.48	276.57	10966.0
2018-07-09 07:25:00	SPY	ETF	276.5	276.52	276.47	276.52	5353.0
2018-07-09 07:30:00	SPY	ETF	276.48	276.5	276.44	276.47	25285.0
2018-07-09 07:35:00	SPY	ETF	276.49	276.55	276.45	276.55	12881.0
2018-07-09 07:40:00	SPY	ETF	276.55	276.56	276.54	276.54	8875.0
2018-07-09 07:45:00	SPY	ETF	276.54	276.55	276.53	276.55	6650.0
2018-07-09 07:50:00	SPY	ETF	276.56	276.56	276.56	276.56	100.0
2018-07-09 07:55:00	SPY	ETF	276.53	276.53	276.53	276.53	4516.0
2018-07-09 08:00:00	SPY	ETF	276.52	276.68	275.42	276.53	20608.0
2018-07-09 08:05:00	SPY	ETF	276.53	276.53	276.5	276.52	9770.0
2018-07-09 08:10:00	SPY	ETF	276.52	276.55	276.49	276.5	8024.0
2018-07-09 08:15:00	SPY	ETF	276.5	276.5	276.43	276.43	7708.0
2018-07-09 08:20:00	SPY	ETF	276.42	276.55	276.41	276.55	18235.0
2018-07-09 08:25:00	SPY	ETF	276.55	276.59	276.52	276.54	34133.0
2018-07-09 08:30:00	SPY	ETF	276.57	276.57	276.52	276.53	17710.0
2018-07-09 08:35:00	SPY	ETF	276.53	276.55	276.5	276.52	6780.0
2018-07-09 08:40:00	SPY	ETF	276.53	276.55	276.42	276.42	14438.0
2018-07-09 08:45:00	SPY	ETF	276.45	276.5	276.44	276.49	22271.0
2018-07-09 08:50:00	SPY	ETF	276.48	276.5	276.45	276.47	21562.0
2018-07-09 08:55:00	SPY	ETF	276.45	276.47	276.42	276.45	24103.0
2018-07-09 09:00:00	SPY	ETF	276.45	276.5	276.45	276.49	24564.0
2018-07-09 09:05:00	SPY	ETF	276.49	276.52	276.49	276.52	10864.0
2018-07-09 09:10:00	SPY	ETF	276.5	276.53	276.47	276.52	24939.0

> showing 50 of 59,224 rows — these rows as CSV

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