PREVIEW / etf_1min / 2017-09-22

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-09-22.parquet
  size:    2.4 MB
  rows:    124,915

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-09-22 04:00:00	SPY	ETF	249.22	249.22	249.22	249.22	333.0
2017-09-22 04:06:00	SPY	ETF	249.22	249.22	249.22	249.22	300.0
2017-09-22 04:10:00	SPY	ETF	249.2	249.2	249.2	249.2	100.0
2017-09-22 04:22:00	SPY	ETF	249.19	249.19	249.19	249.19	200.0
2017-09-22 04:23:00	SPY	ETF	249.16	249.16	249.08	249.08	3825.0
2017-09-22 04:24:00	SPY	ETF	249.09	249.09	249.09	249.09	100.0
2017-09-22 04:25:00	SPY	ETF	249.09	249.09	249.09	249.09	100.0
2017-09-22 04:28:00	SPY	ETF	249.1	249.1	249.1	249.1	100.0
2017-09-22 04:33:00	SPY	ETF	249.14	249.14	249.14	249.14	900.0
2017-09-22 04:42:00	SPY	ETF	249.14	249.14	249.14	249.14	500.0
2017-09-22 04:44:00	SPY	ETF	249.19	249.26	249.19	249.26	2100.0
2017-09-22 04:45:00	SPY	ETF	249.3	249.3	249.3	249.3	100.0
2017-09-22 04:47:00	SPY	ETF	249.24	249.24	249.24	249.24	100.0
2017-09-22 05:00:00	SPY	ETF	249.21	249.21	249.21	249.21	200.0
2017-09-22 06:03:00	SPY	ETF	249.32	249.32	249.32	249.32	100.0
2017-09-22 06:05:00	SPY	ETF	249.31	249.31	249.31	249.31	100.0
2017-09-22 06:09:00	SPY	ETF	249.34	249.34	249.34	249.34	1500.0
2017-09-22 06:15:00	SPY	ETF	249.31	249.31	249.31	249.31	100.0
2017-09-22 06:17:00	SPY	ETF	249.35	249.35	249.35	249.35	1000.0
2017-09-22 06:19:00	SPY	ETF	249.32	249.32	249.32	249.32	2000.0
2017-09-22 06:21:00	SPY	ETF	249.35	249.35	249.35	249.35	1000.0
2017-09-22 06:25:00	SPY	ETF	249.34	249.34	249.34	249.34	100.0
2017-09-22 06:26:00	SPY	ETF	249.38	249.38	249.36	249.36	1700.0
2017-09-22 06:27:00	SPY	ETF	249.36	249.36	249.36	249.36	1500.0
2017-09-22 06:35:00	SPY	ETF	249.37	249.37	249.37	249.37	1200.0
2017-09-22 06:36:00	SPY	ETF	249.41	249.41	249.4	249.4	2000.0
2017-09-22 06:37:00	SPY	ETF	249.4	249.4	249.4	249.4	3300.0
2017-09-22 06:43:00	SPY	ETF	249.37	249.37	249.37	249.37	300.0
2017-09-22 06:47:00	SPY	ETF	249.37	249.37	249.37	249.37	600.0
2017-09-22 06:48:00	SPY	ETF	249.38	249.38	249.38	249.38	600.0
2017-09-22 06:52:00	SPY	ETF	249.39	249.39	249.39	249.39	1000.0
2017-09-22 06:56:00	SPY	ETF	249.38	249.38	249.38	249.38	100.0
2017-09-22 07:00:00	SPY	ETF	249.41	249.41	249.41	249.41	300.0
2017-09-22 07:03:00	SPY	ETF	249.4	249.4	249.4	249.4	100.0
2017-09-22 07:06:00	SPY	ETF	249.39	249.39	249.39	249.39	100.0
2017-09-22 07:09:00	SPY	ETF	249.41	249.41	249.4	249.4	1269.0
2017-09-22 07:10:00	SPY	ETF	249.4	249.4	249.39	249.39	744.0
2017-09-22 07:11:00	SPY	ETF	249.39	249.39	249.38	249.38	769.0
2017-09-22 07:12:00	SPY	ETF	249.38	249.38	249.38	249.38	1669.0
2017-09-22 07:13:00	SPY	ETF	249.37	249.37	249.36	249.36	4638.0
2017-09-22 07:14:00	SPY	ETF	249.35	249.35	249.35	249.35	669.0
2017-09-22 07:15:00	SPY	ETF	249.34	249.34	249.33	249.33	2048.0
2017-09-22 07:17:00	SPY	ETF	249.32	249.32	249.32	249.32	6050.0
2017-09-22 07:18:00	SPY	ETF	249.33	249.33	249.31	249.31	5607.0
2017-09-22 07:19:00	SPY	ETF	249.3	249.3	249.3	249.3	150.0
2017-09-22 07:23:00	SPY	ETF	249.34	249.34	249.34	249.34	10000.0
2017-09-22 07:27:00	SPY	ETF	249.3	249.3	249.3	249.3	5359.0
2017-09-22 07:28:00	SPY	ETF	249.28	249.28	249.26	249.28	2200.0
2017-09-22 07:30:00	SPY	ETF	249.3	249.3	249.3	249.3	1481.0
2017-09-22 07:31:00	SPY	ETF	249.3	249.3	249.3	249.3	380.0

> showing 50 of 124,915 rows — these rows as CSV

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