PREVIEW / etf_1min / 2019-09-25

all etf 1-min files

  file:    by_date/etf_1min/2019/2019-09-25.parquet
  size:    3.2 MB
  rows:    163,384

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-09-25 04:00:00	SPY	ETF	295.41	295.41	295.41	295.41	650.0
2019-09-25 04:01:00	SPY	ETF	295.4	295.41	295.4	295.41	233.0
2019-09-25 04:03:00	SPY	ETF	295.4	295.42	295.4	295.41	3790.0
2019-09-25 04:05:00	SPY	ETF	295.38	295.38	295.38	295.38	280.0
2019-09-25 04:06:00	SPY	ETF	295.38	295.38	295.38	295.38	120.0
2019-09-25 04:07:00	SPY	ETF	295.41	295.41	295.41	295.41	700.0
2019-09-25 04:08:00	SPY	ETF	295.55	295.55	295.55	295.55	1010.0
2019-09-25 04:09:00	SPY	ETF	295.53	295.53	295.53	295.53	100.0
2019-09-25 04:10:00	SPY	ETF	295.48	295.49	295.48	295.48	2000.0
2019-09-25 04:16:00	SPY	ETF	295.5	295.56	295.5	295.56	1600.0
2019-09-25 04:17:00	SPY	ETF	295.55	295.55	295.55	295.55	100.0
2019-09-25 04:26:00	SPY	ETF	295.6	295.6	295.6	295.6	500.0
2019-09-25 04:29:00	SPY	ETF	295.53	295.53	295.53	295.53	500.0
2019-09-25 04:30:00	SPY	ETF	295.3	295.3	295.3	295.3	500.0
2019-09-25 04:31:00	SPY	ETF	295.3	295.3	295.3	295.3	100.0
2019-09-25 04:32:00	SPY	ETF	295.34	295.34	295.34	295.34	100.0
2019-09-25 04:34:00	SPY	ETF	295.33	295.33	295.33	295.33	500.0
2019-09-25 04:40:00	SPY	ETF	295.34	295.34	295.34	295.34	530.0
2019-09-25 04:47:00	SPY	ETF	295.22	295.22	295.2	295.2	618.0
2019-09-25 04:48:00	SPY	ETF	295.21	295.22	295.15	295.15	1800.0
2019-09-25 04:49:00	SPY	ETF	295.16	295.16	295.1	295.14	1225.0
2019-09-25 04:50:00	SPY	ETF	295.09	295.09	295.0	295.06	3060.0
2019-09-25 04:52:00	SPY	ETF	295.0	295.04	295.0	295.0	1100.0
2019-09-25 04:53:00	SPY	ETF	294.99	294.99	294.99	294.99	150.0
2019-09-25 04:55:00	SPY	ETF	295.08	295.08	295.07	295.07	1300.0
2019-09-25 04:59:00	SPY	ETF	295.0	295.0	295.0	295.0	100.0
2019-09-25 05:02:00	SPY	ETF	295.07	295.07	295.07	295.07	100.0
2019-09-25 05:04:00	SPY	ETF	295.02	295.04	295.02	295.04	305.0
2019-09-25 05:05:00	SPY	ETF	294.97	294.97	294.97	294.97	100.0
2019-09-25 05:06:00	SPY	ETF	294.96	294.96	294.9	294.94	600.0
2019-09-25 05:07:00	SPY	ETF	294.98	294.98	294.98	294.98	501.0
2019-09-25 05:08:00	SPY	ETF	295.03	295.03	295.03	295.03	500.0
2019-09-25 05:09:00	SPY	ETF	295.05	295.05	295.05	295.05	400.0
2019-09-25 05:10:00	SPY	ETF	295.04	295.04	295.04	295.04	200.0
2019-09-25 05:11:00	SPY	ETF	295.03	295.03	295.03	295.03	400.0
2019-09-25 05:13:00	SPY	ETF	295.1	295.13	295.07	295.13	2362.0
2019-09-25 05:14:00	SPY	ETF	295.14	295.27	295.14	295.27	1100.0
2019-09-25 05:15:00	SPY	ETF	295.19	295.19	295.18	295.18	300.0
2019-09-25 05:17:00	SPY	ETF	295.2	295.2	295.2	295.2	200.0
2019-09-25 05:18:00	SPY	ETF	295.17	295.18	295.17	295.18	200.0
2019-09-25 05:19:00	SPY	ETF	295.15	295.15	295.15	295.15	100.0
2019-09-25 05:20:00	SPY	ETF	295.13	295.13	295.07	295.07	450.0
2019-09-25 05:22:00	SPY	ETF	294.97	294.97	294.97	294.97	300.0
2019-09-25 05:23:00	SPY	ETF	294.88	294.89	294.82	294.82	1136.0
2019-09-25 05:24:00	SPY	ETF	294.75	294.87	294.65	294.87	2600.0
2019-09-25 05:29:00	SPY	ETF	295.0	295.0	295.0	295.0	182.0
2019-09-25 05:31:00	SPY	ETF	295.04	295.04	295.04	295.04	1500.0
2019-09-25 05:32:00	SPY	ETF	295.02	295.02	295.02	295.02	100.0
2019-09-25 05:33:00	SPY	ETF	294.99	294.99	294.92	294.92	460.0
2019-09-25 05:34:00	SPY	ETF	294.86	294.86	294.86	294.86	100.0

> showing 50 of 163,384 rows — these rows as CSV

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