PREVIEW / etf_1hour / 2011-07-14

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-07-14.parquet
  size:    182 KB
  rows:    5,592

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-14 04:00:00	SPY	ETF	131.85	132.2	131.85	132.12	14434.0
2011-07-14 05:00:00	SPY	ETF	132.14	132.27	131.77	131.77	4103.0
2011-07-14 06:00:00	SPY	ETF	131.69	132.24	131.55	131.8	170810.0
2011-07-14 07:00:00	SPY	ETF	131.83	132.2	131.53	132.08	1531189.0
2011-07-14 08:00:00	SPY	ETF	132.04	132.25	131.14	132.21	3971790.0
2011-07-14 09:00:00	SPY	ETF	132.21	132.72	131.97	132.65	20116414.0
2011-07-14 10:00:00	SPY	ETF	132.64	132.78	131.76	131.82	37134906.0
2011-07-14 11:00:00	SPY	ETF	131.81	132.07	131.61	131.81	21497397.0
2011-07-14 12:00:00	SPY	ETF	131.81	131.81	131.12	131.17	22107602.0
2011-07-14 13:00:00	SPY	ETF	131.17	131.69	130.68	131.48	47546941.0
2011-07-14 14:00:00	SPY	ETF	131.48	131.68	131.03	131.18	23361263.0
2011-07-14 15:00:00	SPY	ETF	131.185	131.31	130.72	130.94	37543261.0
2011-07-14 16:00:00	SPY	ETF	130.95	132.71	130.91	131.15	7617539.0
2011-07-14 17:00:00	SPY	ETF	131.16	131.29	131.11	131.25	300500.0
2011-07-14 18:00:00	SPY	ETF	131.25	131.31	130.94	131.17	289461.0
2011-07-14 19:00:00	SPY	ETF	131.17	131.26	130.41	130.81	419858.0
2011-07-14 04:00:00	QQQ	ETF	57.66	57.8	57.66	57.8	890.0
2011-07-14 05:00:00	QQQ	ETF	57.84	57.94	57.8	57.8	1200.0
2011-07-14 06:00:00	QQQ	ETF	57.76	57.76	57.76	57.76	900.0
2011-07-14 07:00:00	QQQ	ETF	57.84	57.96	57.77	57.86	140160.0
2011-07-14 08:00:00	QQQ	ETF	57.88	57.94	57.81	57.93	2227090.0
2011-07-14 09:00:00	QQQ	ETF	57.92	58.12	57.74	58.11	6803446.0
2011-07-14 10:00:00	QQQ	ETF	58.12	58.18	57.6	57.64	11579511.0
2011-07-14 11:00:00	QQQ	ETF	57.63	57.76	57.47	57.57	10234175.0
2011-07-14 12:00:00	QQQ	ETF	57.56	57.56	57.1	57.12	6483491.0
2011-07-14 13:00:00	QQQ	ETF	57.12	57.33	56.87	57.26	14426144.0
2011-07-14 14:00:00	QQQ	ETF	57.2585	57.345	57.02	57.081	6350493.0
2011-07-14 15:00:00	QQQ	ETF	57.085	57.23	56.91	57.07	10016451.0
2011-07-14 16:00:00	QQQ	ETF	57.07	57.7	57.07	57.41	4813984.0
2011-07-14 17:00:00	QQQ	ETF	57.42	57.47	57.3476	57.3476	52912.0
2011-07-14 18:00:00	QQQ	ETF	57.45	57.69	57.05	57.52	153822.0
2011-07-14 19:00:00	QQQ	ETF	57.51	57.58	57.29	57.52	120935.0
2011-07-14 04:00:00	IWM	ETF	83.59	83.99	83.59	83.99	1294.0
2011-07-14 05:00:00	IWM	ETF	83.75	83.8	83.75	83.8	278.0
2011-07-14 06:00:00	IWM	ETF	83.82	83.82	83.82	83.82	100.0
2011-07-14 07:00:00	IWM	ETF	83.79	84.0	83.5	83.85	148500.0
2011-07-14 08:00:00	IWM	ETF	83.87	84.0	83.77	83.94	1418888.0
2011-07-14 09:00:00	IWM	ETF	83.95	84.11	83.51	84.02	8716051.0
2011-07-14 10:00:00	IWM	ETF	84.0269	84.17	83.09	83.19	15399158.0
2011-07-14 11:00:00	IWM	ETF	83.18	83.33	82.85	82.98	6506828.0
2011-07-14 12:00:00	IWM	ETF	82.97	82.98	82.26	82.32	9316571.0
2011-07-14 13:00:00	IWM	ETF	82.3119	82.79	82.05	82.71	13368168.0
2011-07-14 14:00:00	IWM	ETF	82.72	82.95	82.26	82.4	6605056.0
2011-07-14 15:00:00	IWM	ETF	82.41	82.57	82.14	82.26	10567060.0
2011-07-14 16:00:00	IWM	ETF	82.24	82.55	82.22	82.43	6957649.0
2011-07-14 17:00:00	IWM	ETF	82.43	82.47	82.41	82.46	59600.0
2011-07-14 18:00:00	IWM	ETF	82.52	82.57	82.46	82.55	11534.0
2011-07-14 19:00:00	IWM	ETF	82.54	82.55	82.28	82.31	22454.0
2011-07-14 06:00:00	DIA	ETF	124.51	124.51	124.51	124.51	200.0
2011-07-14 07:00:00	DIA	ETF	124.69	124.92	124.69	124.88	10900.0

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

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