PREVIEW / etf_1hour / 2014-02-11

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-02-11.parquet
  size:    223 KB
  rows:    6,950

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-02-11 04:00:00	SPY	ETF	180.6	180.83	180.6	180.83	22993.0
2014-02-11 05:00:00	SPY	ETF	180.78	180.94	180.75	180.75	15275.0
2014-02-11 06:00:00	SPY	ETF	180.73	180.79	180.5	180.5	40776.0
2014-02-11 07:00:00	SPY	ETF	180.52	180.67	180.48	180.6	191676.0
2014-02-11 08:00:00	SPY	ETF	180.6	180.8	180.16	180.2	2920064.0
2014-02-11 09:00:00	SPY	ETF	180.18	180.73	180.03	180.48	12932362.0
2014-02-11 10:00:00	SPY	ETF	180.48	180.91	180.38	180.76	15632593.0
2014-02-11 11:00:00	SPY	ETF	180.76	181.51	180.74	181.48	18773545.0
2014-02-11 12:00:00	SPY	ETF	181.48	181.6	181.3	181.58	8744266.0
2014-02-11 13:00:00	SPY	ETF	181.58	182.01	181.58	181.809	12165946.0
2014-02-11 14:00:00	SPY	ETF	181.8	182.21	181.73	182.18	12029750.0
2014-02-11 15:00:00	SPY	ETF	182.18	182.439	181.88	181.95	24639287.0
2014-02-11 16:00:00	SPY	ETF	181.95	182.031	180.039	181.77	7200128.0
2014-02-11 17:00:00	SPY	ETF	181.77	181.97	181.77	181.9	222378.0
2014-02-11 18:00:00	SPY	ETF	181.87	181.9	181.68	181.82	133481.0
2014-02-11 19:00:00	SPY	ETF	181.81	181.84	181.71	181.71	102568.0
2014-02-11 04:00:00	QQQ	ETF	88.02	88.19	88.02	88.19	3999.0
2014-02-11 05:00:00	QQQ	ETF	88.17	88.25	88.16	88.18	28200.0
2014-02-11 06:00:00	QQQ	ETF	88.15	88.15	88.06	88.06	8800.0
2014-02-11 07:00:00	QQQ	ETF	88.06	88.14	88.06	88.1	18706.0
2014-02-11 08:00:00	QQQ	ETF	88.11	88.2	87.96	88.02	159005.0
2014-02-11 09:00:00	QQQ	ETF	88.0	88.2	87.89	88.11	4131661.0
2014-02-11 10:00:00	QQQ	ETF	88.11	88.34	88.03	88.2051	7741281.0
2014-02-11 11:00:00	QQQ	ETF	88.2	88.45	88.11	88.439	8297146.0
2014-02-11 12:00:00	QQQ	ETF	88.44	88.55	88.35	88.5499	1989974.0
2014-02-11 13:00:00	QQQ	ETF	88.55	88.79	88.55	88.63	3267382.0
2014-02-11 14:00:00	QQQ	ETF	88.63	88.86	88.619	88.84	2765010.0
2014-02-11 15:00:00	QQQ	ETF	88.845	88.97	88.71	88.79	7228162.0
2014-02-11 16:00:00	QQQ	ETF	88.8	88.8135	88.53	88.68	2000242.0
2014-02-11 17:00:00	QQQ	ETF	88.67	88.72	88.67	88.71	14309.0
2014-02-11 18:00:00	QQQ	ETF	88.68	88.69	88.6	88.67	28069.0
2014-02-11 19:00:00	QQQ	ETF	88.66	88.66	88.61	88.63	15326.0
2014-02-11 04:00:00	IWM	ETF	111.49	111.49	111.32	111.32	300.0
2014-02-11 06:00:00	IWM	ETF	111.27	111.35	111.27	111.35	250.0
2014-02-11 07:00:00	IWM	ETF	111.41	111.45	111.37	111.41	72583.0
2014-02-11 08:00:00	IWM	ETF	111.42	111.48	111.09	111.16	533605.0
2014-02-11 09:00:00	IWM	ETF	111.14	111.53	111.0	111.22	4383971.0
2014-02-11 10:00:00	IWM	ETF	111.22	111.47	110.87	111.08	5515253.0
2014-02-11 11:00:00	IWM	ETF	111.07	111.85	110.95	111.81	6415468.0
2014-02-11 12:00:00	IWM	ETF	111.82	112.08	111.75	112.04	3288728.0
2014-02-11 13:00:00	IWM	ETF	112.04	112.335	112.04	112.125	2880197.0
2014-02-11 14:00:00	IWM	ETF	112.12	112.33	112.06	112.27	2402172.0
2014-02-11 15:00:00	IWM	ETF	112.275	112.34	111.91	112.03	6459969.0
2014-02-11 16:00:00	IWM	ETF	112.04	112.29	111.0599	111.89	2052513.0
2014-02-11 17:00:00	IWM	ETF	111.95	111.96	111.95	111.96	2624.0
2014-02-11 18:00:00	IWM	ETF	111.93	111.97	111.85	111.94	5850.0
2014-02-11 08:00:00	DIA	ETF	158.2	158.35	158.04	158.04	5500.0
2014-02-11 09:00:00	DIA	ETF	158.01	158.55	157.87	158.35	866478.0
2014-02-11 10:00:00	DIA	ETF	158.34	158.75	158.23	158.62	1180250.0
2014-02-11 11:00:00	DIA	ETF	158.61	159.28	158.61	159.23	1165494.0

> showing 50 of 6,950 rows — these rows as CSV

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