PREVIEW / etf_1min / 2018-11-20

all etf 1-min files

  file:    by_date/etf_1min/2018/2018-11-20.parquet
  size:    3.8 MB
  rows:    194,919

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
2018-11-20 04:00:00	SPY	ETF	267.93	267.93	267.93	267.93	839.0
2018-11-20 04:01:00	SPY	ETF	267.7	267.75	267.7	267.75	262.0
2018-11-20 04:02:00	SPY	ETF	267.75	267.75	267.75	267.75	2114.0
2018-11-20 04:04:00	SPY	ETF	267.7	267.7	267.7	267.7	224.0
2018-11-20 04:05:00	SPY	ETF	267.63	267.76	267.27	267.27	4463.0
2018-11-20 04:12:00	SPY	ETF	267.43	267.43	267.43	267.43	1350.0
2018-11-20 04:13:00	SPY	ETF	267.4	267.62	267.4	267.62	3900.0
2018-11-20 04:14:00	SPY	ETF	267.55	267.55	267.55	267.55	135.0
2018-11-20 04:15:00	SPY	ETF	267.5	267.5	267.5	267.5	310.0
2018-11-20 04:16:00	SPY	ETF	267.4	267.55	267.4	267.55	257.0
2018-11-20 04:17:00	SPY	ETF	267.58	267.64	267.58	267.64	625.0
2018-11-20 04:18:00	SPY	ETF	267.64	267.66	267.64	267.66	3072.0
2018-11-20 04:19:00	SPY	ETF	267.7	267.7	267.7	267.7	1800.0
2018-11-20 04:23:00	SPY	ETF	267.58	267.64	267.58	267.64	1537.0
2018-11-20 04:25:00	SPY	ETF	267.79	267.83	267.79	267.83	300.0
2018-11-20 04:26:00	SPY	ETF	267.77	267.77	267.77	267.77	224.0
2018-11-20 04:29:00	SPY	ETF	267.72	267.72	267.72	267.72	400.0
2018-11-20 04:30:00	SPY	ETF	267.82	267.84	267.73	267.84	1600.0
2018-11-20 04:32:00	SPY	ETF	267.9	267.9	267.9	267.9	500.0
2018-11-20 04:33:00	SPY	ETF	267.9	267.9	267.9	267.9	1800.0
2018-11-20 04:38:00	SPY	ETF	267.99	267.99	267.99	267.99	100.0
2018-11-20 04:40:00	SPY	ETF	268.0	268.05	268.0	268.05	500.0
2018-11-20 04:41:00	SPY	ETF	267.87	267.87	267.87	267.87	200.0
2018-11-20 04:42:00	SPY	ETF	267.85	267.85	267.85	267.85	370.0
2018-11-20 04:43:00	SPY	ETF	267.92	267.92	267.92	267.92	500.0
2018-11-20 04:45:00	SPY	ETF	267.92	267.92	267.81	267.81	600.0
2018-11-20 04:49:00	SPY	ETF	267.7	267.7	267.66	267.66	475.0
2018-11-20 04:53:00	SPY	ETF	267.67	267.67	267.67	267.67	500.0
2018-11-20 04:57:00	SPY	ETF	267.61	267.61	267.6	267.6	800.0
2018-11-20 05:00:00	SPY	ETF	267.61	267.61	267.61	267.61	1000.0
2018-11-20 05:01:00	SPY	ETF	267.52	267.6	267.52	267.6	1500.0
2018-11-20 05:02:00	SPY	ETF	267.6	267.6	267.55	267.55	2000.0
2018-11-20 05:04:00	SPY	ETF	267.54	267.54	267.54	267.54	1001.0
2018-11-20 05:05:00	SPY	ETF	267.47	267.47	267.4	267.4	2500.0
2018-11-20 05:06:00	SPY	ETF	267.42	267.42	267.42	267.42	1050.0
2018-11-20 05:07:00	SPY	ETF	267.4	267.42	267.4	267.42	1600.0
2018-11-20 05:09:00	SPY	ETF	267.48	267.48	267.48	267.48	1000.0
2018-11-20 05:10:00	SPY	ETF	267.51	267.51	267.51	267.51	100.0
2018-11-20 05:11:00	SPY	ETF	267.42	267.42	267.4	267.4	2082.0
2018-11-20 05:13:00	SPY	ETF	267.45	267.45	267.4	267.45	1935.0
2018-11-20 05:15:00	SPY	ETF	267.44	267.44	267.4	267.4	1695.0
2018-11-20 05:16:00	SPY	ETF	267.38	267.4	267.38	267.4	600.0
2018-11-20 05:17:00	SPY	ETF	267.4	267.4	267.35	267.35	1100.0
2018-11-20 05:18:00	SPY	ETF	267.35	267.35	267.35	267.35	100.0
2018-11-20 05:19:00	SPY	ETF	267.38	267.41	267.38	267.41	600.0
2018-11-20 05:21:00	SPY	ETF	267.58	267.58	267.54	267.56	1100.0
2018-11-20 05:23:00	SPY	ETF	267.57	267.76	267.57	267.75	4300.0
2018-11-20 05:24:00	SPY	ETF	267.71	267.73	267.71	267.73	1505.0
2018-11-20 05:25:00	SPY	ETF	267.86	267.86	267.81	267.86	1700.0
2018-11-20 05:26:00	SPY	ETF	267.86	267.95	267.84	267.95	6670.0

> showing 50 of 194,919 rows — these rows as CSV

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