PREVIEW / etf_daily / 2010-04-01

all etf daily files

  file:    by_date/etf_daily/2010/2010-04-01.parquet
  size:    32 KB
  rows:    736

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-01	SPY	ETF	117.8	118.25	117.1	117.8	161215200.0
2010-04-01	QQQ	ETF	48.34	48.7	47.79	48.16	83728566.0
2010-04-01	IWM	ETF	68.33	68.69	67.39	68.43	58838700.0
2010-04-01	DIA	ETF	109.24	109.58	108.66	109.28	11474400.0
2010-04-01	GLD	ETF	109.97	110.47	109.92	110.26	11370500.0
2010-04-01	TLT	ETF	88.77	89.03	88.43	88.95	2912400.0
2010-04-01	AAXJ	ETF	57.8	58.1	57.47	58.0	863400.0
2010-04-01	ACWI	ETF	44.11	44.13	43.85	44.13	516600.0
2010-04-01	ACWX	ETF	42.21	42.46	42.1	42.44	69342.0
2010-04-01	ADRE	ETF	44.51	45.0	44.51	44.911	163956.0
2010-04-01	AFK	ETF	31.69	32.05	31.5201	32.05	39370.0
2010-04-01	AGG	ETF	103.82	103.93	103.72	103.84	1386100.0
2010-04-01	AGQ	ETF	121.7	122.5	120.26	121.26	197600.0
2010-04-01	AGZ	ETF	107.75	108.03	107.75	107.95	24239.0
2010-04-01	AIA	ETF	40.76	41.36	40.76	41.36	32643.0
2010-04-01	AIQ	ETF	28.1	28.65	27.75	27.9	16305.0
2010-04-01	AIS	ETF	1.46	1.55	1.43	1.53	2409125.0
2010-04-01	AIVI	ETF	43.01	43.49	43.01	43.48	8600.0
2010-04-01	AMJ	ETF	30.55	30.7	30.4959	30.7	384001.0
2010-04-01	AOA	ETF	31.74	31.83	31.64	31.83	21600.0
2010-04-01	AOK	ETF	27.99	27.99	27.86	27.93	14609.0
2010-04-01	AOM	ETF	28.73	28.85	28.73	28.85	4335.0
2010-04-01	AOR	ETF	29.93	29.93	29.805	29.93	11732.0
2010-04-01	ARB	ETF	26.75	26.88	25.37	25.75	477435.0
2010-04-01	BAB	ETF	24.92	24.94	24.85	24.91	139353.0
2010-04-01	BAL	ETF	39.23	39.25	38.95	39.24	42083.0
2010-04-01	BALT	ETF	13.6	13.72	13.6	13.69	385201.0
2010-04-01	BBH	ETF	34.61	34.8267	34.55	34.74	71400.0
2010-04-01	BIL	ETF	91.68	91.72	91.68	91.72	520800.0
2010-04-01	BITS	ETF	31.84	32.4	31.8	32.16	3706.0
2010-04-01	BIV	ETF	79.98	80.01	79.8	79.88	92700.0
2010-04-01	BJK	ETF	26.01	26.17	25.9	25.9	6600.0
2010-04-01	BKF	ETF	47.02	47.57	47.02	47.57	154688.0
2010-04-01	BLV	ETF	76.35	76.53	76.13	76.5	234600.0
2010-04-01	BMVP	ETF	13.213	13.296	13.203	13.27	12959.0
2010-04-01	BND	ETF	78.98	78.98	78.84	78.93	605200.0
2010-04-01	BNE	ETF	11.18	11.21	11.09	11.09	1482683.0
2010-04-01	BRF	ETF	46.39	46.68	46.11	46.5	308152.0
2010-04-01	BSV	ETF	79.86	79.86	79.77	79.79	434500.0
2010-04-01	BTF	ETF	74.0	75.0	74.0	74.5	6808.8
2010-04-01	BWX	ETF	28.01	28.065	27.95	27.99	322228.0
2010-04-01	BWZ	ETF	35.38	35.62	35.38	35.61	24527.0
2010-04-01	BZQ	ETF	3462.4	3475.2	3403.2	3443.2	1202.5
2010-04-01	CEF	ETF	14.19	14.25	14.09	14.25	934000.0
2010-04-01	CEW	ETF	22.28	22.32	22.25	22.31	123089.0
2010-04-01	CGO	ETF	14.98	15.01	14.83	14.96	22960.0
2010-04-01	CGW	ETF	18.74	18.79	18.61	18.73	83406.0
2010-04-01	CHI	ETF	12.75	12.76	12.62	12.74	242149.0
2010-04-01	CHIE	ETF	14.8509	14.9	14.84	14.88	2555.0
2010-04-01	CHII	ETF	15.58	15.75	15.58	15.69	41608.0

> showing 50 of 736 rows — these rows as CSV

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