PREVIEW / etf_1min / 2019-04-03

all etf 1-min files

  file:    by_date/etf_1min/2019/2019-04-03.parquet
  size:    3.4 MB
  rows:    180,597

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-04-03 04:00:00	SPY	ETF	286.93	287.1	286.93	287.1	3315.0
2019-04-03 04:01:00	SPY	ETF	287.2	287.21	287.2	287.21	300.0
2019-04-03 04:02:00	SPY	ETF	287.24	287.24	287.24	287.24	130.0
2019-04-03 04:06:00	SPY	ETF	287.22	287.22	287.19	287.19	5630.0
2019-04-03 04:07:00	SPY	ETF	287.2	287.22	287.2	287.22	620.0
2019-04-03 04:09:00	SPY	ETF	287.16	287.16	287.16	287.16	100.0
2019-04-03 04:15:00	SPY	ETF	287.15	287.15	287.15	287.15	300.0
2019-04-03 04:17:00	SPY	ETF	287.16	287.16	287.16	287.16	100.0
2019-04-03 04:18:00	SPY	ETF	287.11	287.11	287.11	287.11	300.0
2019-04-03 04:20:00	SPY	ETF	287.17	287.17	287.17	287.17	269.0
2019-04-03 04:21:00	SPY	ETF	287.18	287.18	287.18	287.18	240.0
2019-04-03 04:22:00	SPY	ETF	287.2	287.2	287.2	287.2	394.0
2019-04-03 04:24:00	SPY	ETF	287.18	287.18	287.18	287.18	100.0
2019-04-03 04:28:00	SPY	ETF	287.13	287.13	287.13	287.13	470.0
2019-04-03 04:29:00	SPY	ETF	287.05	287.05	287.05	287.05	100.0
2019-04-03 04:30:00	SPY	ETF	287.05	287.05	287.05	287.05	160.0
2019-04-03 04:31:00	SPY	ETF	287.08	287.1	287.08	287.1	1000.0
2019-04-03 04:32:00	SPY	ETF	287.08	287.08	287.08	287.08	380.0
2019-04-03 04:33:00	SPY	ETF	287.03	287.03	287.03	287.03	200.0
2019-04-03 04:37:00	SPY	ETF	287.05	287.05	287.05	287.05	100.0
2019-04-03 04:42:00	SPY	ETF	287.01	287.03	287.01	287.03	619.0
2019-04-03 04:43:00	SPY	ETF	287.06	287.06	287.06	287.06	169.0
2019-04-03 04:45:00	SPY	ETF	287.07	287.1	287.07	287.1	319.0
2019-04-03 04:47:00	SPY	ETF	287.1	287.1	287.1	287.1	194.0
2019-04-03 04:48:00	SPY	ETF	287.13	287.13	287.13	287.13	169.0
2019-04-03 04:54:00	SPY	ETF	287.1	287.1	287.1	287.1	1100.0
2019-04-03 05:00:00	SPY	ETF	287.1	287.1	287.04	287.05	922.0
2019-04-03 05:01:00	SPY	ETF	287.05	287.08	287.05	287.08	200.0
2019-04-03 05:02:00	SPY	ETF	287.03	287.06	287.03	287.06	600.0
2019-04-03 05:04:00	SPY	ETF	287.01	287.01	286.99	286.99	388.0
2019-04-03 05:08:00	SPY	ETF	287.04	287.04	287.04	287.04	179.0
2019-04-03 05:14:00	SPY	ETF	286.99	286.99	286.99	286.99	169.0
2019-04-03 05:15:00	SPY	ETF	287.01	287.04	287.01	287.04	338.0
2019-04-03 05:16:00	SPY	ETF	287.07	287.07	287.07	287.07	169.0
2019-04-03 05:19:00	SPY	ETF	287.08	287.1	287.08	287.08	2169.0
2019-04-03 05:20:00	SPY	ETF	287.1	287.13	287.1	287.13	969.0
2019-04-03 05:21:00	SPY	ETF	287.14	287.14	287.14	287.14	300.0
2019-04-03 05:24:00	SPY	ETF	287.14	287.14	287.14	287.14	100.0
2019-04-03 05:28:00	SPY	ETF	287.03	287.03	287.03	287.03	600.0
2019-04-03 05:29:00	SPY	ETF	287.03	287.03	287.03	287.03	500.0
2019-04-03 05:36:00	SPY	ETF	287.02	287.02	287.02	287.02	1000.0
2019-04-03 05:37:00	SPY	ETF	287.02	287.02	287.02	287.02	300.0
2019-04-03 05:51:00	SPY	ETF	286.96	286.96	286.96	286.96	230.0
2019-04-03 05:54:00	SPY	ETF	286.99	286.99	286.99	286.99	169.0
2019-04-03 05:59:00	SPY	ETF	287.0	287.0	287.0	287.0	1000.0
2019-04-03 06:00:00	SPY	ETF	286.96	286.96	286.96	286.96	300.0
2019-04-03 06:01:00	SPY	ETF	286.98	286.98	286.96	286.96	4338.0
2019-04-03 06:03:00	SPY	ETF	286.94	286.94	286.94	286.94	199.0
2019-04-03 06:06:00	SPY	ETF	286.91	286.91	286.91	286.91	336.0
2019-04-03 06:08:00	SPY	ETF	286.95	286.95	286.9	286.92	31904.0

> showing 50 of 180,597 rows — these rows as CSV

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