PREVIEW / etf_5min / 2018-06-26

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-06-26.parquet
  size:    1.3 MB
  rows:    58,813

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-06-26 04:00:00	SPY	ETF	271.0	271.0	271.0	271.0	200.0
2018-06-26 04:05:00	SPY	ETF	271.06	271.13	271.06	271.13	3050.0
2018-06-26 04:10:00	SPY	ETF	271.1	271.1	271.1	271.1	220.0
2018-06-26 04:15:00	SPY	ETF	271.26	271.26	271.26	271.26	100.0
2018-06-26 04:20:00	SPY	ETF	271.23	271.31	271.23	271.31	1050.0
2018-06-26 04:25:00	SPY	ETF	271.33	271.33	271.31	271.33	1300.0
2018-06-26 04:30:00	SPY	ETF	271.43	271.43	271.43	271.43	500.0
2018-06-26 04:35:00	SPY	ETF	271.38	271.38	271.36	271.36	400.0
2018-06-26 04:45:00	SPY	ETF	271.2	271.2	271.2	271.2	400.0
2018-06-26 04:50:00	SPY	ETF	271.18	271.18	271.15	271.15	500.0
2018-06-26 04:55:00	SPY	ETF	271.18	271.28	271.18	271.28	3305.0
2018-06-26 05:05:00	SPY	ETF	271.35	271.35	271.3	271.3	750.0
2018-06-26 05:10:00	SPY	ETF	271.14	271.2	271.1	271.2	2300.0
2018-06-26 05:20:00	SPY	ETF	271.33	271.33	271.33	271.33	1620.0
2018-06-26 05:35:00	SPY	ETF	271.15	271.15	271.15	271.15	2000.0
2018-06-26 05:40:00	SPY	ETF	271.15	271.15	271.15	271.15	600.0
2018-06-26 05:45:00	SPY	ETF	271.2	271.2	271.2	271.2	200.0
2018-06-26 05:55:00	SPY	ETF	271.2	271.2	271.1	271.1	200.0
2018-06-26 06:00:00	SPY	ETF	271.12	271.12	271.12	271.12	300.0
2018-06-26 06:05:00	SPY	ETF	271.04	271.04	270.8	270.8	5074.0
2018-06-26 06:10:00	SPY	ETF	270.78	270.79	270.69	270.69	1734.0
2018-06-26 06:15:00	SPY	ETF	270.69	270.73	270.69	270.73	2474.0
2018-06-26 06:20:00	SPY	ETF	270.77	270.78	270.75	270.75	20500.0
2018-06-26 06:25:00	SPY	ETF	270.71	270.71	270.56	270.56	1140.0
2018-06-26 06:30:00	SPY	ETF	270.7	270.7	270.61	270.61	660.0
2018-06-26 06:35:00	SPY	ETF	270.63	270.68	270.6	270.6	4140.0
2018-06-26 06:40:00	SPY	ETF	270.65	270.87	270.65	270.8	7581.0
2018-06-26 06:45:00	SPY	ETF	270.84	270.87	270.77	270.87	30517.0
2018-06-26 06:50:00	SPY	ETF	270.78	270.98	270.78	270.98	6200.0
2018-06-26 06:55:00	SPY	ETF	271.0	271.0	270.96	270.96	300.0
2018-06-26 07:00:00	SPY	ETF	271.0	271.07	270.94	271.04	57751.0
2018-06-26 07:05:00	SPY	ETF	271.04	271.07	271.02	271.02	4709.0
2018-06-26 07:10:00	SPY	ETF	271.07	271.08	270.98	271.04	16274.0
2018-06-26 07:15:00	SPY	ETF	271.04	271.09	271.03	271.09	3124.0
2018-06-26 07:20:00	SPY	ETF	271.04	271.09	271.0	271.0	2825.0
2018-06-26 07:25:00	SPY	ETF	271.02	271.02	270.87	270.9	25433.0
2018-06-26 07:30:00	SPY	ETF	270.93	270.94	270.88	270.94	7500.0
2018-06-26 07:35:00	SPY	ETF	270.93	270.95	270.8	270.83	66314.0
2018-06-26 07:40:00	SPY	ETF	270.78	270.81	270.76	270.79	15502.0
2018-06-26 07:45:00	SPY	ETF	270.79	270.91	270.78	270.89	19251.0
2018-06-26 07:50:00	SPY	ETF	270.89	270.9	270.82	270.89	29508.0
2018-06-26 07:55:00	SPY	ETF	270.91	270.96	270.91	270.96	2010.0
2018-06-26 08:00:00	SPY	ETF	270.96	271.69	270.78	271.04	27810.0
2018-06-26 08:05:00	SPY	ETF	271.03	271.06	271.03	271.04	21020.0
2018-06-26 08:10:00	SPY	ETF	271.03	271.05	271.02	271.04	13695.0
2018-06-26 08:15:00	SPY	ETF	271.05	271.17	271.04	271.1	13850.0
2018-06-26 08:20:00	SPY	ETF	271.1	271.2	271.07	271.17	20394.0
2018-06-26 08:25:00	SPY	ETF	271.2	271.32	271.15	271.28	38749.0
2018-06-26 08:30:00	SPY	ETF	271.26	271.48	271.25	271.39	60428.0
2018-06-26 08:35:00	SPY	ETF	271.35	271.45	271.34	271.44	38853.0

> showing 50 of 58,813 rows — these rows as CSV

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