PREVIEW / etf_daily / 2009-05-13

all etf daily files

  file:    by_date/etf_daily/2009/2009-05-13.parquet
  size:    29 KB
  rows:    654

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-05-13	SPY	ETF	89.74	90.01	88.5	88.68	269619100.0
2009-05-13	QQQ	ETF	33.63	33.65	32.96	33.02	175548207.0
2009-05-13	IWM	ETF	48.7	48.81	47.21	47.28	68822200.0
2009-05-13	DIA	ETF	83.71	83.86	82.8	83.13	17683700.0
2009-05-13	GLD	ETF	90.44	91.5	90.31	91.09	17445900.0
2009-05-13	TLT	ETF	97.36	97.93	97.24	97.69	1917500.0
2009-05-13	AAXJ	ETF	41.3	43.25	40.38	40.47	192400.0
2009-05-13	ACWI	ETF	33.43	33.43	32.88	32.9	83300.0
2009-05-13	ACWX	ETF	31.98	31.98	31.5	31.51	172707.0
2009-05-13	ADRE	ETF	33.01	33.0699	32.29	32.3958	247728.0
2009-05-13	AFK	ETF	24.61	24.77	24.14	24.2699	2500.0
2009-05-13	AGG	ETF	101.95	102.14	101.6	101.9	430700.0
2009-05-13	AGQ	ETF	87.56	90.92	87.16	88.5	128650.0
2009-05-13	AGZ	ETF	108.56	108.56	107.73	108.35	29777.0
2009-05-13	AIA	ETF	30.94	30.9991	30.25	30.46	80289.0
2009-05-13	AIQ	ETF	38.1	38.1	37.0	37.6	54690.0
2009-05-13	AIS	ETF	0.55	0.55	0.49	0.526	195957.0
2009-05-13	AIVI	ETF	33.64	33.83	33.3	33.34	7400.0
2009-05-13	AMJ	ETF	21.82	21.82	21.17	21.3399	16612.0
2009-05-13	AOA	ETF	24.7	24.7	24.08	24.11	10800.0
2009-05-13	AOK	ETF	25.52	25.52	25.4868	25.4868	1185.0
2009-05-13	AOM	ETF	25.1999	25.2	25.1532	25.16	1452.0
2009-05-13	AOR	ETF	24.8686	24.9599	24.69	24.76	2786.0
2009-05-13	ARB	ETF	20.0	20.15	18.91	19.01	229255.0
2009-05-13	BAL	ETF	33.68	33.7	33.36	33.36	2610.0
2009-05-13	BBH	ETF	29.4533	30.0367	29.4533	29.59	483600.0
2009-05-13	BIL	ETF	91.68	91.74	91.68	91.68	100350.0
2009-05-13	BITS	ETF	18.48	18.48	17.8	18.44	2985.0
2009-05-13	BIV	ETF	77.33	77.36	77.17	77.22	76200.0
2009-05-13	BJK	ETF	21.09	21.95	20.05	20.5	150200.0
2009-05-13	BKF	ETF	33.39	33.39	31.0	31.21	79039.0
2009-05-13	BLV	ETF	73.19	73.75	72.93	73.27	22200.0
2009-05-13	BMVP	ETF	10.58	10.58	10.37	10.38	38906.0
2009-05-13	BND	ETF	77.5	77.7	77.44	77.65	299000.0
2009-05-13	BNE	ETF	5.12	5.12	4.27	4.49	281792.0
2009-05-13	BOSS	ETF	17.59	17.94	17.59	17.94	100.0
2009-05-13	BSV	ETF	79.1	79.6	79.09	79.38	224000.0
2009-05-13	BTF	ETF	47.15	47.449999999999996	46.25	47.449999999999996	7126.400000000001
2009-05-13	BWX	ETF	26.5	26.565	26.405	26.525	168150.0
2009-05-13	BWZ	ETF	34.3	34.3	34.2999	34.3	1400.0
2009-05-13	CBON	ETF	1.48	1.49	1.39	1.42	16400.0
2009-05-13	CEF	ETF	11.35	11.68	11.24	11.26	1080800.0
2009-05-13	CEW	ETF	20.19	20.19	20.08	20.14	128653.0
2009-05-13	CGO	ETF	10.12	10.15	10.0	10.03	34651.0
2009-05-13	CGW	ETF	14.35	14.35	14.0	14.07	39002.0
2009-05-13	CHB	ETF	0.55	0.57	0.45	0.46	1284520.0
2009-05-13	CHI	ETF	10.05	10.07	9.75	9.76	165814.0
2009-05-13	CHIC	ETF	11.29	11.32	10.57	10.57	243598.0
2009-05-13	CHW	ETF	6.49	6.5	6.14	6.15	227757.0
2009-05-13	CHY	ETF	9.69	9.69	9.17	9.36	210570.0

> showing 50 of 654 rows — these rows as CSV

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