PREVIEW / etf_daily / 2009-10-30

all etf daily files

  file:    by_date/etf_daily/2009/2009-10-30.parquet
  size:    30 KB
  rows:    681

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-10-30	SPY	ETF	106.3	106.62	103.44	103.56	325608100.0
2009-10-30	QQQ	ETF	42.06	42.15	40.92	40.96	162796442.0
2009-10-30	IWM	ETF	57.67	57.74	55.98	56.33	116215600.0
2009-10-30	DIA	ETF	99.35	99.64	96.87	97.06	29751800.0
2009-10-30	GLD	ETF	102.33	102.66	101.48	102.53	15244500.0
2009-10-30	TLT	ETF	95.1	96.01	94.87	95.78	5118000.0
2009-10-30	AAXJ	ETF	52.66	52.66	50.63	50.92	197400.0
2009-10-30	ACWI	ETF	40.66	40.87	39.61	39.65	124500.0
2009-10-30	ACWX	ETF	39.85	39.85	38.64	38.71	455798.0
2009-10-30	ADRE	ETF	42.05	42.11	40.02	40.48	410577.0
2009-10-30	AFK	ETF	28.78	28.95	28.35	28.5	18487.0
2009-10-30	AGG	ETF	104.5	104.84	104.46	104.81	515200.0
2009-10-30	AGQ	ETF	111.2	111.96	106.2	109.18	274200.0
2009-10-30	AGZ	ETF	108.61	108.7699	108.556	108.75	44759.0
2009-10-30	AIA	ETF	37.91	37.91	36.7	36.97	46321.0
2009-10-30	AIQ	ETF	26.95	27.85	26.95	27.2	65440.0
2009-10-30	AIS	ETF	1.07	1.13	1.07	1.13	613072.0
2009-10-30	AIVI	ETF	42.46	42.46	40.89	40.95	39000.0
2009-10-30	AMJ	ETF	26.08	26.1	25.55	25.73	140531.0
2009-10-30	AOA	ETF	28.73	28.73	28.18	28.19	7500.0
2009-10-30	AOK	ETF	27.0799	27.1	26.92	26.98	17712.0
2009-10-30	AOM	ETF	27.6897	27.6897	27.42	27.47	25591.0
2009-10-30	AOR	ETF	28.17	28.17	27.7324	27.82	9226.0
2009-10-30	ARB	ETF	21.76	22.1	21.49	21.68	792128.0
2009-10-30	BAL	ETF	34.85	35.104	34.7101	34.74	14306.0
2009-10-30	BBH	ETF	30.3067	30.7333	30.0667	30.1467	476100.0
2009-10-30	BIL	ETF	91.74	91.76	91.74	91.76	190950.0
2009-10-30	BITS	ETF	24.92	25.6	23.44	25.48	1200.0
2009-10-30	BIV	ETF	80.16	80.42	80.07	80.4	106000.0
2009-10-30	BJK	ETF	24.24	24.39	23.27	23.4	32400.0
2009-10-30	BKF	ETF	44.09	44.11	41.87	42.44	235546.0
2009-10-30	BLV	ETF	78.38	78.75	78.2	78.75	37700.0
2009-10-30	BMVP	ETF	11.94	11.94	11.66	11.66	37064.0
2009-10-30	BND	ETF	79.3	79.47	79.14	79.47	428700.0
2009-10-30	BNE	ETF	6.72	6.76	6.26	6.53	210227.0
2009-10-30	BRF	ETF	43.73	43.75	40.73	41.39	665012.0
2009-10-30	BSV	ETF	80.01	80.1	79.95	80.06	498000.0
2009-10-30	BTF	ETF	60.099999999999994	60.55	59.599999999999994	60.0	30604.600000000002
2009-10-30	BWX	ETF	29.27	29.33	29.17	29.25	379862.0
2009-10-30	BWZ	ETF	37.3	37.52	37.0388	37.2	41754.0
2009-10-30	BZQ	ETF	4364.8	4956.8	4353.6	4844.8	946.0
2009-10-30	CEF	ETF	13.26	13.34	13.05	13.27	911900.0
2009-10-30	CEW	ETF	21.88	21.88	21.65	21.6801	61785.0
2009-10-30	CGO	ETF	13.92	13.92	13.3	13.3	20255.0
2009-10-30	CGW	ETF	17.54	17.609	17.1	17.2	80239.0
2009-10-30	CHB	ETF	0.2748	0.28	0.21	0.24	2839517.0
2009-10-30	CHI	ETF	11.79	12.06	11.37	11.4	261611.0
2009-10-30	CHW	ETF	7.59	7.73	7.3	7.34	275834.0
2009-10-30	CHY	ETF	11.43	11.55	11.0	11.01	294053.0
2009-10-30	CMF	ETF	53.045	53.05	52.9075	53.02	5334.0

> showing 50 of 681 rows — these rows as CSV

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