PREVIEW / etf_1hour / 2011-02-23

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-02-23.parquet
  size:    185 KB
  rows:    5,580

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-23 04:00:00	SPY	ETF	132.27	132.56	132.19	132.25	1600.0
2011-02-23 05:00:00	SPY	ETF	132.25	132.25	132.0	132.21	700.0
2011-02-23 06:00:00	SPY	ETF	132.26	132.47	132.23	132.46	185300.0
2011-02-23 07:00:00	SPY	ETF	132.46	132.49	132.3	132.34	636177.0
2011-02-23 08:00:00	SPY	ETF	132.34	132.44	132.01	132.06	2420940.0
2011-02-23 09:00:00	SPY	ETF	132.05	132.07	131.48	131.56	24686773.0
2011-02-23 10:00:00	SPY	ETF	131.56	131.84	131.22	131.665	29395830.0
2011-02-23 11:00:00	SPY	ETF	131.67	131.78	130.98	131.0174	25187565.0
2011-02-23 12:00:00	SPY	ETF	131.02	131.1	130.47	130.71	31593978.0
2011-02-23 13:00:00	SPY	ETF	130.71	131.0	130.21	130.87	31191301.0
2011-02-23 14:00:00	SPY	ETF	130.87	131.33	130.82	131.319	23111677.0
2011-02-23 15:00:00	SPY	ETF	131.32	131.58	130.97	131.03	46394323.0
2011-02-23 16:00:00	SPY	ETF	131.03	131.6	130.54	131.1	9871909.0
2011-02-23 17:00:00	SPY	ETF	131.09	131.8126	131.06	131.11	1085743.0
2011-02-23 18:00:00	SPY	ETF	131.11	131.3	131.01	131.29	531687.0
2011-02-23 19:00:00	SPY	ETF	131.23	131.28	131.16	131.19	55957.0
2011-02-23 06:00:00	QQQ	ETF	57.28	57.34	57.28	57.34	10500.0
2011-02-23 07:00:00	QQQ	ETF	57.33	57.35	57.3	57.32	221817.0
2011-02-23 08:00:00	QQQ	ETF	57.31	57.34	57.17	57.21	712969.0
2011-02-23 09:00:00	QQQ	ETF	57.22	57.23	56.93	56.96	10354327.0
2011-02-23 10:00:00	QQQ	ETF	56.96	57.01	56.66	56.8575	16067906.0
2011-02-23 11:00:00	QQQ	ETF	56.86	56.9	56.49	56.5	12342673.0
2011-02-23 12:00:00	QQQ	ETF	56.5	56.5	56.17	56.3649	17410145.0
2011-02-23 13:00:00	QQQ	ETF	56.36	56.51	56.13	56.44	8649845.0
2011-02-23 14:00:00	QQQ	ETF	56.4475	56.71	56.4399	56.7	8063402.0
2011-02-23 15:00:00	QQQ	ETF	56.7	56.82	56.55	56.57	12469792.0
2011-02-23 16:00:00	QQQ	ETF	56.58	56.7401	56.3809	56.64	3168381.0
2011-02-23 17:00:00	QQQ	ETF	56.6	56.65	56.6	56.65	66162.0
2011-02-23 18:00:00	QQQ	ETF	56.63	56.68	56.53	56.66	103570.0
2011-02-23 19:00:00	QQQ	ETF	56.65	56.66	56.61	56.61	25702.0
2011-02-23 06:00:00	IWM	ETF	81.64	81.83	81.64	81.81	14900.0
2011-02-23 07:00:00	IWM	ETF	81.86	81.9	81.8	81.81	155905.0
2011-02-23 08:00:00	IWM	ETF	81.79	81.81	81.55	81.56	242947.0
2011-02-23 09:00:00	IWM	ETF	81.56	81.56	80.81	80.88	9890870.0
2011-02-23 10:00:00	IWM	ETF	80.89	81.05	80.52	80.9	9255024.0
2011-02-23 11:00:00	IWM	ETF	80.89	80.895	79.89	79.9099	10735539.0
2011-02-23 12:00:00	IWM	ETF	79.91	79.92	79.3901	79.65	12530786.0
2011-02-23 13:00:00	IWM	ETF	79.66	79.99	79.29	79.94	10588100.0
2011-02-23 14:00:00	IWM	ETF	79.94	80.4	79.9	80.3	9073005.0
2011-02-23 15:00:00	IWM	ETF	80.3	80.47	79.82	79.83	12562657.0
2011-02-23 16:00:00	IWM	ETF	79.83	81.2071	79.73	79.87	5414777.0
2011-02-23 17:00:00	IWM	ETF	79.84	79.87	79.79	79.82	133663.0
2011-02-23 18:00:00	IWM	ETF	79.86	79.92	79.82	79.89	31642.0
2011-02-23 19:00:00	IWM	ETF	79.9	79.92	79.85	79.85	2700.0
2011-02-23 07:00:00	DIA	ETF	122.2	122.26	122.18	122.19	3110.0
2011-02-23 08:00:00	DIA	ETF	122.18	122.18	121.94	121.94	39081.0
2011-02-23 09:00:00	DIA	ETF	121.94	121.94	121.43	121.5	1168417.0
2011-02-23 10:00:00	DIA	ETF	121.51	121.74	121.27	121.57	1538504.0
2011-02-23 11:00:00	DIA	ETF	121.6	121.675	121.1501	121.18	1263252.0
2011-02-23 12:00:00	DIA	ETF	121.19	121.2	120.67	120.8	1982536.0

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

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