PREVIEW / etf_1hour / 2013-02-28

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-02-28.parquet
  size:    202 KB
  rows:    6,310

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
2013-02-28 04:00:00	SPY	ETF	152.15	152.19	152.01	152.18	349541.0
2013-02-28 05:00:00	SPY	ETF	152.19	152.23	152.05	152.08	71520.0
2013-02-28 06:00:00	SPY	ETF	152.13	152.33	152.13	152.28	61780.0
2013-02-28 07:00:00	SPY	ETF	152.27	152.32	152.09	152.17	838840.0
2013-02-28 08:00:00	SPY	ETF	152.15	152.35	151.94	152.1	1240019.0
2013-02-28 09:00:00	SPY	ETF	152.08	152.48	151.75	152.24	16383664.0
2013-02-28 10:00:00	SPY	ETF	152.245	152.31	151.79	151.938	16123265.0
2013-02-28 11:00:00	SPY	ETF	151.94	152.3	151.84	152.1501	10173785.0
2013-02-28 12:00:00	SPY	ETF	152.151	152.39	152.09	152.29	6644834.0
2013-02-28 13:00:00	SPY	ETF	152.29	152.77	152.28	152.7	13374268.0
2013-02-28 14:00:00	SPY	ETF	152.69	152.87	152.46	152.5	12396775.0
2013-02-28 15:00:00	SPY	ETF	152.5	152.51	151.59	151.61	30313115.0
2013-02-28 16:00:00	SPY	ETF	151.6	151.9288	151.35	151.36	11306530.0
2013-02-28 17:00:00	SPY	ETF	151.37	151.68	151.34	151.64	3008737.0
2013-02-28 18:00:00	SPY	ETF	151.67	151.68	151.2	151.35	165652.0
2013-02-28 19:00:00	SPY	ETF	151.39	151.55	151.32	151.35	81510.0
2013-02-28 04:00:00	QQQ	ETF	67.3	67.32	67.3	67.32	200.0
2013-02-28 06:00:00	QQQ	ETF	67.37	67.37	67.37	67.37	300.0
2013-02-28 07:00:00	QQQ	ETF	67.39	67.39	67.28	67.29	684200.0
2013-02-28 08:00:00	QQQ	ETF	67.28	67.36	67.24	67.34	908568.0
2013-02-28 09:00:00	QQQ	ETF	67.35	67.63	67.22	67.53	5489697.0
2013-02-28 10:00:00	QQQ	ETF	67.53	67.69	67.32	67.39	3855658.0
2013-02-28 11:00:00	QQQ	ETF	67.39	67.55	67.34	67.46	2109906.0
2013-02-28 12:00:00	QQQ	ETF	67.46	67.56	67.43	67.5	1412686.0
2013-02-28 13:00:00	QQQ	ETF	67.5	67.69	67.4799	67.65	2189935.0
2013-02-28 14:00:00	QQQ	ETF	67.65	67.74	67.53	67.55	2297249.0
2013-02-28 15:00:00	QQQ	ETF	67.55	67.56	67.14	67.15	5429412.0
2013-02-28 16:00:00	QQQ	ETF	67.15	67.45	67.07	67.07	2778355.0
2013-02-28 17:00:00	QQQ	ETF	67.06	67.17	67.06	67.11	12200.0
2013-02-28 18:00:00	QQQ	ETF	67.17	67.17	66.97	67.01	31600.0
2013-02-28 19:00:00	QQQ	ETF	67.03	67.11	67.03	67.03	30649.0
2013-02-28 05:00:00	IWM	ETF	90.65	90.65	90.65	90.65	100.0
2013-02-28 07:00:00	IWM	ETF	90.65	90.65	90.54	90.55	29300.0
2013-02-28 08:00:00	IWM	ETF	90.53	90.7	90.36	90.5	924780.0
2013-02-28 09:00:00	IWM	ETF	90.45	90.74	90.18	90.65	5270192.0
2013-02-28 10:00:00	IWM	ETF	90.65	90.75	90.32	90.37	3859453.0
2013-02-28 11:00:00	IWM	ETF	90.36	90.7	90.32	90.56	2906625.0
2013-02-28 12:00:00	IWM	ETF	90.56	90.84	90.5	90.68	1762068.0
2013-02-28 13:00:00	IWM	ETF	90.685	91.02	90.685	90.905	2515729.0
2013-02-28 14:00:00	IWM	ETF	90.91	91.05	90.82	90.9	2552674.0
2013-02-28 15:00:00	IWM	ETF	90.9	90.9	90.44	90.46	8338972.0
2013-02-28 16:00:00	IWM	ETF	90.45	90.48	90.2	90.2	1617922.0
2013-02-28 17:00:00	IWM	ETF	90.19	90.36	90.18	90.36	46300.0
2013-02-28 18:00:00	IWM	ETF	90.32	90.32	90.16	90.2	8310.0
2013-02-28 19:00:00	IWM	ETF	90.3	90.32	90.27	90.32	3109.0
2013-02-28 04:00:00	DIA	ETF	140.65	140.65	140.6	140.6	600.0
2013-02-28 06:00:00	DIA	ETF	140.7	140.7	140.7	140.7	100.0
2013-02-28 07:00:00	DIA	ETF	140.74	140.74	140.63	140.63	5200.0
2013-02-28 08:00:00	DIA	ETF	140.68	140.68	140.5	140.56	65660.0
2013-02-28 09:00:00	DIA	ETF	140.52	140.87	140.3	140.68	1225691.0

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

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