PREVIEW / etf_1hour / 2013-04-03

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-04-03.parquet
  size:    203 KB
  rows:    6,300

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-04-03 04:00:00	SPY	ETF	156.8	157.16	156.8	157.08	15779.0
2013-04-03 05:00:00	SPY	ETF	157.14	157.2	157.1	157.17	109802.0
2013-04-03 06:00:00	SPY	ETF	157.17	157.17	157.06	157.06	9550.0
2013-04-03 07:00:00	SPY	ETF	157.06	157.1	156.89	157.1	411074.0
2013-04-03 08:00:00	SPY	ETF	157.07	157.2	156.82	156.94	2273639.0
2013-04-03 09:00:00	SPY	ETF	156.93	157.03	156.44	156.52	13459111.0
2013-04-03 10:00:00	SPY	ETF	156.51	156.59	155.98	156.02	25160304.0
2013-04-03 11:00:00	SPY	ETF	156.02	156.075	155.75	156.04	14994562.0
2013-04-03 12:00:00	SPY	ETF	156.035	156.04	155.54	155.66	11183901.0
2013-04-03 13:00:00	SPY	ETF	155.65	155.76	155.11	155.125	18311912.0
2013-04-03 14:00:00	SPY	ETF	155.12	155.62	155.06	155.55	21175175.0
2013-04-03 15:00:00	SPY	ETF	155.55	155.55	154.82	155.26	34758945.0
2013-04-03 16:00:00	SPY	ETF	155.24	156.8877	155.15	155.31	6950615.0
2013-04-03 17:00:00	SPY	ETF	155.33	155.36	155.31	155.31	130902.0
2013-04-03 18:00:00	SPY	ETF	155.3	155.34	155.03	155.24	240488.0
2013-04-03 19:00:00	SPY	ETF	155.2	155.36	155.2	155.31	63807.0
2013-04-03 04:00:00	QQQ	ETF	69.08	69.11	69.08	69.11	12000.0
2013-04-03 07:00:00	QQQ	ETF	69.07	69.14	69.05	69.13	561900.0
2013-04-03 08:00:00	QQQ	ETF	69.13	69.15	69.05	69.07	973120.0
2013-04-03 09:00:00	QQQ	ETF	69.09	69.18	69.03	69.0799	3753986.0
2013-04-03 10:00:00	QQQ	ETF	69.07	69.1	68.89	68.93	3444044.0
2013-04-03 11:00:00	QQQ	ETF	68.92	68.94	68.795	68.898	2159749.0
2013-04-03 12:00:00	QQQ	ETF	68.89	68.89	68.6	68.639	2127813.0
2013-04-03 13:00:00	QQQ	ETF	68.639	68.67	68.295	68.3	6418126.0
2013-04-03 14:00:00	QQQ	ETF	68.3	68.53	68.28	68.51	5564453.0
2013-04-03 15:00:00	QQQ	ETF	68.515	68.54	68.24	68.43	6772342.0
2013-04-03 16:00:00	QQQ	ETF	68.43	69.0647	68.4	68.42	3142133.0
2013-04-03 17:00:00	QQQ	ETF	68.42	68.45	68.41	68.45	2995.0
2013-04-03 18:00:00	QQQ	ETF	68.43	68.43	68.35	68.41	5900.0
2013-04-03 19:00:00	QQQ	ETF	68.41	68.44	68.4	68.44	13624.0
2013-04-03 04:00:00	IWM	ETF	93.05	93.05	93.05	93.05	100.0
2013-04-03 05:00:00	IWM	ETF	93.16	93.16	93.16	93.16	100.0
2013-04-03 06:00:00	IWM	ETF	93.12	93.12	93.1	93.12	30899.0
2013-04-03 07:00:00	IWM	ETF	93.09	93.12	93.0	93.12	68299.0
2013-04-03 08:00:00	IWM	ETF	93.09	93.14	92.58	92.98	268517.0
2013-04-03 09:00:00	IWM	ETF	93.0	93.0	92.46	92.59	4348584.0
2013-04-03 10:00:00	IWM	ETF	92.585	92.585	91.92	91.96	9587381.0
2013-04-03 11:00:00	IWM	ETF	91.96	92.04	91.58	91.875	6784290.0
2013-04-03 12:00:00	IWM	ETF	91.8703	91.881	91.49	91.6165	4129281.0
2013-04-03 13:00:00	IWM	ETF	91.61	91.74	90.97	91.01	8207596.0
2013-04-03 14:00:00	IWM	ETF	91.01	91.61	90.92	91.6	7346521.0
2013-04-03 15:00:00	IWM	ETF	91.6	91.61	91.02	91.16	9874214.0
2013-04-03 16:00:00	IWM	ETF	91.16	92.7579	91.07	91.31	2892928.0
2013-04-03 17:00:00	IWM	ETF	91.32	91.35	91.27	91.27	8875.0
2013-04-03 18:00:00	IWM	ETF	91.24	91.3	91.2	91.3	2397.0
2013-04-03 19:00:00	IWM	ETF	91.25	91.32	91.25	91.26	2758.0
2013-04-03 07:00:00	DIA	ETF	146.31	146.31	146.25	146.25	1300.0
2013-04-03 08:00:00	DIA	ETF	146.27	146.37	146.2	146.23	123596.0
2013-04-03 09:00:00	DIA	ETF	146.18	146.47	146.04	146.13	1040055.0
2013-04-03 10:00:00	DIA	ETF	146.11	146.199	145.75	145.78	1151780.0

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

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