PREVIEW / etf_1min / 2019-09-17

all etf 1-min files

  file:    by_date/etf_1min/2019/2019-09-17.parquet
  size:    3.0 MB
  rows:    154,483

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-17 04:00:00	SPY	ETF	300.12	300.12	300.12	300.12	200.0
2019-09-17 04:02:00	SPY	ETF	300.32	300.32	300.32	300.32	510.0
2019-09-17 04:04:00	SPY	ETF	300.36	300.36	300.36	300.36	250.0
2019-09-17 04:13:00	SPY	ETF	300.26	300.26	300.26	300.26	900.0
2019-09-17 04:21:00	SPY	ETF	300.33	300.33	300.33	300.33	300.0
2019-09-17 04:30:00	SPY	ETF	300.19	300.19	300.19	300.19	1000.0
2019-09-17 04:34:00	SPY	ETF	300.08	300.08	300.08	300.08	300.0
2019-09-17 04:39:00	SPY	ETF	300.0	300.04	300.0	300.04	3800.0
2019-09-17 04:42:00	SPY	ETF	300.08	300.08	300.0	300.0	1500.0
2019-09-17 04:43:00	SPY	ETF	299.97	299.97	299.97	299.97	300.0
2019-09-17 04:44:00	SPY	ETF	300.02	300.02	300.02	300.02	400.0
2019-09-17 04:52:00	SPY	ETF	300.0	300.0	300.0	300.0	2000.0
2019-09-17 05:02:00	SPY	ETF	300.1	300.1	300.1	300.1	1000.0
2019-09-17 05:08:00	SPY	ETF	300.2	300.2	300.2	300.2	100.0
2019-09-17 05:11:00	SPY	ETF	300.18	300.18	300.18	300.18	100.0
2019-09-17 05:13:00	SPY	ETF	300.15	300.15	300.13	300.13	1392.0
2019-09-17 05:16:00	SPY	ETF	300.2	300.2	300.2	300.2	2030.0
2019-09-17 05:17:00	SPY	ETF	300.27	300.27	300.27	300.27	400.0
2019-09-17 05:22:00	SPY	ETF	300.22	300.22	300.22	300.22	100.0
2019-09-17 05:25:00	SPY	ETF	300.22	300.22	300.22	300.22	260.0
2019-09-17 05:28:00	SPY	ETF	300.17	300.17	300.17	300.17	300.0
2019-09-17 05:45:00	SPY	ETF	299.99	299.99	299.98	299.98	2100.0
2019-09-17 05:53:00	SPY	ETF	299.95	299.95	299.95	299.95	301.0
2019-09-17 06:01:00	SPY	ETF	299.86	299.86	299.86	299.86	100.0
2019-09-17 06:07:00	SPY	ETF	299.9	299.9	299.9	299.9	400.0
2019-09-17 06:10:00	SPY	ETF	299.92	299.92	299.92	299.92	200.0
2019-09-17 06:11:00	SPY	ETF	299.92	299.95	299.92	299.92	300.0
2019-09-17 06:14:00	SPY	ETF	299.97	299.97	299.97	299.97	500.0
2019-09-17 06:15:00	SPY	ETF	299.94	299.94	299.94	299.94	600.0
2019-09-17 06:19:00	SPY	ETF	299.89	299.89	299.89	299.89	600.0
2019-09-17 06:20:00	SPY	ETF	299.92	299.92	299.92	299.92	300.0
2019-09-17 06:22:00	SPY	ETF	299.9	299.9	299.9	299.9	300.0
2019-09-17 06:23:00	SPY	ETF	299.9	299.9	299.9	299.9	600.0
2019-09-17 06:24:00	SPY	ETF	299.9	299.9	299.9	299.9	300.0
2019-09-17 06:31:00	SPY	ETF	299.9	299.9	299.9	299.9	200.0
2019-09-17 06:33:00	SPY	ETF	299.9	299.9	299.9	299.9	500.0
2019-09-17 06:39:00	SPY	ETF	299.97	299.97	299.97	299.97	200.0
2019-09-17 06:40:00	SPY	ETF	299.91	299.91	299.91	299.91	100.0
2019-09-17 06:43:00	SPY	ETF	299.91	299.91	299.91	299.91	100.0
2019-09-17 06:47:00	SPY	ETF	299.9	299.9	299.9	299.9	100.0
2019-09-17 06:49:00	SPY	ETF	299.95	299.95	299.95	299.95	2500.0
2019-09-17 06:55:00	SPY	ETF	299.83	299.83	299.83	299.83	5100.0
2019-09-17 06:56:00	SPY	ETF	299.79	299.79	299.74	299.74	3420.0
2019-09-17 06:57:00	SPY	ETF	299.72	299.75	299.72	299.72	800.0
2019-09-17 07:00:00	SPY	ETF	299.77	299.78	299.75	299.77	7813.0
2019-09-17 07:02:00	SPY	ETF	299.76	299.76	299.75	299.75	3152.0
2019-09-17 07:03:00	SPY	ETF	299.75	299.75	299.73	299.73	2926.0
2019-09-17 07:04:00	SPY	ETF	299.75	299.76	299.75	299.76	2495.0
2019-09-17 07:05:00	SPY	ETF	299.75	299.76	299.75	299.75	3700.0
2019-09-17 07:06:00	SPY	ETF	299.73	299.73	299.73	299.73	175.0

> showing 50 of 154,483 rows — these rows as CSV

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