PREVIEW / etf_daily / 2008-09-10

all etf daily files

  file:    by_date/etf_daily/2008/2008-09-10.parquet
  size:    27 KB
  rows:    616

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-09-10	SPY	ETF	123.89	124.9	122.55	123.72	298916600.0
2008-09-10	QQQ	ETF	42.87	43.18	42.45	42.8	160658075.0
2008-09-10	IWM	ETF	71.57	72.18	70.43	71.47	126869000.0
2008-09-10	DIA	ETF	113.11	114.0	112.34	113.0	39044100.0
2008-09-10	GLD	ETF	76.88	76.93	74.1	74.22	29365500.0
2008-09-10	TLT	ETF	95.98	96.66	95.82	96.23	2407900.0
2008-09-10	ACWI	ETF	44.17	44.4	43.84	44.24	855900.0
2008-09-10	ACWX	ETF	42.24	42.5399	42.18	42.35	15920.0
2008-09-10	ADRE	ETF	39.01	39.88	38.58	39.27	736294.0
2008-09-10	AFK	ETF	35.0	35.035	34.445	34.5	11215.0
2008-09-10	AGG	ETF	101.4	101.82	101.4	101.75	515400.0
2008-09-10	AIA	ETF	36.06	36.06	35.78	35.78	1800.0
2008-09-10	AIQ	ETF	58.0	58.7	57.35	58.45	65807.0
2008-09-10	AIS	ETF	0.7205	0.74	0.72	0.74	24700.0
2008-09-10	AIVI	ETF	54.23	54.25	53.52	53.65	26900.0
2008-09-10	ARB	ETF	48.5	48.66	47.99	48.19	331415.0
2008-09-10	BAL	ETF	40.3	40.3	39.7	39.7	1000.0
2008-09-10	BBH	ETF	63.0467	64.12	63.0467	63.8333	555300.0
2008-09-10	BIL	ETF	91.76	91.8	91.74	91.78	68600.0
2008-09-10	BITS	ETF	22.6	23.6	22.04	22.04	2975.0
2008-09-10	BIV	ETF	77.12	77.43	76.91	77.38	94500.0
2008-09-10	BJK	ETF	27.7	27.75	27.63	27.63	700.0
2008-09-10	BKF	ETF	37.22	38.18	37.0816	37.93	153415.0
2008-09-10	BLV	ETF	75.85	76.18	75.59	76.03	7100.0
2008-09-10	BMVP	ETF	14.2667	14.4397	14.2233	14.33	37199.0
2008-09-10	BND	ETF	76.85	77.17	76.81	77.14	134900.0
2008-09-10	BNE	ETF	12.06	12.5	11.96	12.23	131652.0
2008-09-10	BRF	ETF	14.85	14.85	14.85	14.85	1300.0
2008-09-10	BSV	ETF	77.73	77.89	77.62	77.88	93100.0
2008-09-10	BTF	ETF	83.39999999999999	84.25	82.55	84.0	7118.400000000001
2008-09-10	BWX	ETF	26.065	26.075	25.85	25.86	246274.0
2008-09-10	CBON	ETF	5.08	5.6099	4.99	5.49	96482.0
2008-09-10	CDL	ETF	0.87	0.95	0.87	0.88	394794.0
2008-09-10	CEF	ETF	9.2	9.42	8.9	9.03	2297500.0
2008-09-10	CGO	ETF	13.33	13.33	12.81	13.17	28018.0
2008-09-10	CGW	ETF	20.86	21.43	20.25	21.26	332285.0
2008-09-10	CHB	ETF	5.37	5.62	5.15	5.46	1388587.0
2008-09-10	CHI	ETF	12.49	12.58	12.328	12.52	109816.0
2008-09-10	CHIC	ETF	12.97	13.08	12.36	12.49	365359.0
2008-09-10	CHW	ETF	9.96	9.96	9.54	9.61	166416.0
2008-09-10	CHY	ETF	12.3	12.47	12.24	12.44	127260.0
2008-09-10	CMF	ETF	52.065	52.13	51.915	51.945	11114.0
2008-09-10	CN	ETF	46.4	46.5	45.24	46.33	184380.0
2008-09-10	CNXT	ETF	5.19	5.34	4.88	5.09	747145.0
2008-09-10	COW	ETF	40.97	41.28	40.89	40.92	89332.0
2008-09-10	CPI	ETF	23.8	23.8	23.4	23.4	500.0
2008-09-10	CPST	ETF	1.8	1.83	1.71	1.77	4125601.0
2008-09-10	CSA	ETF	19.07	19.1	18.65	19.0	31600.0
2008-09-10	CSB	ETF	18.2	18.2	17.45	17.51	17945.0
2008-09-10	CSD	ETF	20.49	20.64	20.34	20.46	84300.0

> showing 50 of 616 rows — these rows as CSV

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