PREVIEW / etf_daily / 2008-01-14

all etf daily files

  file:    by_date/etf_daily/2008/2008-01-14.parquet
  size:    25 KB
  rows:    554

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
2008-01-14	SPY	ETF	141.16	141.86	140.4	141.28	170365500.0
2008-01-14	QQQ	ETF	47.69	48.01	47.31	47.87	168048431.0
2008-01-14	IWM	ETF	71.01	71.19	70.26	70.8	71078600.0
2008-01-14	DIA	ETF	127.28	127.92	126.69	127.51	7932600.0
2008-01-14	GLD	ETF	89.45	89.94	89.0	89.54	10085000.0
2008-01-14	TLT	ETF	94.2	94.55	94.0	94.55	906100.0
2008-01-14	ADRE	ETF	53.63	53.92	53.28	53.75	351689.0
2008-01-14	AGG	ETF	102.51	102.65	102.38	102.59	290400.0
2008-01-14	AIA	ETF	46.12	46.26	45.8	46.16	20900.0
2008-01-14	AIQ	ETF	49.1	49.7	48.25	48.8	45260.0
2008-01-14	AIS	ETF	0.99	0.99	0.96	0.975	57895.0
2008-01-14	AIVI	ETF	69.09	69.35	68.72	69.2	57600.0
2008-01-14	ARB	ETF	41.05	41.26	40.02	40.5	236020.0
2008-01-14	BBH	ETF	56.6633	56.8633	55.8867	56.33	743100.0
2008-01-14	BIL	ETF	91.66	91.72	91.62	91.7	51900.0
2008-01-14	BITS	ETF	22.0	23.2	21.6804	22.16	7284.0
2008-01-14	BIV	ETF	78.61	78.61	78.32	78.52	30600.0
2008-01-14	BKF	ETF	60.52	60.52	58.5	58.61	132600.0
2008-01-14	BLV	ETF	79.78	79.78	77.24	77.28	14100.0
2008-01-14	BMVP	ETF	16.4733	16.6233	16.4567	16.59	40300.0
2008-01-14	BND	ETF	77.96	77.96	77.71	77.87	171500.0
2008-01-14	BNE	ETF	13.79	13.91	13.7	13.78	177500.0
2008-01-14	BRF	ETF	14.66	14.68	14.66	14.66	16700.0
2008-01-14	BSV	ETF	77.92	77.96	77.85	77.93	31100.0
2008-01-14	BTF	ETF	108.2	108.55	106.99999999999999	108.1	1540.0
2008-01-14	BWX	ETF	27.485	27.495	27.29	27.47	341200.0
2008-01-14	CBON	ETF	14.83	15.33	14.73	14.78	62898.0
2008-01-14	CDL	ETF	1.58	1.59	1.5	1.52	1253458.0
2008-01-14	CEF	ETF	11.52	11.7	11.45	11.59	773000.0
2008-01-14	CGO	ETF	19.02	19.18	18.87	19.15	13905.0
2008-01-14	CGW	ETF	24.33	24.6936	24.3	24.65	150628.0
2008-01-14	CHB	ETF	8.14	8.27	7.63	8.16	1488700.0
2008-01-14	CHI	ETF	15.8	15.965	15.61	15.75	134075.0
2008-01-14	CHIC	ETF	14.58	14.65	13.82	14.02	622780.0
2008-01-14	CHW	ETF	13.01	13.07	12.86	13.02	158800.0
2008-01-14	CHY	ETF	13.95	14.19	13.91	13.95	249180.0
2008-01-14	CMF	ETF	52.71	52.93	52.7	52.93	3800.0
2008-01-14	CN	ETF	63.05	63.6	62.41	63.14	178107.0
2008-01-14	CNXT	ETF	0.67	0.7422	0.659	0.74	11164816.0
2008-01-14	COW	ETF	46.4	46.4	45.36	45.6	10200.0
2008-01-14	CPST	ETF	1.64	1.67	1.53	1.59	2689920.0
2008-01-14	CSA	ETF	16.07	16.07	15.38	15.64	14300.0
2008-01-14	CSD	ETF	24.66	24.66	24.48	24.61	11000.0
2008-01-14	CSQ	ETF	14.18	14.22	13.95	14.17	290931.0
2008-01-14	CUT	ETF	22.5	22.55	22.32	22.32	38500.0
2008-01-14	CVY	ETF	22.51	22.51	22.28	22.5	20900.0
2008-01-14	CWI	ETF	26.8933	26.8933	26.6933	26.7533	252900.0
2008-01-14	CZA	ETF	24.46	24.46	24.46	24.46	300.0
2008-01-14	DBA	ETF	36.34	36.84	36.05	36.39	3913400.0
2008-01-14	DBB	ETF	22.98	23.48	22.98	23.28	45900.0

> showing 50 of 554 rows — these rows as CSV

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