PREVIEW / etf_1hour / 2011-02-10

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-02-10.parquet
  size:    181 KB
  rows:    5,595

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-02-10 04:00:00	SPY	ETF	132.07	132.07	131.49	131.49	8970.0
2011-02-10 05:00:00	SPY	ETF	131.45	131.74	131.45	131.72	71000.0
2011-02-10 06:00:00	SPY	ETF	131.74	131.74	131.51	131.54	100207.0
2011-02-10 07:00:00	SPY	ETF	131.53	131.74	131.53	131.59	648537.0
2011-02-10 08:00:00	SPY	ETF	131.64	131.79	131.5	131.54	2994150.0
2011-02-10 09:00:00	SPY	ETF	131.54	131.84	131.325	131.53	22800607.0
2011-02-10 10:00:00	SPY	ETF	131.54	132.2543	131.3	131.87	31189370.0
2011-02-10 11:00:00	SPY	ETF	131.86	132.34	131.81	132.2019	18914661.0
2011-02-10 12:00:00	SPY	ETF	132.21	132.27	132.02	132.03	12215710.0
2011-02-10 13:00:00	SPY	ETF	132.03	132.15	131.88	132.0	13649835.0
2011-02-10 14:00:00	SPY	ETF	131.99	132.26	131.93	132.02	9754837.0
2011-02-10 15:00:00	SPY	ETF	132.02	132.47	131.96	132.33	39066690.0
2011-02-10 16:00:00	SPY	ETF	132.34	132.4391	131.5648	131.89	9533835.0
2011-02-10 17:00:00	SPY	ETF	131.89	131.9	131.78	131.87	655553.0
2011-02-10 18:00:00	SPY	ETF	131.87	132.33	131.82	131.91	151457.0
2011-02-10 19:00:00	SPY	ETF	131.94	132.02	131.83	131.93	94803.0
2011-02-10 04:00:00	QQQ	ETF	57.55	57.55	57.46	57.48	8400.0
2011-02-10 05:00:00	QQQ	ETF	57.5	57.57	57.5	57.57	154700.0
2011-02-10 06:00:00	QQQ	ETF	57.52	57.57	57.52	57.57	60854.0
2011-02-10 07:00:00	QQQ	ETF	57.56	57.62	57.54	57.54	180090.0
2011-02-10 08:00:00	QQQ	ETF	57.56	57.64	57.45	57.52	511241.0
2011-02-10 09:00:00	QQQ	ETF	57.51	57.66	57.49	57.56	7782680.0
2011-02-10 10:00:00	QQQ	ETF	57.5601	57.99	57.49	57.89	14011346.0
2011-02-10 11:00:00	QQQ	ETF	57.885	58.1	57.86	58.06	6510718.0
2011-02-10 12:00:00	QQQ	ETF	58.06	58.1	57.96	58.01	5428425.0
2011-02-10 13:00:00	QQQ	ETF	58.01	58.04	57.71	57.8601	11182442.0
2011-02-10 14:00:00	QQQ	ETF	57.86	58.05	57.81	57.91	5300828.0
2011-02-10 15:00:00	QQQ	ETF	57.91	58.08	57.84	58.0203	10342451.0
2011-02-10 16:00:00	QQQ	ETF	58.04	58.05	57.85	57.86	2935529.0
2011-02-10 17:00:00	QQQ	ETF	57.86	57.87	57.81	57.85	119770.0
2011-02-10 18:00:00	QQQ	ETF	57.86	57.88	57.85	57.87	129000.0
2011-02-10 19:00:00	QQQ	ETF	57.87	57.88	57.85	57.85	38844.0
2011-02-10 04:00:00	IWM	ETF	80.65	80.65	80.3	80.3	1455.0
2011-02-10 05:00:00	IWM	ETF	80.46	80.46	80.45	80.45	3000.0
2011-02-10 06:00:00	IWM	ETF	80.36	80.4	80.31	80.31	5100.0
2011-02-10 07:00:00	IWM	ETF	80.32	80.49	80.32	80.37	63589.0
2011-02-10 08:00:00	IWM	ETF	80.41	80.5	80.3	80.32	405723.0
2011-02-10 09:00:00	IWM	ETF	80.31	80.82	80.22	80.4799	8477459.0
2011-02-10 10:00:00	IWM	ETF	80.47	81.1469	80.24	80.84	10062561.0
2011-02-10 11:00:00	IWM	ETF	80.84	81.29	80.8	81.2319	6961782.0
2011-02-10 12:00:00	IWM	ETF	81.23	81.24	81.03	81.045	2380756.0
2011-02-10 13:00:00	IWM	ETF	81.05	81.15	80.88	80.97	3142730.0
2011-02-10 14:00:00	IWM	ETF	80.97	81.2	80.92	81.02	1906213.0
2011-02-10 15:00:00	IWM	ETF	81.03	81.25	80.95	81.18	7668186.0
2011-02-10 16:00:00	IWM	ETF	81.19	81.26	80.8175	80.92	1569319.0
2011-02-10 17:00:00	IWM	ETF	80.93	80.96	80.86	80.96	72855.0
2011-02-10 18:00:00	IWM	ETF	80.92	81.0	80.87	81.0	4800.0
2011-02-10 19:00:00	IWM	ETF	80.9	80.91	80.9	80.91	5100.0
2011-02-10 04:00:00	DIA	ETF	121.72	121.72	121.72	121.72	100.0
2011-02-10 06:00:00	DIA	ETF	121.78	121.78	121.78	121.78	100.0

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

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