PREVIEW / etf_1hour / 2011-03-07

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-03-07.parquet
  size:    176 KB
  rows:    5,360

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-03-07 07:00:00	SPY	ETF	132.94	133.05	132.33	132.36	1171477.0
2011-03-07 08:00:00	SPY	ETF	132.36	132.86	132.25	132.68	1397431.0
2011-03-07 09:00:00	SPY	ETF	132.68	133.1594	132.67	133.03	22407653.0
2011-03-07 10:00:00	SPY	ETF	133.03	133.14	131.94	132.04	31406019.0
2011-03-07 11:00:00	SPY	ETF	132.04	132.05	131.17	131.3	38630473.0
2011-03-07 12:00:00	SPY	ETF	131.31	131.55	130.91	130.96	21033837.0
2011-03-07 13:00:00	SPY	ETF	130.96	131.19	130.735	131.03	22527640.0
2011-03-07 14:00:00	SPY	ETF	131.02	131.42	130.9	131.26	18815494.0
2011-03-07 15:00:00	SPY	ETF	131.26	131.83	131.12	131.41	37022104.0
2011-03-07 16:00:00	SPY	ETF	131.41	132.4854	131.27	131.4	21001623.0
2011-03-07 17:00:00	SPY	ETF	131.42	131.47	131.37	131.39	149693.0
2011-03-07 18:00:00	SPY	ETF	131.42	131.64	131.37	131.61	236054.0
2011-03-07 19:00:00	SPY	ETF	131.64	131.7	131.46	131.5	113726.0
2011-03-07 07:00:00	QQQ	ETF	58.3	58.3	58.0	58.0	148125.0
2011-03-07 08:00:00	QQQ	ETF	58.0	58.17	57.96	58.17	310213.0
2011-03-07 09:00:00	QQQ	ETF	58.17	58.2599	57.95	58.06	6733382.0
2011-03-07 10:00:00	QQQ	ETF	58.05	58.09	57.39	57.45	12128640.0
2011-03-07 11:00:00	QQQ	ETF	57.45	57.4514	56.88	56.98	20049377.0
2011-03-07 12:00:00	QQQ	ETF	56.9825	57.13	56.81	56.84	7838868.0
2011-03-07 13:00:00	QQQ	ETF	56.83	56.915	56.67	56.81	8903147.0
2011-03-07 14:00:00	QQQ	ETF	56.815	57.09	56.79	57.05	8801568.0
2011-03-07 15:00:00	QQQ	ETF	57.045	57.37	56.9801	57.1905	11964083.0
2011-03-07 16:00:00	QQQ	ETF	57.19	57.2441	57.07	57.15	3876325.0
2011-03-07 17:00:00	QQQ	ETF	57.13	57.15	57.09	57.1	75150.0
2011-03-07 18:00:00	QQQ	ETF	57.11	57.23	57.11	57.23	57850.0
2011-03-07 19:00:00	QQQ	ETF	57.23	57.24	57.16	57.18	48450.0
2011-03-07 07:00:00	IWM	ETF	82.93	82.93	82.43	82.47	71445.0
2011-03-07 08:00:00	IWM	ETF	82.49	82.67	82.4	82.62	442273.0
2011-03-07 09:00:00	IWM	ETF	82.6	82.84	82.41	82.4999	6214144.0
2011-03-07 10:00:00	IWM	ETF	82.5	82.55	81.4	81.42	9589254.0
2011-03-07 11:00:00	IWM	ETF	81.43	81.43	80.63	80.73	17397572.0
2011-03-07 12:00:00	IWM	ETF	80.74	82.4372	80.47	80.54	10362140.0
2011-03-07 13:00:00	IWM	ETF	80.54	80.79	80.41	80.6	8610624.0
2011-03-07 14:00:00	IWM	ETF	80.61	81.0901	80.59	81.05	6389720.0
2011-03-07 15:00:00	IWM	ETF	81.04	81.6	80.93	81.11	12235818.0
2011-03-07 16:00:00	IWM	ETF	81.11	82.4371	80.91	81.03	2391520.0
2011-03-07 17:00:00	IWM	ETF	81.04	81.08	80.92	80.94	77825.0
2011-03-07 18:00:00	IWM	ETF	81.0	81.04	80.93	81.01	5200.0
2011-03-07 19:00:00	IWM	ETF	81.08	81.14	81.08	81.1	10900.0
2011-03-07 07:00:00	DIA	ETF	121.66	121.86	121.46	121.46	3690.0
2011-03-07 08:00:00	DIA	ETF	121.36	121.59	121.33	121.59	5220.0
2011-03-07 09:00:00	DIA	ETF	121.63	122.24	121.63	122.18	854894.0
2011-03-07 10:00:00	DIA	ETF	122.18	122.26	121.28	121.35	1378941.0
2011-03-07 11:00:00	DIA	ETF	121.35	121.35	120.61	120.7	1245104.0
2011-03-07 12:00:00	DIA	ETF	120.71	120.95	120.4	120.44	1338135.0
2011-03-07 13:00:00	DIA	ETF	120.44	120.5299	120.21	120.38	909843.0
2011-03-07 14:00:00	DIA	ETF	120.38	120.69	120.28	120.61	853542.0
2011-03-07 15:00:00	DIA	ETF	120.6	121.1226	120.4735	120.74	1583559.0
2011-03-07 16:00:00	DIA	ETF	120.73	120.919	120.68	120.8	108103.0
2011-03-07 17:00:00	DIA	ETF	120.8	120.8	120.71	120.71	200.0

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

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