PREVIEW / etf_1hour / 2017-10-17

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-10-17.parquet
  size:    281 KB
  rows:    9,283

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-10-17 04:00:00	SPY	ETF	255.22	255.27	255.19	255.24	3700.0
2017-10-17 05:00:00	SPY	ETF	255.22	255.32	255.22	255.29	2620.0
2017-10-17 06:00:00	SPY	ETF	255.32	255.32	255.24	255.29	23024.0
2017-10-17 07:00:00	SPY	ETF	255.3	255.39	255.29	255.36	112664.0
2017-10-17 08:00:00	SPY	ETF	255.36	255.38	255.25	255.3	242503.0
2017-10-17 09:00:00	SPY	ETF	255.3	255.32	255.15	255.28	2803679.0
2017-10-17 10:00:00	SPY	ETF	255.275	255.38	254.98	255.15	6481035.0
2017-10-17 11:00:00	SPY	ETF	255.15	255.37	255.09	255.14	3379941.0
2017-10-17 12:00:00	SPY	ETF	255.14	255.235	255.11	255.135	2319049.0
2017-10-17 13:00:00	SPY	ETF	255.135	255.2	255.02	255.1	2193752.0
2017-10-17 14:00:00	SPY	ETF	255.095	255.3	255.09	255.2792	2380700.0
2017-10-17 15:00:00	SPY	ETF	255.27	255.52	255.24	255.46	8098783.0
2017-10-17 16:00:00	SPY	ETF	255.46	255.48	255.18	255.41	2753837.0
2017-10-17 17:00:00	SPY	ETF	255.42	255.43	255.41	255.41	67808.0
2017-10-17 18:00:00	SPY	ETF	255.4	255.42	255.37	255.39	67639.0
2017-10-17 19:00:00	SPY	ETF	255.4	255.57	255.38	255.54	33715.0
2017-10-17 04:00:00	QQQ	ETF	148.86	148.86	148.81	148.81	300.0
2017-10-17 06:00:00	QQQ	ETF	148.87	148.89	148.86	148.89	600.0
2017-10-17 07:00:00	QQQ	ETF	148.91	148.94	148.88	148.93	93028.0
2017-10-17 08:00:00	QQQ	ETF	148.88	148.95	148.78	148.89	146590.0
2017-10-17 09:00:00	QQQ	ETF	148.87	148.87	148.65	148.75	2412023.0
2017-10-17 10:00:00	QQQ	ETF	148.74	148.87	148.57	148.79	1663822.0
2017-10-17 11:00:00	QQQ	ETF	148.8	148.95	148.71	148.74	1781129.0
2017-10-17 12:00:00	QQQ	ETF	148.75	148.84	148.71	148.77	538371.0
2017-10-17 13:00:00	QQQ	ETF	148.77	148.87	148.74	148.77	758451.0
2017-10-17 14:00:00	QQQ	ETF	148.78	148.92	148.78	148.91	944964.0
2017-10-17 15:00:00	QQQ	ETF	148.91	149.06	148.85	149.04	3032340.0
2017-10-17 16:00:00	QQQ	ETF	149.035	149.05	149.0	149.0	405199.0
2017-10-17 17:00:00	QQQ	ETF	149.02	149.05	149.0	149.04	5359.0
2017-10-17 18:00:00	QQQ	ETF	149.02	149.06	149.0	149.03	27453.0
2017-10-17 19:00:00	QQQ	ETF	149.01	149.13	149.01	149.12	7976.0
2017-10-17 07:00:00	IWM	ETF	149.39	149.5	149.39	149.48	102484.0
2017-10-17 08:00:00	IWM	ETF	149.48	149.5	149.34	149.38	65575.0
2017-10-17 09:00:00	IWM	ETF	149.33	149.46	149.13	149.425	1255255.0
2017-10-17 10:00:00	IWM	ETF	149.43	149.72	148.96	149.3299	2016049.0
2017-10-17 11:00:00	IWM	ETF	149.33	149.77	149.3	149.549	1856543.0
2017-10-17 12:00:00	IWM	ETF	149.53	149.565	149.23	149.24	618095.0
2017-10-17 13:00:00	IWM	ETF	149.24	149.33	148.71	148.76	1819905.0
2017-10-17 14:00:00	IWM	ETF	148.77	148.985	148.76	148.905	1814232.0
2017-10-17 15:00:00	IWM	ETF	148.92	148.935	148.5	148.79	4394300.0
2017-10-17 16:00:00	IWM	ETF	148.79	148.91	148.71	148.86	597747.0
2017-10-17 17:00:00	IWM	ETF	148.777	148.84	148.777	148.84	100500.0
2017-10-17 18:00:00	IWM	ETF	148.88	148.88	148.88	148.88	341.0
2017-10-17 19:00:00	IWM	ETF	148.88	148.98	148.88	148.98	3347.0
2017-10-17 07:00:00	DIA	ETF	229.75	229.75	229.75	229.75	195.0
2017-10-17 08:00:00	DIA	ETF	229.65	229.7	229.56	229.7	7636.0
2017-10-17 09:00:00	DIA	ETF	229.67	229.82	229.52	229.64	232844.0
2017-10-17 10:00:00	DIA	ETF	229.63	229.81	229.57	229.77	246439.0
2017-10-17 11:00:00	DIA	ETF	229.76	229.9599	229.61	229.7045	216146.0
2017-10-17 12:00:00	DIA	ETF	229.7	229.76	229.66	229.69	114401.0

> showing 50 of 9,283 rows — these rows as CSV

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