PREVIEW / etf_1min / 2017-11-09

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-11-09.parquet
  size:    3.0 MB
  rows:    152,552

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-11-09 04:00:00	SPY	ETF	258.85	258.85	258.83	258.83	38610.0
2017-11-09 04:03:00	SPY	ETF	258.77	258.77	258.77	258.77	200.0
2017-11-09 04:04:00	SPY	ETF	258.75	258.75	258.74	258.74	300.0
2017-11-09 04:15:00	SPY	ETF	258.72	258.72	258.72	258.72	5000.0
2017-11-09 04:17:00	SPY	ETF	258.78	258.78	258.78	258.78	500.0
2017-11-09 04:18:00	SPY	ETF	258.78	258.78	258.78	258.78	100.0
2017-11-09 04:19:00	SPY	ETF	258.75	258.75	258.75	258.75	400.0
2017-11-09 04:23:00	SPY	ETF	258.77	258.77	258.77	258.77	200.0
2017-11-09 04:24:00	SPY	ETF	258.75	258.75	258.75	258.75	200.0
2017-11-09 04:26:00	SPY	ETF	258.76	258.76	258.76	258.76	500.0
2017-11-09 04:27:00	SPY	ETF	258.72	258.73	258.72	258.73	1288.0
2017-11-09 04:30:00	SPY	ETF	258.76	258.76	258.76	258.76	100.0
2017-11-09 04:32:00	SPY	ETF	258.75	258.75	258.75	258.75	1600.0
2017-11-09 04:33:00	SPY	ETF	258.72	258.72	258.72	258.72	300.0
2017-11-09 04:34:00	SPY	ETF	258.73	258.73	258.73	258.73	100.0
2017-11-09 04:56:00	SPY	ETF	258.78	258.78	258.78	258.78	600.0
2017-11-09 05:00:00	SPY	ETF	258.79	258.79	258.79	258.79	100.0
2017-11-09 05:03:00	SPY	ETF	258.72	258.72	258.72	258.72	500.0
2017-11-09 05:07:00	SPY	ETF	258.76	258.76	258.76	258.76	100.0
2017-11-09 05:08:00	SPY	ETF	258.73	258.73	258.73	258.73	600.0
2017-11-09 05:09:00	SPY	ETF	258.73	258.73	258.73	258.73	300.0
2017-11-09 05:10:00	SPY	ETF	258.73	258.73	258.73	258.73	100.0
2017-11-09 05:11:00	SPY	ETF	258.73	258.73	258.73	258.73	200.0
2017-11-09 05:12:00	SPY	ETF	258.7	258.7	258.67	258.67	1600.0
2017-11-09 05:14:00	SPY	ETF	258.68	258.68	258.68	258.68	200.0
2017-11-09 05:15:00	SPY	ETF	258.62	258.62	258.62	258.62	1000.0
2017-11-09 05:16:00	SPY	ETF	258.62	258.62	258.62	258.62	100.0
2017-11-09 05:17:00	SPY	ETF	258.59	258.59	258.59	258.59	200.0
2017-11-09 05:20:00	SPY	ETF	258.6	258.6	258.6	258.6	100.0
2017-11-09 05:21:00	SPY	ETF	258.61	258.61	258.61	258.61	900.0
2017-11-09 05:25:00	SPY	ETF	258.59	258.59	258.59	258.59	2020.0
2017-11-09 05:26:00	SPY	ETF	258.56	258.56	258.56	258.56	100.0
2017-11-09 05:27:00	SPY	ETF	258.58	258.58	258.58	258.58	500.0
2017-11-09 05:28:00	SPY	ETF	258.55	258.55	258.55	258.55	100.0
2017-11-09 05:36:00	SPY	ETF	258.58	258.58	258.55	258.55	200.0
2017-11-09 05:42:00	SPY	ETF	258.6	258.6	258.6	258.6	1800.0
2017-11-09 05:44:00	SPY	ETF	258.63	258.63	258.63	258.63	100.0
2017-11-09 05:45:00	SPY	ETF	258.73	258.73	258.73	258.73	500.0
2017-11-09 06:04:00	SPY	ETF	258.65	258.65	258.65	258.65	100.0
2017-11-09 06:10:00	SPY	ETF	258.6	258.6	258.6	258.6	500.0
2017-11-09 06:12:00	SPY	ETF	258.6	258.66	258.6	258.66	3000.0
2017-11-09 06:14:00	SPY	ETF	258.67	258.67	258.67	258.67	1500.0
2017-11-09 06:17:00	SPY	ETF	258.66	258.66	258.66	258.66	100.0
2017-11-09 06:20:00	SPY	ETF	258.61	258.61	258.58	258.58	800.0
2017-11-09 06:22:00	SPY	ETF	258.58	258.58	258.58	258.58	5001.0
2017-11-09 06:23:00	SPY	ETF	258.52	258.52	258.52	258.52	5000.0
2017-11-09 06:24:00	SPY	ETF	258.5	258.5	258.5	258.5	2505.0
2017-11-09 06:26:00	SPY	ETF	258.5	258.51	258.47	258.51	1400.0
2017-11-09 06:27:00	SPY	ETF	258.43	258.43	258.4	258.4	5206.0
2017-11-09 06:28:00	SPY	ETF	258.37	258.41	258.37	258.38	2203.0

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

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