PREVIEW / etf_1hour / 2012-08-15

all etf 1-hour files

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

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-15 04:00:00	SPY	ETF	140.5	140.54	140.39	140.54	17549.0
2012-08-15 05:00:00	SPY	ETF	140.62	140.62	140.51	140.51	7451.0
2012-08-15 06:00:00	SPY	ETF	140.51	140.58	140.41	140.49	48500.0
2012-08-15 07:00:00	SPY	ETF	140.46	140.58	140.41	140.48	147921.0
2012-08-15 08:00:00	SPY	ETF	140.46	140.65	140.35	140.51	683023.0
2012-08-15 09:00:00	SPY	ETF	140.51	141.07	140.46	140.97	9857960.0
2012-08-15 10:00:00	SPY	ETF	140.97	141.08	140.69	140.879	15517655.0
2012-08-15 11:00:00	SPY	ETF	140.88	141.01	140.78	140.95	7634544.0
2012-08-15 12:00:00	SPY	ETF	140.96	141.04	140.9	140.96	4246086.0
2012-08-15 13:00:00	SPY	ETF	140.95	140.97	140.8	140.81	5291961.0
2012-08-15 14:00:00	SPY	ETF	140.81	141.19	140.76	141.0611	9945760.0
2012-08-15 15:00:00	SPY	ETF	141.065	141.11	140.85	140.92	12019722.0
2012-08-15 16:00:00	SPY	ETF	140.93	141.1307	140.7895	141.08	5143623.0
2012-08-15 17:00:00	SPY	ETF	141.08	141.08	140.98	141.05	66362.0
2012-08-15 18:00:00	SPY	ETF	141.04	141.06	140.98	141.06	38420.0
2012-08-15 19:00:00	SPY	ETF	141.02	141.06	141.0	141.04	39380.0
2012-08-15 06:00:00	QQQ	ETF	66.85	66.85	66.85	66.85	1533.0
2012-08-15 07:00:00	QQQ	ETF	66.92	66.94	66.87	66.9	17775.0
2012-08-15 08:00:00	QQQ	ETF	66.92	67.01	66.85	66.93	89345.0
2012-08-15 09:00:00	QQQ	ETF	66.95	67.24	66.93	67.19	3354504.0
2012-08-15 10:00:00	QQQ	ETF	67.19	67.23	67.02	67.18	3465466.0
2012-08-15 11:00:00	QQQ	ETF	67.18	67.29	67.14	67.275	1791831.0
2012-08-15 12:00:00	QQQ	ETF	67.279	67.3199	67.21	67.25	1721001.0
2012-08-15 13:00:00	QQQ	ETF	67.2411	67.25	67.08	67.087	1546997.0
2012-08-15 14:00:00	QQQ	ETF	67.09	67.25	67.05	67.22	2279566.0
2012-08-15 15:00:00	QQQ	ETF	67.23	67.29	67.16	67.21	2850473.0
2012-08-15 16:00:00	QQQ	ETF	67.23	67.41	67.0314	67.39	5501438.0
2012-08-15 17:00:00	QQQ	ETF	67.37	67.39	67.35	67.35	42184.0
2012-08-15 18:00:00	QQQ	ETF	67.36	67.38	67.34	67.38	13444.0
2012-08-15 19:00:00	QQQ	ETF	67.38	67.38	67.35	67.37	6350.0
2012-08-15 06:00:00	IWM	ETF	79.43	79.43	79.43	79.43	300.0
2012-08-15 07:00:00	IWM	ETF	79.38	79.4	79.28	79.28	12831.0
2012-08-15 08:00:00	IWM	ETF	79.28	79.72	78.7	79.27	160137.0
2012-08-15 09:00:00	IWM	ETF	79.26	79.92	79.25	79.84	3718361.0
2012-08-15 10:00:00	IWM	ETF	79.85	80.01	79.67	79.86	3453216.0
2012-08-15 11:00:00	IWM	ETF	79.855	80.05	79.82	79.97	2173282.0
2012-08-15 12:00:00	IWM	ETF	79.98	80.15	79.95	80.12	2632643.0
2012-08-15 13:00:00	IWM	ETF	80.13	80.15	80.01	80.03	1351647.0
2012-08-15 14:00:00	IWM	ETF	80.03	80.24	79.91	80.1689	4154411.0
2012-08-15 15:00:00	IWM	ETF	80.17	80.27	80.03	80.24	4820794.0
2012-08-15 16:00:00	IWM	ETF	80.25	80.45	80.22	80.44	1668399.0
2012-08-15 17:00:00	IWM	ETF	80.42	80.42	79.5524	79.5524	1516065.0
2012-08-15 18:00:00	IWM	ETF	80.35	80.4	80.35	80.4	9900.0
2012-08-15 19:00:00	IWM	ETF	80.41	80.41	80.36	80.41	8670.0
2012-08-15 07:00:00	DIA	ETF	131.36	131.36	131.36	131.36	425.0
2012-08-15 08:00:00	DIA	ETF	131.45	131.48	131.38	131.39	8400.0
2012-08-15 09:00:00	DIA	ETF	131.43	131.9	131.43	131.83	417427.0
2012-08-15 10:00:00	DIA	ETF	131.83	131.99	131.59	131.714	530922.0
2012-08-15 11:00:00	DIA	ETF	131.73	131.84	131.64	131.78	261153.0
2012-08-15 12:00:00	DIA	ETF	131.79	131.85	131.73	131.76	235143.0

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

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