PREVIEW / etf_1hour / 2011-08-11

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-08-11.parquet
  size:    197 KB
  rows:    6,055

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-11 04:00:00	SPY	ETF	114.45	115.15	114.45	114.9	16246.0
2011-08-11 05:00:00	SPY	ETF	114.82	114.9	113.69	113.69	86500.0
2011-08-11 06:00:00	SPY	ETF	113.64	114.25	113.16	114.06	285314.0
2011-08-11 07:00:00	SPY	ETF	114.1	114.15	111.14	111.59	6667692.0
2011-08-11 08:00:00	SPY	ETF	111.59	113.7	110.84	112.81	17652838.0
2011-08-11 09:00:00	SPY	ETF	112.81	114.53	112.51	113.58	67215175.0
2011-08-11 10:00:00	SPY	ETF	113.59	115.96	113.47	115.331	72736692.0
2011-08-11 11:00:00	SPY	ETF	115.3377	115.8	114.79	115.34	42755663.0
2011-08-11 12:00:00	SPY	ETF	115.35	117.01	115.06	116.83	36130212.0
2011-08-11 13:00:00	SPY	ETF	116.83	116.87	115.9	116.66	45306871.0
2011-08-11 14:00:00	SPY	ETF	116.66	117.62	116.46	117.47	42025055.0
2011-08-11 15:00:00	SPY	ETF	117.48	118.92	117.13	117.33	110137290.0
2011-08-11 16:00:00	SPY	ETF	117.34	117.5229	112.3374	117.5	32178668.0
2011-08-11 17:00:00	SPY	ETF	117.47	117.5	116.96	117.1	8842331.0
2011-08-11 18:00:00	SPY	ETF	117.1	117.3	116.77	117.13	719859.0
2011-08-11 19:00:00	SPY	ETF	117.13	117.22	117.09	117.18	194374.0
2011-08-11 04:00:00	QQQ	ETF	51.88	52.35	51.88	52.35	2609.0
2011-08-11 05:00:00	QQQ	ETF	52.11	52.11	52.11	52.11	100.0
2011-08-11 06:00:00	QQQ	ETF	51.6	51.8	51.6	51.78	6900.0
2011-08-11 07:00:00	QQQ	ETF	51.79	51.88	50.76	51.03	469573.0
2011-08-11 08:00:00	QQQ	ETF	51.59	51.59	50.6	51.43	3839892.0
2011-08-11 09:00:00	QQQ	ETF	51.42	52.06	51.26	51.71	21016293.0
2011-08-11 10:00:00	QQQ	ETF	51.73	52.81	51.6716	52.512	21584406.0
2011-08-11 11:00:00	QQQ	ETF	52.513	52.68	52.24	52.5119	10684511.0
2011-08-11 12:00:00	QQQ	ETF	52.52	53.12	52.32	53.05	13257045.0
2011-08-11 13:00:00	QQQ	ETF	53.05	53.06	52.7	53.01	13319558.0
2011-08-11 14:00:00	QQQ	ETF	53.01	53.288	52.92	53.21	14467607.0
2011-08-11 15:00:00	QQQ	ETF	53.21	53.69	52.98	53.1	25611400.0
2011-08-11 16:00:00	QQQ	ETF	53.09	53.3367	52.87	53.2	4246244.0
2011-08-11 17:00:00	QQQ	ETF	53.13	53.13	52.92	53.0	84015.0
2011-08-11 18:00:00	QQQ	ETF	53.0	53.03	52.84	52.94	80348.0
2011-08-11 19:00:00	QQQ	ETF	53.01	53.03	52.96	53.02	52243.0
2011-08-11 20:00:00	QQQ	ETF	53.02	53.02	53.02	53.02	343.0
2011-08-11 04:00:00	IWM	ETF	67.49	67.55	67.49	67.55	14746.0
2011-08-11 05:00:00	IWM	ETF	67.26	67.26	67.26	67.26	200.0
2011-08-11 06:00:00	IWM	ETF	66.75	66.75	66.24	66.64	2900.0
2011-08-11 07:00:00	IWM	ETF	66.79	66.82	65.0	65.55	218590.0
2011-08-11 08:00:00	IWM	ETF	66.34	66.34	64.95	66.08	2008695.0
2011-08-11 09:00:00	IWM	ETF	66.03	67.87	65.8	66.65	18516456.0
2011-08-11 10:00:00	IWM	ETF	66.66	68.19	66.27	67.6975	21045376.0
2011-08-11 11:00:00	IWM	ETF	67.7	68.06	67.27	67.71	9378254.0
2011-08-11 12:00:00	IWM	ETF	67.73	68.61	67.41	68.48	9289576.0
2011-08-11 13:00:00	IWM	ETF	68.48	68.605	67.97	68.57	11795873.0
2011-08-11 14:00:00	IWM	ETF	68.56	69.19	68.42	69.1	7284961.0
2011-08-11 15:00:00	IWM	ETF	69.09	70.44	69.02	69.38	26995854.0
2011-08-11 16:00:00	IWM	ETF	69.37	69.5635	68.79	69.21	8675751.0
2011-08-11 17:00:00	IWM	ETF	69.19	69.2	68.88	69.07	159923.0
2011-08-11 18:00:00	IWM	ETF	68.92	69.04	68.81	69.04	13221.0
2011-08-11 19:00:00	IWM	ETF	69.09	69.2	68.97	68.97	2700.0
2011-08-11 04:00:00	DIA	ETF	108.5	109.05	108.5	109.05	450.0

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

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