PREVIEW / etf_daily / 2007-12-27

all etf daily files

  file:    by_date/etf_daily/2007/2007-12-27.parquet
  size:    25 KB
  rows:    553

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-27	SPY	ETF	149.02	149.03	147.32	147.67	122981700.0
2007-12-27	QQQ	ETF	52.33	52.5	51.71	51.93	65778895.0
2007-12-27	IWM	ETF	78.86	79.08	76.91	77.39	71490100.0
2007-12-27	DIA	ETF	134.93	134.99	133.35	133.68	8127800.0
2007-12-27	GLD	ETF	81.88	82.17	81.37	81.56	5050300.0
2007-12-27	TLT	ETF	90.88	91.16	90.51	91.06	468600.0
2007-12-27	ADRE	ETF	56.0	56.1832	55.154	55.17	206942.0
2007-12-27	AGG	ETF	100.53	100.6	100.2	100.6	427200.0
2007-12-27	AIA	ETF	48.25	48.29	47.77	47.77	21800.0
2007-12-27	AIQ	ETF	49.1	49.1	47.15	47.6	25180.0
2007-12-27	AIS	ETF	0.99	1.08	0.96	1.0	104850.0
2007-12-27	AIVI	ETF	70.97	71.0	70.35	70.4	49200.0
2007-12-27	ARB	ETF	42.55	43.25	41.77	42.09	246000.0
2007-12-27	BBH	ETF	54.8067	55.0367	54.3633	54.4267	400800.0
2007-12-27	BIL	ETF	91.9	91.9	91.8	91.86	7150.0
2007-12-27	BITS	ETF	24.16	24.8	23.52	24.16	8098.0
2007-12-27	BIV	ETF	76.21	77.52	76.21	76.56	15000.0
2007-12-27	BKF	ETF	60.64	60.64	59.5	59.74	27800.0
2007-12-27	BLV	ETF	75.25	75.55	75.14	75.46	19200.0
2007-12-27	BMVP	ETF	17.69	17.69	17.3867	17.41	29810.0
2007-12-27	BND	ETF	76.36	76.66	76.08	76.34	100700.0
2007-12-27	BNE	ETF	18.41	18.49	17.77	17.77	81910.0
2007-12-27	BRF	ETF	14.68	14.68	14.62	14.62	8500.0
2007-12-27	BSV	ETF	76.72	76.74	76.54	76.67	28200.0
2007-12-27	BTF	ETF	110.44999999999999	110.5	109.55	109.55	140.0
2007-12-27	BWX	ETF	26.425	26.56	26.355	26.56	112984.0
2007-12-27	CBON	ETF	18.2	18.21	17.0901	17.2	73707.0
2007-12-27	CDL	ETF	2.05	2.251	2.05	2.09	4356579.0
2007-12-27	CEF	ETF	10.84	10.84	10.6	10.63	224700.0
2007-12-27	CGO	ETF	19.35	19.59	19.05	19.13	18000.0
2007-12-27	CGW	ETF	26.44	26.44	25.81	25.91	359300.0
2007-12-27	CHB	ETF	9.79	9.85	9.14	9.32	1302572.0
2007-12-27	CHI	ETF	15.19	15.2	14.51	14.91	309968.0
2007-12-27	CHIC	ETF	16.01	16.18	15.94	16.01	408908.0
2007-12-27	CHW	ETF	12.49	12.66	12.32	12.55	414400.0
2007-12-27	CHY	ETF	13.39	13.39	12.86	13.06	459939.0
2007-12-27	CMF	ETF	52.05	52.05	51.985	51.985	800.0
2007-12-27	CN	ETF	61.33	63.08	61.12	61.36	330974.0
2007-12-27	CNXT	ETF	0.91	0.919	0.86	0.8602	5761787.0
2007-12-27	COW	ETF	47.67	47.95	47.55	47.61	3400.0
2007-12-27	CPST	ETF	1.8	1.83	1.69	1.69	4177625.0
2007-12-27	CSA	ETF	16.26	16.43	16.12	16.25	26200.0
2007-12-27	CSD	ETF	27.02	27.25	26.85	26.85	49000.0
2007-12-27	CSQ	ETF	14.13	14.21	13.94	14.0	410100.0
2007-12-27	CUT	ETF	24.28	24.3	24.0	24.05	22700.0
2007-12-27	CVY	ETF	23.63	23.63	23.33	23.33	27100.0
2007-12-27	CWI	ETF	27.5733	27.6933	27.3	27.3	136350.0
2007-12-27	CZA	ETF	25.97	25.97	25.97	25.97	1000.0
2007-12-27	DBA	ETF	33.53	33.53	33.0	33.22	879200.0
2007-12-27	DBB	ETF	22.39	22.62	22.3	22.58	23600.0

> showing 50 of 553 rows — these rows as CSV

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