PREVIEW / etf_1min / 2019-09-09

all etf 1-min files

  file:    by_date/etf_1min/2019/2019-09-09.parquet
  size:    3.2 MB
  rows:    162,554

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-09 04:01:00	SPY	ETF	298.92	298.92	298.92	298.92	3000.0
2019-09-09 04:02:00	SPY	ETF	298.82	298.82	298.82	298.82	539.0
2019-09-09 04:03:00	SPY	ETF	298.85	298.85	298.85	298.85	250.0
2019-09-09 04:05:00	SPY	ETF	298.83	298.83	298.83	298.83	170.0
2019-09-09 04:23:00	SPY	ETF	298.77	298.81	298.77	298.81	1300.0
2019-09-09 04:25:00	SPY	ETF	298.76	298.76	298.76	298.76	375.0
2019-09-09 04:29:00	SPY	ETF	298.73	298.73	298.73	298.73	100.0
2019-09-09 04:37:00	SPY	ETF	298.8	298.8	298.8	298.8	450.0
2019-09-09 04:47:00	SPY	ETF	298.78	298.78	298.78	298.78	1000.0
2019-09-09 04:48:00	SPY	ETF	298.8	298.8	298.8	298.8	200.0
2019-09-09 05:33:00	SPY	ETF	298.92	298.92	298.92	298.92	500.0
2019-09-09 05:36:00	SPY	ETF	298.9	298.9	298.9	298.9	300.0
2019-09-09 05:41:00	SPY	ETF	298.87	298.87	298.87	298.87	100.0
2019-09-09 05:42:00	SPY	ETF	298.86	298.86	298.85	298.85	350.0
2019-09-09 05:47:00	SPY	ETF	298.99	299.0	298.99	299.0	700.0
2019-09-09 05:50:00	SPY	ETF	299.05	299.08	299.05	299.08	4000.0
2019-09-09 05:52:00	SPY	ETF	299.03	299.03	299.03	299.03	300.0
2019-09-09 05:53:00	SPY	ETF	299.1	299.1	299.1	299.1	4000.0
2019-09-09 06:01:00	SPY	ETF	299.15	299.15	299.15	299.15	200.0
2019-09-09 06:03:00	SPY	ETF	299.18	299.18	299.18	299.18	300.0
2019-09-09 06:08:00	SPY	ETF	299.18	299.18	299.18	299.18	110.0
2019-09-09 06:10:00	SPY	ETF	299.18	299.21	299.18	299.21	922.0
2019-09-09 06:11:00	SPY	ETF	299.18	299.18	299.18	299.18	305.0
2019-09-09 06:12:00	SPY	ETF	299.18	299.18	299.18	299.18	100.0
2019-09-09 06:13:00	SPY	ETF	299.17	299.17	299.17	299.17	200.0
2019-09-09 06:15:00	SPY	ETF	299.13	299.13	299.13	299.13	200.0
2019-09-09 06:17:00	SPY	ETF	299.1	299.1	299.1	299.1	100.0
2019-09-09 06:18:00	SPY	ETF	299.16	299.16	299.16	299.16	300.0
2019-09-09 06:21:00	SPY	ETF	299.16	299.16	299.16	299.16	300.0
2019-09-09 06:27:00	SPY	ETF	299.13	299.13	299.13	299.13	100.0
2019-09-09 06:33:00	SPY	ETF	299.11	299.11	299.11	299.11	300.0
2019-09-09 06:34:00	SPY	ETF	299.09	299.09	299.09	299.09	100.0
2019-09-09 06:35:00	SPY	ETF	299.05	299.05	299.05	299.05	400.0
2019-09-09 06:36:00	SPY	ETF	299.05	299.05	299.05	299.05	700.0
2019-09-09 06:38:00	SPY	ETF	299.08	299.08	299.08	299.08	300.0
2019-09-09 06:41:00	SPY	ETF	299.03	299.03	299.0	299.0	2657.0
2019-09-09 06:47:00	SPY	ETF	298.98	298.98	298.98	298.98	157.0
2019-09-09 06:50:00	SPY	ETF	299.1	299.1	299.1	299.1	150.0
2019-09-09 06:51:00	SPY	ETF	299.05	299.05	299.05	299.05	157.0
2019-09-09 06:54:00	SPY	ETF	299.04	299.1	299.04	299.1	2100.0
2019-09-09 07:00:00	SPY	ETF	299.04	299.06	299.02	299.02	1900.0
2019-09-09 07:01:00	SPY	ETF	299.0	299.02	299.0	299.0	1790.0
2019-09-09 07:02:00	SPY	ETF	299.0	299.01	299.0	299.0	16305.0
2019-09-09 07:03:00	SPY	ETF	299.0	299.0	299.0	299.0	20808.0
2019-09-09 07:04:00	SPY	ETF	299.0	299.0	298.99	299.0	18329.0
2019-09-09 07:05:00	SPY	ETF	298.99	298.99	298.95	298.95	2405.0
2019-09-09 07:08:00	SPY	ETF	299.0	299.0	299.0	299.0	449.0
2019-09-09 07:09:00	SPY	ETF	298.97	298.97	298.97	298.97	300.0
2019-09-09 07:10:00	SPY	ETF	298.95	298.95	298.92	298.92	1384.0
2019-09-09 07:12:00	SPY	ETF	298.92	298.92	298.92	298.92	850.0

> showing 50 of 162,554 rows — these rows as CSV

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