PREVIEW / etf_daily / 2007-12-18

all etf daily files

  file:    by_date/etf_daily/2007/2007-12-18.parquet
  size:    25 KB
  rows:    546

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-18	SPY	ETF	146.1	146.48	143.96	145.88	245569300.0
2007-12-18	QQQ	ETF	50.24	50.27	49.18	49.89	154251626.0
2007-12-18	IWM	ETF	74.67	75.41	73.35	75.17	114501900.0
2007-12-18	DIA	ETF	132.67	132.92	131.06	132.55	13719100.0
2007-12-18	GLD	ETF	79.59	79.59	78.82	79.25	6757700.0
2007-12-18	TLT	ETF	91.59	92.3	91.55	92.01	1417100.0
2007-12-18	ADRE	ETF	52.61	53.19	51.55	52.84	293720.0
2007-12-18	AGG	ETF	100.93	101.1	100.68	101.06	402300.0
2007-12-18	AIA	ETF	47.82	47.82	45.22	45.84	24000.0
2007-12-18	AIQ	ETF	45.5	47.5	45.5	47.5	75860.0
2007-12-18	AIS	ETF	0.99	1.01	0.98	1.0	149300.0
2007-12-18	AIVI	ETF	69.42	69.83	68.51	69.56	51600.0
2007-12-18	ARB	ETF	41.02	41.91	40.9	41.82	370500.0
2007-12-18	BBH	ETF	53.9333	54.2567	53.4367	53.89	999900.0
2007-12-18	BIL	ETF	91.68	91.78	91.66	91.78	26500.0
2007-12-18	BITS	ETF	22.96	23.28	21.84	23.0	5880.0
2007-12-18	BIV	ETF	76.56	83.0	76.56	76.96	23300.0
2007-12-18	BKF	ETF	56.26	57.24	55.0	57.24	30500.0
2007-12-18	BLV	ETF	75.8	76.1	75.77	76.03	12300.0
2007-12-18	BMVP	ETF	17.16	17.26	17.0	17.19	30931.0
2007-12-18	BND	ETF	76.33	76.73	76.33	76.67	72000.0
2007-12-18	BNE	ETF	17.47	18.04	17.26	18.04	132900.0
2007-12-18	BRF	ETF	14.62	14.62	14.61	14.61	3300.0
2007-12-18	BSV	ETF	76.92	77.1	76.92	77.08	61300.0
2007-12-18	BTF	ETF	111.19999999999999	111.5	110.29999999999998	110.29999999999998	660.0
2007-12-18	BWX	ETF	26.26	26.345	26.245	26.3	50800.0
2007-12-18	CBON	ETF	17.14	18.01	16.52	17.73	141112.0
2007-12-18	CDL	ETF	1.97	2.02	1.91	1.99	1885670.0
2007-12-18	CEF	ETF	10.35	10.52	10.35	10.41	375600.0
2007-12-18	CGO	ETF	19.15	19.21	18.97	19.21	12900.0
2007-12-18	CGW	ETF	24.77	24.91	24.34	24.7901	75900.0
2007-12-18	CHB	ETF	8.11	8.23	7.84	8.16	1430200.0
2007-12-18	CHI	ETF	14.1	14.1	13.67	13.89	338900.0
2007-12-18	CHIC	ETF	15.1	15.33	14.59	15.31	547559.0
2007-12-18	CHW	ETF	12.6	12.76	12.37	12.43	340000.0
2007-12-18	CHY	ETF	13.11	13.14	12.77	12.84	385500.0
2007-12-18	CMF	ETF	52.175	52.175	52.16	52.16	31400.0
2007-12-18	CN	ETF	60.47	61.33	59.25	61.18	301000.0
2007-12-18	CNXT	ETF	0.95	0.97	0.9	0.909	5346410.0
2007-12-18	COW	ETF	47.44	47.61	47.44	47.61	800.0
2007-12-18	CPST	ETF	1.44	1.61	1.35	1.58	4462923.0
2007-12-18	CSA	ETF	16.0	16.0	15.21	15.27	35800.0
2007-12-18	CSD	ETF	26.78	26.81	26.44	26.81	12600.0
2007-12-18	CSQ	ETF	13.82	13.94	13.58	13.75	450000.0
2007-12-18	CUT	ETF	22.5	23.3	22.0	23.1	25500.0
2007-12-18	CVY	ETF	23.35	23.48	23.1	23.35	18100.0
2007-12-18	CWI	ETF	27.7333	27.7333	27.0467	27.3933	85650.0
2007-12-18	DBA	ETF	31.71	31.71	31.49	31.63	562400.0
2007-12-18	DBB	ETF	21.5	21.64	20.83	21.34	84800.0
2007-12-18	DBC	ETF	30.59	30.88	30.11	30.39	311494.0

> showing 50 of 546 rows — these rows as CSV

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