PREVIEW / etf_1min / 2019-10-18

all etf 1-min files

  file:    by_date/etf_1min/2019/2019-10-18.parquet
  size:    2.9 MB
  rows:    150,456

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-18 04:00:00	SPY	ETF	299.03	299.03	299.03	299.03	300.0
2019-10-18 04:02:00	SPY	ETF	298.98	298.98	298.98	298.98	100.0
2019-10-18 04:10:00	SPY	ETF	299.05	299.05	299.05	299.05	200.0
2019-10-18 04:14:00	SPY	ETF	298.95	298.95	298.95	298.95	100.0
2019-10-18 04:17:00	SPY	ETF	298.95	298.95	298.95	298.95	115.0
2019-10-18 04:18:00	SPY	ETF	299.0	299.0	299.0	299.0	100.0
2019-10-18 04:19:00	SPY	ETF	299.02	299.12	299.02	299.12	300.0
2019-10-18 04:24:00	SPY	ETF	299.07	299.07	299.07	299.07	100.0
2019-10-18 04:27:00	SPY	ETF	298.95	298.95	298.95	298.95	100.0
2019-10-18 04:32:00	SPY	ETF	298.92	298.92	298.92	298.92	200.0
2019-10-18 04:35:00	SPY	ETF	298.9	298.9	298.9	298.9	530.0
2019-10-18 04:39:00	SPY	ETF	299.0	299.02	299.0	299.0	1001.0
2019-10-18 04:40:00	SPY	ETF	298.94	298.95	298.94	298.94	1260.0
2019-10-18 04:41:00	SPY	ETF	299.05	299.05	299.05	299.05	720.0
2019-10-18 04:45:00	SPY	ETF	299.12	299.12	299.12	299.12	300.0
2019-10-18 04:50:00	SPY	ETF	299.1	299.1	299.1	299.1	100.0
2019-10-18 04:54:00	SPY	ETF	299.07	299.07	299.07	299.07	100.0
2019-10-18 04:57:00	SPY	ETF	299.12	299.12	299.12	299.12	125.0
2019-10-18 05:20:00	SPY	ETF	298.95	298.95	298.95	298.95	400.0
2019-10-18 05:25:00	SPY	ETF	299.12	299.17	299.12	299.15	300.0
2019-10-18 05:26:00	SPY	ETF	299.22	299.22	299.22	299.22	100.0
2019-10-18 05:27:00	SPY	ETF	299.25	299.3	299.25	299.3	400.0
2019-10-18 05:28:00	SPY	ETF	299.2	299.2	299.2	299.2	500.0
2019-10-18 05:31:00	SPY	ETF	299.15	299.15	299.15	299.15	100.0
2019-10-18 05:33:00	SPY	ETF	299.15	299.15	299.07	299.07	225.0
2019-10-18 05:37:00	SPY	ETF	299.17	299.2	299.17	299.2	720.0
2019-10-18 05:46:00	SPY	ETF	299.25	299.25	299.25	299.25	400.0
2019-10-18 05:49:00	SPY	ETF	299.19	299.19	299.19	299.19	100.0
2019-10-18 05:52:00	SPY	ETF	299.2	299.2	299.2	299.2	1000.0
2019-10-18 05:53:00	SPY	ETF	299.27	299.27	299.27	299.27	140.0
2019-10-18 05:54:00	SPY	ETF	299.27	299.27	299.27	299.27	100.0
2019-10-18 05:56:00	SPY	ETF	299.33	299.33	299.3	299.3	600.0
2019-10-18 06:00:00	SPY	ETF	299.28	299.28	299.27	299.27	1325.0
2019-10-18 06:01:00	SPY	ETF	299.28	299.28	299.28	299.28	400.0
2019-10-18 06:02:00	SPY	ETF	299.29	299.29	299.29	299.29	600.0
2019-10-18 06:04:00	SPY	ETF	299.22	299.22	299.22	299.22	300.0
2019-10-18 06:08:00	SPY	ETF	299.27	299.27	299.27	299.27	300.0
2019-10-18 06:11:00	SPY	ETF	299.25	299.32	299.25	299.29	3600.0
2019-10-18 06:12:00	SPY	ETF	299.19	299.19	299.19	299.19	130.0
2019-10-18 06:14:00	SPY	ETF	299.24	299.24	299.24	299.24	2710.0
2019-10-18 06:19:00	SPY	ETF	299.34	299.34	299.34	299.34	1050.0
2019-10-18 06:21:00	SPY	ETF	299.29	299.29	299.29	299.29	100.0
2019-10-18 06:25:00	SPY	ETF	299.27	299.27	299.27	299.27	150.0
2019-10-18 06:27:00	SPY	ETF	299.19	299.19	299.19	299.19	300.0
2019-10-18 06:32:00	SPY	ETF	299.14	299.14	299.14	299.14	270.0
2019-10-18 06:41:00	SPY	ETF	299.22	299.22	299.22	299.22	400.0
2019-10-18 06:44:00	SPY	ETF	299.27	299.27	299.27	299.27	100.0
2019-10-18 06:45:00	SPY	ETF	299.27	299.28	299.27	299.28	800.0
2019-10-18 06:47:00	SPY	ETF	299.26	299.26	299.26	299.26	500.0
2019-10-18 06:50:00	SPY	ETF	299.28	299.28	299.28	299.28	320.0

> showing 50 of 150,456 rows — these rows as CSV

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