PREVIEW / etf_daily / 2007-12-06

all etf daily files

  file:    by_date/etf_daily/2007/2007-12-06.parquet
  size:    25 KB
  rows:    544

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-12-06	SPY	ETF	148.63	151.21	148.57	150.94	154457400.0
2007-12-06	QQQ	ETF	51.63	52.37	51.61	52.32	99763571.0
2007-12-06	IWM	ETF	76.21	78.44	76.17	78.25	93204000.0
2007-12-06	DIA	ETF	134.39	136.4	134.31	136.08	12317200.0
2007-12-06	GLD	ETF	77.92	79.65	77.8	79.37	6840200.0
2007-12-06	TLT	ETF	93.32	93.34	92.54	92.79	2270200.0
2007-12-06	ADRE	ETF	56.7	57.9	56.4801	57.83	356263.0
2007-12-06	AGG	ETF	101.37	101.7	101.14	101.44	805900.0
2007-12-06	AIA	ETF	50.85	51.47	50.34	51.47	14900.0
2007-12-06	AIQ	ETF	47.55	49.6	47.55	49.5	20880.0
2007-12-06	AIS	ETF	1.02	1.15	1.02	1.13	212800.0
2007-12-06	AIVI	ETF	74.19	75.27	74.19	75.27	36700.0
2007-12-06	ARB	ETF	40.58	42.03	40.45	41.99	299180.0
2007-12-06	BBH	ETF	57.17	57.7167	56.7	57.6067	1083000.0
2007-12-06	BIL	ETF	91.64	91.7	91.54	91.64	288200.0
2007-12-06	BITS	ETF	21.6	21.84	21.4	21.84	6438.0
2007-12-06	BIV	ETF	77.6	77.6	77.21	77.3	23800.0
2007-12-06	BKF	ETF	61.69	62.61	61.47	62.45	36400.0
2007-12-06	BLV	ETF	76.76	77.03	76.31	76.45	34700.0
2007-12-06	BMVP	ETF	17.1433	17.53	17.1433	17.51	54800.0
2007-12-06	BND	ETF	76.89	77.07	76.74	76.76	75500.0
2007-12-06	BNE	ETF	18.18	18.55	18.07	18.45	385100.0
2007-12-06	BRF	ETF	14.64	14.64	14.62	14.62	10300.0
2007-12-06	BSV	ETF	77.42	77.42	77.14	77.16	24800.0
2007-12-06	BTF	ETF	115.8	116.44999999999999	115.8	116.34949999999999	460.0
2007-12-06	BWX	ETF	26.965	26.965	26.865	26.89	114200.0
2007-12-06	CBON	ETF	17.81	18.96	17.68	18.96	39345.0
2007-12-06	CDL	ETF	2.0	2.02	1.95	1.98	3182912.0
2007-12-06	CEF	ETF	10.32	10.62	10.31	10.58	185600.0
2007-12-06	CGO	ETF	19.24	19.51	19.22	19.48	16800.0
2007-12-06	CGW	ETF	26.12	26.12	25.68	26.1	62876.0
2007-12-06	CHB	ETF	8.36	9.9	8.31	9.5	3869074.0
2007-12-06	CHI	ETF	15.07	15.07	14.79	14.83	233600.0
2007-12-06	CHIC	ETF	15.34	15.99	15.15	15.89	354481.0
2007-12-06	CHW	ETF	12.59	12.72	12.31	12.66	464107.0
2007-12-06	CHY	ETF	13.96	13.96	13.73	13.93	243300.0
2007-12-06	CMF	ETF	51.92	51.945	51.725	51.79	8400.0
2007-12-06	CN	ETF	63.33	65.26	62.69	64.95	357150.0
2007-12-06	CNXT	ETF	1.06	1.12	1.06	1.12	5828054.0
2007-12-06	COW	ETF	48.09	48.23	47.98	48.14	2900.0
2007-12-06	CPST	ETF	1.25	1.38	1.25	1.36	5648365.0
2007-12-06	CSA	ETF	15.43	16.42	15.35	16.2	44600.0
2007-12-06	CSD	ETF	27.4	27.7	27.4	27.7	6800.0
2007-12-06	CSQ	ETF	13.97	14.27	13.97	14.27	258700.0
2007-12-06	CUT	ETF	25.0	25.04	24.92	25.04	20500.0
2007-12-06	CVY	ETF	24.48	24.73	24.34	24.73	59700.0
2007-12-06	CWI	ETF	29.4067	29.4067	28.8067	29.2667	108450.0
2007-12-06	CZA	ETF	26.22	26.22	26.19	26.21	7400.0
2007-12-06	DBA	ETF	31.24	31.46	31.19	31.46	583700.0
2007-12-06	DBB	ETF	23.01	23.27	23.0	23.2	22300.0

> showing 50 of 544 rows — these rows as CSV

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