PREVIEW / etf_1hour / 2011-02-04

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-02-04.parquet
  size:    175 KB
  rows:    5,318

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-02-04 04:00:00	SPY	ETF	130.72	130.79	130.71	130.79	3300.0
2011-02-04 05:00:00	SPY	ETF	130.82	130.82	130.81	130.81	600.0
2011-02-04 06:00:00	SPY	ETF	130.75	130.81	130.75	130.8	3400.0
2011-02-04 07:00:00	SPY	ETF	130.77	130.92	130.76	130.9	351295.0
2011-02-04 08:00:00	SPY	ETF	130.89	131.24	130.5	130.88	8224204.0
2011-02-04 09:00:00	SPY	ETF	130.89	131.02	130.43	130.77	18128664.0
2011-02-04 10:00:00	SPY	ETF	130.78	131.01	130.28	130.43	23477159.0
2011-02-04 11:00:00	SPY	ETF	130.43	130.75	130.23	130.6	17041377.0
2011-02-04 12:00:00	SPY	ETF	130.59	130.8	130.5	130.77	8900538.0
2011-02-04 13:00:00	SPY	ETF	130.77	131.0	130.73	130.97	11509741.0
2011-02-04 14:00:00	SPY	ETF	130.98	130.99	130.79	130.97	8986192.0
2011-02-04 15:00:00	SPY	ETF	130.97	131.2	130.87	131.15	23232038.0
2011-02-04 16:00:00	SPY	ETF	131.16	131.45	130.8075	131.14	12968331.0
2011-02-04 17:00:00	SPY	ETF	131.14	131.18	131.12	131.14	211377.0
2011-02-04 18:00:00	SPY	ETF	131.16	131.22	131.15	131.2	27515.0
2011-02-04 19:00:00	SPY	ETF	131.18	131.24	131.16	131.22	28558.0
2011-02-04 06:00:00	QQQ	ETF	57.06	57.07	57.06	57.07	3700.0
2011-02-04 07:00:00	QQQ	ETF	57.04	57.12	57.04	57.12	112241.0
2011-02-04 08:00:00	QQQ	ETF	57.09	57.44	56.92	57.08	2158504.0
2011-02-04 09:00:00	QQQ	ETF	57.09	57.18	56.9	57.1389	7472288.0
2011-02-04 10:00:00	QQQ	ETF	57.13	57.25	56.95	57.0301	6958650.0
2011-02-04 11:00:00	QQQ	ETF	57.02	57.13	56.93	57.0881	7295813.0
2011-02-04 12:00:00	QQQ	ETF	57.085	57.23	57.0698	57.22	1957792.0
2011-02-04 13:00:00	QQQ	ETF	57.2251	57.41	57.19	57.39	5749324.0
2011-02-04 14:00:00	QQQ	ETF	57.38	57.39	57.29	57.36	3390151.0
2011-02-04 15:00:00	QQQ	ETF	57.35	57.42	57.31	57.38	7035121.0
2011-02-04 16:00:00	QQQ	ETF	57.38	57.47	57.37	57.42	2233626.0
2011-02-04 17:00:00	QQQ	ETF	57.43	57.47	57.43	57.47	25180.0
2011-02-04 18:00:00	QQQ	ETF	57.45	57.46	57.44	57.45	22593.0
2011-02-04 19:00:00	QQQ	ETF	57.46	57.47	57.43	57.43	40308.0
2011-02-04 04:00:00	IWM	ETF	79.69	79.69	79.69	79.69	2500.0
2011-02-04 07:00:00	IWM	ETF	79.72	79.81	79.72	79.79	5200.0
2011-02-04 08:00:00	IWM	ETF	79.79	79.97	79.51	79.66	1296139.0
2011-02-04 09:00:00	IWM	ETF	79.65	79.76	79.39	79.72	4204234.0
2011-02-04 10:00:00	IWM	ETF	79.72	79.93	79.32	79.4	8167377.0
2011-02-04 11:00:00	IWM	ETF	79.39	79.58	79.24	79.4	7085503.0
2011-02-04 12:00:00	IWM	ETF	79.41	79.72	79.33	79.6728	2207117.0
2011-02-04 13:00:00	IWM	ETF	79.68	79.97	79.64	79.93	2635039.0
2011-02-04 14:00:00	IWM	ETF	79.94	79.95	79.63	79.8181	3513157.0
2011-02-04 15:00:00	IWM	ETF	79.81	79.94	79.76	79.83	6208500.0
2011-02-04 16:00:00	IWM	ETF	79.84	79.93	79.78	79.89	1041433.0
2011-02-04 17:00:00	IWM	ETF	79.9	79.96	79.87	79.9	18180.0
2011-02-04 18:00:00	IWM	ETF	79.9	79.91	79.89	79.91	5000.0
2011-02-04 19:00:00	IWM	ETF	79.85	79.94	79.85	79.94	2070.0
2011-02-04 07:00:00	DIA	ETF	120.5	120.5	120.5	120.5	100.0
2011-02-04 08:00:00	DIA	ETF	120.49	120.72	120.23	120.43	301770.0
2011-02-04 09:00:00	DIA	ETF	120.46	120.53	120.13	120.35	845471.0
2011-02-04 10:00:00	DIA	ETF	120.34	120.55	120.05	120.17	1021117.0
2011-02-04 11:00:00	DIA	ETF	120.16	120.36	120.02	120.2481	784262.0
2011-02-04 12:00:00	DIA	ETF	120.24	120.39	120.18	120.37	174457.0

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

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