PREVIEW / etf_1hour / 2012-03-21

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-03-21.parquet
  size:    181 KB
  rows:    5,603

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-03-21 04:00:00	SPY	ETF	140.64	140.97	140.64	140.92	44230.0
2012-03-21 05:00:00	SPY	ETF	140.9	140.9	140.7	140.9	34900.0
2012-03-21 06:00:00	SPY	ETF	140.83	140.83	140.71	140.74	33385.0
2012-03-21 07:00:00	SPY	ETF	140.74	140.82	140.69	140.81	121523.0
2012-03-21 08:00:00	SPY	ETF	140.8	140.85	140.4287	140.53	1716458.0
2012-03-21 09:00:00	SPY	ETF	140.51	140.65	140.28	140.375	14472876.0
2012-03-21 10:00:00	SPY	ETF	140.37	140.44	139.99	140.031	27077007.0
2012-03-21 11:00:00	SPY	ETF	140.035	140.36	139.92	140.195	17111311.0
2012-03-21 12:00:00	SPY	ETF	140.2	140.56	140.19	140.51	8645591.0
2012-03-21 13:00:00	SPY	ETF	140.51	140.52	140.24	140.355	7277514.0
2012-03-21 14:00:00	SPY	ETF	140.36	140.57	140.33	140.455	11433159.0
2012-03-21 15:00:00	SPY	ETF	140.46	140.63	140.21	140.21	23868481.0
2012-03-21 16:00:00	SPY	ETF	140.2	140.28	140.07	140.18	8863600.0
2012-03-21 17:00:00	SPY	ETF	140.18	140.2	140.12	140.19	85336.0
2012-03-21 18:00:00	SPY	ETF	140.18	140.31	140.18	140.28	102512.0
2012-03-21 19:00:00	SPY	ETF	140.27	140.35	140.23	140.34	40063.0
2012-03-21 06:00:00	QQQ	ETF	67.2	67.26	67.2	67.26	4000.0
2012-03-21 07:00:00	QQQ	ETF	67.22	67.27	67.19	67.27	123700.0
2012-03-21 08:00:00	QQQ	ETF	67.27	67.28	67.09	67.12	531781.0
2012-03-21 09:00:00	QQQ	ETF	67.11	67.32	67.11	67.23	4811283.0
2012-03-21 10:00:00	QQQ	ETF	67.22	67.3	67.06	67.082	8433352.0
2012-03-21 11:00:00	QQQ	ETF	67.08	67.25	67.03	67.1709	3751490.0
2012-03-21 12:00:00	QQQ	ETF	67.18	67.4	67.17	67.3814	3208803.0
2012-03-21 13:00:00	QQQ	ETF	67.385	67.39	67.23	67.34	2375401.0
2012-03-21 14:00:00	QQQ	ETF	67.34	67.4601	67.32	67.41	3850673.0
2012-03-21 15:00:00	QQQ	ETF	67.41	67.49	67.12	67.12	5488491.0
2012-03-21 16:00:00	QQQ	ETF	67.12	67.18	67.09	67.15	2868424.0
2012-03-21 17:00:00	QQQ	ETF	67.13	67.15	67.11	67.13	14540.0
2012-03-21 18:00:00	QQQ	ETF	67.13	67.15	67.1	67.15	14940.0
2012-03-21 19:00:00	QQQ	ETF	67.13	67.18	67.13	67.17	19850.0
2012-03-21 05:00:00	IWM	ETF	83.31	83.39	83.31	83.39	500.0
2012-03-21 07:00:00	IWM	ETF	83.31	83.38	83.29	83.38	47710.0
2012-03-21 08:00:00	IWM	ETF	83.37	83.39	83.08	83.16	347592.0
2012-03-21 09:00:00	IWM	ETF	83.14	83.36	82.9	83.07	4794521.0
2012-03-21 10:00:00	IWM	ETF	83.06	83.13	82.64	82.78	9252157.0
2012-03-21 11:00:00	IWM	ETF	82.77	83.325	82.68	83.16	4350916.0
2012-03-21 12:00:00	IWM	ETF	83.16	83.43	83.16	83.352	2435506.0
2012-03-21 13:00:00	IWM	ETF	83.3524	83.375	83.03	83.185	2580743.0
2012-03-21 14:00:00	IWM	ETF	83.17	83.34	83.085	83.17	3069574.0
2012-03-21 15:00:00	IWM	ETF	83.16	83.37	82.91	82.91	7119066.0
2012-03-21 16:00:00	IWM	ETF	82.91	82.94	82.78	82.85	5030143.0
2012-03-21 17:00:00	IWM	ETF	82.84	82.87	82.79	82.87	9245.0
2012-03-21 18:00:00	IWM	ETF	82.88	82.9	82.88	82.9	10700.0
2012-03-21 19:00:00	IWM	ETF	82.92	83.03	82.9	83.03	11854.0
2012-03-21 06:00:00	DIA	ETF	131.68	131.68	131.68	131.68	200.0
2012-03-21 07:00:00	DIA	ETF	131.66	131.68	131.64	131.68	27600.0
2012-03-21 08:00:00	DIA	ETF	131.78	131.78	131.51	131.56	7300.0
2012-03-21 09:00:00	DIA	ETF	131.55	131.62	131.27	131.35	507984.0
2012-03-21 10:00:00	DIA	ETF	131.33	131.37	130.87	130.9	980225.0
2012-03-21 11:00:00	DIA	ETF	130.89	131.14	130.81	131.04	686353.0

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

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