PREVIEW / etf_1min / 2017-03-24

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-03-24.parquet
  size:    2.6 MB
  rows:    139,577

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-03-24 04:00:00	SPY	ETF	234.2	234.2	234.2	234.2	371.0
2017-03-24 04:08:00	SPY	ETF	234.07	234.07	234.07	234.07	180.0
2017-03-24 04:15:00	SPY	ETF	234.0	234.0	234.0	234.0	100.0
2017-03-24 04:30:00	SPY	ETF	234.13	234.13	234.13	234.13	105.0
2017-03-24 04:31:00	SPY	ETF	234.19	234.19	234.19	234.19	202.0
2017-03-24 04:40:00	SPY	ETF	234.23	234.23	234.23	234.23	352.0
2017-03-24 04:47:00	SPY	ETF	234.21	234.21	234.21	234.21	304.0
2017-03-24 05:05:00	SPY	ETF	234.12	234.12	234.12	234.12	300.0
2017-03-24 05:06:00	SPY	ETF	234.12	234.12	234.12	234.12	300.0
2017-03-24 05:11:00	SPY	ETF	234.1	234.12	234.1	234.12	7103.0
2017-03-24 05:25:00	SPY	ETF	234.19	234.19	234.19	234.19	400.0
2017-03-24 05:38:00	SPY	ETF	234.16	234.16	234.16	234.16	300.0
2017-03-24 05:53:00	SPY	ETF	234.05	234.05	234.04	234.04	296.0
2017-03-24 06:01:00	SPY	ETF	234.06	234.06	234.06	234.06	500.0
2017-03-24 06:02:00	SPY	ETF	234.06	234.06	234.06	234.06	500.0
2017-03-24 06:08:00	SPY	ETF	234.04	234.04	234.04	234.04	600.0
2017-03-24 06:16:00	SPY	ETF	234.01	234.01	234.01	234.01	232.0
2017-03-24 06:22:00	SPY	ETF	233.96	233.96	233.96	233.96	550.0
2017-03-24 06:25:00	SPY	ETF	233.96	233.96	233.96	233.96	400.0
2017-03-24 06:27:00	SPY	ETF	233.91	233.91	233.91	233.91	1200.0
2017-03-24 06:30:00	SPY	ETF	233.89	233.89	233.89	233.89	1001.0
2017-03-24 06:33:00	SPY	ETF	233.9	233.92	233.9	233.92	21068.0
2017-03-24 06:35:00	SPY	ETF	233.9	233.9	233.9	233.9	100.0
2017-03-24 06:38:00	SPY	ETF	233.88	233.88	233.88	233.88	1000.0
2017-03-24 06:40:00	SPY	ETF	233.9	233.9	233.9	233.9	100.0
2017-03-24 06:41:00	SPY	ETF	233.9	233.9	233.9	233.9	100.0
2017-03-24 06:45:00	SPY	ETF	233.9	233.9	233.9	233.9	2101.0
2017-03-24 06:53:00	SPY	ETF	233.9	233.9	233.88	233.88	275.0
2017-03-24 06:56:00	SPY	ETF	233.88	233.88	233.88	233.88	301.0
2017-03-24 06:57:00	SPY	ETF	233.92	233.92	233.92	233.92	300.0
2017-03-24 06:58:00	SPY	ETF	233.92	233.92	233.92	233.92	800.0
2017-03-24 07:02:00	SPY	ETF	233.95	233.96	233.94	233.94	755.0
2017-03-24 07:03:00	SPY	ETF	233.96	234.0	233.96	234.0	302.0
2017-03-24 07:05:00	SPY	ETF	233.97	234.0	233.96	233.96	8959.0
2017-03-24 07:07:00	SPY	ETF	234.06	234.06	234.06	234.06	203.0
2017-03-24 07:08:00	SPY	ETF	234.06	234.06	234.04	234.04	35402.0
2017-03-24 07:12:00	SPY	ETF	234.09	234.15	234.09	234.15	1108.0
2017-03-24 07:13:00	SPY	ETF	234.13	234.13	234.13	234.13	2499.0
2017-03-24 07:17:00	SPY	ETF	234.16	234.16	234.16	234.16	101.0
2017-03-24 07:19:00	SPY	ETF	234.15	234.22	234.15	234.22	302.0
2017-03-24 07:20:00	SPY	ETF	234.22	234.22	234.22	234.22	204.0
2017-03-24 07:24:00	SPY	ETF	234.2	234.2	234.2	234.2	101.0
2017-03-24 07:26:00	SPY	ETF	234.17	234.17	234.17	234.17	4000.0
2017-03-24 07:28:00	SPY	ETF	234.12	234.12	234.06	234.06	704.0
2017-03-24 07:32:00	SPY	ETF	234.13	234.13	234.13	234.13	240.0
2017-03-24 07:34:00	SPY	ETF	234.1	234.1	234.1	234.1	301.0
2017-03-24 07:36:00	SPY	ETF	234.06	234.06	234.06	234.06	1500.0
2017-03-24 07:37:00	SPY	ETF	234.04	234.04	234.04	234.04	404.0
2017-03-24 07:39:00	SPY	ETF	234.04	234.04	234.04	234.04	201.0
2017-03-24 07:41:00	SPY	ETF	234.0	234.0	234.0	234.0	500.0

> showing 50 of 139,577 rows — these rows as CSV

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