PREVIEW / etf_1min / 2018-09-21

all etf 1-min files

  file:    by_date/etf_1min/2018/2018-09-21.parquet
  size:    2.9 MB
  rows:    151,825

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-09-21 04:00:00	SPY	ETF	293.1	293.13	293.1	293.13	680.0
2018-09-21 04:03:00	SPY	ETF	293.05	293.05	293.05	293.05	102.0
2018-09-21 04:04:00	SPY	ETF	293.02	293.02	293.0	293.0	2352.0
2018-09-21 04:08:00	SPY	ETF	293.07	293.07	293.07	293.07	504.0
2018-09-21 04:09:00	SPY	ETF	293.01	293.01	293.01	293.01	4092.0
2018-09-21 04:18:00	SPY	ETF	292.99	292.99	292.96	292.98	1350.0
2018-09-21 04:22:00	SPY	ETF	293.03	293.08	293.03	293.08	1000.0
2018-09-21 04:25:00	SPY	ETF	293.05	293.05	293.05	293.05	300.0
2018-09-21 04:27:00	SPY	ETF	293.03	293.03	293.03	293.03	100.0
2018-09-21 04:32:00	SPY	ETF	293.0	293.0	293.0	293.0	100.0
2018-09-21 04:33:00	SPY	ETF	292.99	292.99	292.99	292.99	4000.0
2018-09-21 04:34:00	SPY	ETF	292.99	293.01	292.99	293.01	1600.0
2018-09-21 04:35:00	SPY	ETF	292.98	292.98	292.92	292.92	300.0
2018-09-21 04:36:00	SPY	ETF	292.98	292.98	292.97	292.97	4200.0
2018-09-21 04:37:00	SPY	ETF	292.98	292.98	292.97	292.97	1600.0
2018-09-21 04:39:00	SPY	ETF	292.98	292.98	292.98	292.98	800.0
2018-09-21 04:40:00	SPY	ETF	293.0	293.0	293.0	293.0	300.0
2018-09-21 04:41:00	SPY	ETF	292.99	292.99	292.98	292.98	4100.0
2018-09-21 04:42:00	SPY	ETF	292.98	293.02	292.97	293.01	10402.0
2018-09-21 04:45:00	SPY	ETF	292.98	292.98	292.98	292.98	150.0
2018-09-21 04:47:00	SPY	ETF	292.95	292.95	292.95	292.95	5000.0
2018-09-21 04:48:00	SPY	ETF	292.95	292.97	292.95	292.97	10600.0
2018-09-21 04:49:00	SPY	ETF	292.95	292.95	292.95	292.95	400.0
2018-09-21 04:50:00	SPY	ETF	292.95	292.96	292.95	292.96	4200.0
2018-09-21 04:51:00	SPY	ETF	292.96	292.96	292.96	292.96	4500.0
2018-09-21 04:52:00	SPY	ETF	292.96	292.96	292.96	292.96	1300.0
2018-09-21 04:53:00	SPY	ETF	292.92	292.92	292.92	292.92	100.0
2018-09-21 04:54:00	SPY	ETF	292.94	292.94	292.94	292.94	300.0
2018-09-21 04:57:00	SPY	ETF	292.89	292.89	292.89	292.89	702.0
2018-09-21 04:58:00	SPY	ETF	292.87	292.87	292.85	292.85	615.0
2018-09-21 04:59:00	SPY	ETF	292.85	292.85	292.85	292.85	700.0
2018-09-21 05:00:00	SPY	ETF	292.85	292.85	292.85	292.85	100.0
2018-09-21 05:01:00	SPY	ETF	292.85	292.86	292.85	292.86	300.0
2018-09-21 05:03:00	SPY	ETF	292.84	292.84	292.84	292.84	400.0
2018-09-21 05:06:00	SPY	ETF	292.84	292.84	292.84	292.84	100.0
2018-09-21 05:08:00	SPY	ETF	292.86	292.9	292.86	292.9	600.0
2018-09-21 05:09:00	SPY	ETF	292.84	292.84	292.84	292.84	600.0
2018-09-21 05:12:00	SPY	ETF	292.89	292.89	292.89	292.89	2000.0
2018-09-21 05:14:00	SPY	ETF	292.92	292.92	292.87	292.87	300.0
2018-09-21 05:15:00	SPY	ETF	292.92	292.92	292.92	292.92	200.0
2018-09-21 05:16:00	SPY	ETF	292.92	292.92	292.92	292.92	500.0
2018-09-21 05:22:00	SPY	ETF	292.84	292.84	292.84	292.84	100.0
2018-09-21 05:23:00	SPY	ETF	292.8	292.8	292.8	292.8	100.0
2018-09-21 05:25:00	SPY	ETF	292.79	292.79	292.79	292.79	150.0
2018-09-21 05:28:00	SPY	ETF	292.75	292.75	292.75	292.75	100.0
2018-09-21 05:34:00	SPY	ETF	292.77	292.77	292.77	292.77	100.0
2018-09-21 05:35:00	SPY	ETF	292.74	292.74	292.74	292.74	100.0
2018-09-21 05:38:00	SPY	ETF	292.72	292.72	292.72	292.72	100.0
2018-09-21 05:41:00	SPY	ETF	292.74	292.74	292.72	292.72	600.0
2018-09-21 05:42:00	SPY	ETF	292.74	292.74	292.74	292.74	1500.0

> showing 50 of 151,825 rows — these rows as CSV

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