PREVIEW / etf_1hour / 2014-11-07

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-11-07.parquet
  size:    229 KB
  rows:    7,228

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
2014-11-07 04:00:00	SPY	ETF	203.41	203.72	203.41	203.61	14235.0
2014-11-07 05:00:00	SPY	ETF	203.67	203.67	203.17	203.3	143942.0
2014-11-07 06:00:00	SPY	ETF	203.27	203.37	203.17	203.37	26924.0
2014-11-07 07:00:00	SPY	ETF	203.37	203.48	203.22	203.33	204553.0
2014-11-07 08:00:00	SPY	ETF	203.36	203.85	203.15	203.48	2821412.0
2014-11-07 09:00:00	SPY	ETF	203.5	203.5	202.65	202.9	12077268.0
2014-11-07 10:00:00	SPY	ETF	202.9	203.4	202.61	203.34	13039106.0
2014-11-07 11:00:00	SPY	ETF	203.35	203.5999	203.27	203.31	8241582.0
2014-11-07 12:00:00	SPY	ETF	203.32	203.49	203.21	203.3466	6231020.0
2014-11-07 13:00:00	SPY	ETF	203.35	203.53	203.28	203.37	6543593.0
2014-11-07 14:00:00	SPY	ETF	203.38	203.44	202.95	203.02	8742390.0
2014-11-07 15:00:00	SPY	ETF	203.02	203.38	202.76	203.37	17850568.0
2014-11-07 16:00:00	SPY	ETF	203.37	203.4	203.03	203.13	7646806.0
2014-11-07 17:00:00	SPY	ETF	203.15	203.17	203.08	203.14	332947.0
2014-11-07 18:00:00	SPY	ETF	203.14	203.15	203.06	203.14	46700.0
2014-11-07 19:00:00	SPY	ETF	203.14	203.17	203.13	203.16	18985.0
2014-11-07 04:00:00	QQQ	ETF	101.85	102.07	101.85	102.06	500.0
2014-11-07 07:00:00	QQQ	ETF	101.88	101.97	101.83	101.87	28270.0
2014-11-07 08:00:00	QQQ	ETF	101.9	102.11	101.69	101.95	378460.0
2014-11-07 09:00:00	QQQ	ETF	101.91	101.91	101.4098	101.51	4792903.0
2014-11-07 10:00:00	QQQ	ETF	101.5	101.54	101.07	101.47	3795520.0
2014-11-07 11:00:00	QQQ	ETF	101.47	101.61	101.365	101.43	1618613.0
2014-11-07 12:00:00	QQQ	ETF	101.44	101.55	101.395	101.504	1137315.0
2014-11-07 13:00:00	QQQ	ETF	101.51	101.73	101.47	101.63	1383869.0
2014-11-07 14:00:00	QQQ	ETF	101.64	101.66	101.385	101.4166	1193885.0
2014-11-07 15:00:00	QQQ	ETF	101.42	101.6	101.3	101.59	2670642.0
2014-11-07 16:00:00	QQQ	ETF	101.6	101.6762	101.4	101.46	1396472.0
2014-11-07 17:00:00	QQQ	ETF	101.45	101.45	101.44	101.45	12240.0
2014-11-07 18:00:00	QQQ	ETF	101.51	101.51	101.5	101.5	600.0
2014-11-07 19:00:00	QQQ	ETF	101.47	101.55	101.47	101.55	3100.0
2014-11-07 04:00:00	IWM	ETF	116.9	116.95	116.9	116.95	200.0
2014-11-07 07:00:00	IWM	ETF	116.85	116.85	116.65	116.74	35750.0
2014-11-07 08:00:00	IWM	ETF	116.71	116.98	116.55	116.67	310733.0
2014-11-07 09:00:00	IWM	ETF	116.64	116.67	115.8	115.91	5131250.0
2014-11-07 10:00:00	IWM	ETF	115.89	116.29	115.7	116.29	4428234.0
2014-11-07 11:00:00	IWM	ETF	116.28	116.49	116.17	116.38	1862354.0
2014-11-07 12:00:00	IWM	ETF	116.37	116.5	116.33	116.3845	1141845.0
2014-11-07 13:00:00	IWM	ETF	116.38	116.58	116.35	116.45	1648283.0
2014-11-07 14:00:00	IWM	ETF	116.45	116.52	116.25	116.29	1951328.0
2014-11-07 15:00:00	IWM	ETF	116.29	116.7	116.18	116.7	5037904.0
2014-11-07 16:00:00	IWM	ETF	116.69	116.74	116.45	116.45	991031.0
2014-11-07 17:00:00	IWM	ETF	116.45	116.59	116.36	116.36	11746.0
2014-11-07 18:00:00	IWM	ETF	116.54	116.54	116.54	116.54	100.0
2014-11-07 08:00:00	DIA	ETF	175.7	175.83	175.54	175.54	4150.0
2014-11-07 09:00:00	DIA	ETF	175.54	175.54	174.77	174.97	1008238.0
2014-11-07 10:00:00	DIA	ETF	174.94	175.36	174.81	175.31	731494.0
2014-11-07 11:00:00	DIA	ETF	175.32	175.51	175.24	175.34	422558.0
2014-11-07 12:00:00	DIA	ETF	175.35	175.53	175.27	175.46	208194.0
2014-11-07 13:00:00	DIA	ETF	175.45	175.6	175.42	175.49	240078.0
2014-11-07 14:00:00	DIA	ETF	175.49	175.57	175.22	175.2643	272803.0

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

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