PREVIEW / etf_daily / 2008-03-14

all etf daily files

  file:    by_date/etf_daily/2008/2008-03-14.parquet
  size:    26 KB
  rows:    579

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-03-14	SPY	ETF	132.77	132.81	127.78	129.61	484687800.0
2008-03-14	QQQ	ETF	43.36	43.38	41.74	42.25	309589728.0
2008-03-14	IWM	ETF	68.35	68.35	65.35	66.14	176997100.0
2008-03-14	DIA	ETF	122.37	122.37	118.51	120.02	29251700.0
2008-03-14	GLD	ETF	98.03	99.53	98.01	98.71	17565100.0
2008-03-14	TLT	ETF	94.62	95.81	94.62	95.0	6174800.0
2008-03-14	ADRE	ETF	50.31	50.31	47.93	48.54	915008.0
2008-03-14	AGG	ETF	102.46	102.84	102.15	102.55	490900.0
2008-03-14	AIA	ETF	42.99	42.99	40.46	40.46	2400.0
2008-03-14	AIQ	ETF	45.05	45.4	42.3	43.35	32660.0
2008-03-14	AIS	ETF	1.0001	1.01	0.9801	0.99	79500.0
2008-03-14	AIVI	ETF	63.09	63.1	60.8	61.25	36000.0
2008-03-14	ARB	ETF	44.29	44.41	42.46	43.13	446350.0
2008-03-14	BBH	ETF	57.7667	57.93	55.7667	56.8233	1045500.0
2008-03-14	BIL	ETF	91.74	91.88	91.7	91.86	82350.0
2008-03-14	BITS	ETF	20.04	20.08	19.4	20.0	5490.0
2008-03-14	BIV	ETF	78.71	79.11	78.59	78.95	30400.0
2008-03-14	BJK	ETF	39.38	39.38	39.38	39.38	400.0
2008-03-14	BKF	ETF	51.26	51.26	48.6252	48.8601	38000.0
2008-03-14	BLV	ETF	76.15	76.8	73.12	76.45	37600.0
2008-03-14	BMVP	ETF	15.5367	15.5367	15.0867	15.23	48943.0
2008-03-14	BND	ETF	77.36	77.9	77.24	77.41	119900.0
2008-03-14	BNE	ETF	14.81	14.96	13.96	14.36	467500.0
2008-03-14	BRF	ETF	14.61	14.61	14.49	14.56	23900.0
2008-03-14	BSV	ETF	78.78	79.1	78.71	79.0	48700.0
2008-03-14	BTF	ETF	101.64999999999999	102.39999999999999	99.14999999999999	99.49999999999999	2320.0
2008-03-14	BWX	ETF	28.765	29.445	28.765	29.395	933424.0
2008-03-14	CBON	ETF	12.09	12.09	11.53	11.74	111290.0
2008-03-14	CDL	ETF	1.67	1.7	1.43	1.44	1187836.0
2008-03-14	CEF	ETF	14.48	14.56	14.25	14.54	1060600.0
2008-03-14	CGO	ETF	15.94	16.09	15.13	15.62	33968.0
2008-03-14	CGW	ETF	24.1	24.25	23.06	23.223	56100.0
2008-03-14	CHB	ETF	9.11	9.2	8.4	8.97	1708857.0
2008-03-14	CHI	ETF	13.81	13.89	13.4	13.57	89259.0
2008-03-14	CHIC	ETF	20.0	20.05	19.35	19.61	374211.0
2008-03-14	CHW	ETF	11.0	11.13	10.41	10.68	161287.0
2008-03-14	CHY	ETF	12.6	12.75	12.18	12.32	134000.0
2008-03-14	CMF	ETF	51.66	51.7	51.49	51.7	18400.0
2008-03-14	CN	ETF	57.7	57.7	54.89	55.14	568900.0
2008-03-14	CNXT	ETF	0.45	0.46	0.4	0.41	3765606.0
2008-03-14	COW	ETF	42.26	42.26	41.41	41.73	21500.0
2008-03-14	CPI	ETF	18.85	18.85	18.74	18.74	2800.0
2008-03-14	CPST	ETF	2.1	2.1	1.95	2.0	2547813.0
2008-03-14	CSA	ETF	15.02	15.12	14.95	15.01	62500.0
2008-03-14	CSD	ETF	22.59	22.64	22.05	22.22	107200.0
2008-03-14	CSQ	ETF	11.62	11.7	11.19	11.47	432966.0
2008-03-14	CUT	ETF	21.72	21.72	20.63	20.79	22400.0
2008-03-14	CVY	ETF	22.35	22.35	21.57	21.73	44900.0
2008-03-14	CWI	ETF	25.08	25.08	24.2933	24.52	33300.0
2008-03-14	DBA	ETF	42.66	42.66	40.65	41.2	3141300.0

> showing 50 of 579 rows — these rows as CSV

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