PREVIEW / etf_1min / 2019-10-22

all etf 1-min files

  file:    by_date/etf_1min/2019/2019-10-22.parquet
  size:    3.1 MB
  rows:    158,951

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-10-22 04:00:00	SPY	ETF	299.95	299.95	299.95	299.95	500.0
2019-10-22 04:01:00	SPY	ETF	299.9	299.9	299.9	299.9	170.0
2019-10-22 04:04:00	SPY	ETF	299.9	299.91	299.88	299.88	2400.0
2019-10-22 04:05:00	SPY	ETF	299.81	299.81	299.81	299.81	334.0
2019-10-22 04:13:00	SPY	ETF	299.74	299.74	299.74	299.74	200.0
2019-10-22 04:17:00	SPY	ETF	299.82	299.82	299.82	299.82	350.0
2019-10-22 04:21:00	SPY	ETF	299.8	299.8	299.79	299.79	350.0
2019-10-22 04:23:00	SPY	ETF	299.77	299.77	299.77	299.77	260.0
2019-10-22 04:26:00	SPY	ETF	299.75	299.75	299.75	299.75	100.0
2019-10-22 04:27:00	SPY	ETF	299.71	299.71	299.68	299.68	850.0
2019-10-22 04:30:00	SPY	ETF	299.7	299.7	299.64	299.64	3050.0
2019-10-22 04:31:00	SPY	ETF	299.64	299.64	299.64	299.64	100.0
2019-10-22 04:33:00	SPY	ETF	299.7	299.7	299.7	299.7	300.0
2019-10-22 04:34:00	SPY	ETF	299.61	299.61	299.61	299.61	100.0
2019-10-22 04:35:00	SPY	ETF	299.61	299.61	299.55	299.55	2200.0
2019-10-22 04:36:00	SPY	ETF	299.56	299.56	299.56	299.56	1200.0
2019-10-22 04:39:00	SPY	ETF	299.65	299.65	299.65	299.65	300.0
2019-10-22 04:40:00	SPY	ETF	299.68	299.73	299.68	299.73	1400.0
2019-10-22 04:41:00	SPY	ETF	299.75	299.76	299.75	299.76	3300.0
2019-10-22 04:44:00	SPY	ETF	299.81	299.81	299.81	299.81	200.0
2019-10-22 04:45:00	SPY	ETF	299.83	299.83	299.83	299.83	100.0
2019-10-22 04:54:00	SPY	ETF	299.81	299.81	299.81	299.81	100.0
2019-10-22 04:56:00	SPY	ETF	299.85	299.85	299.85	299.85	200.0
2019-10-22 05:04:00	SPY	ETF	299.85	299.85	299.85	299.85	1070.0
2019-10-22 05:13:00	SPY	ETF	299.87	299.87	299.86	299.86	500.0
2019-10-22 05:17:00	SPY	ETF	299.89	299.89	299.89	299.89	100.0
2019-10-22 05:21:00	SPY	ETF	299.89	299.89	299.89	299.89	520.0
2019-10-22 05:22:00	SPY	ETF	299.92	299.92	299.92	299.92	100.0
2019-10-22 05:23:00	SPY	ETF	299.93	299.98	299.93	299.98	400.0
2019-10-22 05:26:00	SPY	ETF	300.0	300.0	300.0	300.0	100.0
2019-10-22 05:27:00	SPY	ETF	300.0	300.0	300.0	300.0	200.0
2019-10-22 05:29:00	SPY	ETF	300.0	300.05	300.0	300.05	2000.0
2019-10-22 05:30:00	SPY	ETF	300.09	300.09	300.09	300.09	1000.0
2019-10-22 05:31:00	SPY	ETF	300.1	300.1	300.1	300.1	1600.0
2019-10-22 05:33:00	SPY	ETF	300.13	300.13	300.12	300.12	200.0
2019-10-22 05:36:00	SPY	ETF	300.14	300.18	300.14	300.18	400.0
2019-10-22 05:41:00	SPY	ETF	300.1	300.1	300.1	300.1	150.0
2019-10-22 05:43:00	SPY	ETF	300.09	300.09	300.09	300.09	346.0
2019-10-22 05:46:00	SPY	ETF	300.07	300.07	300.07	300.07	300.0
2019-10-22 05:50:00	SPY	ETF	300.15	300.15	300.15	300.15	100.0
2019-10-22 05:53:00	SPY	ETF	300.14	300.15	300.14	300.15	700.0
2019-10-22 05:54:00	SPY	ETF	300.14	300.19	300.14	300.15	1444.0
2019-10-22 06:01:00	SPY	ETF	300.2	300.22	300.2	300.22	400.0
2019-10-22 06:03:00	SPY	ETF	300.15	300.15	300.15	300.15	250.0
2019-10-22 06:04:00	SPY	ETF	300.15	300.15	300.15	300.15	100.0
2019-10-22 06:06:00	SPY	ETF	300.19	300.19	300.19	300.19	1000.0
2019-10-22 06:11:00	SPY	ETF	300.15	300.15	300.07	300.07	4600.0
2019-10-22 06:12:00	SPY	ETF	300.07	300.07	300.07	300.07	300.0
2019-10-22 06:14:00	SPY	ETF	300.12	300.12	300.06	300.06	550.0
2019-10-22 06:18:00	SPY	ETF	300.09	300.09	300.09	300.09	300.0

> showing 50 of 158,951 rows — these rows as CSV

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