PREVIEW / etf_1min / 2019-01-22

all etf 1-min files

  file:    by_date/etf_1min/2019/2019-01-22.parquet
  size:    3.7 MB
  rows:    192,306

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-01-22 04:00:00	SPY	ETF	265.11	265.25	264.96	264.96	4394.0
2019-01-22 04:01:00	SPY	ETF	264.97	264.99	264.94	264.96	1795.0
2019-01-22 04:02:00	SPY	ETF	264.97	264.99	264.97	264.97	1100.0
2019-01-22 04:03:00	SPY	ETF	265.02	265.06	265.02	265.06	247.0
2019-01-22 04:04:00	SPY	ETF	265.08	265.08	265.07	265.07	2692.0
2019-01-22 04:06:00	SPY	ETF	265.01	265.01	264.96	264.96	2030.0
2019-01-22 04:07:00	SPY	ETF	264.97	265.0	264.91	264.91	4325.0
2019-01-22 04:08:00	SPY	ETF	264.96	264.97	264.96	264.97	1834.0
2019-01-22 04:09:00	SPY	ETF	265.02	265.02	265.02	265.02	600.0
2019-01-22 04:10:00	SPY	ETF	265.1	265.1	265.1	265.1	100.0
2019-01-22 04:12:00	SPY	ETF	265.05	265.05	265.02	265.05	1418.0
2019-01-22 04:13:00	SPY	ETF	264.97	264.97	264.97	264.97	120.0
2019-01-22 04:14:00	SPY	ETF	265.02	265.02	265.02	265.02	480.0
2019-01-22 04:16:00	SPY	ETF	265.02	265.02	265.02	265.02	313.0
2019-01-22 04:17:00	SPY	ETF	264.97	264.97	264.97	264.97	550.0
2019-01-22 04:18:00	SPY	ETF	265.0	265.1	265.0	265.1	1250.0
2019-01-22 04:19:00	SPY	ETF	265.07	265.07	265.07	265.07	200.0
2019-01-22 04:27:00	SPY	ETF	265.02	265.02	264.97	264.97	350.0
2019-01-22 04:30:00	SPY	ETF	265.09	265.09	265.09	265.09	100.0
2019-01-22 04:31:00	SPY	ETF	265.1	265.12	265.09	265.11	3020.0
2019-01-22 04:33:00	SPY	ETF	265.1	265.15	265.1	265.15	603.0
2019-01-22 04:34:00	SPY	ETF	265.16	265.16	265.16	265.16	100.0
2019-01-22 04:36:00	SPY	ETF	265.15	265.16	265.15	265.16	319.0
2019-01-22 04:37:00	SPY	ETF	265.16	265.16	265.14	265.14	200.0
2019-01-22 04:39:00	SPY	ETF	265.14	265.14	265.01	265.14	1100.0
2019-01-22 04:40:00	SPY	ETF	265.2	265.2	265.2	265.2	503.0
2019-01-22 04:42:00	SPY	ETF	265.09	265.09	265.09	265.09	100.0
2019-01-22 04:47:00	SPY	ETF	265.07	265.07	265.05	265.07	800.0
2019-01-22 04:48:00	SPY	ETF	265.05	265.05	265.05	265.05	1000.0
2019-01-22 04:50:00	SPY	ETF	265.0	265.01	265.0	265.01	250.0
2019-01-22 04:51:00	SPY	ETF	264.99	264.99	264.93	264.93	5600.0
2019-01-22 04:52:00	SPY	ETF	264.91	264.91	264.91	264.91	600.0
2019-01-22 04:54:00	SPY	ETF	265.02	265.02	265.02	265.02	300.0
2019-01-22 04:55:00	SPY	ETF	264.9	264.9	264.9	264.9	200.0
2019-01-22 04:57:00	SPY	ETF	264.99	264.99	264.99	264.99	210.0
2019-01-22 04:58:00	SPY	ETF	264.93	264.93	264.93	264.93	1000.0
2019-01-22 04:59:00	SPY	ETF	264.99	264.99	264.93	264.98	500.0
2019-01-22 05:01:00	SPY	ETF	265.0	265.0	265.0	265.0	250.0
2019-01-22 05:02:00	SPY	ETF	265.02	265.02	265.02	265.02	100.0
2019-01-22 05:03:00	SPY	ETF	264.98	264.98	264.98	264.98	100.0
2019-01-22 05:06:00	SPY	ETF	264.99	264.99	264.95	264.95	200.0
2019-01-22 05:07:00	SPY	ETF	264.95	264.95	264.95	264.95	100.0
2019-01-22 05:08:00	SPY	ETF	264.97	264.97	264.97	264.97	150.0
2019-01-22 05:09:00	SPY	ETF	264.94	264.94	264.94	264.94	200.0
2019-01-22 05:10:00	SPY	ETF	264.94	264.94	264.94	264.94	310.0
2019-01-22 05:11:00	SPY	ETF	264.92	264.92	264.92	264.92	100.0
2019-01-22 05:12:00	SPY	ETF	264.9	264.9	264.87	264.88	750.0
2019-01-22 05:18:00	SPY	ETF	264.82	264.82	264.82	264.82	150.0
2019-01-22 05:19:00	SPY	ETF	264.9	264.9	264.9	264.9	285.0
2019-01-22 05:20:00	SPY	ETF	264.87	264.87	264.87	264.87	400.0

> showing 50 of 192,306 rows — these rows as CSV

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