PREVIEW / etf_1hour / 2013-02-20

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-02-20.parquet
  size:    204 KB
  rows:    6,329

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
2013-02-20 04:00:00	SPY	ETF	153.29	153.4	153.29	153.37	17665.0
2013-02-20 05:00:00	SPY	ETF	153.27	153.31	153.27	153.28	1635.0
2013-02-20 06:00:00	SPY	ETF	153.22	153.24	153.18	153.18	205300.0
2013-02-20 07:00:00	SPY	ETF	153.18	153.22	153.05	153.18	194878.0
2013-02-20 08:00:00	SPY	ETF	153.15	153.25	153.02	153.22	777899.0
2013-02-20 09:00:00	SPY	ETF	153.22	153.29	152.885	152.919	10703452.0
2013-02-20 10:00:00	SPY	ETF	152.919	153.17	152.83	152.84	16632605.0
2013-02-20 11:00:00	SPY	ETF	152.84	152.85	152.4	152.54	17211768.0
2013-02-20 12:00:00	SPY	ETF	152.53	152.76	152.49	152.69	12844362.0
2013-02-20 13:00:00	SPY	ETF	152.68	152.72	152.47	152.52	8003684.0
2013-02-20 14:00:00	SPY	ETF	152.52	152.74	151.88	151.96	23860215.0
2013-02-20 15:00:00	SPY	ETF	151.965	151.97	151.3	151.31	50250984.0
2013-02-20 16:00:00	SPY	ETF	151.33	153.2819	151.09	151.22	13310090.0
2013-02-20 17:00:00	SPY	ETF	151.22	151.26	151.07	151.17	271827.0
2013-02-20 18:00:00	SPY	ETF	151.18	151.29	151.15	151.27	153680.0
2013-02-20 19:00:00	SPY	ETF	151.27	151.34	151.24	151.32	83958.0
2013-02-20 04:00:00	QQQ	ETF	68.33	68.33	68.33	68.33	100.0
2013-02-20 05:00:00	QQQ	ETF	68.29	68.29	68.27	68.27	400.0
2013-02-20 06:00:00	QQQ	ETF	68.27	68.27	68.2	68.2	22300.0
2013-02-20 07:00:00	QQQ	ETF	68.18	68.2	68.1	68.17	190999.0
2013-02-20 08:00:00	QQQ	ETF	68.18	68.22	68.14	68.22	92000.0
2013-02-20 09:00:00	QQQ	ETF	68.21	68.25	68.05	68.0543	3580777.0
2013-02-20 10:00:00	QQQ	ETF	68.05	68.17	68.02	68.02	5103955.0
2013-02-20 11:00:00	QQQ	ETF	68.02	68.03	67.64	67.78	5647147.0
2013-02-20 12:00:00	QQQ	ETF	67.78	67.869	67.74	67.81	1962991.0
2013-02-20 13:00:00	QQQ	ETF	67.8	67.81	67.69	67.74	1359024.0
2013-02-20 14:00:00	QQQ	ETF	67.74	67.86	67.41	67.47	6021486.0
2013-02-20 15:00:00	QQQ	ETF	67.47	67.47	67.18	67.19	7634204.0
2013-02-20 16:00:00	QQQ	ETF	67.19	67.21	66.9	67.1	2803446.0
2013-02-20 17:00:00	QQQ	ETF	67.14	67.15	67.09	67.11	26585.0
2013-02-20 18:00:00	QQQ	ETF	67.14	67.17	67.13	67.17	6360.0
2013-02-20 19:00:00	QQQ	ETF	67.17	67.21	67.17	67.21	9930.0
2013-02-20 07:00:00	IWM	ETF	92.67	92.67	92.55	92.6	54200.0
2013-02-20 08:00:00	IWM	ETF	92.61	92.73	92.57	92.7	153467.0
2013-02-20 09:00:00	IWM	ETF	92.71	92.75	92.33	92.4	2907073.0
2013-02-20 10:00:00	IWM	ETF	92.391	92.46	92.25	92.26	4216749.0
2013-02-20 11:00:00	IWM	ETF	92.26	92.26	91.93	92.04	5847044.0
2013-02-20 12:00:00	IWM	ETF	92.04	92.23	91.97	92.1	2643092.0
2013-02-20 13:00:00	IWM	ETF	92.09	92.12	91.94	91.97	1854243.0
2013-02-20 14:00:00	IWM	ETF	91.97	92.19	91.6	91.64	6167497.0
2013-02-20 15:00:00	IWM	ETF	91.63	91.63	90.74	90.819	10706325.0
2013-02-20 16:00:00	IWM	ETF	90.83	92.05	90.7	90.75	4685548.0
2013-02-20 17:00:00	IWM	ETF	90.82	90.82	90.72	90.74	66220.0
2013-02-20 18:00:00	IWM	ETF	90.75	90.91	90.75	90.91	6190.0
2013-02-20 19:00:00	IWM	ETF	90.86	90.9	90.82	90.84	7300.0
2013-02-20 07:00:00	DIA	ETF	139.98	139.98	139.98	139.98	100.0
2013-02-20 08:00:00	DIA	ETF	139.93	140.11	139.93	140.08	12425.0
2013-02-20 09:00:00	DIA	ETF	140.06	140.12	139.89	139.93	223287.0
2013-02-20 10:00:00	DIA	ETF	139.92	140.284	139.92	140.02	655070.0
2013-02-20 11:00:00	DIA	ETF	140.0	140.02	139.62	139.71	774892.0

> showing 50 of 6,329 rows — these rows as CSV

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