PREVIEW / etf_1min / 2017-06-05

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-06-05.parquet
  size:    2.5 MB
  rows:    133,714

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-06-05 04:00:00	SPY	ETF	243.97	243.97	243.97	243.97	2833.0
2017-06-05 04:04:00	SPY	ETF	244.0	244.0	244.0	244.0	3090.0
2017-06-05 04:12:00	SPY	ETF	244.0	244.09	244.0	244.09	500.0
2017-06-05 04:22:00	SPY	ETF	244.03	244.03	244.03	244.03	400.0
2017-06-05 04:24:00	SPY	ETF	244.03	244.03	243.98	243.98	3120.0
2017-06-05 04:25:00	SPY	ETF	243.93	243.93	243.93	243.93	2600.0
2017-06-05 04:29:00	SPY	ETF	243.96	243.96	243.96	243.96	200.0
2017-06-05 04:37:00	SPY	ETF	244.01	244.01	244.01	244.01	1000.0
2017-06-05 04:38:00	SPY	ETF	244.01	244.01	244.01	244.01	1000.0
2017-06-05 04:43:00	SPY	ETF	244.05	244.05	244.05	244.05	1000.0
2017-06-05 05:13:00	SPY	ETF	244.05	244.05	244.05	244.05	300.0
2017-06-05 05:16:00	SPY	ETF	244.08	244.08	244.08	244.08	200.0
2017-06-05 05:21:00	SPY	ETF	244.12	244.12	244.12	244.12	100.0
2017-06-05 05:25:00	SPY	ETF	244.15	244.15	244.15	244.15	200.0
2017-06-05 05:29:00	SPY	ETF	244.12	244.12	244.07	244.07	1200.0
2017-06-05 05:33:00	SPY	ETF	244.08	244.08	244.08	244.08	100.0
2017-06-05 05:34:00	SPY	ETF	244.05	244.05	244.05	244.05	300.0
2017-06-05 05:36:00	SPY	ETF	244.05	244.05	244.05	244.05	300.0
2017-06-05 05:58:00	SPY	ETF	244.05	244.05	244.02	244.02	300.0
2017-06-05 06:09:00	SPY	ETF	244.03	244.03	244.03	244.03	400.0
2017-06-05 06:31:00	SPY	ETF	244.05	244.05	244.05	244.05	100.0
2017-06-05 06:33:00	SPY	ETF	244.04	244.04	244.04	244.04	500.0
2017-06-05 06:41:00	SPY	ETF	244.04	244.04	244.04	244.04	700.0
2017-06-05 06:44:00	SPY	ETF	244.04	244.04	244.0	244.0	14338.0
2017-06-05 06:54:00	SPY	ETF	243.96	243.96	243.96	243.96	800.0
2017-06-05 06:57:00	SPY	ETF	243.92	243.92	243.92	243.92	600.0
2017-06-05 06:59:00	SPY	ETF	243.96	243.96	243.95	243.95	300.0
2017-06-05 07:01:00	SPY	ETF	243.93	243.93	243.93	243.93	2900.0
2017-06-05 07:02:00	SPY	ETF	243.93	243.93	243.9	243.9	6000.0
2017-06-05 07:03:00	SPY	ETF	243.92	243.94	243.92	243.94	7000.0
2017-06-05 07:04:00	SPY	ETF	243.91	243.91	243.91	243.91	210.0
2017-06-05 07:05:00	SPY	ETF	243.91	243.91	243.91	243.91	6200.0
2017-06-05 07:06:00	SPY	ETF	243.88	243.88	243.84	243.84	25000.0
2017-06-05 07:07:00	SPY	ETF	243.88	243.88	243.88	243.88	4000.0
2017-06-05 07:09:00	SPY	ETF	243.91	243.91	243.91	243.91	4003.0
2017-06-05 07:11:00	SPY	ETF	243.91	243.91	243.91	243.91	4403.0
2017-06-05 07:12:00	SPY	ETF	243.91	243.91	243.91	243.91	450.0
2017-06-05 07:13:00	SPY	ETF	243.9	243.93	243.9	243.93	6500.0
2017-06-05 07:14:00	SPY	ETF	243.93	243.93	243.93	243.93	100.0
2017-06-05 07:15:00	SPY	ETF	243.99	243.99	243.99	243.99	1500.0
2017-06-05 07:19:00	SPY	ETF	243.95	243.95	243.95	243.95	500.0
2017-06-05 07:23:00	SPY	ETF	244.0	244.01	244.0	244.01	6000.0
2017-06-05 07:24:00	SPY	ETF	244.01	244.01	244.01	244.01	200.0
2017-06-05 07:25:00	SPY	ETF	243.95	243.95	243.88	243.88	10103.0
2017-06-05 07:27:00	SPY	ETF	243.94	243.94	243.94	243.94	1000.0
2017-06-05 07:28:00	SPY	ETF	243.93	243.93	243.88	243.88	6807.0
2017-06-05 07:29:00	SPY	ETF	243.91	243.91	243.91	243.91	900.0
2017-06-05 07:31:00	SPY	ETF	243.94	243.94	243.94	243.94	500.0
2017-06-05 07:38:00	SPY	ETF	243.88	243.88	243.88	243.88	5000.0
2017-06-05 07:46:00	SPY	ETF	243.91	243.91	243.91	243.91	104.0

> showing 50 of 133,714 rows — these rows as CSV

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