PREVIEW / etf_daily / 2008-07-09

all etf daily files

  file:    by_date/etf_daily/2008/2008-07-09.parquet
  size:    27 KB
  rows:    605

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
2008-07-09	SPY	ETF	127.5	127.74	124.39	124.79	336729400.0
2008-07-09	QQQ	ETF	45.96	46.03	44.73	44.75	168576293.0
2008-07-09	IWM	ETF	68.1	68.55	66.0	66.25	131076400.0
2008-07-09	DIA	ETF	114.05	114.2	111.45	111.66	24306400.0
2008-07-09	GLD	ETF	90.88	91.64	90.86	91.5	11362800.0
2008-07-09	TLT	ETF	92.94	93.64	92.92	93.5	1582000.0
2008-07-09	ACWI	ETF	48.44	48.91	47.7	48.01	113700.0
2008-07-09	ACWX	ETF	49.3	49.36	48.5	48.53	21697.0
2008-07-09	ADRE	ETF	48.48	48.9299	47.42	47.444	368850.0
2008-07-09	AGG	ETF	100.5	100.8	100.27	100.71	392000.0
2008-07-09	AIA	ETF	40.11	40.41	39.55	39.55	25226.0
2008-07-09	AIQ	ETF	42.3	43.45	42.1	43.1	41490.0
2008-07-09	AIS	ETF	0.72	0.72	0.69	0.71	18850.0
2008-07-09	AIVI	ETF	59.38	59.48	57.87	58.06	99100.0
2008-07-09	ARB	ETF	47.84	48.21	47.32	47.43	213350.0
2008-07-09	BAL	ETF	45.26	45.77	45.22	45.54	4600.0
2008-07-09	BBH	ETF	58.79	59.7633	58.58	58.6333	712200.0
2008-07-09	BIL	ETF	91.74	91.74	91.68	91.68	40700.0
2008-07-09	BITS	ETF	24.64	24.72	24.2	24.52	1535.0
2008-07-09	BIV	ETF	76.69	77.05	76.62	77.05	33000.0
2008-07-09	BJK	ETF	30.9	31.15	30.9	31.15	300.0
2008-07-09	BKF	ETF	49.82	49.9	48.53	48.71	49891.0
2008-07-09	BLV	ETF	74.7	75.01	74.63	74.91	4500.0
2008-07-09	BMVP	ETF	14.9933	15.0547	14.7433	14.764	29499.0
2008-07-09	BND	ETF	76.28	76.35	75.99	76.18	812300.0
2008-07-09	BNE	ETF	11.78	11.83	11.11	11.19	200571.0
2008-07-09	BOSS	ETF	22.87	23.6	22.87	23.6	500.0
2008-07-09	BRF	ETF	14.76	14.78	14.73	14.75	29760.0
2008-07-09	BSV	ETF	77.33	77.52	77.06	77.48	125600.0
2008-07-09	BTF	ETF	83.69999999999999	84.27	80.5	83.07399999999998	3514.4
2008-07-09	BWX	ETF	27.72	27.87	27.595	27.865	254144.0
2008-07-09	CBON	ETF	4.17	4.22	3.95	3.95	143995.0
2008-07-09	CDL	ETF	1.09	1.18	1.05	1.1	818739.0
2008-07-09	CEF	ETF	13.19	13.27	13.04	13.05	613100.0
2008-07-09	CGO	ETF	15.32	15.32	14.88	14.89	16421.0
2008-07-09	CGW	ETF	22.89	22.9	22.23	22.26	43505.0
2008-07-09	CHB	ETF	5.38	5.54	4.68	4.7	1687542.0
2008-07-09	CHI	ETF	13.4	13.61	13.34	13.43	84876.0
2008-07-09	CHIC	ETF	17.16	17.36	16.3	16.38	355435.0
2008-07-09	CHW	ETF	10.81	10.89	10.64	10.69	87685.0
2008-07-09	CHY	ETF	12.55	12.75	12.52	12.6	105387.0
2008-07-09	CMF	ETF	51.805	51.85	51.7	51.85	7540.0
2008-07-09	CN	ETF	57.45	58.19	56.0	56.1	388512.0
2008-07-09	COW	ETF	43.25	43.71	43.08	43.63	77641.0
2008-07-09	CPST	ETF	3.42	3.54	3.3	3.33	3758169.0
2008-07-09	CSA	ETF	17.02	17.07	16.16	16.3	84820.0
2008-07-09	CSB	ETF	17.23	17.3	17.0	17.13	11250.0
2008-07-09	CSD	ETF	21.02	21.19	20.76	20.76	3600.0
2008-07-09	CSQ	ETF	11.05	11.102	10.87	10.93	256769.0
2008-07-09	CUT	ETF	18.3	18.49	18.17	18.17	12300.0

> showing 50 of 605 rows — these rows as CSV

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