PREVIEW / etf_1min / 2017-04-24

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-04-24.parquet
  size:    2.8 MB
  rows:    148,711

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-24 04:00:00	SPY	ETF	237.06	237.1	237.06	237.09	8847.0
2017-04-24 04:02:00	SPY	ETF	237.12	237.13	237.12	237.13	361.0
2017-04-24 04:03:00	SPY	ETF	237.16	237.32	237.08	237.32	810.0
2017-04-24 04:05:00	SPY	ETF	237.15	237.15	237.09	237.14	510.0
2017-04-24 04:06:00	SPY	ETF	237.14	237.14	237.1	237.1	400.0
2017-04-24 04:09:00	SPY	ETF	237.17	237.17	237.17	237.17	375.0
2017-04-24 04:11:00	SPY	ETF	237.13	237.13	237.13	237.13	10000.0
2017-04-24 04:12:00	SPY	ETF	237.15	237.16	237.15	237.16	600.0
2017-04-24 04:13:00	SPY	ETF	237.16	237.16	237.16	237.16	550.0
2017-04-24 04:15:00	SPY	ETF	237.16	237.22	237.16	237.22	1929.0
2017-04-24 04:17:00	SPY	ETF	237.25	237.25	237.25	237.25	500.0
2017-04-24 04:23:00	SPY	ETF	237.2	237.2	237.2	237.2	500.0
2017-04-24 04:25:00	SPY	ETF	237.14	237.14	237.14	237.14	125.0
2017-04-24 04:29:00	SPY	ETF	237.2	237.2	237.2	237.2	120.0
2017-04-24 04:34:00	SPY	ETF	237.22	237.22	237.22	237.22	3462.0
2017-04-24 04:35:00	SPY	ETF	237.24	237.24	237.24	237.24	302.0
2017-04-24 04:37:00	SPY	ETF	237.19	237.19	237.19	237.19	100.0
2017-04-24 04:40:00	SPY	ETF	237.2	237.2	237.2	237.2	106.0
2017-04-24 04:43:00	SPY	ETF	237.2	237.2	237.2	237.2	200.0
2017-04-24 04:45:00	SPY	ETF	237.2	237.21	237.2	237.21	900.0
2017-04-24 04:48:00	SPY	ETF	237.19	237.19	237.19	237.19	106.0
2017-04-24 04:50:00	SPY	ETF	237.21	237.21	237.21	237.21	804.0
2017-04-24 04:53:00	SPY	ETF	237.21	237.21	237.21	237.21	300.0
2017-04-24 04:54:00	SPY	ETF	237.21	237.21	237.21	237.21	300.0
2017-04-24 04:56:00	SPY	ETF	237.24	237.24	237.24	237.24	150.0
2017-04-24 04:58:00	SPY	ETF	237.27	237.31	237.27	237.31	502.0
2017-04-24 04:59:00	SPY	ETF	237.31	237.36	237.31	237.36	2606.0
2017-04-24 05:00:00	SPY	ETF	237.36	237.36	237.35	237.36	1700.0
2017-04-24 05:01:00	SPY	ETF	237.35	237.35	237.35	237.35	515.0
2017-04-24 05:02:00	SPY	ETF	237.31	237.31	237.31	237.31	304.0
2017-04-24 05:03:00	SPY	ETF	237.25	237.25	237.25	237.25	601.0
2017-04-24 05:05:00	SPY	ETF	237.37	237.37	237.37	237.37	1604.0
2017-04-24 05:06:00	SPY	ETF	237.38	237.38	237.38	237.38	101.0
2017-04-24 05:11:00	SPY	ETF	237.35	237.35	237.35	237.35	1000.0
2017-04-24 05:12:00	SPY	ETF	237.4	237.4	237.4	237.4	532.0
2017-04-24 05:13:00	SPY	ETF	237.4	237.4	237.4	237.4	1100.0
2017-04-24 05:14:00	SPY	ETF	237.4	237.4	237.4	237.4	4252.0
2017-04-24 05:16:00	SPY	ETF	237.41	237.41	237.36	237.36	1404.0
2017-04-24 05:19:00	SPY	ETF	237.34	237.34	237.32	237.32	201.0
2017-04-24 05:20:00	SPY	ETF	237.34	237.34	237.3	237.3	4201.0
2017-04-24 05:21:00	SPY	ETF	237.3	237.34	237.3	237.34	800.0
2017-04-24 05:26:00	SPY	ETF	237.47	237.47	237.47	237.47	500.0
2017-04-24 05:27:00	SPY	ETF	237.45	237.45	237.45	237.45	349.0
2017-04-24 05:29:00	SPY	ETF	237.4	237.4	237.4	237.4	2502.0
2017-04-24 05:32:00	SPY	ETF	237.4	237.4	237.4	237.4	201.0
2017-04-24 05:33:00	SPY	ETF	237.4	237.4	237.4	237.4	200.0
2017-04-24 05:35:00	SPY	ETF	237.41	237.41	237.41	237.41	300.0
2017-04-24 05:36:00	SPY	ETF	237.43	237.43	237.43	237.43	1151.0
2017-04-24 05:37:00	SPY	ETF	237.41	237.44	237.41	237.44	1500.0
2017-04-24 05:38:00	SPY	ETF	237.4	237.4	237.4	237.4	100.0

> showing 50 of 148,711 rows — these rows as CSV

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