PREVIEW / etf_1hour / 2011-08-22

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-08-22.parquet
  size:    188 KB
  rows:    5,813

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-08-22 04:00:00	SPY	ETF	113.5	114.02	113.5	113.93	18054.0
2011-08-22 05:00:00	SPY	ETF	114.0	114.08	113.8	113.8	5113.0
2011-08-22 06:00:00	SPY	ETF	113.67	114.24	113.62	114.13	61640.0
2011-08-22 07:00:00	SPY	ETF	114.13	114.85	114.08	114.73	1474966.0
2011-08-22 08:00:00	SPY	ETF	112.8	114.89	112.8	114.76	4121917.0
2011-08-22 09:00:00	SPY	ETF	114.77	115.23	114.08	114.17	33381504.0
2011-08-22 10:00:00	SPY	ETF	114.16	114.42	113.41	113.43	40720338.0
2011-08-22 11:00:00	SPY	ETF	113.44	113.66	112.46	112.7199	40445156.0
2011-08-22 12:00:00	SPY	ETF	112.7178	113.78	112.67	113.75	27478871.0
2011-08-22 13:00:00	SPY	ETF	113.72	113.94	112.95	113.3401	24870332.0
2011-08-22 14:00:00	SPY	ETF	113.33	113.71	112.6847	112.81	29493227.0
2011-08-22 15:00:00	SPY	ETF	112.82	113.35	112.41	112.77	53956379.0
2011-08-22 16:00:00	SPY	ETF	112.76	113.4654	112.67	112.88	12976961.0
2011-08-22 17:00:00	SPY	ETF	112.87	112.95	112.82	112.88	217671.0
2011-08-22 18:00:00	SPY	ETF	112.88	112.9	112.73	112.86	105725.0
2011-08-22 19:00:00	SPY	ETF	112.86	112.87	112.6	112.73	279132.0
2011-08-22 04:00:00	QQQ	ETF	50.67	50.76	50.6	50.7	1542.0
2011-08-22 05:00:00	QQQ	ETF	50.73	50.76	50.65	50.65	1076.0
2011-08-22 06:00:00	QQQ	ETF	50.78	50.84	50.72	50.84	4700.0
2011-08-22 07:00:00	QQQ	ETF	50.8	51.13	50.78	51.11	211818.0
2011-08-22 08:00:00	QQQ	ETF	51.08	51.14	50.86	51.1	461488.0
2011-08-22 09:00:00	QQQ	ETF	51.09	51.25	50.78	50.82	8129514.0
2011-08-22 10:00:00	QQQ	ETF	50.82	51.08	50.54	50.55	11824822.0
2011-08-22 11:00:00	QQQ	ETF	50.55	50.65	50.06	50.14	13087302.0
2011-08-22 12:00:00	QQQ	ETF	50.13	50.74	50.1	50.7	9581953.0
2011-08-22 13:00:00	QQQ	ETF	50.7	50.8001	50.11	50.44	6267751.0
2011-08-22 14:00:00	QQQ	ETF	50.44	50.625	50.15	50.16	7253729.0
2011-08-22 15:00:00	QQQ	ETF	50.16	50.49	50.091	50.2	12316269.0
2011-08-22 16:00:00	QQQ	ETF	50.19	50.35	50.19	50.25	1092098.0
2011-08-22 17:00:00	QQQ	ETF	50.28	50.33	50.25	50.29	92854.0
2011-08-22 18:00:00	QQQ	ETF	50.29	50.29	50.25	50.25	90301.0
2011-08-22 19:00:00	QQQ	ETF	50.25	50.25	50.16	50.17	55740.0
2011-08-22 04:00:00	IWM	ETF	65.99	66.22	65.99	66.22	890.0
2011-08-22 05:00:00	IWM	ETF	66.15	66.3	66.15	66.3	10903.0
2011-08-22 06:00:00	IWM	ETF	66.25	66.5	66.25	66.5	2400.0
2011-08-22 07:00:00	IWM	ETF	66.52	66.96	66.5	66.93	38873.0
2011-08-22 08:00:00	IWM	ETF	66.97	67.06	66.55	66.96	785281.0
2011-08-22 09:00:00	IWM	ETF	66.95	67.19	66.03	66.13	7542081.0
2011-08-22 10:00:00	IWM	ETF	66.13	66.35	65.6	65.64	8377991.0
2011-08-22 11:00:00	IWM	ETF	65.62	65.8	64.57	64.72	11635136.0
2011-08-22 12:00:00	IWM	ETF	64.73	65.79	64.6802	65.74	7534465.0
2011-08-22 13:00:00	IWM	ETF	65.74	65.93	65.07	65.43	5602958.0
2011-08-22 14:00:00	IWM	ETF	65.42	65.61	65.06	65.0612	5200385.0
2011-08-22 15:00:00	IWM	ETF	65.062	65.4	64.87	65.13	11494409.0
2011-08-22 16:00:00	IWM	ETF	65.13	65.25	65.04	65.15	6297892.0
2011-08-22 17:00:00	IWM	ETF	65.12	65.28	65.12	65.23	17564.0
2011-08-22 18:00:00	IWM	ETF	65.26	65.26	65.1	65.15	1140.0
2011-08-22 19:00:00	IWM	ETF	65.1	65.1	65.05	65.05	2800.0
2011-08-22 06:00:00	DIA	ETF	109.15	109.15	109.15	109.15	500.0
2011-08-22 07:00:00	DIA	ETF	109.24	109.65	109.24	109.65	5716.0

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

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