PREVIEW / etf_1hour / 2012-05-04

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-05-04.parquet
  size:    186 KB
  rows:    5,754

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-05-04 04:00:00	SPY	ETF	139.25	139.25	138.97	138.97	1850.0
2012-05-04 05:00:00	SPY	ETF	138.89	139.08	138.89	138.95	6750.0
2012-05-04 06:00:00	SPY	ETF	138.91	139.36	138.91	139.36	11050.0
2012-05-04 07:00:00	SPY	ETF	139.35	139.4	139.03	139.1	306761.0
2012-05-04 08:00:00	SPY	ETF	139.1	139.43	138.36	138.77	9389436.0
2012-05-04 09:00:00	SPY	ETF	138.77	138.86	137.97	138.08	25930650.0
2012-05-04 10:00:00	SPY	ETF	138.07	138.11	137.51	137.825	29388734.0
2012-05-04 11:00:00	SPY	ETF	137.82	137.84	137.12	137.165	24084218.0
2012-05-04 12:00:00	SPY	ETF	137.16	137.4	136.93	137.2	16423489.0
2012-05-04 13:00:00	SPY	ETF	137.2	139.3012	137.09	137.344	15998850.0
2012-05-04 14:00:00	SPY	ETF	137.345	137.35	136.92	137.15	16112957.0
2012-05-04 15:00:00	SPY	ETF	137.16	137.39	137.0	137.0	32237112.0
2012-05-04 16:00:00	SPY	ETF	137.02	139.3012	136.7	136.83	21907997.0
2012-05-04 17:00:00	SPY	ETF	136.85	136.86	136.62	136.65	625932.0
2012-05-04 18:00:00	SPY	ETF	136.64	136.68	136.32	136.32	329259.0
2012-05-04 19:00:00	SPY	ETF	136.32	136.51	136.27	136.48	105691.0
2012-05-04 07:00:00	QQQ	ETF	66.25	66.28	66.1	66.12	155105.0
2012-05-04 08:00:00	QQQ	ETF	66.13	66.27	65.85	65.96	6447331.0
2012-05-04 09:00:00	QQQ	ETF	65.96	65.99	65.43	65.4896	17435735.0
2012-05-04 10:00:00	QQQ	ETF	65.48	65.4905	65.15	65.4	13884148.0
2012-05-04 11:00:00	QQQ	ETF	65.39	65.4099	64.94	65.02	12284005.0
2012-05-04 12:00:00	QQQ	ETF	65.01	65.12	64.79	64.94	6206536.0
2012-05-04 13:00:00	QQQ	ETF	64.94	65.01	64.84	64.96	7201025.0
2012-05-04 14:00:00	QQQ	ETF	64.96	64.96	64.735	64.83	6799859.0
2012-05-04 15:00:00	QQQ	ETF	64.839	64.97	64.7	64.71	11339096.0
2012-05-04 16:00:00	QQQ	ETF	64.71	66.3524	64.51	64.54	8140237.0
2012-05-04 17:00:00	QQQ	ETF	64.57	64.63	64.5	64.5	19418.0
2012-05-04 18:00:00	QQQ	ETF	64.5	64.58	64.41	64.41	31263.0
2012-05-04 19:00:00	QQQ	ETF	64.45	64.5	64.33	64.43	18539.0
2012-05-04 06:00:00	IWM	ETF	80.93	80.95	80.93	80.95	4600.0
2012-05-04 07:00:00	IWM	ETF	80.82	80.99	80.75	80.76	53575.0
2012-05-04 08:00:00	IWM	ETF	80.75	81.03	80.21	80.37	1550434.0
2012-05-04 09:00:00	IWM	ETF	80.31	80.4	79.58	79.71	10941391.0
2012-05-04 10:00:00	IWM	ETF	79.71	79.71	79.16	79.44	10940795.0
2012-05-04 11:00:00	IWM	ETF	79.44	79.47	78.94	79.1	8717800.0
2012-05-04 12:00:00	IWM	ETF	79.1	79.28	78.97	79.17	5362756.0
2012-05-04 13:00:00	IWM	ETF	79.162	79.44	79.08	79.38	5366295.0
2012-05-04 14:00:00	IWM	ETF	79.3785	79.38	79.05	79.17	4504168.0
2012-05-04 15:00:00	IWM	ETF	79.17	79.27	79.07	79.07	8345188.0
2012-05-04 16:00:00	IWM	ETF	79.07	79.12	78.65	78.72	3089848.0
2012-05-04 17:00:00	IWM	ETF	78.74	78.75	78.66	78.66	7711.0
2012-05-04 18:00:00	IWM	ETF	78.66	78.7	78.64	78.64	1301.0
2012-05-04 19:00:00	IWM	ETF	78.61	78.7	78.55	78.68	3962.0
2012-05-04 07:00:00	DIA	ETF	131.81	131.81	131.81	131.81	200.0
2012-05-04 08:00:00	DIA	ETF	131.8	131.95	131.0	131.35	29770.0
2012-05-04 09:00:00	DIA	ETF	131.36	131.43	130.8	130.8793	783399.0
2012-05-04 10:00:00	DIA	ETF	130.87	130.92	130.4	130.68	1001250.0
2012-05-04 11:00:00	DIA	ETF	130.68	130.69	130.1	130.17	1143085.0
2012-05-04 12:00:00	DIA	ETF	130.15	130.38	129.97	130.18	626579.0
2012-05-04 13:00:00	DIA	ETF	130.2	130.33	130.09	130.309	263357.0

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

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