PREVIEW / etf_5min / 2018-02-07

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-02-07.parquet
  size:    1.6 MB
  rows:    68,330

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-07 04:00:00	SPY	ETF	266.94	266.96	266.6	266.6	19498.0
2018-02-07 04:05:00	SPY	ETF	266.65	266.69	266.5	266.5	6172.0
2018-02-07 04:10:00	SPY	ETF	266.38	266.62	266.38	266.62	456.0
2018-02-07 04:15:00	SPY	ETF	266.58	266.7	266.58	266.7	230.0
2018-02-07 04:20:00	SPY	ETF	266.64	266.67	266.41	266.41	20600.0
2018-02-07 04:25:00	SPY	ETF	266.52	266.81	266.5	266.81	5200.0
2018-02-07 04:30:00	SPY	ETF	266.9	267.12	266.9	267.01	2040.0
2018-02-07 04:35:00	SPY	ETF	267.07	267.07	267.07	267.07	100.0
2018-02-07 04:40:00	SPY	ETF	267.2	267.2	267.02	267.04	2126.0
2018-02-07 04:45:00	SPY	ETF	266.96	266.96	266.74	266.74	2245.0
2018-02-07 04:50:00	SPY	ETF	266.74	266.74	266.5	266.5	4254.0
2018-02-07 04:55:00	SPY	ETF	266.54	266.61	266.54	266.61	923.0
2018-02-07 05:00:00	SPY	ETF	266.7	266.7	266.68	266.68	705.0
2018-02-07 05:10:00	SPY	ETF	266.96	267.06	266.93	267.06	1009.0
2018-02-07 05:15:00	SPY	ETF	267.01	267.06	267.0	267.05	10104.0
2018-02-07 05:20:00	SPY	ETF	267.01	267.02	266.94	266.94	5464.0
2018-02-07 05:25:00	SPY	ETF	266.9	266.9	266.65	266.65	783.0
2018-02-07 05:30:00	SPY	ETF	266.8	266.8	266.8	266.8	305.0
2018-02-07 05:35:00	SPY	ETF	266.64	266.64	266.5	266.53	7227.0
2018-02-07 05:40:00	SPY	ETF	266.61	266.61	266.52	266.52	1478.0
2018-02-07 05:45:00	SPY	ETF	266.92	266.94	266.9	266.9	723.0
2018-02-07 05:50:00	SPY	ETF	266.8	266.8	266.8	266.8	150.0
2018-02-07 05:55:00	SPY	ETF	266.65	266.65	266.42	266.58	7235.0
2018-02-07 06:00:00	SPY	ETF	266.42	266.48	266.42	266.48	1218.0
2018-02-07 06:05:00	SPY	ETF	266.37	266.66	266.32	266.66	3544.0
2018-02-07 06:10:00	SPY	ETF	266.65	266.65	266.59	266.6	6216.0
2018-02-07 06:15:00	SPY	ETF	266.6	266.7	266.6	266.7	564.0
2018-02-07 06:20:00	SPY	ETF	266.72	266.9	266.72	266.83	6383.0
2018-02-07 06:25:00	SPY	ETF	266.92	266.92	266.85	266.85	1925.0
2018-02-07 06:30:00	SPY	ETF	266.87	266.97	266.87	266.97	2117.0
2018-02-07 06:35:00	SPY	ETF	267.0	267.12	267.0	267.07	5658.0
2018-02-07 06:40:00	SPY	ETF	267.1	267.42	267.1	267.42	17312.0
2018-02-07 06:45:00	SPY	ETF	267.45	267.66	267.45	267.66	11571.0
2018-02-07 06:50:00	SPY	ETF	267.7	267.71	267.44	267.49	14077.0
2018-02-07 06:55:00	SPY	ETF	267.5	268.16	267.5	268.0	71872.0
2018-02-07 07:00:00	SPY	ETF	268.17	268.3	267.81	268.3	133997.0
2018-02-07 07:05:00	SPY	ETF	268.2	268.24	267.99	268.06	77839.0
2018-02-07 07:10:00	SPY	ETF	268.12	268.35	268.1	268.25	101378.0
2018-02-07 07:15:00	SPY	ETF	268.25	268.3	267.92	267.95	40732.0
2018-02-07 07:20:00	SPY	ETF	267.89	268.11	267.88	268.06	14651.0
2018-02-07 07:25:00	SPY	ETF	268.03	268.18	267.99	268.1	25919.0
2018-02-07 07:30:00	SPY	ETF	268.09	268.15	267.91	268.12	31252.0
2018-02-07 07:35:00	SPY	ETF	268.1	268.39	268.0	268.39	28253.0
2018-02-07 07:40:00	SPY	ETF	268.42	268.49	268.3	268.47	36085.0
2018-02-07 07:45:00	SPY	ETF	268.48	268.48	268.11	268.11	59071.0
2018-02-07 07:50:00	SPY	ETF	268.11	268.11	267.7	267.9	52514.0
2018-02-07 07:55:00	SPY	ETF	267.95	268.18	267.95	268.06	112537.0
2018-02-07 08:00:00	SPY	ETF	267.92	268.47	265.92	268.04	87065.0
2018-02-07 08:05:00	SPY	ETF	267.95	268.23	267.95	268.18	55325.0
2018-02-07 08:10:00	SPY	ETF	268.13	268.38	268.08	268.33	26486.0

> showing 50 of 68,330 rows — these rows as CSV

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