PREVIEW / etf_5min / 2017-11-28

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-11-28.parquet
  size:    1.3 MB
  rows:    55,643

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-11-28 04:00:00	SPY	ETF	260.35	260.45	260.35	260.45	1299.0
2017-11-28 04:10:00	SPY	ETF	260.49	260.5	260.49	260.5	300.0
2017-11-28 04:15:00	SPY	ETF	260.53	260.53	260.53	260.53	200.0
2017-11-28 04:25:00	SPY	ETF	260.5	260.5	260.5	260.5	130.0
2017-11-28 04:30:00	SPY	ETF	260.49	260.5	260.49	260.5	2800.0
2017-11-28 04:35:00	SPY	ETF	260.53	260.53	260.53	260.53	800.0
2017-11-28 04:40:00	SPY	ETF	260.52	260.52	260.52	260.52	300.0
2017-11-28 04:45:00	SPY	ETF	260.53	260.53	260.5	260.52	900.0
2017-11-28 04:50:00	SPY	ETF	260.52	260.52	260.5	260.5	400.0
2017-11-28 04:55:00	SPY	ETF	260.53	260.53	260.53	260.53	500.0
2017-11-28 05:00:00	SPY	ETF	260.53	260.6	260.53	260.6	1500.0
2017-11-28 05:05:00	SPY	ETF	260.63	260.63	260.63	260.63	300.0
2017-11-28 05:10:00	SPY	ETF	260.57	260.57	260.57	260.57	300.0
2017-11-28 05:15:00	SPY	ETF	260.56	260.56	260.56	260.56	100.0
2017-11-28 05:20:00	SPY	ETF	260.51	260.51	260.51	260.51	300.0
2017-11-28 05:55:00	SPY	ETF	260.61	260.61	260.61	260.61	2000.0
2017-11-28 06:00:00	SPY	ETF	260.62	260.62	260.62	260.62	201.0
2017-11-28 06:05:00	SPY	ETF	260.6	260.62	260.56	260.56	1251.0
2017-11-28 06:10:00	SPY	ETF	260.59	260.6	260.59	260.6	600.0
2017-11-28 06:15:00	SPY	ETF	260.56	260.56	260.56	260.56	200.0
2017-11-28 06:25:00	SPY	ETF	260.62	260.62	260.6	260.61	2200.0
2017-11-28 06:30:00	SPY	ETF	260.65	260.68	260.65	260.68	2501.0
2017-11-28 06:35:00	SPY	ETF	260.68	260.68	260.65	260.65	2750.0
2017-11-28 06:40:00	SPY	ETF	260.67	260.7	260.65	260.65	4130.0
2017-11-28 06:45:00	SPY	ETF	260.66	260.66	260.65	260.65	600.0
2017-11-28 06:55:00	SPY	ETF	260.66	260.7	260.66	260.7	600.0
2017-11-28 07:00:00	SPY	ETF	260.65	260.69	260.64	260.69	26350.0
2017-11-28 07:05:00	SPY	ETF	260.68	260.69	260.67	260.69	49100.0
2017-11-28 07:10:00	SPY	ETF	260.69	260.69	260.67	260.69	37794.0
2017-11-28 07:15:00	SPY	ETF	260.7	260.7	260.66	260.69	13664.0
2017-11-28 07:20:00	SPY	ETF	260.69	260.69	260.68	260.68	360.0
2017-11-28 07:25:00	SPY	ETF	260.68	260.68	260.66	260.66	13000.0
2017-11-28 07:30:00	SPY	ETF	260.66	260.69	260.65	260.68	88840.0
2017-11-28 07:35:00	SPY	ETF	260.7	260.71	260.69	260.69	3969.0
2017-11-28 07:40:00	SPY	ETF	260.65	260.65	260.63	260.63	900.0
2017-11-28 07:45:00	SPY	ETF	260.64	260.65	260.62	260.63	13157.0
2017-11-28 07:50:00	SPY	ETF	260.63	260.63	260.62	260.62	1269.0
2017-11-28 07:55:00	SPY	ETF	260.64	260.65	260.63	260.63	1400.0
2017-11-28 08:00:00	SPY	ETF	260.62	260.65	260.62	260.64	18277.0
2017-11-28 08:05:00	SPY	ETF	260.62	260.67	260.62	260.64	22107.0
2017-11-28 08:10:00	SPY	ETF	260.66	260.68	260.66	260.67	6128.0
2017-11-28 08:15:00	SPY	ETF	260.66	260.67	260.66	260.67	11369.0
2017-11-28 08:20:00	SPY	ETF	260.69	260.69	260.68	260.69	2669.0
2017-11-28 08:25:00	SPY	ETF	260.64	260.67	260.64	260.65	5687.0
2017-11-28 08:30:00	SPY	ETF	260.67	260.68	260.67	260.68	6954.0
2017-11-28 08:35:00	SPY	ETF	260.65	260.66	260.61	260.61	8328.0
2017-11-28 08:40:00	SPY	ETF	260.61	260.66	260.61	260.65	5932.0
2017-11-28 08:45:00	SPY	ETF	260.66	260.7	260.66	260.67	19338.0
2017-11-28 08:50:00	SPY	ETF	260.68	260.77	260.68	260.75	56296.0
2017-11-28 08:55:00	SPY	ETF	260.74	260.75	260.73	260.74	48915.0

> showing 50 of 55,643 rows — these rows as CSV

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