PREVIEW / etf_1min / 2017-12-26

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-12-26.parquet
  size:    2.5 MB
  rows:    132,475

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
2017-12-26 04:45:00	SPY	ETF	267.26	267.26	267.26	267.26	261.0
2017-12-26 05:08:00	SPY	ETF	267.29	267.29	267.29	267.29	107.0
2017-12-26 05:13:00	SPY	ETF	267.29	267.29	267.29	267.29	200.0
2017-12-26 05:59:00	SPY	ETF	267.26	267.26	267.26	267.26	739.0
2017-12-26 06:03:00	SPY	ETF	267.25	267.25	267.25	267.25	300.0
2017-12-26 06:22:00	SPY	ETF	267.2	267.2	267.2	267.2	100.0
2017-12-26 06:37:00	SPY	ETF	267.2	267.2	267.2	267.2	600.0
2017-12-26 06:39:00	SPY	ETF	267.25	267.25	267.25	267.25	2500.0
2017-12-26 06:41:00	SPY	ETF	267.2	267.2	267.2	267.2	3190.0
2017-12-26 06:45:00	SPY	ETF	267.11	267.12	267.11	267.12	1000.0
2017-12-26 06:46:00	SPY	ETF	267.12	267.12	267.11	267.11	1000.0
2017-12-26 06:51:00	SPY	ETF	267.1	267.1	267.1	267.1	600.0
2017-12-26 07:00:00	SPY	ETF	267.09	267.09	267.09	267.09	5031.0
2017-12-26 07:01:00	SPY	ETF	267.06	267.11	267.06	267.11	300.0
2017-12-26 07:02:00	SPY	ETF	267.05	267.05	267.05	267.05	300.0
2017-12-26 07:03:00	SPY	ETF	267.06	267.06	267.01	267.01	1200.0
2017-12-26 07:08:00	SPY	ETF	267.03	267.03	267.03	267.03	453.0
2017-12-26 07:19:00	SPY	ETF	267.02	267.02	267.02	267.02	3547.0
2017-12-26 07:23:00	SPY	ETF	267.04	267.04	267.04	267.04	300.0
2017-12-26 07:26:00	SPY	ETF	267.03	267.03	267.03	267.03	800.0
2017-12-26 07:28:00	SPY	ETF	267.02	267.02	267.0	267.02	1600.0
2017-12-26 07:33:00	SPY	ETF	267.0	267.01	267.0	267.0	6004.0
2017-12-26 07:38:00	SPY	ETF	266.95	266.95	266.95	266.95	200.0
2017-12-26 07:39:00	SPY	ETF	266.97	266.98	266.97	266.98	1900.0
2017-12-26 07:40:00	SPY	ETF	266.98	267.0	266.98	267.0	499.0
2017-12-26 07:42:00	SPY	ETF	266.98	266.98	266.98	266.98	100.0
2017-12-26 07:44:00	SPY	ETF	266.96	266.96	266.96	266.96	100.0
2017-12-26 07:48:00	SPY	ETF	266.94	266.94	266.94	266.94	100.0
2017-12-26 07:49:00	SPY	ETF	266.96	266.96	266.96	266.96	100.0
2017-12-26 07:57:00	SPY	ETF	266.98	266.98	266.98	266.98	300.0
2017-12-26 08:00:00	SPY	ETF	267.02	267.03	267.02	267.03	1680.0
2017-12-26 08:03:00	SPY	ETF	267.03	267.03	267.03	267.03	125.0
2017-12-26 08:04:00	SPY	ETF	267.0	267.0	267.0	267.0	575.0
2017-12-26 08:05:00	SPY	ETF	267.0	267.0	266.99	267.0	253375.0
2017-12-26 08:07:00	SPY	ETF	266.99	266.99	266.99	266.99	2273.0
2017-12-26 08:08:00	SPY	ETF	267.0	267.02	267.0	267.01	9876.0
2017-12-26 08:09:00	SPY	ETF	267.0	267.0	266.99	267.0	1555.0
2017-12-26 08:10:00	SPY	ETF	266.98	266.98	266.97	266.98	2307.0
2017-12-26 08:13:00	SPY	ETF	266.97	266.97	266.95	266.95	37655.0
2017-12-26 08:14:00	SPY	ETF	266.95	266.98	266.95	266.95	4105.0
2017-12-26 08:15:00	SPY	ETF	266.95	266.95	266.95	266.95	200.0
2017-12-26 08:16:00	SPY	ETF	266.97	266.98	266.97	266.98	3500.0
2017-12-26 08:19:00	SPY	ETF	266.95	266.95	266.91	266.91	19534.0
2017-12-26 08:20:00	SPY	ETF	266.91	266.91	266.89	266.89	11500.0
2017-12-26 08:21:00	SPY	ETF	266.88	266.88	266.85	266.86	10000.0
2017-12-26 08:22:00	SPY	ETF	266.88	266.88	266.88	266.88	100.0
2017-12-26 08:25:00	SPY	ETF	266.91	266.91	266.91	266.91	600.0
2017-12-26 08:26:00	SPY	ETF	266.91	266.91	266.91	266.91	600.0
2017-12-26 08:27:00	SPY	ETF	266.9	266.91	266.88	266.91	800.0
2017-12-26 08:28:00	SPY	ETF	266.89	266.93	266.89	266.93	700.0

> showing 50 of 132,475 rows — these rows as CSV

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