PREVIEW / etf_1min / 2017-12-29

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-12-29.parquet
  size:    2.9 MB
  rows:    152,399

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-12-29 04:00:00	SPY	ETF	267.94	268.0	267.94	268.0	440.0
2017-12-29 04:16:00	SPY	ETF	268.12	268.12	268.12	268.12	206.0
2017-12-29 04:21:00	SPY	ETF	268.06	268.06	268.06	268.06	191.0
2017-12-29 04:41:00	SPY	ETF	268.15	268.15	268.15	268.15	100.0
2017-12-29 04:42:00	SPY	ETF	268.18	268.18	268.18	268.18	351.0
2017-12-29 05:02:00	SPY	ETF	268.3	268.3	268.3	268.3	603.0
2017-12-29 05:04:00	SPY	ETF	268.33	268.4	268.33	268.4	1142.0
2017-12-29 05:06:00	SPY	ETF	268.42	268.43	268.42	268.43	200.0
2017-12-29 05:07:00	SPY	ETF	268.43	268.43	268.43	268.43	500.0
2017-12-29 05:12:00	SPY	ETF	268.43	268.43	268.43	268.43	178.0
2017-12-29 05:13:00	SPY	ETF	268.43	268.43	268.43	268.43	200.0
2017-12-29 05:14:00	SPY	ETF	268.45	268.45	268.45	268.45	10542.0
2017-12-29 05:28:00	SPY	ETF	268.4	268.4	268.4	268.4	4000.0
2017-12-29 05:32:00	SPY	ETF	268.35	268.35	268.35	268.35	5053.0
2017-12-29 05:39:00	SPY	ETF	268.4	268.4	268.4	268.4	501.0
2017-12-29 05:43:00	SPY	ETF	268.4	268.4	268.4	268.4	500.0
2017-12-29 05:44:00	SPY	ETF	268.39	268.39	268.39	268.39	300.0
2017-12-29 05:45:00	SPY	ETF	268.4	268.42	268.4	268.42	5003.0
2017-12-29 05:50:00	SPY	ETF	268.47	268.47	268.47	268.47	2000.0
2017-12-29 05:51:00	SPY	ETF	268.49	268.49	268.49	268.49	302.0
2017-12-29 05:55:00	SPY	ETF	268.49	268.54	268.49	268.54	5902.0
2017-12-29 05:57:00	SPY	ETF	268.57	268.57	268.57	268.57	492.0
2017-12-29 05:58:00	SPY	ETF	268.54	268.54	268.54	268.54	4000.0
2017-12-29 06:02:00	SPY	ETF	268.52	268.52	268.52	268.52	500.0
2017-12-29 06:09:00	SPY	ETF	268.55	268.55	268.54	268.54	20000.0
2017-12-29 06:17:00	SPY	ETF	268.56	268.56	268.56	268.56	200.0
2017-12-29 06:23:00	SPY	ETF	268.6	268.6	268.6	268.6	1650.0
2017-12-29 06:32:00	SPY	ETF	268.6	268.6	268.6	268.6	2672.0
2017-12-29 06:45:00	SPY	ETF	268.61	268.61	268.61	268.61	2000.0
2017-12-29 06:50:00	SPY	ETF	268.62	268.62	268.62	268.62	400.0
2017-12-29 06:59:00	SPY	ETF	268.62	268.62	268.62	268.62	501.0
2017-12-29 07:00:00	SPY	ETF	268.58	268.59	268.58	268.59	500.0
2017-12-29 07:01:00	SPY	ETF	268.56	268.56	268.56	268.56	500.0
2017-12-29 07:02:00	SPY	ETF	268.6	268.6	268.6	268.6	1002.0
2017-12-29 07:03:00	SPY	ETF	268.61	268.61	268.61	268.61	1000.0
2017-12-29 07:07:00	SPY	ETF	268.61	268.61	268.61	268.61	450.0
2017-12-29 07:08:00	SPY	ETF	268.61	268.61	268.6	268.6	1000.0
2017-12-29 07:10:00	SPY	ETF	268.63	268.63	268.6	268.6	5201.0
2017-12-29 07:12:00	SPY	ETF	268.6	268.63	268.6	268.63	5267.0
2017-12-29 07:13:00	SPY	ETF	268.64	268.65	268.64	268.65	7601.0
2017-12-29 07:14:00	SPY	ETF	268.66	268.67	268.63	268.65	8644.0
2017-12-29 07:15:00	SPY	ETF	268.67	268.67	268.67	268.67	300.0
2017-12-29 07:16:00	SPY	ETF	268.67	268.73	268.67	268.73	1040.0
2017-12-29 07:17:00	SPY	ETF	268.73	268.73	268.73	268.73	250.0
2017-12-29 07:18:00	SPY	ETF	268.72	268.72	268.72	268.72	1000.0
2017-12-29 07:19:00	SPY	ETF	268.73	268.73	268.73	268.73	5000.0
2017-12-29 07:20:00	SPY	ETF	268.73	268.73	268.72	268.72	6000.0
2017-12-29 07:21:00	SPY	ETF	268.76	268.78	268.75	268.75	520.0
2017-12-29 07:22:00	SPY	ETF	268.75	268.78	268.75	268.77	11022.0
2017-12-29 07:23:00	SPY	ETF	268.82	268.93	268.8	268.91	6545.0

> showing 50 of 152,399 rows — these rows as CSV

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