PREVIEW / etf_1hour / 2011-08-09

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-08-09.parquet
  size:    205 KB
  rows:    6,336

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-09 04:00:00	SPY	ETF	111.6	113.09	110.66	111.77	65923.0
2011-08-09 05:00:00	SPY	ETF	111.6	112.22	110.21	111.86	146399.0
2011-08-09 06:00:00	SPY	ETF	111.84	113.09	111.66	113.03	824856.0
2011-08-09 07:00:00	SPY	ETF	113.03	114.17	112.57	113.48	6028859.0
2011-08-09 08:00:00	SPY	ETF	113.44	114.5	112.26	113.18	10942978.0
2011-08-09 09:00:00	SPY	ETF	113.18	114.31	112.14	114.14	76150242.0
2011-08-09 10:00:00	SPY	ETF	114.14	115.3	114.05	114.89	93601681.0
2011-08-09 11:00:00	SPY	ETF	114.9	115.37	113.94	115.22	54113110.0
2011-08-09 12:00:00	SPY	ETF	115.23	115.46	114.62	114.6201	32769248.0
2011-08-09 13:00:00	SPY	ETF	114.62	114.91	113.51	113.93	37945228.0
2011-08-09 14:00:00	SPY	ETF	113.93	114.93	110.27	111.895	177613714.0
2011-08-09 15:00:00	SPY	ETF	111.89	117.5	111.28	117.47	139902352.0
2011-08-09 16:00:00	SPY	ETF	117.46	118.02	112.1405	117.82	55224557.0
2011-08-09 17:00:00	SPY	ETF	117.82	118.43	111.09	118.22	11664095.0
2011-08-09 18:00:00	SPY	ETF	118.24	118.38	117.37	118.31	15543522.0
2011-08-09 19:00:00	SPY	ETF	118.33	118.33	118.07	118.16	247015.0
2011-08-09 04:00:00	QQQ	ETF	50.45	50.6	49.8	50.23	2062.0
2011-08-09 05:00:00	QQQ	ETF	49.85	50.4	49.54	50.12	7993.0
2011-08-09 06:00:00	QQQ	ETF	50.31	50.71	50.17	50.71	18766.0
2011-08-09 07:00:00	QQQ	ETF	50.6	51.23	50.56	50.94	598153.0
2011-08-09 08:00:00	QQQ	ETF	50.93	51.05	50.6	50.9	1349486.0
2011-08-09 09:00:00	QQQ	ETF	50.9	51.7	50.67	51.69	23665453.0
2011-08-09 10:00:00	QQQ	ETF	51.69	52.23	51.63	52.07	26645918.0
2011-08-09 11:00:00	QQQ	ETF	52.06	52.295	51.6	52.21	13274373.0
2011-08-09 12:00:00	QQQ	ETF	52.2007	52.3699	51.8297	51.97	9929980.0
2011-08-09 13:00:00	QQQ	ETF	51.96	52.1	51.4	51.641	10900640.0
2011-08-09 14:00:00	QQQ	ETF	51.64	52.11	49.93	50.82	53325262.0
2011-08-09 15:00:00	QQQ	ETF	50.82	53.07	50.51	53.06	32745895.0
2011-08-09 16:00:00	QQQ	ETF	53.06	53.11	52.72	53.05	5915912.0
2011-08-09 17:00:00	QQQ	ETF	53.05	53.36	53.05	53.3	153101.0
2011-08-09 18:00:00	QQQ	ETF	53.25	53.27	53.18	53.23	45532.0
2011-08-09 19:00:00	QQQ	ETF	53.25	53.25	53.1	53.12	56537.0
2011-08-09 04:00:00	IWM	ETF	65.3	65.84	64.46	65.11	4921.0
2011-08-09 05:00:00	IWM	ETF	64.39	65.31	64.39	65.31	1100.0
2011-08-09 06:00:00	IWM	ETF	64.98	65.8	64.98	65.28	5831.0
2011-08-09 07:00:00	IWM	ETF	65.74	66.53	65.52	66.25	354130.0
2011-08-09 08:00:00	IWM	ETF	66.17	67.14	65.38	66.6	4656470.0
2011-08-09 09:00:00	IWM	ETF	66.6	67.16	64.81	66.33	27526598.0
2011-08-09 10:00:00	IWM	ETF	66.34	67.62	66.25	67.46	26406503.0
2011-08-09 11:00:00	IWM	ETF	67.44	67.87	66.71	67.75	13504369.0
2011-08-09 12:00:00	IWM	ETF	67.76	68.025	67.425	67.55	9028954.0
2011-08-09 13:00:00	IWM	ETF	67.55	67.63	66.35	66.77	11160270.0
2011-08-09 14:00:00	IWM	ETF	66.77	67.35	63.76	65.11	45841423.0
2011-08-09 15:00:00	IWM	ETF	65.09	69.62	64.65	69.55	39471771.0
2011-08-09 16:00:00	IWM	ETF	69.55	69.74	66.6	69.54	13029944.0
2011-08-09 17:00:00	IWM	ETF	69.56	70.0	69.56	69.8	93662.0
2011-08-09 18:00:00	IWM	ETF	69.89	70.0	69.85	69.94	70599.0
2011-08-09 19:00:00	IWM	ETF	69.93	69.98	69.8	69.94	9917.0
2011-08-09 04:00:00	DIA	ETF	107.01	107.9	107.01	107.9	760.0
2011-08-09 06:00:00	DIA	ETF	107.75	108.85	107.75	108.85	5100.0

> showing 50 of 6,336 rows — these rows as CSV

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