PREVIEW / etf_1hour / 2011-03-02

all etf 1-hour files

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

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-02 04:00:00	SPY	ETF	130.54	130.61	130.0	130.46	7437.0
2011-03-02 05:00:00	SPY	ETF	130.6	130.85	130.58	130.58	11990.0
2011-03-02 06:00:00	SPY	ETF	130.65	130.96	130.65	130.84	48480.0
2011-03-02 07:00:00	SPY	ETF	130.88	131.02	130.69	130.85	484815.0
2011-03-02 08:00:00	SPY	ETF	130.81	130.88	130.0	130.52	3349743.0
2011-03-02 09:00:00	SPY	ETF	130.52	131.26	130.52	131.21	23692003.0
2011-03-02 10:00:00	SPY	ETF	131.21	131.7	131.07	131.565	33873873.0
2011-03-02 11:00:00	SPY	ETF	131.58	131.82	130.35	130.73	30557883.0
2011-03-02 12:00:00	SPY	ETF	130.72	131.42	130.6	131.2691	24555672.0
2011-03-02 13:00:00	SPY	ETF	131.265	131.45	130.91	131.035	15785674.0
2011-03-02 14:00:00	SPY	ETF	131.04	131.61	130.855	131.45	29709844.0
2011-03-02 15:00:00	SPY	ETF	131.45	131.67	131.04	131.2	24351326.0
2011-03-02 16:00:00	SPY	ETF	131.19	131.2232	130.95	131.06	6659863.0
2011-03-02 17:00:00	SPY	ETF	131.05	131.05	130.97	131.0	4102784.0
2011-03-02 18:00:00	SPY	ETF	131.01	131.21	130.95	131.05	102875.0
2011-03-02 19:00:00	SPY	ETF	131.04	131.22	131.04	131.17	113834.0
2011-03-02 04:00:00	QQQ	ETF	56.72	56.72	56.69	56.71	1400.0
2011-03-02 05:00:00	QQQ	ETF	56.75	56.87	56.75	56.87	2400.0
2011-03-02 06:00:00	QQQ	ETF	56.89	56.91	56.89	56.9	550.0
2011-03-02 07:00:00	QQQ	ETF	56.91	56.96	56.84	56.87	33240.0
2011-03-02 08:00:00	QQQ	ETF	56.86	56.88	56.62	56.77	764664.0
2011-03-02 09:00:00	QQQ	ETF	56.79	57.09	56.78	57.09	6985205.0
2011-03-02 10:00:00	QQQ	ETF	57.08	57.43	57.02	57.3705	12724820.0
2011-03-02 11:00:00	QQQ	ETF	57.38	57.511	57.0	57.0	9149836.0
2011-03-02 12:00:00	QQQ	ETF	57.0011	57.299	56.95	57.21	5553278.0
2011-03-02 13:00:00	QQQ	ETF	57.205	57.4	57.04	57.09	5512182.0
2011-03-02 14:00:00	QQQ	ETF	57.1	57.32	56.98	57.28	6354837.0
2011-03-02 15:00:00	QQQ	ETF	57.29	57.425	57.09	57.15	8449573.0
2011-03-02 16:00:00	QQQ	ETF	57.15	57.2679	57.0	57.07	2418937.0
2011-03-02 17:00:00	QQQ	ETF	57.07	57.07	57.04	57.07	154912.0
2011-03-02 18:00:00	QQQ	ETF	57.07	57.08	57.04	57.08	33052.0
2011-03-02 19:00:00	QQQ	ETF	57.08	57.13	57.06	57.11	47448.0
2011-03-02 05:00:00	IWM	ETF	80.53	80.53	80.53	80.53	2000.0
2011-03-02 06:00:00	IWM	ETF	80.67	80.7	80.67	80.7	5200.0
2011-03-02 07:00:00	IWM	ETF	80.66	80.75	80.58	80.58	71300.0
2011-03-02 08:00:00	IWM	ETF	80.6	80.68	80.07	80.43	441128.0
2011-03-02 09:00:00	IWM	ETF	80.44	80.87	80.44	80.72	7207462.0
2011-03-02 10:00:00	IWM	ETF	80.72	81.36	80.54	81.19	11008768.0
2011-03-02 11:00:00	IWM	ETF	81.19	81.37	80.39	80.4	10324865.0
2011-03-02 12:00:00	IWM	ETF	80.41	81.02	80.24	80.88	7008442.0
2011-03-02 13:00:00	IWM	ETF	80.88	81.06	80.44	80.52	5313414.0
2011-03-02 14:00:00	IWM	ETF	80.52	81.11	80.36	80.98	6905606.0
2011-03-02 15:00:00	IWM	ETF	80.98	81.25	80.89	80.94	6990029.0
2011-03-02 16:00:00	IWM	ETF	80.95	81.02	80.6436	81.02	2182281.0
2011-03-02 17:00:00	IWM	ETF	80.96	81.01	80.94	80.95	30100.0
2011-03-02 18:00:00	IWM	ETF	80.99	80.99	80.97	80.97	1300.0
2011-03-02 19:00:00	IWM	ETF	81.0	81.12	80.97	80.97	3700.0
2011-03-02 07:00:00	DIA	ETF	120.36	120.49	120.34	120.47	3407.0
2011-03-02 08:00:00	DIA	ETF	120.32	120.33	119.9	120.13	22916.0
2011-03-02 09:00:00	DIA	ETF	120.2	120.68	120.2	120.66	1020002.0

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

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