PREVIEW / etf_daily / 2008-05-06

all etf daily files

  file:    by_date/etf_daily/2008/2008-05-06.parquet
  size:    26 KB
  rows:    584

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-05-06	SPY	ETF	140.02	142.2	139.69	142.05	179339800.0
2008-05-06	QQQ	ETF	48.49	49.13	48.14	48.93	139582514.0
2008-05-06	IWM	ETF	71.86	73.07	71.67	72.86	60503800.0
2008-05-06	DIA	ETF	129.1	130.4	128.58	130.25	12113800.0
2008-05-06	GLD	ETF	86.33	87.15	86.33	86.63	10760400.0
2008-05-06	TLT	ETF	92.01	92.08	90.79	90.95	4037500.0
2008-05-06	ACWI	ETF	53.42	53.93	53.39	53.93	2200.0
2008-05-06	ACWX	ETF	54.53	55.03	54.53	55.02	20358.0
2008-05-06	ADRE	ETF	55.98	56.35	55.378	56.34	358586.0
2008-05-06	AGG	ETF	102.14	102.14	101.55	101.64	930100.0
2008-05-06	AIA	ETF	48.08	48.41	47.79	48.4	14789.0
2008-05-06	AIQ	ETF	42.55	43.2	41.05	41.4	36659.0
2008-05-06	AIS	ETF	0.88	0.89	0.85	0.89	32560.0
2008-05-06	AIVI	ETF	66.85	68.07	66.85	67.92	30400.0
2008-05-06	ARB	ETF	47.04	48.55	46.98	47.8	227386.0
2008-05-06	BBH	ETF	54.89	55.3333	54.6767	55.0933	277200.0
2008-05-06	BIL	ETF	91.68	91.68	91.58	91.58	104000.0
2008-05-06	BITS	ETF	23.72	24.0	22.24	23.44	3775.0
2008-05-06	BIV	ETF	78.36	78.36	77.65	77.75	26600.0
2008-05-06	BJK	ETF	38.25	38.34	38.25	38.34	400.0
2008-05-06	BKF	ETF	57.36	58.13	56.843	58.11	108267.0
2008-05-06	BLV	ETF	76.0	76.0	75.29	75.29	15200.0
2008-05-06	BMVP	ETF	16.19	16.3709	16.154	16.3333	42224.0
2008-05-06	BND	ETF	77.38	77.39	76.84	76.96	132800.0
2008-05-06	BNE	ETF	16.54	16.76	16.51	16.51	262996.0
2008-05-06	BRF	ETF	14.7	14.73	14.68	14.72	2200.0
2008-05-06	BSV	ETF	77.94	77.97	77.71	77.77	67800.0
2008-05-06	BTF	ETF	104.49999999999999	105.39999999999999	104.49999999999999	105.19999999999999	4012.8
2008-05-06	BWX	ETF	28.01	28.225	27.775	28.02	304224.0
2008-05-06	CBON	ETF	10.62	10.75	10.05	10.71	124021.0
2008-05-06	CDL	ETF	1.43	1.43	1.32	1.32	939830.0
2008-05-06	CEF	ETF	12.19	12.33	12.1	12.33	401800.0
2008-05-06	CGO	ETF	16.98	17.03	16.9	16.97	14061.0
2008-05-06	CGW	ETF	24.88	24.88	24.54	24.8	60567.0
2008-05-06	CHB	ETF	9.91	10.01	9.71	9.95	759598.0
2008-05-06	CHI	ETF	15.63	15.69	15.54	15.62	92199.0
2008-05-06	CHIC	ETF	16.43	17.16	16.32	16.96	376613.0
2008-05-06	CHW	ETF	12.29	12.39	12.21	12.32	121947.0
2008-05-06	CHY	ETF	14.31	14.31	14.15	14.16	122821.0
2008-05-06	CMF	ETF	52.375	52.39	52.105	52.27	9522.0
2008-05-06	CN	ETF	63.59	65.48	63.2	65.3	375918.0
2008-05-06	CNXT	ETF	0.49	0.4912	0.4602	0.4895	3216195.0
2008-05-06	COW	ETF	42.8	43.13	42.7	43.1	135194.0
2008-05-06	CPI	ETF	18.25	19.15	18.25	19.15	1300.0
2008-05-06	CPST	ETF	2.8	3.05	2.78	2.95	7716545.0
2008-05-06	CSA	ETF	17.5	17.64	17.18	17.46	60369.0
2008-05-06	CSB	ETF	22.65	23.47	22.64	23.1	32950.0
2008-05-06	CSD	ETF	23.65	24.11	23.65	24.11	3600.0
2008-05-06	CSQ	ETF	12.87	12.97	12.8	12.94	293954.0
2008-05-06	CUT	ETF	21.5	21.95	21.5	21.78	38200.0

> showing 50 of 584 rows — these rows as CSV

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