PREVIEW / etf_5min / 2018-09-07

all etf 5-min files

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

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-09-07 04:00:00	SPY	ETF	287.97	287.97	287.85	287.85	700.0
2018-09-07 04:05:00	SPY	ETF	287.84	287.84	287.8	287.8	3000.0
2018-09-07 04:10:00	SPY	ETF	287.77	287.77	287.77	287.77	100.0
2018-09-07 04:15:00	SPY	ETF	287.81	287.81	287.81	287.81	800.0
2018-09-07 04:20:00	SPY	ETF	287.81	287.84	287.81	287.83	2200.0
2018-09-07 04:35:00	SPY	ETF	287.91	287.91	287.91	287.91	100.0
2018-09-07 04:55:00	SPY	ETF	287.71	287.71	287.71	287.71	40000.0
2018-09-07 05:00:00	SPY	ETF	287.65	287.65	287.65	287.65	1100.0
2018-09-07 05:05:00	SPY	ETF	287.75	287.75	287.75	287.75	9100.0
2018-09-07 05:10:00	SPY	ETF	287.75	287.75	287.75	287.75	900.0
2018-09-07 05:20:00	SPY	ETF	287.96	288.03	287.96	288.03	600.0
2018-09-07 05:25:00	SPY	ETF	287.96	287.96	287.92	287.92	4300.0
2018-09-07 05:30:00	SPY	ETF	287.86	287.86	287.86	287.86	400.0
2018-09-07 05:35:00	SPY	ETF	287.78	287.78	287.78	287.78	700.0
2018-09-07 05:40:00	SPY	ETF	287.77	287.77	287.71	287.74	10000.0
2018-09-07 05:45:00	SPY	ETF	287.65	287.65	287.63	287.63	8200.0
2018-09-07 05:50:00	SPY	ETF	287.5	287.5	287.46	287.46	5874.0
2018-09-07 05:55:00	SPY	ETF	287.52	287.52	287.52	287.52	370.0
2018-09-07 06:00:00	SPY	ETF	287.54	287.56	287.46	287.46	550.0
2018-09-07 06:05:00	SPY	ETF	287.5	287.5	287.5	287.5	100.0
2018-09-07 06:10:00	SPY	ETF	287.55	287.55	287.55	287.55	1050.0
2018-09-07 06:15:00	SPY	ETF	287.5	287.53	287.5	287.53	3100.0
2018-09-07 06:20:00	SPY	ETF	287.54	287.56	287.54	287.56	3800.0
2018-09-07 06:25:00	SPY	ETF	287.61	287.61	287.61	287.61	200.0
2018-09-07 06:30:00	SPY	ETF	287.65	287.81	287.65	287.75	11744.0
2018-09-07 06:35:00	SPY	ETF	287.74	287.76	287.74	287.76	3320.0
2018-09-07 06:40:00	SPY	ETF	287.73	287.73	287.72	287.72	550.0
2018-09-07 06:45:00	SPY	ETF	287.76	287.83	287.75	287.83	6544.0
2018-09-07 06:50:00	SPY	ETF	287.79	287.79	287.78	287.78	1200.0
2018-09-07 06:55:00	SPY	ETF	287.79	287.79	287.79	287.79	397.0
2018-09-07 07:00:00	SPY	ETF	287.74	287.76	287.72	287.76	598.0
2018-09-07 07:05:00	SPY	ETF	287.73	287.76	287.68	287.76	19850.0
2018-09-07 07:10:00	SPY	ETF	287.71	287.78	287.71	287.77	14719.0
2018-09-07 07:15:00	SPY	ETF	287.81	287.85	287.81	287.85	5098.0
2018-09-07 07:20:00	SPY	ETF	287.82	287.82	287.79	287.82	2200.0
2018-09-07 07:25:00	SPY	ETF	287.82	287.83	287.75	287.77	7100.0
2018-09-07 07:30:00	SPY	ETF	287.74	287.8	287.74	287.79	1506.0
2018-09-07 07:35:00	SPY	ETF	287.76	287.76	287.76	287.76	2100.0
2018-09-07 07:40:00	SPY	ETF	287.76	287.76	287.66	287.66	24090.0
2018-09-07 07:45:00	SPY	ETF	287.76	287.78	287.75	287.78	836.0
2018-09-07 07:50:00	SPY	ETF	287.75	287.75	287.75	287.75	200.0
2018-09-07 07:55:00	SPY	ETF	287.73	287.73	287.61	287.65	21680.0
2018-09-07 08:00:00	SPY	ETF	287.64	288.11	287.64	287.64	12290.0
2018-09-07 08:05:00	SPY	ETF	287.63	287.65	287.59	287.61	7825.0
2018-09-07 08:10:00	SPY	ETF	287.58	287.67	287.58	287.65	36993.0
2018-09-07 08:15:00	SPY	ETF	287.69	287.73	287.62	287.62	9827.0
2018-09-07 08:20:00	SPY	ETF	287.61	287.65	287.6	287.61	14169.0
2018-09-07 08:25:00	SPY	ETF	287.61	287.77	287.57	287.72	55454.0
2018-09-07 08:30:00	SPY	ETF	287.66	287.88	287.15	287.2	356710.0
2018-09-07 08:35:00	SPY	ETF	287.19	287.24	287.04	287.06	137598.0

> showing 50 of 56,696 rows — these rows as CSV

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