PREVIEW / etf_daily / 2010-05-27

all etf daily files

  file:    by_date/etf_daily/2010/2010-05-27.parquet
  size:    32 KB
  rows:    752

schema

  date         DATE
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

date	symbol	asset_type	open	high	low	close	volume
2010-05-27	SPY	ETF	109.19	110.8	108.78	110.76	300870500.0
2010-05-27	QQQ	ETF	45.22	45.89	45.09	45.87	110736050.0
2010-05-27	IWM	ETF	65.96	67.14	64.35	67.11	86856200.0
2010-05-27	DIA	ETF	101.44	102.73	101.07	102.72	18333200.0
2010-05-27	GLD	ETF	118.16	119.04	118.14	118.69	10418500.0
2010-05-27	TLT	ETF	96.83	96.99	95.88	96.06	7653200.0
2010-05-27	AAXJ	ETF	51.74	53.02	51.36	53.02	772500.0
2010-05-27	ACWI	ETF	39.37	39.9	39.14	39.9	668600.0
2010-05-27	ACWX	ETF	36.36	37.2	36.279	37.2	149343.0
2010-05-27	ADRE	ETF	39.41	40.21	39.21	40.15	188535.0
2010-05-27	AFK	ETF	28.56	29.08	28.26	29.08	27375.0
2010-05-27	AGG	ETF	105.67	105.67	105.37	105.6	1072500.0
2010-05-27	AGQ	ETF	122.56	126.74	122.16	125.62	127850.0
2010-05-27	AGZ	ETF	109.22	109.22	108.9085	109.16	24303.0
2010-05-27	AIA	ETF	37.01	37.42	36.85	37.42	7880.0
2010-05-27	AIQ	ETF	26.7	27.8	26.25	27.8	18658.0
2010-05-27	AIS	ETF	1.6	1.6	1.55	1.6	430383.0
2010-05-27	AIVI	ETF	36.98	37.9	36.98	37.9	21300.0
2010-05-27	AMJ	ETF	28.8	29.375	28.8	29.32	757258.0
2010-05-27	AOA	ETF	29.27	29.74	29.24	29.74	19300.0
2010-05-27	AOK	ETF	27.38	27.5499	27.38	27.504	20890.0
2010-05-27	AOM	ETF	27.91	28.09	27.8925	28.09	11854.0
2010-05-27	AOR	ETF	28.4113	28.77	28.4113	28.77	4246.0
2010-05-27	ARB	ETF	29.92	30.89	29.92	30.8	127317.0
2010-05-27	BAB	ETF	25.75	25.84	25.7	25.71	313528.0
2010-05-27	BAL	ETF	38.86	38.86	38.34	38.34	7145.0
2010-05-27	BALT	ETF	12.23	12.64	12.1692	12.6	194955.0
2010-05-27	BBH	ETF	28.9167	29.4167	28.9167	29.4167	172200.0
2010-05-27	BIB	ETF	5.7287	5.8087	5.6931	5.8087	12000.0
2010-05-27	BICK	ETF	26.97	27.27	26.6401	27.255	12348.0
2010-05-27	BIL	ETF	91.72	91.72	91.7	91.7	518600.0
2010-05-27	BIS	ETF	12040.0	12061.6	11824.0	11824.0	10.0
2010-05-27	BITS	ETF	28.08	29.04	27.36	29.04	4330.0
2010-05-27	BIV	ETF	81.99	82.01	81.67	81.81	282500.0
2010-05-27	BJK	ETF	23.67	24.37	23.67	24.37	11600.0
2010-05-27	BKF	ETF	40.93	41.74	40.59	41.705	392735.0
2010-05-27	BLV	ETF	79.97	79.98	79.28	79.55	82900.0
2010-05-27	BMVP	ETF	12.38	12.63	12.38	12.63	17655.0
2010-05-27	BND	ETF	80.41	80.41	80.18	80.3	870700.0
2010-05-27	BNE	ETF	11.02	11.1	11.0	11.06	545442.0
2010-05-27	BRF	ETF	41.5	42.56	41.25	42.41	140037.0
2010-05-27	BSV	ETF	80.25	80.32	80.21	80.3	574600.0
2010-05-27	BTF	ETF	65.0	66.25	65.0	66.14999999999999	8219.2
2010-05-27	BWX	ETF	26.57	26.57	26.205	26.46	227022.0
2010-05-27	BWZ	ETF	33.23	33.85	33.23	33.82	80899.0
2010-05-27	BZQ	ETF	4528.0	4612.8	4344.0	4358.4	1382.0
2010-05-27	CEF	ETF	14.94	15.02	14.82	14.98	1891500.0
2010-05-27	CEW	ETF	21.21	21.51	21.21	21.51	102347.0
2010-05-27	CGO	ETF	12.9	13.11	12.884	13.11	10361.0
2010-05-27	CGW	ETF	16.29	16.93	16.29	16.93	41133.0

> showing 50 of 752 rows — these rows as CSV

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