PREVIEW / etf_1hour / 2016-06-23

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-06-23.parquet
  size:    257 KB
  rows:    8,323

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
2016-06-23 04:00:00	SPY	ETF	209.06	209.37	209.05	209.33	10182.0
2016-06-23 05:00:00	SPY	ETF	209.35	210.55	209.35	210.07	140137.0
2016-06-23 06:00:00	SPY	ETF	210.11	210.36	210.0	210.02	72577.0
2016-06-23 07:00:00	SPY	ETF	210.08	210.17	209.73	209.73	650387.0
2016-06-23 08:00:00	SPY	ETF	209.74	210.13	209.74	210.04	827298.0
2016-06-23 09:00:00	SPY	ETF	210.05	210.06	209.27	209.585	10089112.0
2016-06-23 10:00:00	SPY	ETF	209.585	209.93	209.38	209.75	12005341.0
2016-06-23 11:00:00	SPY	ETF	209.75	210.28	209.74	210.18	14298914.0
2016-06-23 12:00:00	SPY	ETF	210.19	210.31	209.87	210.03	7491198.0
2016-06-23 13:00:00	SPY	ETF	210.02	210.16	209.8	209.935	9545394.0
2016-06-23 14:00:00	SPY	ETF	209.94	210.26	209.8	210.17	7435236.0
2016-06-23 15:00:00	SPY	ETF	210.17	210.85	209.96	210.83	23927056.0
2016-06-23 16:00:00	SPY	ETF	210.82	211.64	209.3694	211.63	9408282.0
2016-06-23 17:00:00	SPY	ETF	211.63	212.0	211.39	212.0	1037204.0
2016-06-23 18:00:00	SPY	ETF	211.99	212.25	210.81	211.35	1176069.0
2016-06-23 19:00:00	SPY	ETF	211.35	211.35	209.21	210.11	1573337.0
2016-06-23 04:00:00	QQQ	ETF	107.71	107.88	107.71	107.88	2600.0
2016-06-23 05:00:00	QQQ	ETF	108.05	108.62	108.05	108.3	3209.0
2016-06-23 06:00:00	QQQ	ETF	108.46	108.51	108.26	108.3	7045.0
2016-06-23 07:00:00	QQQ	ETF	108.28	108.37	108.12	108.12	157914.0
2016-06-23 08:00:00	QQQ	ETF	108.13	108.28	108.13	108.28	110887.0
2016-06-23 09:00:00	QQQ	ETF	108.29	108.29	107.62	107.8799	2760902.0
2016-06-23 10:00:00	QQQ	ETF	107.88	108.25	107.83	108.19	2507055.0
2016-06-23 11:00:00	QQQ	ETF	108.19	108.4299	108.19	108.37	2231043.0
2016-06-23 12:00:00	QQQ	ETF	108.375	108.47	108.24	108.33	1336718.0
2016-06-23 13:00:00	QQQ	ETF	108.3336	108.44	108.21	108.27	1023166.0
2016-06-23 14:00:00	QQQ	ETF	108.2705	108.4499	108.21	108.38	1280459.0
2016-06-23 15:00:00	QQQ	ETF	108.38	108.79	108.24	108.76	5682595.0
2016-06-23 16:00:00	QQQ	ETF	108.78	109.24	108.7	109.24	827882.0
2016-06-23 17:00:00	QQQ	ETF	109.1	109.29	109.05	109.29	115621.0
2016-06-23 18:00:00	QQQ	ETF	109.26	109.64	109.12	109.12	73246.0
2016-06-23 19:00:00	QQQ	ETF	109.12	109.15	108.16	108.69	67942.0
2016-06-23 04:00:00	IWM	ETF	115.22	115.5	115.22	115.5	600.0
2016-06-23 05:00:00	IWM	ETF	115.6	116.24	115.6	116.1	13349.0
2016-06-23 06:00:00	IWM	ETF	116.14	116.2	115.5	116.14	2250.0
2016-06-23 07:00:00	IWM	ETF	116.11	116.2	115.91	115.91	187627.0
2016-06-23 08:00:00	IWM	ETF	115.98	116.15	115.87	116.01	51521.0
2016-06-23 09:00:00	IWM	ETF	115.95	116.195	115.73	115.97	3115288.0
2016-06-23 10:00:00	IWM	ETF	115.98	116.31	115.8	116.02	2817573.0
2016-06-23 11:00:00	IWM	ETF	116.02	116.66	116.01	116.56	2983990.0
2016-06-23 12:00:00	IWM	ETF	116.565	116.71	116.33	116.42	2075991.0
2016-06-23 13:00:00	IWM	ETF	116.42	116.4899	116.18	116.295	1140177.0
2016-06-23 14:00:00	IWM	ETF	116.3	116.61	116.22	116.52	1592234.0
2016-06-23 15:00:00	IWM	ETF	116.53	116.91	116.4	116.87	5547938.0
2016-06-23 16:00:00	IWM	ETF	116.85	117.49	116.1673	117.49	2668079.0
2016-06-23 17:00:00	IWM	ETF	117.51	117.84	117.47	117.8	354618.0
2016-06-23 18:00:00	IWM	ETF	117.8	117.8	117.68	117.8	21736.0
2016-06-23 19:00:00	IWM	ETF	117.5	117.6	116.67	116.76	33884.0
2016-06-23 05:00:00	DIA	ETF	178.56	179.4	178.56	179.03	630.0
2016-06-23 06:00:00	DIA	ETF	179.32	179.36	179.2	179.2	700.0

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

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