PREVIEW / etf_1hour / 2015-11-16

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-11-16.parquet
  size:    244 KB
  rows:    7,759

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
2015-11-16 04:00:00	SPY	ETF	202.55	203.16	202.45	202.94	296477.0
2015-11-16 05:00:00	SPY	ETF	202.9	203.3	202.82	202.82	69856.0
2015-11-16 06:00:00	SPY	ETF	202.83	203.23	202.69	203.14	196345.0
2015-11-16 07:00:00	SPY	ETF	203.11	203.3	202.92	202.97	624921.0
2015-11-16 08:00:00	SPY	ETF	203.2	203.21	202.34	202.36	1562778.0
2015-11-16 09:00:00	SPY	ETF	202.36	203.76	202.04	203.15	20377720.0
2015-11-16 10:00:00	SPY	ETF	203.15	203.7	202.8	202.865	15708290.0
2015-11-16 11:00:00	SPY	ETF	202.85	203.42	202.66	203.23	10283225.0
2015-11-16 12:00:00	SPY	ETF	203.24	204.0	203.14	203.78	9098089.0
2015-11-16 13:00:00	SPY	ETF	203.79	204.48	203.7	204.47	9222975.0
2015-11-16 14:00:00	SPY	ETF	204.48	204.95	204.37	204.8	12395529.0
2015-11-16 15:00:00	SPY	ETF	204.8	205.64	204.795	205.6	23613686.0
2015-11-16 16:00:00	SPY	ETF	205.61	205.79	203.0728	205.58	9147695.0
2015-11-16 17:00:00	SPY	ETF	205.63	205.65	205.53	205.53	609662.0
2015-11-16 18:00:00	SPY	ETF	205.51	205.65	205.27	205.43	234963.0
2015-11-16 19:00:00	SPY	ETF	205.41	205.47	205.34	205.41	61812.0
2015-11-16 04:00:00	QQQ	ETF	109.99	110.22	109.89	110.19	4515.0
2015-11-16 05:00:00	QQQ	ETF	110.13	110.16	110.1	110.1	21215.0
2015-11-16 06:00:00	QQQ	ETF	110.07	110.2	110.0	110.2	14907.0
2015-11-16 07:00:00	QQQ	ETF	110.11	110.19	110.0	110.0	37323.0
2015-11-16 08:00:00	QQQ	ETF	110.17	110.18	109.67	109.71	240930.0
2015-11-16 09:00:00	QQQ	ETF	109.72	110.35	109.48	110.02	5175226.0
2015-11-16 10:00:00	QQQ	ETF	110.01	110.45	109.79	109.83	4457902.0
2015-11-16 11:00:00	QQQ	ETF	109.82	110.01	109.6	109.91	2653199.0
2015-11-16 12:00:00	QQQ	ETF	109.92	110.4	109.8676	110.33	3051293.0
2015-11-16 13:00:00	QQQ	ETF	110.33	110.839	110.27	110.83	2864501.0
2015-11-16 14:00:00	QQQ	ETF	110.83	111.16	110.7507	111.103	4365411.0
2015-11-16 15:00:00	QQQ	ETF	111.1099	111.44	111.1	111.39	6395804.0
2015-11-16 16:00:00	QQQ	ETF	111.39	111.48	111.3	111.42	3079701.0
2015-11-16 17:00:00	QQQ	ETF	111.42	111.46	111.41	111.44	34174.0
2015-11-16 18:00:00	QQQ	ETF	111.39	111.39	111.29	111.35	150568.0
2015-11-16 19:00:00	QQQ	ETF	111.35	111.41	111.32	111.35	88002.0
2015-11-16 04:00:00	IWM	ETF	114.07	114.07	114.07	114.07	100.0
2015-11-16 05:00:00	IWM	ETF	114.2	114.24	114.2	114.24	1000.0
2015-11-16 06:00:00	IWM	ETF	114.11	114.11	114.01	114.01	1100.0
2015-11-16 07:00:00	IWM	ETF	114.3	114.35	114.12	114.12	35898.0
2015-11-16 08:00:00	IWM	ETF	114.17	114.25	113.86	113.88	37831.0
2015-11-16 09:00:00	IWM	ETF	113.89	114.36	113.8	113.91	4044179.0
2015-11-16 10:00:00	IWM	ETF	113.91	114.23	113.51	113.6	4411009.0
2015-11-16 11:00:00	IWM	ETF	113.59	113.81	113.36	113.67	3022512.0
2015-11-16 12:00:00	IWM	ETF	113.67	114.21	113.65	113.98	2573590.0
2015-11-16 13:00:00	IWM	ETF	113.99	114.39	113.92	114.3899	2338209.0
2015-11-16 14:00:00	IWM	ETF	114.39	114.61	114.26	114.5956	3162700.0
2015-11-16 15:00:00	IWM	ETF	114.59	115.03	114.57	115.01	5942774.0
2015-11-16 16:00:00	IWM	ETF	115.01	115.09	114.079	114.85	962432.0
2015-11-16 17:00:00	IWM	ETF	114.8	114.8	114.76	114.76	6725.0
2015-11-16 18:00:00	IWM	ETF	114.76	114.85	114.76	114.85	3881.0
2015-11-16 19:00:00	IWM	ETF	114.75	114.79	114.74	114.79	500.0
2015-11-16 04:00:00	DIA	ETF	172.75	173.0	172.75	172.93	300.0
2015-11-16 05:00:00	DIA	ETF	173.0	173.0	172.95	172.95	200.0

> showing 50 of 7,759 rows — these rows as CSV

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