PREVIEW / etf_5min / 2017-08-18

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-08-18.parquet
  size:    1.2 MB
  rows:    52,856

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-08-18 04:00:00	SPY	ETF	243.11	243.11	243.06	243.06	930.0
2017-08-18 04:05:00	SPY	ETF	243.1	243.1	243.04	243.06	1700.0
2017-08-18 04:10:00	SPY	ETF	243.05	243.05	242.97	242.97	1100.0
2017-08-18 04:15:00	SPY	ETF	242.92	242.94	242.92	242.94	300.0
2017-08-18 04:20:00	SPY	ETF	243.05	243.09	243.0	243.09	430.0
2017-08-18 04:30:00	SPY	ETF	243.1	243.1	243.1	243.1	300.0
2017-08-18 04:35:00	SPY	ETF	242.99	242.99	242.99	242.99	100.0
2017-08-18 04:40:00	SPY	ETF	242.82	242.84	242.82	242.84	8092.0
2017-08-18 04:45:00	SPY	ETF	242.82	242.82	242.82	242.82	500.0
2017-08-18 04:50:00	SPY	ETF	242.74	242.76	242.72	242.72	6720.0
2017-08-18 04:55:00	SPY	ETF	242.76	242.8	242.76	242.8	6000.0
2017-08-18 05:00:00	SPY	ETF	242.78	242.82	242.77	242.82	5500.0
2017-08-18 05:05:00	SPY	ETF	242.87	242.9	242.87	242.9	3300.0
2017-08-18 05:10:00	SPY	ETF	242.85	242.85	242.85	242.85	400.0
2017-08-18 05:15:00	SPY	ETF	242.95	242.95	242.95	242.95	1000.0
2017-08-18 05:20:00	SPY	ETF	242.95	242.95	242.95	242.95	300.0
2017-08-18 05:25:00	SPY	ETF	243.0	243.0	243.0	243.0	500.0
2017-08-18 05:30:00	SPY	ETF	243.05	243.05	243.05	243.05	503.0
2017-08-18 05:35:00	SPY	ETF	243.18	243.18	243.18	243.18	1000.0
2017-08-18 05:40:00	SPY	ETF	243.2	243.2	243.2	243.2	1500.0
2017-08-18 05:45:00	SPY	ETF	243.25	243.25	243.25	243.25	1000.0
2017-08-18 05:50:00	SPY	ETF	243.1	243.1	243.1	243.1	1400.0
2017-08-18 05:55:00	SPY	ETF	243.1	243.1	243.1	243.1	1650.0
2017-08-18 06:00:00	SPY	ETF	243.15	243.15	243.15	243.15	2140.0
2017-08-18 06:05:00	SPY	ETF	243.22	243.22	243.22	243.22	1000.0
2017-08-18 06:10:00	SPY	ETF	243.25	243.25	243.22	243.22	1700.0
2017-08-18 06:15:00	SPY	ETF	243.33	243.35	243.31	243.35	5200.0
2017-08-18 06:20:00	SPY	ETF	243.32	243.32	243.32	243.32	1000.0
2017-08-18 06:25:00	SPY	ETF	243.32	243.38	243.32	243.38	1800.0
2017-08-18 06:30:00	SPY	ETF	243.27	243.35	243.27	243.35	6000.0
2017-08-18 06:35:00	SPY	ETF	243.32	243.32	243.28	243.28	800.0
2017-08-18 06:40:00	SPY	ETF	243.27	243.33	243.27	243.33	2703.0
2017-08-18 06:45:00	SPY	ETF	243.29	243.31	243.27	243.3	3200.0
2017-08-18 06:50:00	SPY	ETF	243.29	243.31	243.29	243.31	4700.0
2017-08-18 06:55:00	SPY	ETF	243.29	243.29	243.2	243.23	5635.0
2017-08-18 07:00:00	SPY	ETF	243.23	243.25	243.2	243.2	120764.0
2017-08-18 07:05:00	SPY	ETF	243.2	243.2	243.17	243.17	6880.0
2017-08-18 07:10:00	SPY	ETF	243.17	243.17	243.05	243.09	5650.0
2017-08-18 07:15:00	SPY	ETF	243.08	243.13	243.06	243.11	9723.0
2017-08-18 07:20:00	SPY	ETF	243.11	243.11	243.04	243.04	8000.0
2017-08-18 07:25:00	SPY	ETF	243.03	243.05	243.0	243.04	4550.0
2017-08-18 07:30:00	SPY	ETF	243.03	243.08	243.03	243.08	3400.0
2017-08-18 07:35:00	SPY	ETF	243.1	243.14	243.1	243.14	19923.0
2017-08-18 07:40:00	SPY	ETF	243.18	243.31	243.18	243.31	77900.0
2017-08-18 07:45:00	SPY	ETF	243.32	243.4	243.32	243.4	39987.0
2017-08-18 07:50:00	SPY	ETF	243.4	243.45	243.38	243.4	36551.0
2017-08-18 07:55:00	SPY	ETF	243.41	243.41	243.37	243.4	2000.0
2017-08-18 08:00:00	SPY	ETF	243.23	243.48	242.61	243.47	443173.0
2017-08-18 08:05:00	SPY	ETF	243.47	243.48	243.42	243.46	26625.0
2017-08-18 08:10:00	SPY	ETF	243.45	243.48	243.41	243.48	18010.0

> showing 50 of 52,856 rows — these rows as CSV

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