PREVIEW / etf_1min / 2017-01-03

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-01-03.parquet
  size:    3.3 MB
  rows:    172,529

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-01-03 04:00:00	SPY	ETF	224.8	224.83	224.3	224.83	4960.0
2017-01-03 04:01:00	SPY	ETF	224.83	224.83	224.6	224.6	5976.0
2017-01-03 04:02:00	SPY	ETF	224.77	224.77	224.77	224.77	1994.0
2017-01-03 04:03:00	SPY	ETF	224.77	224.77	224.77	224.77	110.0
2017-01-03 04:05:00	SPY	ETF	224.77	224.77	224.77	224.77	7500.0
2017-01-03 04:06:00	SPY	ETF	224.79	224.8	224.79	224.8	1100.0
2017-01-03 04:10:00	SPY	ETF	224.77	224.83	224.77	224.83	1300.0
2017-01-03 04:11:00	SPY	ETF	224.82	224.82	224.76	224.76	5320.0
2017-01-03 04:12:00	SPY	ETF	224.8	224.8	224.8	224.8	1280.0
2017-01-03 04:13:00	SPY	ETF	224.81	224.81	224.81	224.81	100.0
2017-01-03 04:14:00	SPY	ETF	224.81	224.81	224.81	224.81	100.0
2017-01-03 04:15:00	SPY	ETF	224.78	224.78	224.78	224.78	2000.0
2017-01-03 04:16:00	SPY	ETF	224.83	224.83	224.83	224.83	200.0
2017-01-03 04:17:00	SPY	ETF	224.83	224.84	224.83	224.84	3000.0
2017-01-03 04:23:00	SPY	ETF	224.82	224.82	224.78	224.78	1800.0
2017-01-03 04:24:00	SPY	ETF	224.78	224.78	224.78	224.78	700.0
2017-01-03 04:30:00	SPY	ETF	224.72	224.76	224.72	224.76	600.0
2017-01-03 04:31:00	SPY	ETF	224.76	224.76	224.76	224.76	400.0
2017-01-03 04:32:00	SPY	ETF	224.76	224.76	224.76	224.76	667.0
2017-01-03 04:34:00	SPY	ETF	224.74	224.74	224.7	224.7	1300.0
2017-01-03 04:35:00	SPY	ETF	224.74	224.74	224.74	224.74	400.0
2017-01-03 04:36:00	SPY	ETF	224.71	224.71	224.71	224.71	200.0
2017-01-03 04:41:00	SPY	ETF	224.86	224.86	224.86	224.86	700.0
2017-01-03 04:44:00	SPY	ETF	224.87	224.87	224.87	224.87	400.0
2017-01-03 04:46:00	SPY	ETF	224.85	224.85	224.85	224.85	100.0
2017-01-03 04:47:00	SPY	ETF	224.84	224.84	224.84	224.84	300.0
2017-01-03 04:48:00	SPY	ETF	224.8	224.8	224.8	224.8	150.0
2017-01-03 04:49:00	SPY	ETF	224.84	224.84	224.84	224.84	1300.0
2017-01-03 04:54:00	SPY	ETF	224.86	224.86	224.86	224.86	300.0
2017-01-03 04:56:00	SPY	ETF	224.86	224.86	224.86	224.86	400.0
2017-01-03 04:59:00	SPY	ETF	224.86	224.86	224.86	224.86	1400.0
2017-01-03 05:00:00	SPY	ETF	224.87	224.93	224.87	224.93	2396.0
2017-01-03 05:01:00	SPY	ETF	224.96	224.96	224.96	224.96	200.0
2017-01-03 05:04:00	SPY	ETF	224.96	224.96	224.96	224.96	400.0
2017-01-03 05:06:00	SPY	ETF	224.95	224.95	224.95	224.95	1000.0
2017-01-03 05:07:00	SPY	ETF	224.95	224.95	224.95	224.95	200.0
2017-01-03 05:09:00	SPY	ETF	224.96	224.96	224.96	224.96	300.0
2017-01-03 05:13:00	SPY	ETF	224.94	224.94	224.94	224.94	500.0
2017-01-03 05:14:00	SPY	ETF	224.93	224.96	224.93	224.96	2188.0
2017-01-03 05:17:00	SPY	ETF	224.96	224.97	224.96	224.97	980.0
2017-01-03 05:19:00	SPY	ETF	224.9	224.9	224.9	224.9	500.0
2017-01-03 05:24:00	SPY	ETF	224.86	224.86	224.85	224.85	3100.0
2017-01-03 05:25:00	SPY	ETF	224.85	224.85	224.84	224.84	30500.0
2017-01-03 05:29:00	SPY	ETF	224.89	224.89	224.89	224.89	400.0
2017-01-03 05:30:00	SPY	ETF	224.85	224.85	224.84	224.84	22222.0
2017-01-03 05:31:00	SPY	ETF	224.88	224.88	224.88	224.88	800.0
2017-01-03 05:32:00	SPY	ETF	224.88	224.88	224.88	224.88	400.0
2017-01-03 05:36:00	SPY	ETF	224.88	224.88	224.88	224.88	400.0
2017-01-03 05:43:00	SPY	ETF	224.9	224.9	224.9	224.9	200.0
2017-01-03 05:44:00	SPY	ETF	224.91	224.91	224.91	224.91	300.0

> showing 50 of 172,529 rows — these rows as CSV

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