PREVIEW / etf_5min / 2019-07-15

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-07-15.parquet
  size:    1.3 MB
  rows:    60,568

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
2019-07-15 04:00:00	SPY	ETF	301.16	301.25	301.16	301.25	1608.0
2019-07-15 04:05:00	SPY	ETF	301.22	301.22	301.22	301.22	135.0
2019-07-15 04:10:00	SPY	ETF	301.01	301.01	301.01	301.01	1000.0
2019-07-15 04:40:00	SPY	ETF	301.0	301.0	301.0	301.0	160.0
2019-07-15 04:45:00	SPY	ETF	301.0	301.0	301.0	301.0	103.0
2019-07-15 04:55:00	SPY	ETF	300.97	300.97	300.95	300.95	800.0
2019-07-15 05:05:00	SPY	ETF	300.87	300.87	300.87	300.87	100.0
2019-07-15 05:10:00	SPY	ETF	301.0	301.0	301.0	301.0	200.0
2019-07-15 05:20:00	SPY	ETF	300.8	300.8	300.8	300.8	100.0
2019-07-15 05:30:00	SPY	ETF	300.74	300.8	300.74	300.8	2400.0
2019-07-15 05:35:00	SPY	ETF	300.72	300.72	300.62	300.62	905.0
2019-07-15 05:45:00	SPY	ETF	300.75	300.75	300.75	300.75	1000.0
2019-07-15 05:50:00	SPY	ETF	300.79	300.87	300.79	300.87	2400.0
2019-07-15 05:55:00	SPY	ETF	300.87	300.87	300.79	300.79	2500.0
2019-07-15 06:00:00	SPY	ETF	300.83	300.83	300.82	300.82	631.0
2019-07-15 06:05:00	SPY	ETF	300.83	300.89	300.82	300.89	900.0
2019-07-15 06:10:00	SPY	ETF	300.89	300.89	300.89	300.89	1969.0
2019-07-15 06:15:00	SPY	ETF	300.94	301.05	300.94	301.05	2650.0
2019-07-15 06:25:00	SPY	ETF	300.96	300.96	300.93	300.95	1938.0
2019-07-15 06:30:00	SPY	ETF	300.9	300.93	300.9	300.93	876.0
2019-07-15 06:40:00	SPY	ETF	300.92	300.99	300.92	300.92	2727.0
2019-07-15 06:45:00	SPY	ETF	300.92	301.0	300.92	300.97	4101.0
2019-07-15 06:55:00	SPY	ETF	300.94	300.94	300.94	300.94	500.0
2019-07-15 07:00:00	SPY	ETF	300.97	301.01	300.96	300.99	6181.0
2019-07-15 07:05:00	SPY	ETF	300.97	301.01	300.97	301.01	12169.0
2019-07-15 07:10:00	SPY	ETF	301.02	301.05	300.96	301.04	1938.0
2019-07-15 07:15:00	SPY	ETF	301.02	301.02	301.01	301.01	500.0
2019-07-15 07:20:00	SPY	ETF	301.01	301.05	301.01	301.05	31570.0
2019-07-15 07:25:00	SPY	ETF	301.08	301.08	301.05	301.05	2666.0
2019-07-15 07:30:00	SPY	ETF	301.06	301.06	301.06	301.06	244.0
2019-07-15 07:35:00	SPY	ETF	301.08	301.08	301.05	301.05	2115.0
2019-07-15 07:40:00	SPY	ETF	301.08	301.13	301.06	301.08	11055.0
2019-07-15 07:45:00	SPY	ETF	301.04	301.04	301.04	301.04	200.0
2019-07-15 07:50:00	SPY	ETF	301.04	301.1	301.04	301.1	18020.0
2019-07-15 07:55:00	SPY	ETF	301.15	301.2	301.1	301.15	25580.0
2019-07-15 08:00:00	SPY	ETF	301.08	301.2	300.65	301.16	28844.0
2019-07-15 08:05:00	SPY	ETF	301.15	301.2001	301.13	301.17	88161.0
2019-07-15 08:10:00	SPY	ETF	301.19	301.22	301.13	301.18	34335.0
2019-07-15 08:15:00	SPY	ETF	301.17	301.25	301.15	301.15	27986.0
2019-07-15 08:20:00	SPY	ETF	301.17	301.17	301.15	301.17	5910.0
2019-07-15 08:25:00	SPY	ETF	301.18	301.19	301.13	301.13	13557.0
2019-07-15 08:30:00	SPY	ETF	301.13	301.15	301.1	301.12	11536.0
2019-07-15 08:35:00	SPY	ETF	301.12	301.12	301.06	301.07	8050.0
2019-07-15 08:40:00	SPY	ETF	301.09	301.12	301.08	301.09	8885.0
2019-07-15 08:45:00	SPY	ETF	301.16	301.22	301.16	301.21	18360.0
2019-07-15 08:50:00	SPY	ETF	301.21	301.26	301.2	301.21	13359.0
2019-07-15 08:55:00	SPY	ETF	301.23	301.24	301.17	301.1799	27521.0
2019-07-15 09:00:00	SPY	ETF	301.17	301.2101	301.13	301.19	7496.0
2019-07-15 09:05:00	SPY	ETF	301.16	301.17	301.14	301.17	1241.0
2019-07-15 09:10:00	SPY	ETF	301.14	301.16	301.14	301.14	6438.0

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

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