PREVIEW / etf_1min / 2017-11-15

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-11-15.parquet
  size:    2.7 MB
  rows:    142,984

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-15 04:00:00	SPY	ETF	256.78	256.78	256.75	256.75	700.0
2017-11-15 04:04:00	SPY	ETF	256.7	256.7	256.7	256.7	200.0
2017-11-15 04:05:00	SPY	ETF	256.7	256.7	256.7	256.7	1001.0
2017-11-15 04:06:00	SPY	ETF	256.72	256.72	256.72	256.72	102.0
2017-11-15 04:11:00	SPY	ETF	256.75	256.75	256.75	256.75	400.0
2017-11-15 04:12:00	SPY	ETF	256.71	256.71	256.71	256.71	500.0
2017-11-15 04:17:00	SPY	ETF	256.83	256.83	256.83	256.83	150.0
2017-11-15 04:19:00	SPY	ETF	256.85	256.85	256.85	256.85	500.0
2017-11-15 04:24:00	SPY	ETF	256.83	256.83	256.83	256.83	800.0
2017-11-15 04:26:00	SPY	ETF	256.83	256.83	256.83	256.83	504.0
2017-11-15 04:27:00	SPY	ETF	256.81	256.81	256.81	256.81	500.0
2017-11-15 04:28:00	SPY	ETF	256.82	256.82	256.82	256.82	500.0
2017-11-15 04:29:00	SPY	ETF	256.81	256.81	256.8	256.8	4900.0
2017-11-15 04:30:00	SPY	ETF	256.77	256.77	256.76	256.76	1200.0
2017-11-15 04:34:00	SPY	ETF	256.75	256.75	256.75	256.75	1000.0
2017-11-15 04:35:00	SPY	ETF	256.75	256.75	256.73	256.73	504.0
2017-11-15 04:37:00	SPY	ETF	256.7	256.7	256.68	256.68	606.0
2017-11-15 04:38:00	SPY	ETF	256.6	256.61	256.58	256.61	862.0
2017-11-15 04:39:00	SPY	ETF	256.58	256.58	256.58	256.58	123.0
2017-11-15 04:43:00	SPY	ETF	256.54	256.54	256.54	256.54	159.0
2017-11-15 04:45:00	SPY	ETF	256.5	256.5	256.5	256.5	3001.0
2017-11-15 04:47:00	SPY	ETF	256.54	256.54	256.47	256.49	1495.0
2017-11-15 04:54:00	SPY	ETF	256.64	256.64	256.6	256.6	300.0
2017-11-15 04:57:00	SPY	ETF	256.7	256.7	256.7	256.7	2001.0
2017-11-15 05:09:00	SPY	ETF	256.71	256.71	256.71	256.71	400.0
2017-11-15 05:17:00	SPY	ETF	256.7	256.7	256.7	256.7	3999.0
2017-11-15 05:24:00	SPY	ETF	256.38	256.38	256.38	256.38	103.0
2017-11-15 05:26:00	SPY	ETF	256.38	256.38	256.38	256.38	3003.0
2017-11-15 05:29:00	SPY	ETF	256.3	256.3	256.3	256.3	1052.0
2017-11-15 05:30:00	SPY	ETF	256.3	256.4	256.3	256.4	904.0
2017-11-15 05:31:00	SPY	ETF	256.4	256.4	256.4	256.4	2402.0
2017-11-15 05:38:00	SPY	ETF	256.37	256.37	256.37	256.37	2500.0
2017-11-15 05:39:00	SPY	ETF	256.38	256.38	256.38	256.38	5000.0
2017-11-15 05:40:00	SPY	ETF	256.42	256.42	256.42	256.42	5000.0
2017-11-15 05:43:00	SPY	ETF	256.42	256.42	256.4	256.4	542.0
2017-11-15 05:52:00	SPY	ETF	256.38	256.38	256.38	256.38	2002.0
2017-11-15 05:53:00	SPY	ETF	256.42	256.42	256.42	256.42	102.0
2017-11-15 06:00:00	SPY	ETF	256.45	256.45	256.41	256.41	400.0
2017-11-15 06:01:00	SPY	ETF	256.43	256.43	256.43	256.43	400.0
2017-11-15 06:04:00	SPY	ETF	256.43	256.43	256.43	256.43	300.0
2017-11-15 06:05:00	SPY	ETF	256.41	256.42	256.41	256.42	500.0
2017-11-15 06:11:00	SPY	ETF	256.5	256.5	256.46	256.46	2601.0
2017-11-15 06:12:00	SPY	ETF	256.45	256.45	256.45	256.45	1002.0
2017-11-15 06:15:00	SPY	ETF	256.49	256.49	256.49	256.49	1002.0
2017-11-15 06:18:00	SPY	ETF	256.49	256.49	256.49	256.49	230.0
2017-11-15 06:23:00	SPY	ETF	256.46	256.46	256.46	256.46	500.0
2017-11-15 06:24:00	SPY	ETF	256.46	256.46	256.46	256.46	313.0
2017-11-15 06:27:00	SPY	ETF	256.4	256.4	256.4	256.4	601.0
2017-11-15 06:29:00	SPY	ETF	256.45	256.46	256.45	256.45	50000.0
2017-11-15 06:32:00	SPY	ETF	256.44	256.44	256.44	256.44	200.0

> showing 50 of 142,984 rows — these rows as CSV

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