PREVIEW / etf_1min / 2017-04-12

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-04-12.parquet
  size:    2.7 MB
  rows:    142,537

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-04-12 04:00:00	SPY	ETF	235.4	235.4	235.4	235.4	110.0
2017-04-12 04:09:00	SPY	ETF	235.33	235.33	235.33	235.33	250.0
2017-04-12 04:10:00	SPY	ETF	235.35	235.35	235.28	235.28	1280.0
2017-04-12 04:11:00	SPY	ETF	235.24	235.24	235.24	235.24	200.0
2017-04-12 04:12:00	SPY	ETF	235.3	235.3	235.3	235.3	200.0
2017-04-12 04:17:00	SPY	ETF	235.38	235.4	235.38	235.4	1100.0
2017-04-12 04:18:00	SPY	ETF	235.4	235.4	235.4	235.4	500.0
2017-04-12 04:19:00	SPY	ETF	235.43	235.44	235.43	235.44	500.0
2017-04-12 04:22:00	SPY	ETF	235.45	235.45	235.45	235.45	100.0
2017-04-12 04:24:00	SPY	ETF	235.48	235.48	235.48	235.48	150.0
2017-04-12 04:25:00	SPY	ETF	235.45	235.45	235.38	235.38	1150.0
2017-04-12 04:31:00	SPY	ETF	235.43	235.43	235.43	235.43	100.0
2017-04-12 04:32:00	SPY	ETF	235.39	235.39	235.39	235.39	100.0
2017-04-12 04:33:00	SPY	ETF	235.36	235.36	235.36	235.36	300.0
2017-04-12 04:36:00	SPY	ETF	235.31	235.31	235.31	235.31	100.0
2017-04-12 04:41:00	SPY	ETF	235.3	235.3	235.3	235.3	105.0
2017-04-12 04:44:00	SPY	ETF	235.32	235.32	235.32	235.32	200.0
2017-04-12 04:51:00	SPY	ETF	235.3	235.3	235.3	235.3	200.0
2017-04-12 05:02:00	SPY	ETF	235.21	235.21	235.21	235.21	390.0
2017-04-12 05:07:00	SPY	ETF	235.21	235.21	235.21	235.21	500.0
2017-04-12 05:12:00	SPY	ETF	235.32	235.32	235.32	235.32	200.0
2017-04-12 05:16:00	SPY	ETF	235.24	235.24	235.24	235.24	1500.0
2017-04-12 05:17:00	SPY	ETF	235.21	235.23	235.21	235.23	500.0
2017-04-12 05:24:00	SPY	ETF	235.26	235.26	235.26	235.26	400.0
2017-04-12 05:30:00	SPY	ETF	235.36	235.38	235.36	235.38	740.0
2017-04-12 05:34:00	SPY	ETF	235.36	235.36	235.36	235.36	600.0
2017-04-12 05:38:00	SPY	ETF	235.33	235.33	235.33	235.33	300.0
2017-04-12 05:49:00	SPY	ETF	235.26	235.26	235.26	235.26	2204.0
2017-04-12 05:54:00	SPY	ETF	235.19	235.19	235.19	235.19	202.0
2017-04-12 05:55:00	SPY	ETF	235.17	235.17	235.17	235.17	101.0
2017-04-12 05:56:00	SPY	ETF	235.17	235.17	235.15	235.15	1103.0
2017-04-12 05:57:00	SPY	ETF	235.14	235.14	235.14	235.14	100.0
2017-04-12 06:05:00	SPY	ETF	235.17	235.17	235.17	235.17	500.0
2017-04-12 06:08:00	SPY	ETF	235.15	235.15	235.15	235.15	703.0
2017-04-12 06:09:00	SPY	ETF	235.11	235.11	235.11	235.11	104.0
2017-04-12 06:10:00	SPY	ETF	235.06	235.06	235.06	235.06	434.0
2017-04-12 06:11:00	SPY	ETF	235.0	235.0	234.98	234.98	603.0
2017-04-12 06:15:00	SPY	ETF	234.99	234.99	234.99	234.99	101.0
2017-04-12 06:16:00	SPY	ETF	235.02	235.02	235.02	235.02	502.0
2017-04-12 06:28:00	SPY	ETF	235.02	235.02	235.02	235.02	2001.0
2017-04-12 06:35:00	SPY	ETF	234.98	234.98	234.98	234.98	102.0
2017-04-12 06:45:00	SPY	ETF	234.97	234.97	234.97	234.97	101.0
2017-04-12 06:46:00	SPY	ETF	234.92	234.92	234.92	234.92	503.0
2017-04-12 06:47:00	SPY	ETF	234.92	234.92	234.92	234.92	600.0
2017-04-12 06:48:00	SPY	ETF	234.89	234.89	234.89	234.89	204.0
2017-04-12 07:00:00	SPY	ETF	234.97	234.97	234.97	234.97	200.0
2017-04-12 07:01:00	SPY	ETF	234.99	234.99	234.99	234.99	3800.0
2017-04-12 07:06:00	SPY	ETF	234.97	235.0	234.97	234.97	92001.0
2017-04-12 07:08:00	SPY	ETF	235.03	235.03	235.0	235.0	976.0
2017-04-12 07:09:00	SPY	ETF	235.0	235.0	234.99	234.99	2700.0

> showing 50 of 142,537 rows — these rows as CSV

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