PREVIEW / etf_daily / 2008-05-07

all etf daily files

  file:    by_date/etf_daily/2008/2008-05-07.parquet
  size:    26 KB
  rows:    587

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-07	SPY	ETF	141.89	142.04	139.13	139.52	199267300.0
2008-05-07	QQQ	ETF	48.93	49.23	47.872	48.04	140008268.0
2008-05-07	IWM	ETF	72.9	73.22	71.34	71.56	57431100.0
2008-05-07	DIA	ETF	130.27	130.37	128.0	128.4	13406000.0
2008-05-07	GLD	ETF	85.47	86.1	85.2	85.82	7218400.0
2008-05-07	TLT	ETF	90.73	91.43	90.62	91.34	3876200.0
2008-05-07	ACWI	ETF	53.87	53.87	53.0	53.03	5300.0
2008-05-07	ACWX	ETF	54.84	54.84	54.15	54.15	7003.0
2008-05-07	ADRE	ETF	56.29	56.29	54.3501	54.445	370515.0
2008-05-07	AGG	ETF	101.57	101.94	101.41	101.93	299200.0
2008-05-07	AIA	ETF	48.32	48.32	46.68	46.68	48049.0
2008-05-07	AIQ	ETF	41.55	41.55	40.5	40.5	34109.0
2008-05-07	AIS	ETF	0.93	0.93	0.86	0.88	24280.0
2008-05-07	AIVI	ETF	67.4	67.4	66.23	66.23	13600.0
2008-05-07	ARB	ETF	47.94	48.0	46.39	46.39	214393.0
2008-05-07	BBH	ETF	54.88	55.1833	54.3233	54.4	270600.0
2008-05-07	BIL	ETF	91.64	91.64	91.58	91.64	26400.0
2008-05-07	BITS	ETF	23.68	23.88	23.0	23.28	4583.0
2008-05-07	BIV	ETF	77.59	77.95	77.33	77.94	30000.0
2008-05-07	BJK	ETF	38.84	38.84	38.84	38.84	100.0
2008-05-07	BKF	ETF	56.84	57.75	56.12	56.33	79041.0
2008-05-07	BLV	ETF	75.2	75.36	75.18	75.31	28200.0
2008-05-07	BMVP	ETF	16.3233	16.3673	16.0967	16.0967	25552.0
2008-05-07	BND	ETF	76.95	77.21	76.85	77.07	265900.0
2008-05-07	BNE	ETF	16.54	17.02	16.54	16.59	158209.0
2008-05-07	BOSS	ETF	36.9	37.6	36.9	37.15	100.0
2008-05-07	BRF	ETF	14.68	14.68	14.68	14.68	600.0
2008-05-07	BSV	ETF	77.6	77.94	77.6	77.87	53600.0
2008-05-07	BTF	ETF	105.5	105.89999999999999	105.25	105.5625	5628.0
2008-05-07	BWX	ETF	27.89	27.94	27.75	27.93	253138.0
2008-05-07	CBON	ETF	10.73	10.73	9.85	9.85	123315.0
2008-05-07	CDL	ETF	1.3	1.38	1.24	1.24	1512758.0
2008-05-07	CEF	ETF	12.19	12.33	12.05	12.1	518400.0
2008-05-07	CGO	ETF	16.96	17.01	16.89	16.91	12679.0
2008-05-07	CGW	ETF	24.89	24.95	24.51	24.525	52384.0
2008-05-07	CHB	ETF	9.88	10.14	9.42	9.5	1212012.0
2008-05-07	CHI	ETF	15.67	15.74	15.48	15.5	94373.0
2008-05-07	CHIC	ETF	16.62	17.04	16.29	16.34	336446.0
2008-05-07	CHW	ETF	12.32	12.39	12.25	12.26	136679.0
2008-05-07	CHY	ETF	14.15	14.3	14.02	14.05	128837.0
2008-05-07	CMF	ETF	52.38	52.38	52.15	52.15	9064.0
2008-05-07	CN	ETF	64.95	65.2099	63.01	63.14	692306.0
2008-05-07	CNXT	ETF	0.48	0.5	0.47	0.485	4158396.0
2008-05-07	COW	ETF	43.07	43.26	42.5	43.2599	211277.0
2008-05-07	CPI	ETF	19.25	19.25	19.25	19.25	500.0
2008-05-07	CPST	ETF	2.99	3.0	2.81	2.83	3114827.0
2008-05-07	CSA	ETF	17.54	17.74	17.1	17.12	39875.0
2008-05-07	CSB	ETF	23.01	23.45	22.6	23.0	33025.0
2008-05-07	CSD	ETF	24.22	24.26	23.94	23.94	3400.0
2008-05-07	CSQ	ETF	12.93	13.0	12.81	12.82	247886.0

> showing 50 of 587 rows — these rows as CSV

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