PREVIEW / etf_5min / 2018-02-26

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-02-26.parquet
  size:    1.4 MB
  rows:    60,262

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-02-26 04:00:00	SPY	ETF	275.7	276.1	275.7	276.0	2293.0
2018-02-26 04:05:00	SPY	ETF	276.06	276.08	276.02	276.06	3110.0
2018-02-26 04:10:00	SPY	ETF	276.04	276.06	276.01	276.01	2022.0
2018-02-26 04:15:00	SPY	ETF	275.98	275.98	275.81	275.91	2440.0
2018-02-26 04:20:00	SPY	ETF	275.84	275.85	275.83	275.83	6839.0
2018-02-26 04:25:00	SPY	ETF	275.8	275.82	275.69	275.81	6270.0
2018-02-26 04:30:00	SPY	ETF	275.69	275.69	275.69	275.69	1816.0
2018-02-26 04:35:00	SPY	ETF	275.71	275.73	275.65	275.65	2494.0
2018-02-26 04:40:00	SPY	ETF	275.76	275.76	275.76	275.76	408.0
2018-02-26 04:45:00	SPY	ETF	275.93	275.93	275.78	275.78	1608.0
2018-02-26 04:50:00	SPY	ETF	275.79	275.79	275.79	275.79	500.0
2018-02-26 04:55:00	SPY	ETF	275.75	275.75	275.75	275.75	100.0
2018-02-26 05:00:00	SPY	ETF	275.76	275.77	275.76	275.76	2400.0
2018-02-26 05:05:00	SPY	ETF	275.78	275.91	275.78	275.87	6015.0
2018-02-26 05:10:00	SPY	ETF	275.84	275.84	275.79	275.79	645.0
2018-02-26 05:15:00	SPY	ETF	275.9	275.93	275.9	275.92	1955.0
2018-02-26 05:20:00	SPY	ETF	275.95	275.95	275.92	275.92	1050.0
2018-02-26 05:25:00	SPY	ETF	275.92	275.92	275.91	275.91	5300.0
2018-02-26 05:30:00	SPY	ETF	275.95	275.95	275.95	275.95	500.0
2018-02-26 05:35:00	SPY	ETF	275.9	275.9	275.9	275.9	300.0
2018-02-26 05:40:00	SPY	ETF	275.94	275.95	275.94	275.95	2000.0
2018-02-26 05:45:00	SPY	ETF	275.91	275.93	275.91	275.93	301.0
2018-02-26 05:50:00	SPY	ETF	275.84	275.92	275.83	275.92	2102.0
2018-02-26 05:55:00	SPY	ETF	275.92	275.98	275.92	275.96	3586.0
2018-02-26 06:00:00	SPY	ETF	276.0	276.0	276.0	276.0	590.0
2018-02-26 06:05:00	SPY	ETF	276.0	276.07	276.0	276.07	1865.0
2018-02-26 06:10:00	SPY	ETF	276.04	276.04	275.98	275.98	1150.0
2018-02-26 06:15:00	SPY	ETF	275.97	275.97	275.92	275.92	1000.0
2018-02-26 06:30:00	SPY	ETF	275.88	275.88	275.85	275.86	5923.0
2018-02-26 06:35:00	SPY	ETF	275.84	275.86	275.84	275.86	900.0
2018-02-26 06:40:00	SPY	ETF	275.82	275.86	275.8	275.86	800.0
2018-02-26 06:45:00	SPY	ETF	275.87	275.93	275.87	275.92	2006.0
2018-02-26 06:50:00	SPY	ETF	275.98	275.98	275.84	275.84	2800.0
2018-02-26 06:55:00	SPY	ETF	275.84	275.88	275.84	275.88	1200.0
2018-02-26 07:00:00	SPY	ETF	275.88	275.9	275.85	275.89	2282.0
2018-02-26 07:05:00	SPY	ETF	275.93	276.05	275.93	276.04	6126.0
2018-02-26 07:10:00	SPY	ETF	276.02	276.03	275.93	275.98	40995.0
2018-02-26 07:15:00	SPY	ETF	275.94	276.02	275.92	276.02	23350.0
2018-02-26 07:20:00	SPY	ETF	276.05	276.05	275.93	275.95	33271.0
2018-02-26 07:25:00	SPY	ETF	275.95	275.95	275.82	275.87	15131.0
2018-02-26 07:30:00	SPY	ETF	275.84	275.87	275.8	275.81	6787.0
2018-02-26 07:35:00	SPY	ETF	275.8	275.8	275.69	275.72	3637.0
2018-02-26 07:40:00	SPY	ETF	275.68	275.72	275.63	275.63	10766.0
2018-02-26 07:45:00	SPY	ETF	275.7	275.77	275.7	275.75	5142.0
2018-02-26 07:50:00	SPY	ETF	275.77	275.77	275.75	275.77	2905.0
2018-02-26 07:55:00	SPY	ETF	275.78	275.94	275.78	275.91	4797.0
2018-02-26 08:00:00	SPY	ETF	275.95	276.03	275.35	275.94	52039.0
2018-02-26 08:05:00	SPY	ETF	275.95	275.95	275.82	275.85	8020.0
2018-02-26 08:10:00	SPY	ETF	275.87	275.87	275.71	275.75	20860.0
2018-02-26 08:15:00	SPY	ETF	275.75	275.78	275.74	275.75	6030.0

> showing 50 of 60,262 rows — these rows as CSV

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