PREVIEW / etf_1hour / 2013-02-27

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-02-27.parquet
  size:    198 KB
  rows:    6,092

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-27 04:00:00	SPY	ETF	149.68	149.7	149.47	149.64	31102.0
2013-02-27 05:00:00	SPY	ETF	149.64	149.79	149.61	149.63	38880.0
2013-02-27 06:00:00	SPY	ETF	149.68	149.84	149.66	149.84	45880.0
2013-02-27 07:00:00	SPY	ETF	149.83	150.1	149.8	150.08	216932.0
2013-02-27 08:00:00	SPY	ETF	150.08	150.08	149.63	149.75	1561830.0
2013-02-27 09:00:00	SPY	ETF	149.73	150.47	149.69	150.35	14041052.0
2013-02-27 10:00:00	SPY	ETF	150.37	151.08	150.32	150.85	19717124.0
2013-02-27 11:00:00	SPY	ETF	150.85	151.36	150.84	151.25	18570006.0
2013-02-27 12:00:00	SPY	ETF	151.245	151.76	151.22	151.5801	16892482.0
2013-02-27 13:00:00	SPY	ETF	151.58	151.72	151.44	151.6	8259352.0
2013-02-27 14:00:00	SPY	ETF	151.601	152.12	151.57	152.09	14282193.0
2013-02-27 15:00:00	SPY	ETF	152.099	152.33	151.88	151.91	28938353.0
2013-02-27 16:00:00	SPY	ETF	151.91	152.1	150.004	152.07	19575072.0
2013-02-27 17:00:00	SPY	ETF	152.05	152.08	151.97	152.02	2134395.0
2013-02-27 18:00:00	SPY	ETF	152.02	152.09	151.95	152.04	98752.0
2013-02-27 19:00:00	SPY	ETF	152.04	152.08	151.95	152.08	95553.0
2013-02-27 04:00:00	QQQ	ETF	66.39	66.39	66.37	66.37	400.0
2013-02-27 05:00:00	QQQ	ETF	66.36	66.36	66.36	66.36	200.0
2013-02-27 06:00:00	QQQ	ETF	66.47	66.5	66.47	66.5	1100.0
2013-02-27 07:00:00	QQQ	ETF	66.5	66.6	66.48	66.6	8515.0
2013-02-27 08:00:00	QQQ	ETF	66.58	66.6	66.47	66.52	24857.0
2013-02-27 09:00:00	QQQ	ETF	66.52	66.75	66.47	66.68	3013378.0
2013-02-27 10:00:00	QQQ	ETF	66.68	67.15	66.61	67.02	5567477.0
2013-02-27 11:00:00	QQQ	ETF	67.02	67.335	67.01	67.23	4230931.0
2013-02-27 12:00:00	QQQ	ETF	67.22	67.485	67.18	67.3	6035152.0
2013-02-27 13:00:00	QQQ	ETF	67.3	67.38	67.17	67.27	1821436.0
2013-02-27 14:00:00	QQQ	ETF	67.28	67.64	67.26	67.6155	3128649.0
2013-02-27 15:00:00	QQQ	ETF	67.62	67.65	67.23	67.24	8489958.0
2013-02-27 16:00:00	QQQ	ETF	67.24	67.5601	66.5511	67.27	2862049.0
2013-02-27 17:00:00	QQQ	ETF	67.26	67.28	67.2	67.23	21078.0
2013-02-27 18:00:00	QQQ	ETF	67.22	67.24	67.2	67.24	12921.0
2013-02-27 19:00:00	QQQ	ETF	67.24	67.27	67.24	67.26	10915.0
2013-02-27 05:00:00	IWM	ETF	89.2	89.22	89.2	89.22	1000.0
2013-02-27 06:00:00	IWM	ETF	89.18	89.19	89.18	89.19	2500.0
2013-02-27 07:00:00	IWM	ETF	89.26	89.45	89.25	89.43	43598.0
2013-02-27 08:00:00	IWM	ETF	89.4	89.4	89.2	89.31	441908.0
2013-02-27 09:00:00	IWM	ETF	89.33	89.99	89.25	89.955	4849213.0
2013-02-27 10:00:00	IWM	ETF	89.96	90.47	89.89	90.18	6781336.0
2013-02-27 11:00:00	IWM	ETF	90.18	90.55	90.18	90.48	3461607.0
2013-02-27 12:00:00	IWM	ETF	90.48	90.67	90.33	90.38	3797275.0
2013-02-27 13:00:00	IWM	ETF	90.38	90.57	90.25	90.5099	1931974.0
2013-02-27 14:00:00	IWM	ETF	90.51	90.84	90.48	90.83	2828373.0
2013-02-27 15:00:00	IWM	ETF	90.83	90.85	90.3	90.31	8589796.0
2013-02-27 16:00:00	IWM	ETF	90.31	90.5575	90.29	90.45	1395645.0
2013-02-27 17:00:00	IWM	ETF	90.42	90.42	90.4	90.4	15000.0
2013-02-27 18:00:00	IWM	ETF	90.43	90.48	90.4	90.48	7902.0
2013-02-27 19:00:00	IWM	ETF	90.48	90.48	90.41	90.44	7042.0
2013-02-27 07:00:00	DIA	ETF	138.81	138.81	138.81	138.81	100.0
2013-02-27 08:00:00	DIA	ETF	138.78	138.79	138.6	138.65	6900.0
2013-02-27 09:00:00	DIA	ETF	138.68	139.25	138.62	139.09	615748.0

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

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