PREVIEW / etf_5min / 2018-04-03

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-04-03.parquet
  size:    1.4 MB
  rows:    59,074

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-04-03 04:00:00	SPY	ETF	257.91	258.0	257.88	258.0	5450.0
2018-04-03 04:05:00	SPY	ETF	258.0	258.05	257.87	258.05	16071.0
2018-04-03 04:10:00	SPY	ETF	258.0	258.02	257.97	258.02	3602.0
2018-04-03 04:15:00	SPY	ETF	258.0	258.0	257.95	257.95	1600.0
2018-04-03 04:20:00	SPY	ETF	257.94	257.95	257.94	257.95	1200.0
2018-04-03 04:25:00	SPY	ETF	258.0	258.06	258.0	258.06	600.0
2018-04-03 04:30:00	SPY	ETF	258.02	258.02	258.0	258.0	4204.0
2018-04-03 04:35:00	SPY	ETF	258.02	258.02	258.02	258.02	500.0
2018-04-03 04:40:00	SPY	ETF	258.02	258.09	258.02	258.09	1200.0
2018-04-03 04:50:00	SPY	ETF	258.05	258.05	258.05	258.05	500.0
2018-04-03 05:00:00	SPY	ETF	258.01	258.01	258.01	258.01	150.0
2018-04-03 05:05:00	SPY	ETF	258.15	258.15	258.15	258.15	300.0
2018-04-03 05:10:00	SPY	ETF	258.05	258.05	258.05	258.05	100.0
2018-04-03 05:15:00	SPY	ETF	258.0	258.03	257.9	257.9	700.0
2018-04-03 05:20:00	SPY	ETF	257.95	258.0	257.87	257.87	1900.0
2018-04-03 05:25:00	SPY	ETF	257.98	257.98	257.86	257.86	310.0
2018-04-03 05:30:00	SPY	ETF	257.94	257.94	257.88	257.88	2172.0
2018-04-03 05:35:00	SPY	ETF	257.93	257.93	257.93	257.93	105.0
2018-04-03 05:40:00	SPY	ETF	257.93	257.93	257.93	257.93	1000.0
2018-04-03 05:50:00	SPY	ETF	257.91	257.91	257.85	257.85	3000.0
2018-04-03 05:55:00	SPY	ETF	257.85	257.85	257.85	257.85	400.0
2018-04-03 06:10:00	SPY	ETF	257.92	258.1	257.92	258.09	8300.0
2018-04-03 06:15:00	SPY	ETF	258.09	258.09	258.09	258.09	300.0
2018-04-03 06:20:00	SPY	ETF	258.13	258.15	258.13	258.15	1160.0
2018-04-03 06:25:00	SPY	ETF	258.06	258.19	258.06	258.13	3900.0
2018-04-03 06:30:00	SPY	ETF	258.26	258.28	258.26	258.28	1200.0
2018-04-03 06:35:00	SPY	ETF	258.29	258.43	258.28	258.38	32315.0
2018-04-03 06:40:00	SPY	ETF	258.43	258.43	258.32	258.32	10700.0
2018-04-03 06:45:00	SPY	ETF	258.4	258.47	258.24	258.33	11699.0
2018-04-03 06:50:00	SPY	ETF	258.3	258.3	258.24	258.26	6588.0
2018-04-03 06:55:00	SPY	ETF	258.3	258.3	258.19	258.19	1000.0
2018-04-03 07:00:00	SPY	ETF	258.15	258.18	258.08	258.11	5566.0
2018-04-03 07:05:00	SPY	ETF	258.18	258.24	258.1	258.24	5901.0
2018-04-03 07:10:00	SPY	ETF	258.33	258.47	258.31	258.35	16008.0
2018-04-03 07:15:00	SPY	ETF	258.29	258.3	258.15	258.15	7932.0
2018-04-03 07:20:00	SPY	ETF	258.22	258.22	258.09	258.1	18539.0
2018-04-03 07:25:00	SPY	ETF	258.13	258.13	258.04	258.1	52071.0
2018-04-03 07:30:00	SPY	ETF	258.1	258.18	258.02	258.15	2200.0
2018-04-03 07:35:00	SPY	ETF	258.09	258.14	258.07	258.11	1771.0
2018-04-03 07:40:00	SPY	ETF	258.11	258.31	258.11	258.31	14629.0
2018-04-03 07:45:00	SPY	ETF	258.27	258.33	258.27	258.33	11825.0
2018-04-03 07:50:00	SPY	ETF	258.32	258.34	258.24	258.33	4978.0
2018-04-03 07:55:00	SPY	ETF	258.33	258.45	258.31	258.42	13173.0
2018-04-03 08:00:00	SPY	ETF	258.47	258.61	257.7	258.46	42908.0
2018-04-03 08:05:00	SPY	ETF	258.52	258.54	258.37	258.52	17615.0
2018-04-03 08:10:00	SPY	ETF	258.46	258.58	258.41	258.55	14909.0
2018-04-03 08:15:00	SPY	ETF	258.55	258.83	258.53	258.83	104423.0
2018-04-03 08:20:00	SPY	ETF	258.83	258.92	258.77	258.8	38858.0
2018-04-03 08:25:00	SPY	ETF	258.78	258.85	258.77	258.84	42925.0
2018-04-03 08:30:00	SPY	ETF	258.84	258.86	258.72	258.72	35050.0

> showing 50 of 59,074 rows — these rows as CSV

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