PREVIEW / etf_1hour / 2012-04-18

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-04-18.parquet
  size:    178 KB
  rows:    5,530

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
2012-04-18 04:00:00	SPY	ETF	138.97	139.1	138.8	138.8	15818.0
2012-04-18 05:00:00	SPY	ETF	138.73	138.86	138.7	138.8	7900.0
2012-04-18 06:00:00	SPY	ETF	138.77	138.78	138.49	138.49	58392.0
2012-04-18 07:00:00	SPY	ETF	138.53	138.59	138.34	138.54	519985.0
2012-04-18 08:00:00	SPY	ETF	138.55	138.71	138.29	138.44	1438400.0
2012-04-18 09:00:00	SPY	ETF	138.43	138.9	138.38	138.86	16641955.0
2012-04-18 10:00:00	SPY	ETF	138.86	139.06	138.65	138.945	26621090.0
2012-04-18 11:00:00	SPY	ETF	138.945	138.98	138.42	138.77	22989784.0
2012-04-18 12:00:00	SPY	ETF	138.765	138.8	138.59	138.6789	7456078.0
2012-04-18 13:00:00	SPY	ETF	138.67	138.79	138.38	138.44	7534506.0
2012-04-18 14:00:00	SPY	ETF	138.44	138.91	138.39	138.87	10491179.0
2012-04-18 15:00:00	SPY	ETF	138.88	139.08	138.55	138.62	21687379.0
2012-04-18 16:00:00	SPY	ETF	138.62	138.8637	138.3	138.49	6329158.0
2012-04-18 17:00:00	SPY	ETF	138.5	138.55	138.45	138.52	162861.0
2012-04-18 18:00:00	SPY	ETF	138.52	138.52	138.45	138.49	30071.0
2012-04-18 19:00:00	SPY	ETF	138.48	138.53	138.42	138.47	109477.0
2012-04-18 06:00:00	QQQ	ETF	66.51	66.51	66.5	66.5	4600.0
2012-04-18 07:00:00	QQQ	ETF	66.48	66.5	66.36	66.49	151710.0
2012-04-18 08:00:00	QQQ	ETF	66.49	66.63	66.45	66.55	448680.0
2012-04-18 09:00:00	QQQ	ETF	66.54	66.86	66.5	66.8577	6130269.0
2012-04-18 10:00:00	QQQ	ETF	66.85	66.92	66.685	66.85	7482104.0
2012-04-18 11:00:00	QQQ	ETF	66.85	66.87	66.41	66.65	7277485.0
2012-04-18 12:00:00	QQQ	ETF	66.65	66.68	66.52	66.62	2371574.0
2012-04-18 13:00:00	QQQ	ETF	66.62	66.6999	66.46	66.49	2912266.0
2012-04-18 14:00:00	QQQ	ETF	66.49	66.91	66.46	66.895	3465436.0
2012-04-18 15:00:00	QQQ	ETF	66.89	67.0	66.6	66.61	7410438.0
2012-04-18 16:00:00	QQQ	ETF	66.61	66.8527	66.17	66.44	3558633.0
2012-04-18 17:00:00	QQQ	ETF	66.44	66.5	66.44	66.5	247945.0
2012-04-18 18:00:00	QQQ	ETF	66.48	66.49	66.43	66.48	43650.0
2012-04-18 19:00:00	QQQ	ETF	66.48	66.48	66.38	66.39	13480.0
2012-04-18 04:00:00	IWM	ETF	80.79	80.79	80.79	80.79	3000.0
2012-04-18 06:00:00	IWM	ETF	80.63	80.63	80.4	80.4	1100.0
2012-04-18 07:00:00	IWM	ETF	80.35	80.44	80.24	80.39	61765.0
2012-04-18 08:00:00	IWM	ETF	80.4	80.5	80.25	80.38	219534.0
2012-04-18 09:00:00	IWM	ETF	80.36	80.65	80.15	80.62	5030040.0
2012-04-18 10:00:00	IWM	ETF	80.63	80.668	80.16	80.47	6794338.0
2012-04-18 11:00:00	IWM	ETF	80.48	80.5	79.97	80.26	8383622.0
2012-04-18 12:00:00	IWM	ETF	80.26	80.261	79.99	80.16	2228397.0
2012-04-18 13:00:00	IWM	ETF	80.16	80.22	79.83	79.9	3451705.0
2012-04-18 14:00:00	IWM	ETF	79.9	80.38	79.85	80.315	3659604.0
2012-04-18 15:00:00	IWM	ETF	80.305	80.52	80.15	80.22	6956380.0
2012-04-18 16:00:00	IWM	ETF	80.22	80.9232	79.93	80.03	3407347.0
2012-04-18 17:00:00	IWM	ETF	80.03	80.05	80.01	80.03	33100.0
2012-04-18 18:00:00	IWM	ETF	80.17	80.17	79.99	79.99	800.0
2012-04-18 19:00:00	IWM	ETF	79.99	80.09	79.99	80.0	1500.0
2012-04-18 05:00:00	DIA	ETF	130.67	130.68	130.67	130.68	1000.0
2012-04-18 06:00:00	DIA	ETF	130.61	130.61	130.51	130.51	400.0
2012-04-18 07:00:00	DIA	ETF	130.41	130.41	130.29	130.39	16000.0
2012-04-18 08:00:00	DIA	ETF	130.38	130.47	130.19	130.31	103901.0
2012-04-18 09:00:00	DIA	ETF	130.27	130.56	130.1302	130.5	911752.0

> showing 50 of 5,530 rows — these rows as CSV

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