PREVIEW / etf_1min / 2017-11-01

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-11-01.parquet
  size:    2.9 MB
  rows:    150,147

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-11-01 04:00:00	SPY	ETF	257.6	257.9	257.6	257.9	1010.0
2017-11-01 04:03:00	SPY	ETF	257.85	257.87	257.85	257.87	700.0
2017-11-01 04:04:00	SPY	ETF	257.9	257.9	257.9	257.9	200.0
2017-11-01 04:07:00	SPY	ETF	257.79	257.84	257.79	257.84	1300.0
2017-11-01 04:10:00	SPY	ETF	257.82	257.82	257.8	257.8	10000.0
2017-11-01 04:13:00	SPY	ETF	257.85	257.85	257.85	257.85	1000.0
2017-11-01 04:15:00	SPY	ETF	257.88	257.88	257.88	257.88	500.0
2017-11-01 04:16:00	SPY	ETF	257.88	257.88	257.88	257.88	1000.0
2017-11-01 04:18:00	SPY	ETF	257.91	257.91	257.91	257.91	354.0
2017-11-01 04:26:00	SPY	ETF	257.9	257.9	257.9	257.9	300.0
2017-11-01 04:29:00	SPY	ETF	257.9	257.9	257.9	257.9	100.0
2017-11-01 04:37:00	SPY	ETF	257.92	257.92	257.92	257.92	800.0
2017-11-01 04:41:00	SPY	ETF	257.86	257.86	257.86	257.86	100.0
2017-11-01 04:46:00	SPY	ETF	257.89	257.89	257.89	257.89	2000.0
2017-11-01 04:49:00	SPY	ETF	257.89	257.89	257.89	257.89	23000.0
2017-11-01 04:50:00	SPY	ETF	257.92	257.92	257.92	257.92	800.0
2017-11-01 04:53:00	SPY	ETF	257.94	257.94	257.94	257.94	760.0
2017-11-01 05:00:00	SPY	ETF	257.96	257.96	257.96	257.96	1600.0
2017-11-01 05:01:00	SPY	ETF	257.97	257.97	257.97	257.97	200.0
2017-11-01 05:02:00	SPY	ETF	257.96	257.96	257.96	257.96	2400.0
2017-11-01 05:06:00	SPY	ETF	257.95	257.95	257.95	257.95	1000.0
2017-11-01 05:09:00	SPY	ETF	257.97	257.97	257.97	257.97	1000.0
2017-11-01 05:11:00	SPY	ETF	257.98	258.01	257.98	258.0	3608.0
2017-11-01 05:22:00	SPY	ETF	257.96	257.96	257.96	257.96	502.0
2017-11-01 05:26:00	SPY	ETF	257.96	257.96	257.96	257.96	100.0
2017-11-01 05:51:00	SPY	ETF	258.0	258.0	258.0	258.0	303.0
2017-11-01 05:56:00	SPY	ETF	258.04	258.04	258.04	258.04	498.0
2017-11-01 05:57:00	SPY	ETF	258.06	258.06	258.06	258.06	300.0
2017-11-01 05:59:00	SPY	ETF	258.07	258.07	258.07	258.07	1004.0
2017-11-01 06:02:00	SPY	ETF	258.21	258.21	258.21	258.21	133.0
2017-11-01 06:04:00	SPY	ETF	258.22	258.22	258.22	258.22	121.0
2017-11-01 06:09:00	SPY	ETF	258.2	258.2	258.2	258.2	300.0
2017-11-01 06:11:00	SPY	ETF	258.2	258.2	258.2	258.2	100.0
2017-11-01 06:14:00	SPY	ETF	258.2	258.24	258.2	258.24	950.0
2017-11-01 06:15:00	SPY	ETF	258.25	258.25	258.25	258.25	501.0
2017-11-01 06:16:00	SPY	ETF	258.22	258.22	258.22	258.22	755.0
2017-11-01 06:20:00	SPY	ETF	258.26	258.26	258.26	258.26	300.0
2017-11-01 06:28:00	SPY	ETF	258.3	258.31	258.3	258.31	501.0
2017-11-01 06:33:00	SPY	ETF	258.24	258.25	258.24	258.25	301.0
2017-11-01 06:35:00	SPY	ETF	258.27	258.28	258.27	258.28	500.0
2017-11-01 06:43:00	SPY	ETF	258.22	258.22	258.22	258.22	600.0
2017-11-01 06:45:00	SPY	ETF	258.24	258.24	258.24	258.24	301.0
2017-11-01 06:48:00	SPY	ETF	258.25	258.25	258.25	258.25	2100.0
2017-11-01 06:59:00	SPY	ETF	258.22	258.22	258.22	258.22	200.0
2017-11-01 07:00:00	SPY	ETF	258.22	258.22	258.22	258.22	25358.0
2017-11-01 07:01:00	SPY	ETF	258.22	258.22	258.22	258.22	2333.0
2017-11-01 07:02:00	SPY	ETF	258.18	258.18	258.17	258.17	6102.0
2017-11-01 07:03:00	SPY	ETF	258.17	258.18	258.16	258.18	6828.0
2017-11-01 07:04:00	SPY	ETF	258.18	258.18	258.18	258.18	5050.0
2017-11-01 07:05:00	SPY	ETF	258.17	258.17	258.17	258.17	500.0

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

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