PREVIEW / etf_1hour / 2014-11-10

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-11-10.parquet
  size:    230 KB
  rows:    7,333

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-10 04:00:00	SPY	ETF	203.25	203.26	203.03	203.2	9419.0
2014-11-10 05:00:00	SPY	ETF	203.25	203.48	203.25	203.35	38384.0
2014-11-10 06:00:00	SPY	ETF	203.29	203.42	203.24	203.4	43590.0
2014-11-10 07:00:00	SPY	ETF	203.44	203.5	203.27	203.41	195040.0
2014-11-10 08:00:00	SPY	ETF	203.42	203.49	203.27	203.33	460521.0
2014-11-10 09:00:00	SPY	ETF	203.32	203.53	203.13	203.35	10147318.0
2014-11-10 10:00:00	SPY	ETF	203.34	203.93	203.17	203.84	12699872.0
2014-11-10 11:00:00	SPY	ETF	203.85	204.04	203.72	203.81	8600269.0
2014-11-10 12:00:00	SPY	ETF	203.815	203.8599	203.65	203.8	4912841.0
2014-11-10 13:00:00	SPY	ETF	203.79	203.93	203.59	203.6475	3777614.0
2014-11-10 14:00:00	SPY	ETF	203.65	203.88	203.61	203.87	3935333.0
2014-11-10 15:00:00	SPY	ETF	203.87	204.0	203.75	203.97	12984291.0
2014-11-10 16:00:00	SPY	ETF	203.96	204.04	203.333	203.98	6044284.0
2014-11-10 17:00:00	SPY	ETF	203.99	204.02	203.9	203.92	157873.0
2014-11-10 18:00:00	SPY	ETF	203.92	203.93	203.78	203.79	275946.0
2014-11-10 19:00:00	SPY	ETF	203.8	203.92	203.76	203.9	71659.0
2014-11-10 05:00:00	QQQ	ETF	101.66	101.71	101.57	101.57	11000.0
2014-11-10 06:00:00	QQQ	ETF	101.56	101.66	101.56	101.65	24633.0
2014-11-10 07:00:00	QQQ	ETF	101.65	101.72	101.65	101.71	146083.0
2014-11-10 08:00:00	QQQ	ETF	101.69	101.73	101.4	101.67	47506.0
2014-11-10 09:00:00	QQQ	ETF	101.65	101.7	101.38	101.505	2721294.0
2014-11-10 10:00:00	QQQ	ETF	101.51	102.0	101.49	101.92	3041144.0
2014-11-10 11:00:00	QQQ	ETF	101.93	102.09	101.88	101.965	2124804.0
2014-11-10 12:00:00	QQQ	ETF	101.97	101.9872	101.8	101.87	1387489.0
2014-11-10 13:00:00	QQQ	ETF	101.86	101.97	101.82	101.86	908031.0
2014-11-10 14:00:00	QQQ	ETF	101.86	102.01	101.85	101.965	1083372.0
2014-11-10 15:00:00	QQQ	ETF	101.97	102.03	101.85	101.96	2837438.0
2014-11-10 16:00:00	QQQ	ETF	101.96	102.0	101.55	101.92	1073690.0
2014-11-10 17:00:00	QQQ	ETF	101.93	101.97	101.9	101.9	36042.0
2014-11-10 18:00:00	QQQ	ETF	101.85	101.86	101.83	101.84	11599.0
2014-11-10 19:00:00	QQQ	ETF	101.9	101.9	101.85	101.86	5061.0
2014-11-10 04:00:00	IWM	ETF	116.54	116.54	116.54	116.54	500.0
2014-11-10 07:00:00	IWM	ETF	116.78	116.78	116.78	116.78	25200.0
2014-11-10 08:00:00	IWM	ETF	116.77	116.87	116.66	116.71	114008.0
2014-11-10 09:00:00	IWM	ETF	116.71	116.98	116.56	116.9	2877050.0
2014-11-10 10:00:00	IWM	ETF	116.9	117.27	116.55	117.15	4856695.0
2014-11-10 11:00:00	IWM	ETF	117.16	117.205	116.6932	116.765	2847025.0
2014-11-10 12:00:00	IWM	ETF	116.76	116.76	116.46	116.63	2011680.0
2014-11-10 13:00:00	IWM	ETF	116.63	116.81	116.54	116.64	1917986.0
2014-11-10 14:00:00	IWM	ETF	116.63	116.91	116.6	116.9	1846315.0
2014-11-10 15:00:00	IWM	ETF	116.9	117.29	116.9	117.29	6354823.0
2014-11-10 16:00:00	IWM	ETF	117.29	117.32	116.8532	117.22	2297123.0
2014-11-10 17:00:00	IWM	ETF	117.22	117.25	117.19	117.19	4557.0
2014-11-10 18:00:00	IWM	ETF	117.16	117.2	117.1	117.1	2600.0
2014-11-10 19:00:00	IWM	ETF	117.22	117.22	117.19	117.19	900.0
2014-11-10 07:00:00	DIA	ETF	175.61	175.61	175.61	175.61	100.0
2014-11-10 08:00:00	DIA	ETF	175.6	175.72	175.58	175.58	622.0
2014-11-10 09:00:00	DIA	ETF	175.61	175.63	175.33	175.4801	498054.0
2014-11-10 10:00:00	DIA	ETF	175.48	175.9	175.35	175.82	544020.0
2014-11-10 11:00:00	DIA	ETF	175.8261	176.02	175.747	175.86	393935.0

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

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