PREVIEW / etf_1hour / 2011-02-11

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-02-11.parquet
  size:    177 KB
  rows:    5,367

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-11 04:00:00	SPY	ETF	131.87	131.87	131.6	131.6	800.0
2011-02-11 05:00:00	SPY	ETF	131.56	131.64	131.46	131.6	63300.0
2011-02-11 06:00:00	SPY	ETF	131.57	132.09	131.57	131.68	146744.0
2011-02-11 07:00:00	SPY	ETF	131.66	131.97	131.66	131.93	398584.0
2011-02-11 08:00:00	SPY	ETF	131.91	131.98	131.69	131.94	1211846.0
2011-02-11 09:00:00	SPY	ETF	131.94	132.14	131.77	132.11	14942189.0
2011-02-11 10:00:00	SPY	ETF	132.12	132.79	132.06	132.76	20142322.0
2011-02-11 11:00:00	SPY	ETF	132.76	133.12	132.67	132.78	26652370.0
2011-02-11 12:00:00	SPY	ETF	132.78	132.84	132.48	132.79	16084717.0
2011-02-11 13:00:00	SPY	ETF	132.8	132.94	132.76	132.91	8704364.0
2011-02-11 14:00:00	SPY	ETF	132.9068	133.27	132.9	133.14	14579834.0
2011-02-11 15:00:00	SPY	ETF	133.15	133.28	133.01	133.11	23015213.0
2011-02-11 16:00:00	SPY	ETF	133.12	133.32	132.05	133.26	10849938.0
2011-02-11 17:00:00	SPY	ETF	133.24	133.28	133.2	133.21	176275.0
2011-02-11 18:00:00	SPY	ETF	133.23	133.23	133.15	133.22	21686.0
2011-02-11 19:00:00	SPY	ETF	133.22	133.27	133.18	133.24	29564.0
2011-02-11 05:00:00	QQQ	ETF	57.73	57.77	57.73	57.77	50100.0
2011-02-11 06:00:00	QQQ	ETF	57.78	57.78	57.76	57.77	26000.0
2011-02-11 07:00:00	QQQ	ETF	57.81	57.91	57.78	57.9	468716.0
2011-02-11 08:00:00	QQQ	ETF	57.9	57.96	57.87	57.92	652958.0
2011-02-11 09:00:00	QQQ	ETF	57.92	58.01	57.77	58.0	5713267.0
2011-02-11 10:00:00	QQQ	ETF	58.0	58.19	57.9	58.18	7101141.0
2011-02-11 11:00:00	QQQ	ETF	58.18	58.3	58.12	58.22	7884855.0
2011-02-11 12:00:00	QQQ	ETF	58.23	58.31	58.14	58.289	4089293.0
2011-02-11 13:00:00	QQQ	ETF	58.29	58.37	58.27	58.36	3339591.0
2011-02-11 14:00:00	QQQ	ETF	58.355	58.48	58.34	58.42	3803174.0
2011-02-11 15:00:00	QQQ	ETF	58.42	58.46	58.34	58.44	10970807.0
2011-02-11 16:00:00	QQQ	ETF	58.44	58.46	58.3424	58.42	2795692.0
2011-02-11 17:00:00	QQQ	ETF	58.42	58.46	58.42	58.46	25325.0
2011-02-11 18:00:00	QQQ	ETF	58.48	58.5	58.42	58.47	35655.0
2011-02-11 19:00:00	QQQ	ETF	58.5	58.57	58.5	58.53	10608.0
2011-02-11 04:00:00	IWM	ETF	80.86	80.86	80.65	80.65	400.0
2011-02-11 05:00:00	IWM	ETF	80.6	80.67	80.6	80.67	300.0
2011-02-11 06:00:00	IWM	ETF	80.76	80.77	80.76	80.77	2360.0
2011-02-11 07:00:00	IWM	ETF	80.75	80.98	80.75	80.94	91220.0
2011-02-11 08:00:00	IWM	ETF	80.96	81.02	80.88	80.97	232912.0
2011-02-11 09:00:00	IWM	ETF	80.97	81.14	80.79	81.13	3501239.0
2011-02-11 10:00:00	IWM	ETF	81.13	81.45	81.08	81.44	3681655.0
2011-02-11 11:00:00	IWM	ETF	81.44	81.7001	81.35	81.65	6937877.0
2011-02-11 12:00:00	IWM	ETF	81.65	81.75	81.47	81.72	3614447.0
2011-02-11 13:00:00	IWM	ETF	81.72	82.0	81.72	81.855	4245039.0
2011-02-11 14:00:00	IWM	ETF	81.855	82.05	81.83	81.965	3132637.0
2011-02-11 15:00:00	IWM	ETF	81.97	82.1	81.93	82.1	8692784.0
2011-02-11 16:00:00	IWM	ETF	82.1	82.17	81.1854	81.8315	1445303.0
2011-02-11 17:00:00	IWM	ETF	82.16	82.22	82.15	82.21	24585.0
2011-02-11 18:00:00	IWM	ETF	82.22	82.26	82.18	82.26	7351.0
2011-02-11 19:00:00	IWM	ETF	82.27	82.3	82.26	82.29	1500.0
2011-02-11 05:00:00	DIA	ETF	121.6	121.6	121.56	121.56	200.0
2011-02-11 07:00:00	DIA	ETF	121.76	121.86	121.75	121.86	8725.0
2011-02-11 08:00:00	DIA	ETF	121.88	121.93	121.8	121.81	13000.0

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

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