PREVIEW / etf_1min / 2017-12-05

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-12-05.parquet
  size:    2.9 MB
  rows:    150,991

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-05 04:05:00	SPY	ETF	264.3	264.3	264.3	264.3	500.0
2017-12-05 04:08:00	SPY	ETF	264.3	264.3	264.3	264.3	2000.0
2017-12-05 04:42:00	SPY	ETF	264.32	264.32	264.32	264.32	200.0
2017-12-05 04:46:00	SPY	ETF	264.34	264.34	264.34	264.34	300.0
2017-12-05 04:47:00	SPY	ETF	264.34	264.34	264.34	264.34	100.0
2017-12-05 04:59:00	SPY	ETF	264.46	264.46	264.46	264.46	100.0
2017-12-05 05:00:00	SPY	ETF	264.46	264.46	264.46	264.46	200.0
2017-12-05 05:23:00	SPY	ETF	264.03	264.03	264.03	264.03	300.0
2017-12-05 05:31:00	SPY	ETF	264.02	264.02	264.02	264.02	200.0
2017-12-05 05:36:00	SPY	ETF	264.02	264.02	264.02	264.02	300.0
2017-12-05 05:46:00	SPY	ETF	264.05	264.05	264.05	264.05	101.0
2017-12-05 05:52:00	SPY	ETF	263.96	263.96	263.96	263.96	600.0
2017-12-05 05:58:00	SPY	ETF	263.83	263.83	263.83	263.83	603.0
2017-12-05 06:05:00	SPY	ETF	263.97	263.97	263.96	263.96	404.0
2017-12-05 06:09:00	SPY	ETF	263.95	263.95	263.95	263.95	403.0
2017-12-05 06:11:00	SPY	ETF	264.0	264.0	264.0	264.0	401.0
2017-12-05 06:13:00	SPY	ETF	264.01	264.01	264.01	264.01	200.0
2017-12-05 06:14:00	SPY	ETF	264.02	264.05	264.01	264.05	800.0
2017-12-05 06:17:00	SPY	ETF	264.05	264.05	264.05	264.05	301.0
2017-12-05 06:18:00	SPY	ETF	264.05	264.06	264.05	264.06	300.0
2017-12-05 06:19:00	SPY	ETF	264.07	264.07	264.07	264.07	901.0
2017-12-05 06:20:00	SPY	ETF	263.98	263.98	263.98	263.98	102.0
2017-12-05 06:21:00	SPY	ETF	264.0	264.0	264.0	264.0	100.0
2017-12-05 06:29:00	SPY	ETF	264.04	264.05	264.01	264.01	7600.0
2017-12-05 06:30:00	SPY	ETF	264.01	264.01	264.01	264.01	700.0
2017-12-05 06:31:00	SPY	ETF	264.01	264.01	264.01	264.01	700.0
2017-12-05 06:32:00	SPY	ETF	264.0	264.0	264.0	264.0	200.0
2017-12-05 06:34:00	SPY	ETF	264.06	264.06	264.06	264.06	101.0
2017-12-05 06:37:00	SPY	ETF	264.11	264.13	264.11	264.13	400.0
2017-12-05 06:38:00	SPY	ETF	264.14	264.14	264.14	264.14	150.0
2017-12-05 06:39:00	SPY	ETF	264.13	264.13	264.13	264.13	100.0
2017-12-05 06:41:00	SPY	ETF	264.19	264.19	264.19	264.19	320.0
2017-12-05 06:43:00	SPY	ETF	264.19	264.19	264.18	264.18	1500.0
2017-12-05 06:44:00	SPY	ETF	264.2	264.2	264.2	264.2	350.0
2017-12-05 06:48:00	SPY	ETF	264.16	264.18	264.16	264.18	700.0
2017-12-05 06:49:00	SPY	ETF	264.21	264.23	264.21	264.23	1400.0
2017-12-05 06:51:00	SPY	ETF	264.26	264.26	264.26	264.26	300.0
2017-12-05 06:56:00	SPY	ETF	264.28	264.28	264.28	264.28	3200.0
2017-12-05 06:57:00	SPY	ETF	264.3	264.3	264.3	264.3	300.0
2017-12-05 06:58:00	SPY	ETF	264.27	264.31	264.26	264.26	900.0
2017-12-05 07:00:00	SPY	ETF	264.3	264.31	264.28	264.28	6100.0
2017-12-05 07:01:00	SPY	ETF	264.38	264.38	264.38	264.38	500.0
2017-12-05 07:02:00	SPY	ETF	264.34	264.34	264.3	264.32	11655.0
2017-12-05 07:03:00	SPY	ETF	264.3	264.3	264.26	264.26	5000.0
2017-12-05 07:04:00	SPY	ETF	264.24	264.27	264.24	264.27	1204.0
2017-12-05 07:05:00	SPY	ETF	264.24	264.24	264.24	264.24	300.0
2017-12-05 07:07:00	SPY	ETF	264.29	264.3	264.29	264.29	2200.0
2017-12-05 07:08:00	SPY	ETF	264.26	264.26	264.26	264.26	279.0
2017-12-05 07:09:00	SPY	ETF	264.25	264.25	264.25	264.25	313.0
2017-12-05 07:13:00	SPY	ETF	264.29	264.29	264.29	264.29	700.0

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

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