PREVIEW / etf_daily / 2007-12-19

all etf daily files

  file:    by_date/etf_daily/2007/2007-12-19.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-19	SPY	ETF	145.94	146.89	144.94	145.88	198917200.0
2007-12-19	QQQ	ETF	49.89	50.2	49.61	49.88	137971798.0
2007-12-19	IWM	ETF	75.09	75.73	74.72	75.7	85850100.0
2007-12-19	DIA	ETF	132.51	133.12	131.58	132.27	14342800.0
2007-12-19	GLD	ETF	79.23	79.57	78.98	79.24	5638500.0
2007-12-19	TLT	ETF	92.4	93.56	91.88	93.23	2252400.0
2007-12-19	ADRE	ETF	53.2	53.672	52.9	53.21	290603.0
2007-12-19	AGG	ETF	101.14	101.56	100.89	101.27	634800.0
2007-12-19	AIA	ETF	47.37	47.44	46.7	47.2	13600.0
2007-12-19	AIQ	ETF	47.7	48.7	46.85	48.45	26200.0
2007-12-19	AIS	ETF	1.06	1.06	0.93	0.95	300328.0
2007-12-19	AIVI	ETF	69.28	69.36	68.37	68.69	68400.0
2007-12-19	ARB	ETF	41.89	42.2	41.31	41.93	326600.0
2007-12-19	BBH	ETF	53.7233	54.12	53.5733	53.8233	511200.0
2007-12-19	BIL	ETF	91.82	91.84	91.68	91.82	25800.0
2007-12-19	BITS	ETF	22.8	24.96	22.8	23.32	18192.0
2007-12-19	BIV	ETF	77.19	77.47	76.61	77.22	34900.0
2007-12-19	BKF	ETF	57.67	57.67	56.71	57.26	8100.0
2007-12-19	BLV	ETF	76.38	76.75	75.85	76.62	35200.0
2007-12-19	BMVP	ETF	17.1933	17.2835	17.1	17.1633	36218.0
2007-12-19	BND	ETF	76.83	77.07	76.5	76.99	105900.0
2007-12-19	BNE	ETF	17.93	18.03	17.6	17.9	127400.0
2007-12-19	BRF	ETF	14.61	14.61	14.58	14.58	10800.0
2007-12-19	BSV	ETF	77.19	77.26	76.97	77.13	39400.0
2007-12-19	BTF	ETF	110.64999999999999	110.64999999999999	109.93399999999998	109.93399999999998	340.0
2007-12-19	BWX	ETF	26.325	26.365	26.2	26.355	140400.0
2007-12-19	CBON	ETF	17.73	17.86	17.24	17.24	75644.0
2007-12-19	CDL	ETF	2.02	2.04	1.91	1.96	1741773.0
2007-12-19	CEF	ETF	10.51	10.51	10.43	10.45	280300.0
2007-12-19	CGO	ETF	19.21	19.27	18.3301	18.7	26700.0
2007-12-19	CGW	ETF	25.15	25.15	24.58	24.66	59800.0
2007-12-19	CHB	ETF	8.16	8.6	7.97	8.51	1123900.0
2007-12-19	CHI	ETF	14.0	14.02	13.65	13.66	355200.0
2007-12-19	CHIC	ETF	15.3	15.35	14.7	14.93	441111.0
2007-12-19	CHW	ETF	12.36	12.5	12.15	12.2	337400.0
2007-12-19	CHY	ETF	13.13	13.13	12.77	12.77	479206.0
2007-12-19	CMF	ETF	52.165	52.2	52.1649	52.165	39600.0
2007-12-19	CN	ETF	62.25	63.69	62.15	62.7	384100.0
2007-12-19	CNXT	ETF	0.9	0.949	0.8701	0.92	7256574.0
2007-12-19	COW	ETF	48.0	48.09	47.95	47.95	3300.0
2007-12-19	CPI	ETF	24.5	24.5	24.0001	24.0001	300.0
2007-12-19	CPST	ETF	1.62	1.71	1.52	1.57	6730722.0
2007-12-19	CSA	ETF	15.34	15.6	15.2	15.39	41400.0
2007-12-19	CSD	ETF	26.62	26.94	26.61	26.7	12200.0
2007-12-19	CSQ	ETF	13.78	13.82	13.63	13.72	279700.0
2007-12-19	CUT	ETF	23.37	23.4	23.1	23.25	22700.0
2007-12-19	CVY	ETF	23.47	23.5	23.22	23.35	21600.0
2007-12-19	CWI	ETF	27.3867	27.72	27.1533	27.4533	176700.0
2007-12-19	CZA	ETF	25.71	25.71	25.71	25.71	1400.0
2007-12-19	DBA	ETF	31.83	32.19	31.66	32.19	704900.0

> showing 50 of 546 rows — these rows as CSV

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