PREVIEW / etf_daily / 2010-08-19

all etf daily files

  file:    by_date/etf_daily/2010/2010-08-19.parquet
  size:    33 KB
  rows:    767

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
2010-08-19	SPY	ETF	109.22	109.49	107.43	107.88	265847600.0
2010-08-19	QQQ	ETF	45.29	45.46	44.56	44.86	82969472.0
2010-08-19	IWM	ETF	62.59	62.85	60.94	61.09	89236900.0
2010-08-19	DIA	ETF	104.08	104.31	102.55	103.06	8882600.0
2010-08-19	GLD	ETF	120.65	120.99	120.11	120.39	10014500.0
2010-08-19	TLT	ETF	104.79	106.61	104.64	106.16	13128500.0
2010-08-19	AADR	ETF	25.75	25.75	25.75	25.75	500.0
2010-08-19	AAXJ	ETF	56.04	56.05	55.33	55.59	212500.0
2010-08-19	ACWI	ETF	40.93	40.94	40.13	40.36	97900.0
2010-08-19	ACWX	ETF	38.85	38.95	38.1201	38.39	56121.0
2010-08-19	ADRE	ETF	42.41	42.638	41.9301	42.16	207056.0
2010-08-19	AFK	ETF	30.66	30.81	30.0	30.24	11927.0
2010-08-19	AGG	ETF	108.11	108.5	108.08	108.45	469500.0
2010-08-19	AGQ	ETF	122.2	122.78	118.46	119.5	114950.0
2010-08-19	AGZ	ETF	110.98	111.2305	110.98	111.19	23243.0
2010-08-19	AIA	ETF	39.86	39.87	39.26	39.45	31119.0
2010-08-19	AIQ	ETF	23.35	23.65	23.05	23.35	30640.0
2010-08-19	AIS	ETF	1.6	1.67	1.55	1.55	642117.0
2010-08-19	AIVI	ETF	40.49	40.49	39.57	39.74	12600.0
2010-08-19	AMJ	ETF	32.73	32.99	32.54	32.64	861186.0
2010-08-19	AOA	ETF	29.84	29.84	29.4	29.47	16900.0
2010-08-19	AOK	ETF	27.82	27.8299	27.77	27.8	8702.0
2010-08-19	AOM	ETF	28.41	28.41	28.218	28.27	10023.0
2010-08-19	AOR	ETF	28.86	28.86	28.6856	28.73	8863.0
2010-08-19	ARB	ETF	25.52	25.63	24.96	25.4	214500.0
2010-08-19	BAB	ETF	26.58	26.72	26.532	26.69	518596.0
2010-08-19	BAL	ETF	41.02	41.111	41.0	41.024	1750.0
2010-08-19	BALT	ETF	11.5	11.5	10.89	11.03	153815.0
2010-08-19	BBH	ETF	30.83	30.87	30.21	30.3533	136200.0
2010-08-19	BIB	ETF	5.5788	5.5788	5.5788	5.5788	1600.0
2010-08-19	BICK	ETF	29.44	29.44	28.85	28.98	12786.0
2010-08-19	BIL	ETF	91.72	91.72	91.7	91.7	280000.0
2010-08-19	BIS	ETF	11481.6	11481.6	11481.6	11481.6	0.625
2010-08-19	BITS	ETF	25.8	26.08	23.12	24.0	46676.0
2010-08-19	BIV	ETF	85.97	86.32	85.88	86.25	126800.0
2010-08-19	BJK	ETF	25.99	26.0	25.53	25.78	3900.0
2010-08-19	BKF	ETF	44.76	44.84	44.08	44.36	95602.0
2010-08-19	BLV	ETF	85.87	86.89	85.7	86.58	58600.0
2010-08-19	BMVP	ETF	12.39	12.39	12.2	12.24	20404.0
2010-08-19	BND	ETF	82.28	82.6	82.28	82.57	490300.0
2010-08-19	BNE	ETF	11.16	11.17	11.1	11.11	393117.0
2010-08-19	BNO	ETF	25.595	25.595	25.34	25.405	67400.0
2010-08-19	BRF	ETF	51.34	51.34	50.65	51.02	716409.0
2010-08-19	BSCE	ETF	20.84	20.85	20.84	20.8499	5171.0
2010-08-19	BSV	ETF	81.57	81.64	81.52	81.62	287700.0
2010-08-19	BTF	ETF	69.0	69.14999999999999	68.2	68.5425	2074.4
2010-08-19	BWX	ETF	28.92	28.985	28.647	28.81	119804.0
2010-08-19	BWZ	ETF	35.41	35.46	35.207	35.32	15355.0
2010-08-19	BZQ	ETF	3326.4	3428.8	3318.4	3390.4	917.5
2010-08-19	CEF	ETF	15.11	15.18	15.0	15.05	605200.0

> showing 50 of 767 rows — these rows as CSV

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