PREVIEW / etf_daily / 2010-04-14

all etf daily files

  file:    by_date/etf_daily/2010/2010-04-14.parquet
  size:    32 KB
  rows:    750

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-04-14	SPY	ETF	120.27	121.19	120.08	121.19	161609000.0
2010-04-14	QQQ	ETF	49.57	49.92	49.5	49.91	69004754.0
2010-04-14	IWM	ETF	71.11	72.21	70.99	72.21	62041600.0
2010-04-14	DIA	ETF	110.6	111.32	110.43	111.29	7987400.0
2010-04-14	GLD	ETF	113.23	113.66	112.78	113.03	10572100.0
2010-04-14	TLT	ETF	89.76	89.87	89.11	89.11	3570100.0
2010-04-14	AAXJ	ETF	58.99	59.46	58.94	59.36	159600.0
2010-04-14	ACWI	ETF	45.06	45.29	44.87	45.29	229400.0
2010-04-14	ACWX	ETF	43.09	43.3	42.91	43.26	296808.0
2010-04-14	ADRE	ETF	45.6	45.85	45.498	45.824	76385.0
2010-04-14	AFK	ETF	32.57	32.8799	32.57	32.73	13395.0
2010-04-14	AGG	ETF	104.15	104.25	103.97	104.07	513500.0
2010-04-14	AGQ	ETF	128.22	128.96	127.08	127.94	94700.0
2010-04-14	AGZ	ETF	108.16	108.185	108.0	108.02	10686.0
2010-04-14	AIA	ETF	41.97	42.44	41.97	42.44	28711.0
2010-04-14	AIQ	ETF	26.75	27.0	26.35	26.85	37092.0
2010-04-14	AIS	ETF	1.54	1.61	1.52	1.58	978712.0
2010-04-14	AIVI	ETF	44.19	44.5	44.19	44.47	22000.0
2010-04-14	AMJ	ETF	31.38	31.38	31.19	31.32	298569.0
2010-04-14	AOA	ETF	32.42	32.73	32.42	32.72	28200.0
2010-04-14	AOK	ETF	28.05	28.15	28.05	28.15	7331.0
2010-04-14	AOM	ETF	29.1	29.23	29.1	29.23	19131.0
2010-04-14	AOR	ETF	30.41	30.51	30.31	30.51	23041.0
2010-04-14	ARB	ETF	27.07	27.55	26.84	27.54	310661.0
2010-04-14	BAB	ETF	25.22	25.22	25.0901	25.11	253851.0
2010-04-14	BAL	ETF	38.54	38.66	38.23	38.23	1000.0
2010-04-14	BALT	ETF	13.26	13.83	13.26	13.48	321947.0
2010-04-14	BBH	ETF	34.56	34.7767	34.5033	34.7767	54300.0
2010-04-14	BIB	ETF	7.53	7.5987	7.515	7.5987	29600.0
2010-04-14	BICK	ETF	30.37	30.7	30.3	30.65	18855.0
2010-04-14	BIL	ETF	91.68	91.7	91.68	91.68	158500.0
2010-04-14	BIS	ETF	9556.8	9603.2	9483.2	9483.2	6.9
2010-04-14	BITS	ETF	32.4	32.4	32.0	32.24	1825.0
2010-04-14	BIV	ETF	80.2	80.38	80.09	80.15	122000.0
2010-04-14	BJK	ETF	27.36	27.48	27.24	27.38	7000.0
2010-04-14	BKF	ETF	48.44	48.56	48.12	48.37	175431.0
2010-04-14	BLV	ETF	77.11	77.33	76.8	76.82	21200.0
2010-04-14	BMVP	ETF	13.58	13.69	13.55	13.67	30554.0
2010-04-14	BND	ETF	79.19	79.25	79.07	79.12	605000.0
2010-04-14	BNE	ETF	11.17	11.17	11.14	11.15	450203.0
2010-04-14	BRF	ETF	47.12	47.24	46.7604	47.2	244530.0
2010-04-14	BSV	ETF	79.8	79.9	79.79	79.84	324600.0
2010-04-14	BTF	ETF	75.14999999999999	75.75	75.14999999999999	75.19999999999999	5253.400000000001
2010-04-14	BWX	ETF	28.065	28.13	27.91	28.08	237702.0
2010-04-14	BWZ	ETF	35.81	36.2256	35.81	35.854	30571.0
2010-04-14	BZQ	ETF	3379.2	3419.2	3350.4	3368.0	189.5
2010-04-14	CEF	ETF	14.66	14.71	14.59	14.67	745600.0
2010-04-14	CEW	ETF	22.49	22.52	22.4675	22.51	223072.0
2010-04-14	CGO	ETF	15.06	15.08	14.92	14.9601	22342.0
2010-04-14	CGW	ETF	18.99	19.09	18.9	19.04	47584.0

> showing 50 of 750 rows — these rows as CSV

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