PREVIEW / etf_1hour / 2013-02-26

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-02-26.parquet
  size:    201 KB
  rows:    6,266

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-26 04:00:00	SPY	ETF	149.47	149.71	149.39	149.7	31235.0
2013-02-26 05:00:00	SPY	ETF	149.51	149.59	149.34	149.4	25600.0
2013-02-26 06:00:00	SPY	ETF	149.38	149.54	149.37	149.38	116719.0
2013-02-26 07:00:00	SPY	ETF	149.35	149.67	149.28	149.61	609973.0
2013-02-26 08:00:00	SPY	ETF	149.59	149.85	149.37	149.81	1226767.0
2013-02-26 09:00:00	SPY	ETF	149.81	149.99	149.6	149.92	21502358.0
2013-02-26 10:00:00	SPY	ETF	149.92	150.14	149.06	149.4	48978691.0
2013-02-26 11:00:00	SPY	ETF	149.405	149.46	148.73	149.0999	26511210.0
2013-02-26 12:00:00	SPY	ETF	149.1	149.72	149.01	149.65	19375528.0
2013-02-26 13:00:00	SPY	ETF	149.65	149.89	149.32	149.73	16595566.0
2013-02-26 14:00:00	SPY	ETF	149.73	150.13	149.67	149.88	15801043.0
2013-02-26 15:00:00	SPY	ETF	149.88	150.2	149.68	150.01	24959665.0
2013-02-26 16:00:00	SPY	ETF	150.01	150.05	148.87	149.74	6916886.0
2013-02-26 17:00:00	SPY	ETF	149.75	150.02	149.67	149.73	1854513.0
2013-02-26 18:00:00	SPY	ETF	149.74	149.8	149.69	149.72	98028.0
2013-02-26 19:00:00	SPY	ETF	149.72	149.85	149.6	149.67	194251.0
2013-02-26 04:00:00	QQQ	ETF	66.38	66.38	66.38	66.38	100.0
2013-02-26 05:00:00	QQQ	ETF	66.46	66.46	66.39	66.39	300.0
2013-02-26 06:00:00	QQQ	ETF	66.41	66.41	66.39	66.39	1000.0
2013-02-26 07:00:00	QQQ	ETF	66.35	66.47	66.35	66.44	35490.0
2013-02-26 08:00:00	QQQ	ETF	66.43	66.49	66.35	66.49	142790.0
2013-02-26 09:00:00	QQQ	ETF	66.5	66.53	66.28	66.508	4784122.0
2013-02-26 10:00:00	QQQ	ETF	66.51	66.68	66.18	66.36	9657413.0
2013-02-26 11:00:00	QQQ	ETF	66.34	66.38	65.96	66.072	8219665.0
2013-02-26 12:00:00	QQQ	ETF	66.079	66.3201	66.02	66.26	3447778.0
2013-02-26 13:00:00	QQQ	ETF	66.26	66.55	66.1501	66.47	5852661.0
2013-02-26 14:00:00	QQQ	ETF	66.46	66.6	66.41	66.53	2428157.0
2013-02-26 15:00:00	QQQ	ETF	66.53	66.655	66.4	66.56	5199618.0
2013-02-26 16:00:00	QQQ	ETF	66.56	66.56	66.233	66.52	1264563.0
2013-02-26 17:00:00	QQQ	ETF	66.52	66.52	66.48	66.48	1900.0
2013-02-26 18:00:00	QQQ	ETF	66.5	66.52	66.5	66.51	2600.0
2013-02-26 19:00:00	QQQ	ETF	66.52	66.54	66.47	66.47	13300.0
2013-02-26 04:00:00	IWM	ETF	89.3	89.4	89.3	89.4	1000.0
2013-02-26 07:00:00	IWM	ETF	89.22	89.45	89.21	89.42	76715.0
2013-02-26 08:00:00	IWM	ETF	89.42	89.46	89.22	89.46	192652.0
2013-02-26 09:00:00	IWM	ETF	89.45	89.54	89.12	89.35	4384924.0
2013-02-26 10:00:00	IWM	ETF	89.35	89.78	88.87	89.23	8917874.0
2013-02-26 11:00:00	IWM	ETF	89.23	89.23	88.79	88.9	7006574.0
2013-02-26 12:00:00	IWM	ETF	88.89	89.36	88.828	89.2501	3519885.0
2013-02-26 13:00:00	IWM	ETF	89.25	89.53	89.13	89.438	4125442.0
2013-02-26 14:00:00	IWM	ETF	89.43	89.7	89.38	89.53	3537074.0
2013-02-26 15:00:00	IWM	ETF	89.54	89.64	89.33	89.36	6741442.0
2013-02-26 16:00:00	IWM	ETF	89.38	89.4246	89.13	89.2	1503590.0
2013-02-26 17:00:00	IWM	ETF	89.2	89.2	89.15	89.15	37248.0
2013-02-26 18:00:00	IWM	ETF	89.15	89.2	89.15	89.2	7500.0
2013-02-26 19:00:00	IWM	ETF	89.2	89.24	89.19	89.19	18463.0
2013-02-26 04:00:00	DIA	ETF	138.17	138.2	138.15	138.2	1000.0
2013-02-26 07:00:00	DIA	ETF	138.09	138.23	138.09	138.23	3800.0
2013-02-26 08:00:00	DIA	ETF	138.17	138.28	138.07	138.28	19888.0
2013-02-26 09:00:00	DIA	ETF	138.31	138.74	138.26	138.74	1183396.0

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

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