PREVIEW / etf_1hour / 2011-08-29

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-08-29.parquet
  size:    183 KB
  rows:    5,597

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-29 04:00:00	SPY	ETF	118.7	119.33	118.7	119.19	21995.0
2011-08-29 05:00:00	SPY	ETF	119.33	119.37	119.22	119.27	2985.0
2011-08-29 06:00:00	SPY	ETF	119.27	119.32	119.1	119.31	20780.0
2011-08-29 07:00:00	SPY	ETF	119.3	119.65	119.25	119.28	545155.0
2011-08-29 08:00:00	SPY	ETF	119.28	119.56	118.15	119.42	2721476.0
2011-08-29 09:00:00	SPY	ETF	119.42	120.25	119.39	120.07	27225629.0
2011-08-29 10:00:00	SPY	ETF	120.08	120.44	119.9	120.09	26008896.0
2011-08-29 11:00:00	SPY	ETF	120.09	120.42	119.78	120.26	21098081.0
2011-08-29 12:00:00	SPY	ETF	120.255	120.76	120.251	120.67	15301431.0
2011-08-29 13:00:00	SPY	ETF	120.66	120.9301	120.56	120.68	13550298.0
2011-08-29 14:00:00	SPY	ETF	120.69	121.16	120.67	120.97	16579242.0
2011-08-29 15:00:00	SPY	ETF	120.97	121.43	120.9	121.35	44775314.0
2011-08-29 16:00:00	SPY	ETF	121.34	121.5	121.23	121.32	12980471.0
2011-08-29 17:00:00	SPY	ETF	121.33	121.4	121.28	121.29	4981989.0
2011-08-29 18:00:00	SPY	ETF	121.29	121.38	121.24	121.24	394567.0
2011-08-29 19:00:00	SPY	ETF	121.25	121.35	121.24	121.34	144470.0
2011-08-29 04:00:00	QQQ	ETF	53.42	53.59	53.42	53.58	1002.0
2011-08-29 05:00:00	QQQ	ETF	53.7	53.7	53.57	53.57	3100.0
2011-08-29 06:00:00	QQQ	ETF	53.62	53.65	53.6	53.65	1350.0
2011-08-29 07:00:00	QQQ	ETF	53.69	53.79	53.63	53.63	43379.0
2011-08-29 08:00:00	QQQ	ETF	53.64	53.79	53.6	53.74	279481.0
2011-08-29 09:00:00	QQQ	ETF	53.75	54.2	53.64	54.1	8650336.0
2011-08-29 10:00:00	QQQ	ETF	54.11	54.28	53.97	54.14	7279803.0
2011-08-29 11:00:00	QQQ	ETF	54.13	54.31	53.99	54.26	4211218.0
2011-08-29 12:00:00	QQQ	ETF	54.26	54.41	54.245	54.37	4117918.0
2011-08-29 13:00:00	QQQ	ETF	54.36	54.49	54.3	54.35	3995133.0
2011-08-29 14:00:00	QQQ	ETF	54.3452	54.55	54.33	54.461	3548993.0
2011-08-29 15:00:00	QQQ	ETF	54.47	54.67	54.41	54.61	8794827.0
2011-08-29 16:00:00	QQQ	ETF	54.61	54.69	54.53	54.59	2376135.0
2011-08-29 17:00:00	QQQ	ETF	54.56	54.59	54.56	54.57	4277.0
2011-08-29 18:00:00	QQQ	ETF	54.57	54.57	54.53	54.53	22859.0
2011-08-29 19:00:00	QQQ	ETF	54.56	54.57	54.55	54.55	5108.0
2011-08-29 06:00:00	IWM	ETF	69.79	69.79	69.79	69.79	100.0
2011-08-29 07:00:00	IWM	ETF	69.99	70.15	69.87	69.87	142184.0
2011-08-29 08:00:00	IWM	ETF	69.83	70.09	69.79	70.05	502203.0
2011-08-29 09:00:00	IWM	ETF	70.04	71.01	69.98	70.87	8608621.0
2011-08-29 10:00:00	IWM	ETF	70.89	71.03	70.6	70.88	6591917.0
2011-08-29 11:00:00	IWM	ETF	70.87	71.41	70.67	71.33	5889377.0
2011-08-29 12:00:00	IWM	ETF	71.3288	71.829	71.32	71.66	5723471.0
2011-08-29 13:00:00	IWM	ETF	71.66	71.88	71.62	71.68	4057523.0
2011-08-29 14:00:00	IWM	ETF	71.68	72.095	71.6475	71.93	4681529.0
2011-08-29 15:00:00	IWM	ETF	71.94	72.45	71.93	72.37	13776316.0
2011-08-29 16:00:00	IWM	ETF	72.37	72.54	71.0	72.33	1671232.0
2011-08-29 17:00:00	IWM	ETF	72.32	72.35	72.24	72.3	16285.0
2011-08-29 18:00:00	IWM	ETF	72.32	72.33	72.28	72.33	2671.0
2011-08-29 19:00:00	IWM	ETF	72.25	72.34	72.25	72.31	5777.0
2011-08-29 04:00:00	DIA	ETF	113.5	113.5	113.5	113.5	1000.0
2011-08-29 06:00:00	DIA	ETF	113.75	113.75	113.74	113.74	1300.0
2011-08-29 07:00:00	DIA	ETF	113.75	113.95	113.57	113.57	16322.0
2011-08-29 08:00:00	DIA	ETF	113.57	113.97	113.43	113.88	20931.0

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

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