PREVIEW / etf_1hour / 2016-06-28

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-06-28.parquet
  size:    266 KB
  rows:    8,565

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-28 04:00:00	SPY	ETF	200.88	201.35	200.88	201.05	87822.0
2016-06-28 05:00:00	SPY	ETF	201.07	201.25	201.0	201.22	34113.0
2016-06-28 06:00:00	SPY	ETF	201.22	201.28	200.98	201.01	147023.0
2016-06-28 07:00:00	SPY	ETF	201.01	201.06	200.79	201.03	620784.0
2016-06-28 08:00:00	SPY	ETF	201.03	201.65	199.81	201.48	1724046.0
2016-06-28 09:00:00	SPY	ETF	201.47	202.29	201.21	202.12	24989032.0
2016-06-28 10:00:00	SPY	ETF	202.13	202.3	201.51	201.61	23087724.0
2016-06-28 11:00:00	SPY	ETF	201.61	201.89	201.12	201.8135	17410279.0
2016-06-28 12:00:00	SPY	ETF	201.82	202.11	201.54	201.9198	11985726.0
2016-06-28 13:00:00	SPY	ETF	201.91	201.95	201.38	201.65	12254049.0
2016-06-28 14:00:00	SPY	ETF	201.65	202.97	201.35	202.75	18795769.0
2016-06-28 15:00:00	SPY	ETF	202.74	203.2	202.37	203.1725	35831169.0
2016-06-28 16:00:00	SPY	ETF	203.16	203.47	203.11	203.32	9093088.0
2016-06-28 17:00:00	SPY	ETF	203.3	204.3308	201.9191	203.3	1115249.0
2016-06-28 18:00:00	SPY	ETF	203.3	203.32	203.06	203.27	84348.0
2016-06-28 19:00:00	SPY	ETF	203.28	203.28	203.15	203.2	83515.0
2016-06-28 04:00:00	QQQ	ETF	103.09	103.3	103.06	103.06	116792.0
2016-06-28 05:00:00	QQQ	ETF	103.13	103.17	103.0	103.15	12884.0
2016-06-28 06:00:00	QQQ	ETF	103.16	103.19	103.04	103.04	19995.0
2016-06-28 07:00:00	QQQ	ETF	103.05	103.12	102.96	103.09	88593.0
2016-06-28 08:00:00	QQQ	ETF	103.07	103.36	102.96	103.31	262882.0
2016-06-28 09:00:00	QQQ	ETF	103.26	104.0963	103.21	104.03	5020249.0
2016-06-28 10:00:00	QQQ	ETF	104.03	104.08	103.74	103.8	3280558.0
2016-06-28 11:00:00	QQQ	ETF	103.81	103.8865	103.41	103.79	2702078.0
2016-06-28 12:00:00	QQQ	ETF	103.81	103.965	103.62	103.86	1529546.0
2016-06-28 13:00:00	QQQ	ETF	103.86	103.88	103.59	103.73	2382292.0
2016-06-28 14:00:00	QQQ	ETF	103.73	104.36	103.525	104.24	2793902.0
2016-06-28 15:00:00	QQQ	ETF	104.24	104.51	104.09	104.46	6583019.0
2016-06-28 16:00:00	QQQ	ETF	104.49	104.57	104.42	104.51	1420137.0
2016-06-28 17:00:00	QQQ	ETF	104.52	104.52	104.42	104.46	8755.0
2016-06-28 18:00:00	QQQ	ETF	104.45	104.49	104.39	104.49	140735.0
2016-06-28 19:00:00	QQQ	ETF	104.48	104.48	104.42	104.47	9943.0
2016-06-28 04:00:00	IWM	ETF	109.42	109.6	109.38	109.4	20804.0
2016-06-28 05:00:00	IWM	ETF	109.43	109.48	109.34	109.36	24608.0
2016-06-28 06:00:00	IWM	ETF	109.36	109.36	109.28	109.31	10772.0
2016-06-28 07:00:00	IWM	ETF	109.32	109.38	109.2	109.38	50295.0
2016-06-28 08:00:00	IWM	ETF	109.38	109.63	109.24	109.58	382561.0
2016-06-28 09:00:00	IWM	ETF	109.59	110.7499	109.41	110.65	5971689.0
2016-06-28 10:00:00	IWM	ETF	110.65	110.77	109.92	110.25	4957887.0
2016-06-28 11:00:00	IWM	ETF	110.25	110.43	109.78	110.28	3977444.0
2016-06-28 12:00:00	IWM	ETF	110.29	110.43	110.09	110.19	1800269.0
2016-06-28 13:00:00	IWM	ETF	110.18	110.23	109.8	110.0865	2614980.0
2016-06-28 14:00:00	IWM	ETF	110.08	110.85	109.9	110.6801	2425498.0
2016-06-28 15:00:00	IWM	ETF	110.68	110.88	110.12	110.41	8097916.0
2016-06-28 16:00:00	IWM	ETF	110.39	110.83	110.34	110.72	1604236.0
2016-06-28 17:00:00	IWM	ETF	110.75	110.75	110.7	110.7	7049.0
2016-06-28 18:00:00	IWM	ETF	110.71	110.71	110.55	110.62	3080.0
2016-06-28 19:00:00	IWM	ETF	110.56	110.58	110.46	110.58	4576.0
2016-06-28 05:00:00	DIA	ETF	172.5	172.58	172.5	172.55	800.0
2016-06-28 07:00:00	DIA	ETF	172.45	172.55	172.33	172.55	2800.0

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

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