PREVIEW / etf_1hour / 2012-08-07

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-08-07.parquet
  size:    186 KB
  rows:    5,782

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-08-07 04:00:00	SPY	ETF	140.02	140.02	139.89	139.89	591.0
2012-08-07 05:00:00	SPY	ETF	139.9	139.91	139.75	139.83	8500.0
2012-08-07 06:00:00	SPY	ETF	139.69	140.02	139.65	140.0	47825.0
2012-08-07 07:00:00	SPY	ETF	140.0	140.18	139.95	140.06	296396.0
2012-08-07 08:00:00	SPY	ETF	140.05	140.37	140.04	140.14	1335759.0
2012-08-07 09:00:00	SPY	ETF	140.14	140.48	140.1	140.42	13369508.0
2012-08-07 10:00:00	SPY	ETF	140.43	140.66	140.34	140.535	17311818.0
2012-08-07 11:00:00	SPY	ETF	140.54	140.83	140.34	140.791	16989780.0
2012-08-07 12:00:00	SPY	ETF	140.795	140.92	140.73	140.81	9752816.0
2012-08-07 13:00:00	SPY	ETF	140.82	140.86	140.74	140.76	7313019.0
2012-08-07 14:00:00	SPY	ETF	140.77	140.79	140.56	140.58	7149393.0
2012-08-07 15:00:00	SPY	ETF	140.59	140.6	140.26	140.29	20970708.0
2012-08-07 16:00:00	SPY	ETF	140.3	140.44	140.2	140.31	12889962.0
2012-08-07 17:00:00	SPY	ETF	140.3	140.32	140.2	140.21	165810.0
2012-08-07 18:00:00	SPY	ETF	140.24	140.32	140.2	140.31	43429.0
2012-08-07 19:00:00	SPY	ETF	140.31	140.31	140.18	140.21	67350.0
2012-08-07 04:00:00	QQQ	ETF	66.38	66.43	66.38	66.43	3098.0
2012-08-07 05:00:00	QQQ	ETF	66.37	66.39	66.34	66.34	1100.0
2012-08-07 06:00:00	QQQ	ETF	66.39	66.4	66.38	66.38	2700.0
2012-08-07 07:00:00	QQQ	ETF	66.39	66.43	66.38	66.39	75305.0
2012-08-07 08:00:00	QQQ	ETF	66.4	66.52	66.38	66.41	131692.0
2012-08-07 09:00:00	QQQ	ETF	66.41	66.52	66.28	66.44	3823455.0
2012-08-07 10:00:00	QQQ	ETF	66.44	66.64	66.4	66.6	4666070.0
2012-08-07 11:00:00	QQQ	ETF	66.6	66.84	66.47	66.81	5015330.0
2012-08-07 12:00:00	QQQ	ETF	66.8192	66.92	66.78	66.839	3577488.0
2012-08-07 13:00:00	QQQ	ETF	66.83	66.85	66.76	66.81	1448510.0
2012-08-07 14:00:00	QQQ	ETF	66.8	66.83	66.72	66.77	1641500.0
2012-08-07 15:00:00	QQQ	ETF	66.765	66.77	66.595	66.64	4926299.0
2012-08-07 16:00:00	QQQ	ETF	66.64	66.72	66.51	66.6	1280059.0
2012-08-07 17:00:00	QQQ	ETF	66.6	66.66	66.53	66.59	36487.0
2012-08-07 18:00:00	QQQ	ETF	66.55	66.59	66.53	66.59	25145.0
2012-08-07 19:00:00	QQQ	ETF	66.6	66.6	66.55	66.55	20640.0
2012-08-07 04:00:00	IWM	ETF	79.74	79.83	79.74	79.83	2819.0
2012-08-07 05:00:00	IWM	ETF	79.6	79.6	79.51	79.51	1480.0
2012-08-07 07:00:00	IWM	ETF	79.8	79.95	79.8	79.9	93941.0
2012-08-07 08:00:00	IWM	ETF	79.85	80.05	79.82	79.89	388317.0
2012-08-07 09:00:00	IWM	ETF	79.87	79.98	79.64	79.82	4521192.0
2012-08-07 10:00:00	IWM	ETF	79.83	80.26	79.74	80.08	6627417.0
2012-08-07 11:00:00	IWM	ETF	80.08	80.44	79.87	80.39	5345918.0
2012-08-07 12:00:00	IWM	ETF	80.38	80.57	80.3	80.39	5191803.0
2012-08-07 13:00:00	IWM	ETF	80.38	80.42	80.29	80.33	2841964.0
2012-08-07 14:00:00	IWM	ETF	80.34	80.3501	80.17	80.2	2269956.0
2012-08-07 15:00:00	IWM	ETF	80.2	80.22	79.86	79.94	8097864.0
2012-08-07 16:00:00	IWM	ETF	79.93	79.99	79.2579	79.98	2502157.0
2012-08-07 17:00:00	IWM	ETF	79.99	80.0	79.92	79.92	700.0
2012-08-07 18:00:00	IWM	ETF	79.9	80.0	79.9	80.0	300.0
2012-08-07 08:00:00	DIA	ETF	131.31	131.46	131.28	131.4	12095.0
2012-08-07 09:00:00	DIA	ETF	131.29	131.6	131.29	131.57	434481.0
2012-08-07 10:00:00	DIA	ETF	131.58	131.78	131.5	131.66	824462.0
2012-08-07 11:00:00	DIA	ETF	131.67	131.82	131.4401	131.75	486512.0

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

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