PREVIEW / etf_1hour / 2017-02-14

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-02-14.parquet
  size:    277 KB
  rows:    8,901

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-02-14 04:00:00	SPY	ETF	232.75	232.75	232.57	232.64	8950.0
2017-02-14 05:00:00	SPY	ETF	232.59	232.6	232.59	232.59	1303.0
2017-02-14 06:00:00	SPY	ETF	232.77	232.8	232.64	232.8	6791.0
2017-02-14 07:00:00	SPY	ETF	232.76	232.83	232.75	232.77	65058.0
2017-02-14 08:00:00	SPY	ETF	232.79	232.92	232.5	232.71	252748.0
2017-02-14 09:00:00	SPY	ETF	232.71	232.79	232.4	232.47	6208758.0
2017-02-14 10:00:00	SPY	ETF	232.47	232.66	232.17	232.49	9500493.0
2017-02-14 11:00:00	SPY	ETF	232.49	232.82	232.16	232.77	7003418.0
2017-02-14 12:00:00	SPY	ETF	232.76	233.23	232.71	233.175	5961216.0
2017-02-14 13:00:00	SPY	ETF	233.17	233.53	233.14	233.46	8024893.0
2017-02-14 14:00:00	SPY	ETF	233.46	233.67	233.29	233.345	10591981.0
2017-02-14 15:00:00	SPY	ETF	233.3465	233.71	233.33	233.71	14907806.0
2017-02-14 16:00:00	SPY	ETF	233.7	233.94	233.64	233.74	5723676.0
2017-02-14 17:00:00	SPY	ETF	233.74	233.85	232.7772	233.72	1518820.0
2017-02-14 18:00:00	SPY	ETF	233.72	233.74	233.66	233.66	78775.0
2017-02-14 19:00:00	SPY	ETF	233.67	233.72	233.65	233.72	42993.0
2017-02-14 04:00:00	QQQ	ETF	128.12	128.12	128.12	128.12	350.0
2017-02-14 05:00:00	QQQ	ETF	128.14	128.14	128.1	128.11	3349.0
2017-02-14 06:00:00	QQQ	ETF	128.24	128.24	128.16	128.16	11483.0
2017-02-14 07:00:00	QQQ	ETF	128.2	128.21	128.2	128.2	15324.0
2017-02-14 08:00:00	QQQ	ETF	128.16	128.21	128.11	128.14	39259.0
2017-02-14 09:00:00	QQQ	ETF	128.12	128.16	127.96	128.078	2920145.0
2017-02-14 10:00:00	QQQ	ETF	128.07	128.135	127.74	127.91	2228559.0
2017-02-14 11:00:00	QQQ	ETF	127.91	128.19	127.7628	128.14	1212475.0
2017-02-14 12:00:00	QQQ	ETF	128.15	128.369	128.12	128.34	1171840.0
2017-02-14 13:00:00	QQQ	ETF	128.34	128.48	128.31	128.45	2012237.0
2017-02-14 14:00:00	QQQ	ETF	128.45	128.53	128.31	128.345	2080276.0
2017-02-14 15:00:00	QQQ	ETF	128.345	128.535	128.31	128.53	3001969.0
2017-02-14 16:00:00	QQQ	ETF	128.53	128.65	128.49	128.56	519388.0
2017-02-14 17:00:00	QQQ	ETF	128.59	128.62	128.57	128.62	4429.0
2017-02-14 18:00:00	QQQ	ETF	128.58	128.58	128.52	128.53	7477.0
2017-02-14 19:00:00	QQQ	ETF	128.54	128.55	128.52	128.52	77749.0
2017-02-14 04:00:00	IWM	ETF	138.34	138.34	138.04	138.04	250.0
2017-02-14 05:00:00	IWM	ETF	137.95	137.95	137.95	137.95	100.0
2017-02-14 07:00:00	IWM	ETF	138.09	138.14	138.04	138.09	29880.0
2017-02-14 08:00:00	IWM	ETF	138.08	138.22	137.98	138.04	18857.0
2017-02-14 09:00:00	IWM	ETF	137.95	138.018	137.61	137.85	4466542.0
2017-02-14 10:00:00	IWM	ETF	137.845	138.47	137.79	138.25	5076840.0
2017-02-14 11:00:00	IWM	ETF	138.24	138.54	137.98	138.37	2636358.0
2017-02-14 12:00:00	IWM	ETF	138.3857	138.61	138.28	138.53	1403912.0
2017-02-14 13:00:00	IWM	ETF	138.54	138.79	138.49	138.65	1698610.0
2017-02-14 14:00:00	IWM	ETF	138.65	138.79	138.43	138.49	1886300.0
2017-02-14 15:00:00	IWM	ETF	138.49	138.945	138.45	138.8	4897703.0
2017-02-14 16:00:00	IWM	ETF	138.8	139.09	138.74	138.94	2079636.0
2017-02-14 17:00:00	IWM	ETF	138.94	139.04	138.94	138.98	3060.0
2017-02-14 18:00:00	IWM	ETF	138.92	138.96	138.76	138.96	189764.0
2017-02-14 19:00:00	IWM	ETF	138.94	138.94	138.87	138.87	2062.0
2017-02-14 07:00:00	DIA	ETF	204.3	204.31	203.9	203.9	100300.0
2017-02-14 08:00:00	DIA	ETF	203.8	204.38	203.8	204.28	300200.0
2017-02-14 09:00:00	DIA	ETF	204.2	204.36	204.025	204.12	339338.0

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

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