PREVIEW / etf_1hour / 2012-09-18

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-09-18.parquet
  size:    186 KB
  rows:    5,872

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
2012-09-18 04:00:00	SPY	ETF	146.57	146.57	146.29	146.42	71840.0
2012-09-18 05:00:00	SPY	ETF	146.32	146.38	146.22	146.24	27765.0
2012-09-18 06:00:00	SPY	ETF	146.25	146.45	146.25	146.45	24000.0
2012-09-18 07:00:00	SPY	ETF	146.44	146.6	146.38	146.58	407522.0
2012-09-18 08:00:00	SPY	ETF	146.59	146.99	146.4	146.63	1401805.0
2012-09-18 09:00:00	SPY	ETF	146.63	146.66	146.25	146.51	14848984.0
2012-09-18 10:00:00	SPY	ETF	146.5	146.66	146.35	146.6401	18055447.0
2012-09-18 11:00:00	SPY	ETF	146.64	146.81	146.49	146.53	10560570.0
2012-09-18 12:00:00	SPY	ETF	146.531	146.5799	146.28	146.45	9530966.0
2012-09-18 13:00:00	SPY	ETF	146.45	146.55	146.27	146.34	8461556.0
2012-09-18 14:00:00	SPY	ETF	146.34	146.47	146.29	146.4	5502235.0
2012-09-18 15:00:00	SPY	ETF	146.39	146.65	146.35	146.62	16036085.0
2012-09-18 16:00:00	SPY	ETF	146.63	146.77	146.4741	146.74	11888788.0
2012-09-18 17:00:00	SPY	ETF	146.74	146.78	146.7	146.77	99281.0
2012-09-18 18:00:00	SPY	ETF	146.75	146.75	146.7	146.73	17424.0
2012-09-18 19:00:00	SPY	ETF	146.71	146.76	146.7	146.7	15738.0
2012-09-18 05:00:00	QQQ	ETF	69.92	69.92	69.92	69.92	100.0
2012-09-18 06:00:00	QQQ	ETF	69.92	70.02	69.92	70.02	25200.0
2012-09-18 07:00:00	QQQ	ETF	70.02	70.08	70.0	70.08	15091.0
2012-09-18 08:00:00	QQQ	ETF	69.92	70.14	69.92	70.08	69059.0
2012-09-18 09:00:00	QQQ	ETF	70.08	70.26	70.02	70.23	4824506.0
2012-09-18 10:00:00	QQQ	ETF	70.23	70.3	70.1	70.22	4474810.0
2012-09-18 11:00:00	QQQ	ETF	70.22	70.28	70.18	70.2	2911493.0
2012-09-18 12:00:00	QQQ	ETF	70.2	70.23	70.07	70.15	2598020.0
2012-09-18 13:00:00	QQQ	ETF	70.15	70.21	70.08	70.14	1582992.0
2012-09-18 14:00:00	QQQ	ETF	70.15	70.22	70.12	70.16	1531682.0
2012-09-18 15:00:00	QQQ	ETF	70.16	70.26	70.14	70.26	4389137.0
2012-09-18 16:00:00	QQQ	ETF	70.26	70.28	70.17	70.28	465392.0
2012-09-18 17:00:00	QQQ	ETF	70.24	70.3	70.24	70.3	6331.0
2012-09-18 18:00:00	QQQ	ETF	70.29	70.3	70.29	70.3	400.0
2012-09-18 19:00:00	QQQ	ETF	70.29	70.3	70.29	70.29	11296.0
2012-09-18 05:00:00	IWM	ETF	85.75	85.75	85.75	85.75	400.0
2012-09-18 06:00:00	IWM	ETF	85.62	85.62	85.62	85.62	100.0
2012-09-18 07:00:00	IWM	ETF	85.74	85.83	85.74	85.83	37440.0
2012-09-18 08:00:00	IWM	ETF	85.89	85.93	85.72	85.84	746314.0
2012-09-18 09:00:00	IWM	ETF	85.84	85.9	85.53	85.71	3731373.0
2012-09-18 10:00:00	IWM	ETF	85.71	85.87	85.6	85.76	3748954.0
2012-09-18 11:00:00	IWM	ETF	85.76	85.84	85.62	85.66	2378241.0
2012-09-18 12:00:00	IWM	ETF	85.66	85.69	85.39	85.53	3022118.0
2012-09-18 13:00:00	IWM	ETF	85.53	85.61	85.36	85.48	1806433.0
2012-09-18 14:00:00	IWM	ETF	85.48	85.6	85.42	85.54	2417038.0
2012-09-18 15:00:00	IWM	ETF	85.54	85.75	85.52	85.74	8350100.0
2012-09-18 16:00:00	IWM	ETF	85.74	85.88	85.69	85.88	2287225.0
2012-09-18 17:00:00	IWM	ETF	85.89	85.9	85.76	85.89	16800.0
2012-09-18 18:00:00	IWM	ETF	85.84	85.85	85.81	85.81	2421.0
2012-09-18 19:00:00	IWM	ETF	85.85	85.85	85.85	85.85	100.0
2012-09-18 07:00:00	DIA	ETF	135.2	135.2	135.2	135.2	300.0
2012-09-18 08:00:00	DIA	ETF	135.25	135.34	135.14	135.34	6300.0
2012-09-18 09:00:00	DIA	ETF	135.29	135.451	135.13	135.41	864978.0
2012-09-18 10:00:00	DIA	ETF	135.45	135.68	135.385	135.67	536576.0

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

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