PREVIEW / etf_1hour / 2017-09-11

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-09-11.parquet
  size:    282 KB
  rows:    9,346

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-09-11 04:00:00	SPY	ETF	247.87	248.11	247.85	248.04	25162.0
2017-09-11 05:00:00	SPY	ETF	248.09	248.09	247.98	248.08	26508.0
2017-09-11 06:00:00	SPY	ETF	248.08	248.11	248.01	248.06	59528.0
2017-09-11 07:00:00	SPY	ETF	248.04	248.06	247.77	247.81	122608.0
2017-09-11 08:00:00	SPY	ETF	247.82	247.97	247.81	247.93	636719.0
2017-09-11 09:00:00	SPY	ETF	247.92	248.65	247.92	248.53	9245726.0
2017-09-11 10:00:00	SPY	ETF	248.53	248.79	248.5	248.55	10146024.0
2017-09-11 11:00:00	SPY	ETF	248.56	248.95	248.52	248.9	5241066.0
2017-09-11 12:00:00	SPY	ETF	248.9	249.3	248.81	249.12	6204581.0
2017-09-11 13:00:00	SPY	ETF	249.12	249.24	249.1	249.16	4324195.0
2017-09-11 14:00:00	SPY	ETF	249.17	249.22	249.04	249.045	5844386.0
2017-09-11 15:00:00	SPY	ETF	249.045	249.21	249.0	249.17	15250493.0
2017-09-11 16:00:00	SPY	ETF	249.17	249.35	246.5251	249.28	11100871.0
2017-09-11 17:00:00	SPY	ETF	249.29	249.29	248.9601	249.27	628930.0
2017-09-11 18:00:00	SPY	ETF	249.28	249.3	249.22	249.24	58943.0
2017-09-11 19:00:00	SPY	ETF	249.24	249.33	249.18	249.31	36885.0
2017-09-11 04:00:00	QQQ	ETF	145.18	145.39	145.17	145.39	10808.0
2017-09-11 05:00:00	QQQ	ETF	145.36	145.44	145.34	145.41	17051.0
2017-09-11 06:00:00	QQQ	ETF	145.42	145.42	145.37	145.41	34783.0
2017-09-11 07:00:00	QQQ	ETF	145.39	145.39	145.19	145.21	153368.0
2017-09-11 08:00:00	QQQ	ETF	145.2	145.34	145.2	145.34	109899.0
2017-09-11 09:00:00	QQQ	ETF	145.34	145.99	145.3	145.9	5037152.0
2017-09-11 10:00:00	QQQ	ETF	145.9	146.12	145.51	145.56	3785623.0
2017-09-11 11:00:00	QQQ	ETF	145.5561	145.7288	145.4	145.69	2301446.0
2017-09-11 12:00:00	QQQ	ETF	145.69	145.955	145.64	145.89	1699841.0
2017-09-11 13:00:00	QQQ	ETF	145.9	145.95	145.78	145.87	1488449.0
2017-09-11 14:00:00	QQQ	ETF	145.88	145.95	145.66	145.73	2267667.0
2017-09-11 15:00:00	QQQ	ETF	145.73	145.89	145.68	145.83	5946030.0
2017-09-11 16:00:00	QQQ	ETF	145.81	146.02	145.5594	145.95	1108153.0
2017-09-11 17:00:00	QQQ	ETF	145.9	146.0	145.87	145.88	199986.0
2017-09-11 18:00:00	QQQ	ETF	145.92	145.95	145.87	145.92	16509.0
2017-09-11 19:00:00	QQQ	ETF	145.93	146.0	145.89	146.0	10142.0
2017-09-11 04:00:00	IWM	ETF	140.43	140.5	140.43	140.47	8300.0
2017-09-11 06:00:00	IWM	ETF	140.45	140.51	140.42	140.45	11290.0
2017-09-11 07:00:00	IWM	ETF	140.42	140.42	140.22	140.25	18088.0
2017-09-11 08:00:00	IWM	ETF	140.23	140.38	140.23	140.32	46193.0
2017-09-11 09:00:00	IWM	ETF	140.37	140.92	140.34	140.5604	3365923.0
2017-09-11 10:00:00	IWM	ETF	140.57	140.69	140.23	140.41	3807978.0
2017-09-11 11:00:00	IWM	ETF	140.42	140.78	140.23	140.72	2715620.0
2017-09-11 12:00:00	IWM	ETF	140.72	140.9	140.63	140.76	1598579.0
2017-09-11 13:00:00	IWM	ETF	140.77	140.89	140.65	140.77	1748466.0
2017-09-11 14:00:00	IWM	ETF	140.77	140.815	140.6	140.6	1097485.0
2017-09-11 15:00:00	IWM	ETF	140.6	140.85	140.59	140.69	3811544.0
2017-09-11 16:00:00	IWM	ETF	140.68	140.9	140.65	140.84	1662644.0
2017-09-11 17:00:00	IWM	ETF	140.78	140.85	139.1724	140.6219	609591.0
2017-09-11 19:00:00	IWM	ETF	140.73	140.85	140.73	140.85	4400.0
2017-09-11 04:00:00	DIA	ETF	218.8	219.5	218.8	219.5	900.0
2017-09-11 06:00:00	DIA	ETF	219.57	219.57	219.57	219.57	150.0
2017-09-11 07:00:00	DIA	ETF	219.57	219.57	219.41	219.41	800.0
2017-09-11 08:00:00	DIA	ETF	219.32	219.59	219.31	219.47	5292.0

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

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