PREVIEW / etf_daily / 2007-11-16

all etf daily files

  file:    by_date/etf_daily/2007/2007-11-16.parquet
  size:    24 KB
  rows:    536

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
2007-11-16	SPY	ETF	146.31	146.47	144.57	145.79	308770600.0
2007-11-16	QQQ	ETF	50.14	50.49	49.34	50.28	263623649.0
2007-11-16	IWM	ETF	77.32	77.36	75.54	76.29	123470600.0
2007-11-16	DIA	ETF	131.75	132.02	130.4	131.44	22485600.0
2007-11-16	GLD	ETF	78.34	78.85	77.17	77.75	8078000.0
2007-11-16	TLT	ETF	92.27	92.7	92.21	92.41	1333800.0
2007-11-16	ADRE	ETF	54.35	55.101	53.96	54.97	255049.0
2007-11-16	AGG	ETF	101.0	101.1	100.85	100.99	1810900.0
2007-11-16	AIA	ETF	48.69	49.45	48.42	49.4	51700.0
2007-11-16	AIQ	ETF	44.8	44.8	42.45	43.4	57920.0
2007-11-16	AIS	ETF	1.1001	1.14	1.1	1.1	487800.0
2007-11-16	AIVI	ETF	72.28	72.79	71.5	72.79	28800.0
2007-11-16	ARB	ETF	50.64	52.1	50.37	51.81	425000.0
2007-11-16	BBH	ETF	58.5	59.2067	58.2533	58.9067	567300.0
2007-11-16	BIL	ETF	91.8	91.8	91.74	91.78	24450.0
2007-11-16	BITS	ETF	23.0	23.48	22.76	23.44	18673.0
2007-11-16	BIV	ETF	76.83	77.02	76.8	76.8	26600.0
2007-11-16	BKF	ETF	58.64	58.64	58.2	58.29	1400.0
2007-11-16	BLV	ETF	76.64	76.84	76.64	76.67	3800.0
2007-11-16	BMVP	ETF	16.9867	16.9867	16.7767	16.9067	64100.0
2007-11-16	BND	ETF	76.5	76.58	76.44	76.48	99500.0
2007-11-16	BNE	ETF	17.0	17.07	16.87	17.02	211300.0
2007-11-16	BRF	ETF	14.65	14.658	14.64	14.658	6300.0
2007-11-16	BSV	ETF	76.89	76.91	76.79	76.86	46400.0
2007-11-16	BTF	ETF	112.44999999999999	112.75	111.95	112.5	720.0
2007-11-16	BWX	ETF	27.075	27.15	27.07	27.08	103000.0
2007-11-16	CBON	ETF	19.65	19.69	18.57	18.87	93319.0
2007-11-16	CDL	ETF	2.56	2.594	2.31	2.41	2435594.0
2007-11-16	CEF	ETF	10.65	10.68	10.47	10.51	348400.0
2007-11-16	CGO	ETF	18.44	18.44	18.13	18.3	18400.0
2007-11-16	CGW	ETF	25.41	25.45	24.62	24.89	36600.0
2007-11-16	CHB	ETF	10.14	10.24	9.02	9.06	2720400.0
2007-11-16	CHI	ETF	15.08	15.12	14.93	15.07	130100.0
2007-11-16	CHIC	ETF	15.76	15.76	14.87	15.04	569822.0
2007-11-16	CHW	ETF	12.27	12.41	12.18	12.26	216000.0
2007-11-16	CHY	ETF	13.24	13.34	13.13	13.31	167400.0
2007-11-16	CMF	ETF	51.875	51.875	51.75	51.75	8400.0
2007-11-16	CN	ETF	52.3	52.75	50.74	52.51	418100.0
2007-11-16	CNXT	ETF	1.21	1.23	1.17	1.19	5731222.0
2007-11-16	CPST	ETF	1.25	1.2501	1.22	1.24	875784.0
2007-11-16	CSA	ETF	17.78	17.81	16.72	16.8	96800.0
2007-11-16	CSD	ETF	27.18	27.22	26.93	27.2	9100.0
2007-11-16	CSM	ETF	1.475	1.475	1.475	1.475	8000.0
2007-11-16	CSQ	ETF	13.35	13.6	13.35	13.57	370200.0
2007-11-16	CUT	ETF	24.58	24.58	24.24	24.45	21600.0
2007-11-16	CVY	ETF	24.15	24.47	24.15	24.34	15800.0
2007-11-16	CWI	ETF	28.2467	28.32	28.06	28.3	371250.0
2007-11-16	CZA	ETF	25.59	25.59	25.59	25.59	400.0
2007-11-16	DBA	ETF	29.68	29.95	29.66	29.76	191600.0
2007-11-16	DBB	ETF	24.21	24.21	23.88	24.12	18600.0

> showing 50 of 536 rows — these rows as CSV

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