PREVIEW / etf_1min / 2018-08-30

all etf 1-min files

  file:    by_date/etf_1min/2018/2018-08-30.parquet
  size:    3.0 MB
  rows:    152,775

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
2018-08-30 04:00:00	SPY	ETF	291.19	291.19	291.1	291.1	1500.0
2018-08-30 04:01:00	SPY	ETF	291.07	291.18	291.07	291.18	551.0
2018-08-30 04:02:00	SPY	ETF	291.06	291.06	291.06	291.06	690.0
2018-08-30 04:03:00	SPY	ETF	291.05	291.05	291.05	291.05	700.0
2018-08-30 04:05:00	SPY	ETF	291.03	291.03	291.02	291.02	1417.0
2018-08-30 04:12:00	SPY	ETF	291.12	291.12	291.12	291.12	151.0
2018-08-30 04:15:00	SPY	ETF	291.16	291.16	291.16	291.16	100.0
2018-08-30 04:20:00	SPY	ETF	291.11	291.11	291.05	291.05	500.0
2018-08-30 04:21:00	SPY	ETF	291.02	291.02	291.0	291.0	740.0
2018-08-30 04:22:00	SPY	ETF	291.03	291.03	291.03	291.03	100.0
2018-08-30 04:23:00	SPY	ETF	290.98	290.98	290.98	290.98	300.0
2018-08-30 04:24:00	SPY	ETF	290.98	290.98	290.98	290.98	2050.0
2018-08-30 04:25:00	SPY	ETF	290.95	290.95	290.91	290.91	552.0
2018-08-30 04:27:00	SPY	ETF	290.91	290.91	290.9	290.9	3195.0
2018-08-30 04:29:00	SPY	ETF	290.9	290.9	290.9	290.9	900.0
2018-08-30 04:32:00	SPY	ETF	290.9	290.9	290.9	290.9	300.0
2018-08-30 04:34:00	SPY	ETF	290.95	290.95	290.95	290.95	2500.0
2018-08-30 04:35:00	SPY	ETF	290.95	290.95	290.94	290.94	3000.0
2018-08-30 04:39:00	SPY	ETF	290.92	290.92	290.92	290.92	1300.0
2018-08-30 04:41:00	SPY	ETF	290.87	290.87	290.82	290.82	600.0
2018-08-30 04:45:00	SPY	ETF	290.82	290.82	290.82	290.82	225.0
2018-08-30 04:48:00	SPY	ETF	290.74	290.74	290.74	290.74	1202.0
2018-08-30 04:50:00	SPY	ETF	290.74	290.77	290.74	290.76	30000.0
2018-08-30 04:53:00	SPY	ETF	290.86	290.9	290.86	290.9	8000.0
2018-08-30 04:54:00	SPY	ETF	290.9	290.9	290.9	290.9	500.0
2018-08-30 04:55:00	SPY	ETF	290.9	290.9	290.84	290.84	4500.0
2018-08-30 05:01:00	SPY	ETF	290.95	290.95	290.95	290.95	102.0
2018-08-30 05:03:00	SPY	ETF	290.89	290.89	290.89	290.89	1450.0
2018-08-30 05:05:00	SPY	ETF	290.94	290.94	290.94	290.94	100.0
2018-08-30 05:08:00	SPY	ETF	290.94	290.94	290.94	290.94	100.0
2018-08-30 05:10:00	SPY	ETF	290.94	290.94	290.94	290.94	300.0
2018-08-30 05:13:00	SPY	ETF	290.9	290.9	290.9	290.9	100.0
2018-08-30 05:15:00	SPY	ETF	290.86	290.86	290.86	290.86	2100.0
2018-08-30 05:22:00	SPY	ETF	290.92	290.92	290.92	290.92	100.0
2018-08-30 05:23:00	SPY	ETF	290.91	290.91	290.9	290.9	3500.0
2018-08-30 05:28:00	SPY	ETF	290.92	290.92	290.92	290.92	2000.0
2018-08-30 05:29:00	SPY	ETF	290.92	290.92	290.92	290.92	3000.0
2018-08-30 05:30:00	SPY	ETF	290.87	290.87	290.87	290.87	100.0
2018-08-30 05:32:00	SPY	ETF	290.94	290.94	290.94	290.94	100.0
2018-08-30 05:33:00	SPY	ETF	290.94	290.96	290.94	290.96	400.0
2018-08-30 05:35:00	SPY	ETF	290.99	290.99	290.99	290.99	100.0
2018-08-30 05:39:00	SPY	ETF	291.0	291.0	291.0	291.0	2600.0
2018-08-30 05:41:00	SPY	ETF	290.97	290.97	290.97	290.97	300.0
2018-08-30 05:44:00	SPY	ETF	290.97	290.97	290.97	290.97	500.0
2018-08-30 05:47:00	SPY	ETF	290.98	290.98	290.98	290.98	100.0
2018-08-30 05:48:00	SPY	ETF	291.0	291.0	291.0	291.0	200.0
2018-08-30 05:56:00	SPY	ETF	290.92	290.92	290.91	290.91	2100.0
2018-08-30 06:00:00	SPY	ETF	290.96	290.96	290.96	290.96	500.0
2018-08-30 06:07:00	SPY	ETF	290.91	290.91	290.86	290.86	2600.0
2018-08-30 06:08:00	SPY	ETF	290.89	290.89	290.89	290.89	300.0

> showing 50 of 152,775 rows — these rows as CSV

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