PREVIEW / etf_1min / 2019-11-05

all etf 1-min files

  file:    by_date/etf_1min/2019/2019-11-05.parquet
  size:    3.3 MB
  rows:    171,405

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-11-05 04:00:00	SPY	ETF	307.86	307.86	307.86	307.86	206.0
2019-11-05 04:02:00	SPY	ETF	307.86	307.86	307.86	307.86	400.0
2019-11-05 04:03:00	SPY	ETF	307.89	307.94	307.89	307.94	7800.0
2019-11-05 04:11:00	SPY	ETF	307.9	307.9	307.9	307.9	100.0
2019-11-05 04:12:00	SPY	ETF	307.91	307.91	307.91	307.91	200.0
2019-11-05 04:15:00	SPY	ETF	307.91	307.91	307.91	307.91	110.0
2019-11-05 04:18:00	SPY	ETF	307.9	307.9	307.9	307.9	154.0
2019-11-05 04:20:00	SPY	ETF	307.97	307.97	307.97	307.97	200.0
2019-11-05 04:21:00	SPY	ETF	307.99	307.99	307.99	307.99	100.0
2019-11-05 04:22:00	SPY	ETF	308.02	308.02	308.02	308.02	101.0
2019-11-05 04:26:00	SPY	ETF	308.05	308.05	308.05	308.05	100.0
2019-11-05 04:28:00	SPY	ETF	308.02	308.02	308.02	308.02	200.0
2019-11-05 04:32:00	SPY	ETF	308.03	308.03	308.03	308.03	400.0
2019-11-05 04:34:00	SPY	ETF	308.03	308.03	308.03	308.03	305.0
2019-11-05 04:35:00	SPY	ETF	308.03	308.03	308.03	308.03	1300.0
2019-11-05 04:37:00	SPY	ETF	308.06	308.07	308.05	308.06	23010.0
2019-11-05 04:38:00	SPY	ETF	308.08	308.1	308.08	308.1	7200.0
2019-11-05 04:39:00	SPY	ETF	308.1	308.1	308.1	308.1	5000.0
2019-11-05 04:40:00	SPY	ETF	308.05	308.1	308.05	308.09	14790.0
2019-11-05 04:43:00	SPY	ETF	308.03	308.03	308.03	308.03	200.0
2019-11-05 04:48:00	SPY	ETF	307.97	307.97	307.97	307.97	200.0
2019-11-05 04:55:00	SPY	ETF	307.93	307.93	307.93	307.93	303.0
2019-11-05 05:03:00	SPY	ETF	308.04	308.05	308.04	308.05	3000.0
2019-11-05 05:05:00	SPY	ETF	308.06	308.08	308.06	308.08	200.0
2019-11-05 05:06:00	SPY	ETF	308.1	308.1	308.1	308.1	200.0
2019-11-05 05:07:00	SPY	ETF	308.1	308.1	308.1	308.1	100.0
2019-11-05 05:11:00	SPY	ETF	308.15	308.15	308.15	308.15	600.0
2019-11-05 05:12:00	SPY	ETF	308.15	308.17	308.15	308.17	1500.0
2019-11-05 05:16:00	SPY	ETF	308.15	308.15	308.15	308.15	1000.0
2019-11-05 05:23:00	SPY	ETF	308.13	308.13	308.13	308.13	500.0
2019-11-05 05:26:00	SPY	ETF	308.18	308.18	308.16	308.16	500.0
2019-11-05 05:27:00	SPY	ETF	308.13	308.13	308.13	308.13	100.0
2019-11-05 05:29:00	SPY	ETF	308.1	308.13	308.1	308.13	410.0
2019-11-05 05:30:00	SPY	ETF	308.09	308.09	308.09	308.09	300.0
2019-11-05 05:32:00	SPY	ETF	308.13	308.13	308.13	308.13	100.0
2019-11-05 05:36:00	SPY	ETF	308.16	308.16	308.16	308.16	100.0
2019-11-05 05:44:00	SPY	ETF	308.11	308.11	308.11	308.11	800.0
2019-11-05 05:46:00	SPY	ETF	308.13	308.2	308.13	308.2	6425.0
2019-11-05 05:48:00	SPY	ETF	308.16	308.16	308.16	308.16	200.0
2019-11-05 05:51:00	SPY	ETF	308.21	308.21	308.18	308.18	1000.0
2019-11-05 05:52:00	SPY	ETF	308.16	308.16	308.13	308.13	900.0
2019-11-05 05:53:00	SPY	ETF	308.15	308.15	308.12	308.12	700.0
2019-11-05 06:00:00	SPY	ETF	308.13	308.13	308.13	308.13	300.0
2019-11-05 06:01:00	SPY	ETF	308.13	308.13	308.13	308.13	300.0
2019-11-05 06:02:00	SPY	ETF	308.11	308.11	308.07	308.11	900.0
2019-11-05 06:06:00	SPY	ETF	308.11	308.11	308.11	308.11	600.0
2019-11-05 06:07:00	SPY	ETF	308.0	308.0	307.86	307.86	708.0
2019-11-05 06:08:00	SPY	ETF	307.86	307.86	307.86	307.86	115.0
2019-11-05 06:09:00	SPY	ETF	308.06	308.06	307.99	308.04	2400.0
2019-11-05 06:10:00	SPY	ETF	308.01	308.01	308.0	308.01	500.0

> showing 50 of 171,405 rows — these rows as CSV

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