PREVIEW / etf_1min / 2017-02-24

all etf 1-min files

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

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-02-24 04:10:00	SPY	ETF	236.17	236.17	236.17	236.17	150.0
2017-02-24 04:31:00	SPY	ETF	236.15	236.15	236.15	236.15	100.0
2017-02-24 04:35:00	SPY	ETF	236.15	236.15	236.15	236.15	241.0
2017-02-24 04:44:00	SPY	ETF	236.2	236.2	236.2	236.2	100.0
2017-02-24 04:47:00	SPY	ETF	236.3	236.3	236.3	236.3	130.0
2017-02-24 05:11:00	SPY	ETF	236.22	236.22	236.22	236.22	953.0
2017-02-24 05:18:00	SPY	ETF	236.2	236.21	236.2	236.2	10001.0
2017-02-24 05:19:00	SPY	ETF	236.19	236.19	236.19	236.19	200.0
2017-02-24 05:30:00	SPY	ETF	236.07	236.07	236.07	236.07	213.0
2017-02-24 05:32:00	SPY	ETF	236.0	236.0	235.96	235.96	1030.0
2017-02-24 05:36:00	SPY	ETF	235.93	235.93	235.93	235.93	200.0
2017-02-24 05:38:00	SPY	ETF	235.92	235.92	235.92	235.92	2000.0
2017-02-24 05:39:00	SPY	ETF	235.93	235.93	235.93	235.93	2001.0
2017-02-24 05:40:00	SPY	ETF	235.96	235.96	235.96	235.96	2000.0
2017-02-24 05:45:00	SPY	ETF	235.88	235.88	235.88	235.88	256.0
2017-02-24 05:46:00	SPY	ETF	235.82	235.82	235.82	235.82	1025.0
2017-02-24 05:49:00	SPY	ETF	235.88	235.88	235.88	235.88	1989.0
2017-02-24 05:51:00	SPY	ETF	235.93	235.93	235.93	235.93	499.0
2017-02-24 05:53:00	SPY	ETF	235.95	235.95	235.95	235.95	500.0
2017-02-24 05:55:00	SPY	ETF	235.94	235.94	235.93	235.93	500.0
2017-02-24 05:57:00	SPY	ETF	235.95	235.95	235.95	235.95	500.0
2017-02-24 05:59:00	SPY	ETF	235.98	235.98	235.98	235.98	501.0
2017-02-24 06:00:00	SPY	ETF	235.95	235.95	235.95	235.95	202.0
2017-02-24 06:05:00	SPY	ETF	235.85	235.85	235.85	235.85	303.0
2017-02-24 06:06:00	SPY	ETF	235.82	235.82	235.81	235.81	952.0
2017-02-24 06:07:00	SPY	ETF	235.85	235.85	235.85	235.85	200.0
2017-02-24 06:10:00	SPY	ETF	235.83	235.83	235.8	235.8	2202.0
2017-02-24 06:11:00	SPY	ETF	235.79	235.79	235.78	235.78	202.0
2017-02-24 06:12:00	SPY	ETF	235.77	235.8	235.77	235.8	627.0
2017-02-24 06:15:00	SPY	ETF	235.83	235.83	235.78	235.78	1105.0
2017-02-24 06:19:00	SPY	ETF	235.72	235.75	235.72	235.75	601.0
2017-02-24 06:20:00	SPY	ETF	235.71	235.71	235.68	235.68	626.0
2017-02-24 06:21:00	SPY	ETF	235.68	235.7	235.61	235.61	1111.0
2017-02-24 06:24:00	SPY	ETF	235.66	235.66	235.66	235.66	1001.0
2017-02-24 06:26:00	SPY	ETF	235.59	235.62	235.59	235.59	10500.0
2017-02-24 06:27:00	SPY	ETF	235.61	235.61	235.6	235.6	10050.0
2017-02-24 06:28:00	SPY	ETF	235.59	235.59	235.59	235.59	2000.0
2017-02-24 06:29:00	SPY	ETF	235.59	235.66	235.59	235.66	26303.0
2017-02-24 06:30:00	SPY	ETF	235.65	235.65	235.65	235.65	200.0
2017-02-24 06:31:00	SPY	ETF	235.64	235.64	235.64	235.64	4700.0
2017-02-24 06:32:00	SPY	ETF	235.64	235.64	235.64	235.64	400.0
2017-02-24 06:33:00	SPY	ETF	235.71	235.73	235.7	235.73	5504.0
2017-02-24 06:34:00	SPY	ETF	235.73	235.73	235.73	235.73	5000.0
2017-02-24 06:35:00	SPY	ETF	235.7	235.7	235.7	235.7	304.0
2017-02-24 06:36:00	SPY	ETF	235.68	235.68	235.68	235.68	200.0
2017-02-24 06:39:00	SPY	ETF	235.68	235.68	235.68	235.68	1500.0
2017-02-24 06:40:00	SPY	ETF	235.68	235.68	235.68	235.68	200.0
2017-02-24 06:41:00	SPY	ETF	235.67	235.67	235.65	235.65	9300.0
2017-02-24 06:42:00	SPY	ETF	235.66	235.66	235.65	235.65	71506.0
2017-02-24 06:44:00	SPY	ETF	235.65	235.65	235.65	235.65	5600.0

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

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