PREVIEW / etf_1hour / 2015-11-20

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-11-20.parquet
  size:    243 KB
  rows:    7,701

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-20 04:00:00	SPY	ETF	208.75	208.9	208.52	208.85	20156.0
2015-11-20 05:00:00	SPY	ETF	208.73	209.02	208.73	209.02	13690.0
2015-11-20 06:00:00	SPY	ETF	209.05	209.08	208.95	209.02	26066.0
2015-11-20 07:00:00	SPY	ETF	209.0	209.25	209.0	209.24	258133.0
2015-11-20 08:00:00	SPY	ETF	209.06	209.39	209.03	209.33	602379.0
2015-11-20 09:00:00	SPY	ETF	209.35	210.02	209.11	209.93	17129966.0
2015-11-20 10:00:00	SPY	ETF	209.93	210.12	209.55	209.61	14887646.0
2015-11-20 11:00:00	SPY	ETF	209.61	209.85	209.44	209.495	10886162.0
2015-11-20 12:00:00	SPY	ETF	209.495	209.65	209.31	209.505	7069534.0
2015-11-20 13:00:00	SPY	ETF	209.505	209.69	209.19	209.325	6759716.0
2015-11-20 14:00:00	SPY	ETF	209.33	209.47	209.01	209.03	7311496.0
2015-11-20 15:00:00	SPY	ETF	209.03	209.4	208.86	209.35	19219583.0
2015-11-20 16:00:00	SPY	ETF	209.34	209.58	209.3004	209.58	7771484.0
2015-11-20 17:00:00	SPY	ETF	209.57	209.59	209.35	209.35	1067007.0
2015-11-20 18:00:00	SPY	ETF	209.35	209.49	209.35	209.48	7407.0
2015-11-20 19:00:00	SPY	ETF	209.48	209.52	209.42	209.5	10742.0
2015-11-20 04:00:00	QQQ	ETF	113.84	113.84	113.84	113.84	200.0
2015-11-20 06:00:00	QQQ	ETF	114.05	114.05	114.02	114.03	2350.0
2015-11-20 07:00:00	QQQ	ETF	114.04	114.1	114.04	114.1	84758.0
2015-11-20 08:00:00	QQQ	ETF	114.1	114.15	114.04	114.15	158496.0
2015-11-20 09:00:00	QQQ	ETF	114.15	114.5977	114.04	114.4	4267892.0
2015-11-20 10:00:00	QQQ	ETF	114.4	114.57	114.25	114.29	3274272.0
2015-11-20 11:00:00	QQQ	ETF	114.28	114.54	114.25	114.28	1970053.0
2015-11-20 12:00:00	QQQ	ETF	114.28	114.46	114.2	114.4	1459178.0
2015-11-20 13:00:00	QQQ	ETF	114.4	114.52	114.27	114.35	1303060.0
2015-11-20 14:00:00	QQQ	ETF	114.35	114.44	114.22	114.23	1686428.0
2015-11-20 15:00:00	QQQ	ETF	114.24	114.45	114.14	114.45	5294657.0
2015-11-20 16:00:00	QQQ	ETF	114.44	114.54	114.44	114.53	901269.0
2015-11-20 17:00:00	QQQ	ETF	114.52	114.56	114.49	114.54	1096112.0
2015-11-20 18:00:00	QQQ	ETF	114.54	114.57	114.52	114.57	4180.0
2015-11-20 19:00:00	QQQ	ETF	114.55	114.55	114.49	114.49	5871.0
2015-11-20 07:00:00	IWM	ETF	116.37	116.37	116.24	116.31	77600.0
2015-11-20 08:00:00	IWM	ETF	116.26	116.32	116.22	116.26	103179.0
2015-11-20 09:00:00	IWM	ETF	116.27	116.98	116.17	116.87	5439283.0
2015-11-20 10:00:00	IWM	ETF	116.88	117.32	116.66	117.05	4632119.0
2015-11-20 11:00:00	IWM	ETF	117.05	117.36	117.015	117.03	3094985.0
2015-11-20 12:00:00	IWM	ETF	117.03	117.12	116.8	117.06	2127915.0
2015-11-20 13:00:00	IWM	ETF	117.06	117.25	116.79	116.95	2535340.0
2015-11-20 14:00:00	IWM	ETF	116.945	117.17	116.78	116.79	2115838.0
2015-11-20 15:00:00	IWM	ETF	116.79	117.0	116.72	116.81	4939703.0
2015-11-20 16:00:00	IWM	ETF	116.82	116.9	116.75	116.85	1405685.0
2015-11-20 17:00:00	IWM	ETF	116.86	116.86	116.85	116.85	231700.0
2015-11-20 19:00:00	IWM	ETF	116.85	116.85	116.85	116.85	100.0
2015-11-20 07:00:00	DIA	ETF	177.83	177.83	177.83	177.83	100.0
2015-11-20 08:00:00	DIA	ETF	177.9	177.98	177.9	177.98	2000.0
2015-11-20 09:00:00	DIA	ETF	177.98	178.7	177.9	178.6299	1353522.0
2015-11-20 10:00:00	DIA	ETF	178.64	178.97	178.35	178.39	3640769.0
2015-11-20 11:00:00	DIA	ETF	178.38	178.57	178.14	178.2	366700.0
2015-11-20 12:00:00	DIA	ETF	178.19	178.29	178.06	178.15	235280.0
2015-11-20 13:00:00	DIA	ETF	178.1405	178.27	177.84	177.99	444536.0

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

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