PREVIEW / etf_1hour / 2017-10-09

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-10-09.parquet
  size:    272 KB
  rows:    8,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
2017-10-09 04:00:00	SPY	ETF	254.51	254.51	254.45	254.51	2485.0
2017-10-09 05:00:00	SPY	ETF	254.47	254.47	254.47	254.47	105.0
2017-10-09 06:00:00	SPY	ETF	254.57	254.65	254.57	254.62	2953.0
2017-10-09 07:00:00	SPY	ETF	254.64	254.78	254.62	254.74	112404.0
2017-10-09 08:00:00	SPY	ETF	254.37	254.78	254.37	254.61	193993.0
2017-10-09 09:00:00	SPY	ETF	254.62	254.73	254.15	254.26	4387624.0
2017-10-09 10:00:00	SPY	ETF	254.26	254.37	254.07	254.22	3494097.0
2017-10-09 11:00:00	SPY	ETF	254.22	254.42	254.19	254.37	1841327.0
2017-10-09 12:00:00	SPY	ETF	254.38	254.4	254.19	254.22	1319514.0
2017-10-09 13:00:00	SPY	ETF	254.2164	254.3	254.21	254.28	2079610.0
2017-10-09 14:00:00	SPY	ETF	254.29	254.3	253.98	253.99	2812431.0
2017-10-09 15:00:00	SPY	ETF	253.985	253.99	253.65	253.96	11536609.0
2017-10-09 16:00:00	SPY	ETF	253.95	254.13	253.95	254.08	6301643.0
2017-10-09 17:00:00	SPY	ETF	254.1	254.12	254.05	254.06	944148.0
2017-10-09 18:00:00	SPY	ETF	254.06	254.11	254.03	254.07	61586.0
2017-10-09 19:00:00	SPY	ETF	254.07	254.11	254.06	254.1	38317.0
2017-10-09 04:00:00	QQQ	ETF	147.76	147.8	147.7	147.8	12500.0
2017-10-09 05:00:00	QQQ	ETF	147.74	147.82	147.74	147.82	1492.0
2017-10-09 06:00:00	QQQ	ETF	147.87	147.87	147.86	147.86	1998.0
2017-10-09 07:00:00	QQQ	ETF	147.81	147.91	147.81	147.9	23197.0
2017-10-09 08:00:00	QQQ	ETF	147.66	147.98	147.66	147.91	90033.0
2017-10-09 09:00:00	QQQ	ETF	147.92	147.95	147.6412	147.86	2172387.0
2017-10-09 10:00:00	QQQ	ETF	147.85	148.0093	147.58	147.7	2252622.0
2017-10-09 11:00:00	QQQ	ETF	147.7	147.87	147.69	147.84	821018.0
2017-10-09 12:00:00	QQQ	ETF	147.84	147.86	147.69	147.73	611148.0
2017-10-09 13:00:00	QQQ	ETF	147.73	147.79	147.63	147.69	1012491.0
2017-10-09 14:00:00	QQQ	ETF	147.69	147.77	147.54	147.54	1566489.0
2017-10-09 15:00:00	QQQ	ETF	147.5408	147.56	147.3	147.48	2879372.0
2017-10-09 16:00:00	QQQ	ETF	147.49	147.6	147.42	147.49	367670.0
2017-10-09 17:00:00	QQQ	ETF	147.45	147.53	147.45	147.53	1543.0
2017-10-09 18:00:00	QQQ	ETF	147.53	147.53	147.53	147.53	1400.0
2017-10-09 19:00:00	QQQ	ETF	147.5	147.55	147.5	147.55	6803.0
2017-10-09 06:00:00	IWM	ETF	150.35	150.35	150.35	150.35	1000.0
2017-10-09 07:00:00	IWM	ETF	150.25	150.34	150.25	150.32	10900.0
2017-10-09 08:00:00	IWM	ETF	150.27	150.33	150.15	150.15	50053.0
2017-10-09 09:00:00	IWM	ETF	150.2	150.68	149.83	149.91	2241331.0
2017-10-09 10:00:00	IWM	ETF	149.91	150.06	149.69	149.75	1568704.0
2017-10-09 11:00:00	IWM	ETF	149.74	149.91	149.6201	149.85	1034297.0
2017-10-09 12:00:00	IWM	ETF	149.855	149.855	149.52	149.54	620653.0
2017-10-09 13:00:00	IWM	ETF	149.54	149.64	149.42	149.525	891588.0
2017-10-09 14:00:00	IWM	ETF	149.525	149.56	149.36	149.43	1033730.0
2017-10-09 15:00:00	IWM	ETF	149.42	149.48	149.18	149.42	2830359.0
2017-10-09 16:00:00	IWM	ETF	149.42	149.7	149.3765	149.3765	715335.0
2017-10-09 17:00:00	IWM	ETF	149.63	149.67	149.63	149.67	1017.0
2017-10-09 18:00:00	IWM	ETF	149.6	149.67	149.6	149.65	3246.0
2017-10-09 19:00:00	IWM	ETF	149.67	149.68	149.65	149.65	4922.0
2017-10-09 06:00:00	DIA	ETF	227.8	227.8	227.8	227.8	600.0
2017-10-09 07:00:00	DIA	ETF	227.9	227.9	227.9	227.9	100.0
2017-10-09 08:00:00	DIA	ETF	227.83	227.83	227.8	227.8	1670.0
2017-10-09 09:00:00	DIA	ETF	227.85	227.96	227.5	227.6	225092.0

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

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