PREVIEW / etf_1hour / 2011-09-29

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-09-29.parquet
  size:    184 KB
  rows:    5,703

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-09-29 04:00:00	SPY	ETF	116.2	116.62	116.2	116.55	6192.0
2011-09-29 05:00:00	SPY	ETF	116.5	116.77	116.22	116.61	76220.0
2011-09-29 06:00:00	SPY	ETF	116.57	116.94	116.08	116.1	146021.0
2011-09-29 07:00:00	SPY	ETF	116.1	116.3	115.88	116.05	877587.0
2011-09-29 08:00:00	SPY	ETF	116.04	117.28	115.85	117.07	6446396.0
2011-09-29 09:00:00	SPY	ETF	117.09	117.63	116.92	117.21	32748691.0
2011-09-29 10:00:00	SPY	ETF	117.21	117.37	115.55	115.97	53401945.0
2011-09-29 11:00:00	SPY	ETF	115.97	116.63	115.72	116.38	28602614.0
2011-09-29 12:00:00	SPY	ETF	116.39	116.66	115.66	115.985	23187736.0
2011-09-29 13:00:00	SPY	ETF	115.98	116.37	114.82	115.17	29258566.0
2011-09-29 14:00:00	SPY	ETF	115.165	115.29	114.14	114.69	38449308.0
2011-09-29 15:00:00	SPY	ETF	114.66	116.04	113.93	116.02	74075398.0
2011-09-29 16:00:00	SPY	ETF	116.04	116.45	115.25	116.38	8318890.0
2011-09-29 17:00:00	SPY	ETF	116.34	116.5	116.28	116.38	378319.0
2011-09-29 18:00:00	SPY	ETF	116.38	116.54	116.02	116.46	285352.0
2011-09-29 19:00:00	SPY	ETF	116.44	116.44	116.23	116.3	136414.0
2011-09-29 04:00:00	QQQ	ETF	54.91	55.16	54.91	55.14	5698.0
2011-09-29 05:00:00	QQQ	ETF	55.19	55.19	55.12	55.12	375.0
2011-09-29 06:00:00	QQQ	ETF	55.14	55.32	55.02	55.05	12600.0
2011-09-29 07:00:00	QQQ	ETF	55.02	55.02	54.79	54.9	70387.0
2011-09-29 08:00:00	QQQ	ETF	54.9	55.56	54.86	55.49	1395592.0
2011-09-29 09:00:00	QQQ	ETF	55.47	55.57	55.05	55.1	11361061.0
2011-09-29 10:00:00	QQQ	ETF	55.12	55.2	54.04	54.23	15591748.0
2011-09-29 11:00:00	QQQ	ETF	54.223	54.62	54.1	54.4584	8682221.0
2011-09-29 12:00:00	QQQ	ETF	54.455	54.58	54.06	54.15	6195805.0
2011-09-29 13:00:00	QQQ	ETF	54.15	54.34	53.42	53.58	14626884.0
2011-09-29 14:00:00	QQQ	ETF	53.58	53.65	52.97	53.32	22297150.0
2011-09-29 15:00:00	QQQ	ETF	53.32	53.9291	53.0	53.91	19760119.0
2011-09-29 16:00:00	QQQ	ETF	53.91	54.06	53.7797	53.98	1570202.0
2011-09-29 17:00:00	QQQ	ETF	53.98	54.04	53.98	54.0	30221.0
2011-09-29 18:00:00	QQQ	ETF	54.0	54.08	54.0	54.01	29826.0
2011-09-29 19:00:00	QQQ	ETF	54.0	54.0	53.95	54.0	60320.0
2011-09-29 04:00:00	IWM	ETF	66.22	66.34	66.18	66.28	3057.0
2011-09-29 05:00:00	IWM	ETF	66.12	66.12	66.12	66.12	1600.0
2011-09-29 06:00:00	IWM	ETF	66.1	66.1	66.1	66.1	200.0
2011-09-29 07:00:00	IWM	ETF	65.9	66.05	65.78	65.93	26682.0
2011-09-29 08:00:00	IWM	ETF	65.95	66.73	65.89	66.61	1219892.0
2011-09-29 09:00:00	IWM	ETF	66.61	67.02	66.38	66.42	11117471.0
2011-09-29 10:00:00	IWM	ETF	66.43	66.61	65.35	65.62	11181476.0
2011-09-29 11:00:00	IWM	ETF	65.62	66.32	65.471	66.0899	5967354.0
2011-09-29 12:00:00	IWM	ETF	66.08	66.35	65.53	65.69	4055232.0
2011-09-29 13:00:00	IWM	ETF	65.67	65.92	64.701	65.03	6835014.0
2011-09-29 14:00:00	IWM	ETF	65.03	65.15	64.37	64.99	10499907.0
2011-09-29 15:00:00	IWM	ETF	64.99	66.34	64.44	66.32	19008754.0
2011-09-29 16:00:00	IWM	ETF	66.32	66.66	64.9	66.57	2110306.0
2011-09-29 17:00:00	IWM	ETF	66.54	66.63	66.53	66.53	31125.0
2011-09-29 18:00:00	IWM	ETF	66.52	66.62	66.5	66.5	55994.0
2011-09-29 19:00:00	IWM	ETF	66.5	66.51	66.42	66.49	3000.0
2011-09-29 05:00:00	DIA	ETF	111.35	111.4	111.35	111.4	1000.0
2011-09-29 06:00:00	DIA	ETF	111.45	111.5	111.32	111.32	1600.0

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

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