PREVIEW / etf_1hour / 2015-12-15

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-12-15.parquet
  size:    250 KB
  rows:    7,965

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-12-15 04:00:00	SPY	ETF	203.76	204.2	203.76	204.11	161736.0
2015-12-15 05:00:00	SPY	ETF	204.15	204.27	203.72	204.11	100301.0
2015-12-15 06:00:00	SPY	ETF	204.12	204.32	203.92	204.19	161360.0
2015-12-15 07:00:00	SPY	ETF	204.13	204.23	203.8	203.91	346089.0
2015-12-15 08:00:00	SPY	ETF	203.91	204.89	202.818	204.8	2061575.0
2015-12-15 09:00:00	SPY	ETF	204.78	205.74	204.54	205.542	19464888.0
2015-12-15 10:00:00	SPY	ETF	205.55	205.64	204.915	205.16	21559939.0
2015-12-15 11:00:00	SPY	ETF	205.17	205.42	204.58	204.98	16777448.0
2015-12-15 12:00:00	SPY	ETF	204.98	206.11	204.89	206.0025	23091119.0
2015-12-15 13:00:00	SPY	ETF	206.01	206.08	205.24	205.81	13659357.0
2015-12-15 14:00:00	SPY	ETF	205.815	206.02	205.58	205.68	12047133.0
2015-12-15 15:00:00	SPY	ETF	205.69	205.72	202.8666	205.09	32983128.0
2015-12-15 16:00:00	SPY	ETF	205.08	205.41	202.8653	205.27	8707296.0
2015-12-15 17:00:00	SPY	ETF	205.3	205.36	205.3	205.3	1410224.0
2015-12-15 18:00:00	SPY	ETF	205.31	205.41	205.19	205.24	125170.0
2015-12-15 19:00:00	SPY	ETF	205.24	205.42	205.06	205.23	182256.0
2015-12-15 04:00:00	QQQ	ETF	111.83	112.38	111.83	112.37	28712.0
2015-12-15 05:00:00	QQQ	ETF	112.16	112.28	112.16	112.28	1200.0
2015-12-15 06:00:00	QQQ	ETF	112.3	112.3	112.22	112.25	14610.0
2015-12-15 07:00:00	QQQ	ETF	112.2	112.25	112.05	112.17	42962.0
2015-12-15 08:00:00	QQQ	ETF	112.1999	112.7	112.08	112.66	454241.0
2015-12-15 09:00:00	QQQ	ETF	112.67	113.23	112.39	113.1185	7702298.0
2015-12-15 10:00:00	QQQ	ETF	113.13	113.17	112.84	112.96	5824376.0
2015-12-15 11:00:00	QQQ	ETF	112.96	112.97	112.3401	112.55	4029469.0
2015-12-15 12:00:00	QQQ	ETF	112.54	113.28	112.5	113.2	5727104.0
2015-12-15 13:00:00	QQQ	ETF	113.21	113.25	112.73	113.06	3025353.0
2015-12-15 14:00:00	QQQ	ETF	113.05	113.14	112.805	112.855	2342901.0
2015-12-15 15:00:00	QQQ	ETF	112.86	112.87	112.17	112.31	5611675.0
2015-12-15 16:00:00	QQQ	ETF	112.31	112.55	112.17	112.51	774347.0
2015-12-15 17:00:00	QQQ	ETF	112.47	112.52	112.47	112.52	6752.0
2015-12-15 18:00:00	QQQ	ETF	112.54	112.57	112.48	112.57	10564.0
2015-12-15 19:00:00	QQQ	ETF	112.49	112.59	112.47	112.51	13100.0
2015-12-15 04:00:00	IWM	ETF	111.3	111.73	111.3	111.73	300.0
2015-12-15 05:00:00	IWM	ETF	111.65	111.65	111.65	111.65	100.0
2015-12-15 06:00:00	IWM	ETF	111.69	111.69	111.62	111.62	600.0
2015-12-15 07:00:00	IWM	ETF	111.72	111.72	111.53	111.56	14198.0
2015-12-15 08:00:00	IWM	ETF	111.56	111.81	111.37	111.78	693452.0
2015-12-15 09:00:00	IWM	ETF	111.79	112.66	111.6	112.65	8899846.0
2015-12-15 10:00:00	IWM	ETF	112.63	112.72	111.91	112.18	8183264.0
2015-12-15 11:00:00	IWM	ETF	112.17	112.34	111.77	112.12	3346964.0
2015-12-15 12:00:00	IWM	ETF	112.11	112.86	112.07	112.77	4013225.0
2015-12-15 13:00:00	IWM	ETF	112.78	112.9	112.43	112.86	3175421.0
2015-12-15 14:00:00	IWM	ETF	112.86	112.96	112.65	112.76	4024084.0
2015-12-15 15:00:00	IWM	ETF	112.77	112.8	112.28	112.71	8849711.0
2015-12-15 16:00:00	IWM	ETF	112.72	112.98	112.3	112.94	2686234.0
2015-12-15 17:00:00	IWM	ETF	112.94	112.94	112.76	112.81	2097.0
2015-12-15 18:00:00	IWM	ETF	112.8	112.8	112.62	112.62	7499.0
2015-12-15 19:00:00	IWM	ETF	112.85	112.9	112.73	112.9	1635.0
2015-12-15 04:00:00	DIA	ETF	174.69	174.69	174.69	174.69	100.0
2015-12-15 06:00:00	DIA	ETF	174.7	175.09	174.7	175.09	1760.0

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

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