PREVIEW / etf_1hour / 2011-07-12

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-07-12.parquet
  size:    184 KB
  rows:    5,689

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
2011-07-12 04:00:00	SPY	ETF	130.95	131.0	130.17	130.8	41475.0
2011-07-12 05:00:00	SPY	ETF	130.84	131.51	130.8	131.06	53345.0
2011-07-12 06:00:00	SPY	ETF	131.0	131.3	130.91	131.01	323171.0
2011-07-12 07:00:00	SPY	ETF	130.96	131.8	130.63	131.74	2448318.0
2011-07-12 08:00:00	SPY	ETF	131.7	132.1	130.67	131.76	7289948.0
2011-07-12 09:00:00	SPY	ETF	131.76	132.05	131.25	132.03	29191993.0
2011-07-12 10:00:00	SPY	ETF	132.03	132.23	131.67	131.875	28428574.0
2011-07-12 11:00:00	SPY	ETF	131.88	132.4	131.79	132.23	19970570.0
2011-07-12 12:00:00	SPY	ETF	132.22	132.36	131.97	132.08	13579625.0
2011-07-12 13:00:00	SPY	ETF	132.09	132.25	131.82	131.92	15454052.0
2011-07-12 14:00:00	SPY	ETF	131.925	132.78	131.85	132.155	36378851.0
2011-07-12 15:00:00	SPY	ETF	132.16	132.28	131.36	131.402	48382171.0
2011-07-12 16:00:00	SPY	ETF	131.41	132.0676	131.33	131.5	11370187.0
2011-07-12 17:00:00	SPY	ETF	131.47	131.53	131.4	131.45	889365.0
2011-07-12 18:00:00	SPY	ETF	131.44	131.44	131.21	131.24	510303.0
2011-07-12 19:00:00	SPY	ETF	131.25	131.45	131.23	131.4	254013.0
2011-07-12 04:00:00	QQQ	ETF	57.57	57.59	57.34	57.59	5065.0
2011-07-12 05:00:00	QQQ	ETF	57.69	57.8	57.6	57.6	21000.0
2011-07-12 06:00:00	QQQ	ETF	57.68	57.75	57.63	57.68	3500.0
2011-07-12 07:00:00	QQQ	ETF	57.71	57.93	57.5	57.92	669058.0
2011-07-12 08:00:00	QQQ	ETF	57.89	58.13	57.84	58.05	893431.0
2011-07-12 09:00:00	QQQ	ETF	58.06	58.06	57.49	57.7	11765252.0
2011-07-12 10:00:00	QQQ	ETF	57.7	57.95	57.62	57.73	11073412.0
2011-07-12 11:00:00	QQQ	ETF	57.74	57.93	57.71	57.7699	6824257.0
2011-07-12 12:00:00	QQQ	ETF	57.77	57.855	57.63	57.71	4996221.0
2011-07-12 13:00:00	QQQ	ETF	57.71	57.85	57.63	57.73	3824506.0
2011-07-12 14:00:00	QQQ	ETF	57.7301	58.07	57.7	57.76	8904460.0
2011-07-12 15:00:00	QQQ	ETF	57.76	57.85	57.46	57.51	11631744.0
2011-07-12 16:00:00	QQQ	ETF	57.52	57.61	57.5	57.57	2000246.0
2011-07-12 17:00:00	QQQ	ETF	57.56	57.7456	57.51	57.7456	14741.0
2011-07-12 18:00:00	QQQ	ETF	57.53	57.53	57.44	57.45	56076.0
2011-07-12 19:00:00	QQQ	ETF	57.48	57.55	57.46	57.46	16279.0
2011-07-12 04:00:00	IWM	ETF	82.08	82.34	81.9	82.24	3955.0
2011-07-12 05:00:00	IWM	ETF	82.49	82.79	82.45	82.5	6500.0
2011-07-12 06:00:00	IWM	ETF	82.53	82.53	82.35	82.35	749.0
2011-07-12 07:00:00	IWM	ETF	82.34	82.88	82.1	82.81	65817.0
2011-07-12 08:00:00	IWM	ETF	82.81	83.24	82.72	82.96	991282.0
2011-07-12 09:00:00	IWM	ETF	82.97	83.2	82.72	83.1101	11442196.0
2011-07-12 10:00:00	IWM	ETF	83.12	83.48	83.03	83.22	11197700.0
2011-07-12 11:00:00	IWM	ETF	83.23	83.768	83.17	83.63	7316866.0
2011-07-12 12:00:00	IWM	ETF	83.62	83.74	83.36	83.42	4098225.0
2011-07-12 13:00:00	IWM	ETF	83.42	83.51	83.18	83.245	3454547.0
2011-07-12 14:00:00	IWM	ETF	83.248	83.76	83.2	83.28	8807064.0
2011-07-12 15:00:00	IWM	ETF	83.28	83.4	82.78	82.87	9428919.0
2011-07-12 16:00:00	IWM	ETF	82.87	82.99	82.83	82.85	3292283.0
2011-07-12 17:00:00	IWM	ETF	82.86	82.9	82.81	82.86	27342.0
2011-07-12 18:00:00	IWM	ETF	82.86	82.87	82.77	82.8	17744.0
2011-07-12 19:00:00	IWM	ETF	82.81	82.85	82.81	82.85	2600.0
2011-07-12 04:00:00	DIA	ETF	124.4	124.4	123.77	123.77	400.0
2011-07-12 06:00:00	DIA	ETF	124.45	124.45	124.45	124.45	600.0

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

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