PREVIEW / etf_daily / 2009-03-19

all etf daily files

  file:    by_date/etf_daily/2009/2009-03-19.parquet
  size:    28 KB
  rows:    643

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
2009-03-19	SPY	ETF	80.93	81.0	78.69	78.94	428520400.0
2009-03-19	QQQ	ETF	30.12	30.13	29.46	29.68	146766511.0
2009-03-19	IWM	ETF	42.45	42.5	41.15	41.41	64512500.0
2009-03-19	DIA	ETF	75.83	75.87	73.83	74.11	25410900.0
2009-03-19	GLD	ETF	93.41	94.77	92.91	94.35	35006600.0
2009-03-19	TLT	ETF	105.62	105.66	104.22	104.5	3650900.0
2009-03-19	AAXJ	ETF	32.61	32.62	31.74	31.85	126700.0
2009-03-19	ACWI	ETF	28.73	28.73	27.92	27.94	74800.0
2009-03-19	ACWX	ETF	26.9	26.9	26.23	26.24	103741.0
2009-03-19	ADRE	ETF	27.45	28.0399	27.34	27.46	190598.0
2009-03-19	AFK	ETF	19.99	20.09	19.84	19.84	7300.0
2009-03-19	AGG	ETF	101.74	102.89	101.41	101.9	738500.0
2009-03-19	AGQ	ETF	83.0	87.54	82.78	86.74	172550.0
2009-03-19	AGZ	ETF	112.77	112.77	104.0	108.09	12781.0
2009-03-19	AIA	ETF	25.28	25.28	24.6	24.64	12127.0
2009-03-19	AIQ	ETF	35.4	35.4	33.45	33.75	43149.0
2009-03-19	AIS	ETF	0.3999	0.4	0.39	0.4	111953.0
2009-03-19	AIVI	ETF	29.06	29.06	28.22	28.26	45800.0
2009-03-19	AOA	ETF	21.81	21.94	21.4	21.59	11500.0
2009-03-19	AOK	ETF	24.97	24.97	24.83	24.83	1515.0
2009-03-19	AOM	ETF	23.99	24.49	23.8704	23.88	15000.0
2009-03-19	AOR	ETF	23.02	23.0794	22.9	22.9	4022.0
2009-03-19	ARB	ETF	13.49	13.55	12.84	12.95	175190.0
2009-03-19	BAL	ETF	24.59	24.75	24.42	24.57	20850.0
2009-03-19	BBH	ETF	57.3567	57.72	56.5767	56.8967	1110900.0
2009-03-19	BIL	ETF	91.72	91.76	91.68	91.7	395000.0
2009-03-19	BITS	ETF	17.2	17.24	16.4	16.59	3141.0
2009-03-19	BIV	ETF	77.66	77.66	76.64	76.72	146600.0
2009-03-19	BJK	ETF	15.0	15.68	15.0	15.68	4700.0
2009-03-19	BKF	ETF	24.56	24.85	24.4077	24.44	100668.0
2009-03-19	BLV	ETF	73.71	74.9	72.8	72.81	45900.0
2009-03-19	BMVP	ETF	9.84	9.86	9.7	9.71	16490.0
2009-03-19	BND	ETF	77.39	77.85	77.16	77.35	375800.0
2009-03-19	BNE	ETF	2.1	2.18	1.93	2.09	470000.0
2009-03-19	BSV	ETF	79.22	79.22	78.45	78.86	138900.0
2009-03-19	BTF	ETF	38.9	39.949999999999996	38.849999999999994	39.24999999999999	7380.0
2009-03-19	BWX	ETF	26.18	26.2786	26.045	26.15	242528.0
2009-03-19	BWZ	ETF	33.75	33.75	33.47	33.47	1498.0
2009-03-19	CBON	ETF	1.04	1.05	0.97	1.01	29811.0
2009-03-19	CEF	ETF	12.31	12.5	12.13	12.44	1724400.0
2009-03-19	CGO	ETF	8.96	8.97	8.65	8.65	17887.0
2009-03-19	CGW	ETF	12.01	12.24	11.8201	11.83	31620.0
2009-03-19	CHB	ETF	0.2	0.2	0.16	0.17	845793.0
2009-03-19	CHI	ETF	8.4	8.42	8.21	8.26	121626.0
2009-03-19	CHIC	ETF	6.5	6.77	6.26	6.69	186586.0
2009-03-19	CHW	ETF	5.4	5.4	5.17	5.2	163369.0
2009-03-19	CHY	ETF	8.05	8.3	7.97	8.01	192021.0
2009-03-19	CMF	ETF	51.35	51.675	51.28	51.425	16604.0
2009-03-19	CNXT	ETF	0.71	0.71	0.6401	0.7	305225.0
2009-03-19	COW	ETF	31.58	31.82	31.56	31.79	13781.0

> showing 50 of 643 rows — these rows as CSV

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