PREVIEW / etf_1hour / 2012-08-14

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-08-14.parquet
  size:    178 KB
  rows:    5,537

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-14 04:00:00	SPY	ETF	141.3	141.33	141.18	141.18	13750.0
2012-08-14 05:00:00	SPY	ETF	141.22	141.28	141.16	141.16	4110.0
2012-08-14 06:00:00	SPY	ETF	141.16	141.23	141.16	141.22	1510.0
2012-08-14 07:00:00	SPY	ETF	141.12	141.17	141.0	141.17	113900.0
2012-08-14 08:00:00	SPY	ETF	141.16	141.57	141.11	141.32	2120971.0
2012-08-14 09:00:00	SPY	ETF	141.31	141.42	140.85	141.0	13135452.0
2012-08-14 10:00:00	SPY	ETF	141.005	141.2	140.82	141.07	18356669.0
2012-08-14 11:00:00	SPY	ETF	141.07	141.31	141.04	141.2	9068905.0
2012-08-14 12:00:00	SPY	ETF	141.21	141.27	140.9	140.99	11508890.0
2012-08-14 13:00:00	SPY	ETF	141.0	141.07	140.84	140.98	7570451.0
2012-08-14 14:00:00	SPY	ETF	140.975	141.07	140.87	141.06	7412401.0
2012-08-14 15:00:00	SPY	ETF	141.05	141.07	140.37	140.76	20100888.0
2012-08-14 16:00:00	SPY	ETF	140.77	140.9412	140.6	140.68	12392247.0
2012-08-14 17:00:00	SPY	ETF	140.71	140.71	140.64	140.68	40613.0
2012-08-14 18:00:00	SPY	ETF	140.68	140.7	140.63	140.64	69680.0
2012-08-14 19:00:00	SPY	ETF	140.63	140.66	140.57	140.66	99980.0
2012-08-14 05:00:00	QQQ	ETF	67.17	67.17	67.17	67.17	3000.0
2012-08-14 06:00:00	QQQ	ETF	67.2	67.2	67.15	67.15	300.0
2012-08-14 07:00:00	QQQ	ETF	67.1	67.18	67.1	67.15	46985.0
2012-08-14 08:00:00	QQQ	ETF	67.16	67.58	67.1	67.31	276104.0
2012-08-14 09:00:00	QQQ	ETF	67.32	67.36	67.13	67.2501	4027822.0
2012-08-14 10:00:00	QQQ	ETF	67.25	67.33	67.11	67.32	3695886.0
2012-08-14 11:00:00	QQQ	ETF	67.32	67.41	67.29	67.3199	2462212.0
2012-08-14 12:00:00	QQQ	ETF	67.313	67.35	67.06	67.1455	1882280.0
2012-08-14 13:00:00	QQQ	ETF	67.15	67.24	67.08	67.19	1383294.0
2012-08-14 14:00:00	QQQ	ETF	67.1992	67.22	67.088	67.21	1463855.0
2012-08-14 15:00:00	QQQ	ETF	67.21	67.22	66.86	67.03	4901907.0
2012-08-14 16:00:00	QQQ	ETF	67.03	67.0779	66.91	66.92	3599447.0
2012-08-14 17:00:00	QQQ	ETF	66.97	67.01	66.94	66.94	5980.0
2012-08-14 18:00:00	QQQ	ETF	66.96	66.98	66.96	66.96	10900.0
2012-08-14 19:00:00	QQQ	ETF	66.95	66.97	66.92	66.96	14600.0
2012-08-14 04:00:00	IWM	ETF	80.15	80.27	80.15	80.27	227.0
2012-08-14 05:00:00	IWM	ETF	80.0	80.2	80.0	80.2	300.0
2012-08-14 06:00:00	IWM	ETF	80.3	80.3	80.13	80.13	1100.0
2012-08-14 07:00:00	IWM	ETF	80.19	80.2	80.15	80.2	2400.0
2012-08-14 08:00:00	IWM	ETF	80.18	80.48	80.12	80.34	332953.0
2012-08-14 09:00:00	IWM	ETF	80.35	80.42	79.905	80.02	3845457.0
2012-08-14 10:00:00	IWM	ETF	80.025	80.11	79.78	80.01	4094589.0
2012-08-14 11:00:00	IWM	ETF	80.01	80.13	79.95	80.02	3203004.0
2012-08-14 12:00:00	IWM	ETF	80.015	80.03	79.71	79.78	2057834.0
2012-08-14 13:00:00	IWM	ETF	79.78	79.82	79.65	79.71	1255157.0
2012-08-14 14:00:00	IWM	ETF	79.71	79.81	79.68	79.785	1816775.0
2012-08-14 15:00:00	IWM	ETF	79.78	79.8	79.27	79.595	7602288.0
2012-08-14 16:00:00	IWM	ETF	79.59	79.66	79.3657	79.57	911847.0
2012-08-14 17:00:00	IWM	ETF	79.59	79.6	79.58	79.58	3832.0
2012-08-14 18:00:00	IWM	ETF	79.57	79.57	79.57	79.57	5800.0
2012-08-14 19:00:00	IWM	ETF	79.52	79.53	79.51	79.53	1599.0
2012-08-14 08:00:00	DIA	ETF	131.95	132.17	131.91	131.98	13000.0
2012-08-14 09:00:00	DIA	ETF	132.1	132.16	131.66	131.81	599858.0
2012-08-14 10:00:00	DIA	ETF	131.79	131.99	131.7	131.86	677820.0

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

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