PREVIEW / etf_daily / 2010-08-12

all etf daily files

  file:    by_date/etf_daily/2010/2010-08-12.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-12	SPY	ETF	107.65	109.02	107.6	108.63	239542600.0
2010-08-12	QQQ	ETF	44.56	45.24	44.45	45.04	66000468.0
2010-08-12	IWM	ETF	60.85	62.15	60.76	61.77	63300200.0
2010-08-12	DIA	ETF	102.85	103.87	102.78	103.45	14562800.0
2010-08-12	GLD	ETF	118.56	118.86	118.46	118.77	12327000.0
2010-08-12	TLT	ETF	101.58	101.94	100.87	101.03	7590100.0
2010-08-12	AADR	ETF	25.04	25.04	25.04	25.04	1000.0
2010-08-12	AAXJ	ETF	54.35	54.98	54.34	54.79	356300.0
2010-08-12	ACWI	ETF	39.97	40.47	39.97	40.32	166600.0
2010-08-12	ACWX	ETF	37.85	38.21	37.85	38.1	51193.0
2010-08-12	ADRE	ETF	41.16	41.9	41.15	41.89	96408.0
2010-08-12	AFK	ETF	30.0	30.25	30.0	30.126	9630.0
2010-08-12	AGG	ETF	107.93	107.98	107.67	107.74	671600.0
2010-08-12	AGQ	ETF	115.34	116.86	115.08	116.48	94300.0
2010-08-12	AGZ	ETF	110.95	110.95	110.76	110.8	9422.0
2010-08-12	AIA	ETF	38.95	39.25	38.86	39.185	11117.0
2010-08-12	AIQ	ETF	22.1	23.25	21.8	22.8	24021.0
2010-08-12	AIS	ETF	1.66	1.7	1.6	1.65	471724.0
2010-08-12	AIVI	ETF	39.71	39.87	39.64	39.82	5900.0
2010-08-12	AMJ	ETF	31.92	32.18	31.62	32.01	830613.0
2010-08-12	AOA	ETF	29.18	29.57	29.18	29.54	9700.0
2010-08-12	AOK	ETF	27.81	27.81	27.71	27.748	22372.0
2010-08-12	AOM	ETF	28.19	28.26	28.19	28.25	5367.0
2010-08-12	AOR	ETF	28.55	28.74	28.55	28.74	2797.0
2010-08-12	ARB	ETF	25.86	26.38	25.47	26.25	157308.0
2010-08-12	BAB	ETF	26.25	26.38	26.25	26.3	483187.0
2010-08-12	BAL	ETF	40.7	41.0	40.144	40.72	18428.0
2010-08-12	BALT	ETF	10.71	10.87	10.37	10.39	318043.0
2010-08-12	BBH	ETF	30.79	31.3967	30.79	31.3633	81600.0
2010-08-12	BICK	ETF	28.57	28.57	28.17	28.44	62579.0
2010-08-12	BIL	ETF	91.7	91.72	91.7	91.72	955750.0
2010-08-12	BIS	ETF	11356.8	11356.8	10958.4	11052.8	16.9
2010-08-12	BITS	ETF	27.9996	27.9996	27.8	27.8	125.0
2010-08-12	BIV	ETF	85.73	85.73	85.33	85.36	335100.0
2010-08-12	BJK	ETF	24.91	24.99	24.81	24.93	5700.0
2010-08-12	BKF	ETF	43.02	43.749	43.01	43.71	209137.0
2010-08-12	BLV	ETF	83.82	83.89	83.36	83.47	65700.0
2010-08-12	BMVP	ETF	12.093	12.289	12.093	12.27	16823.0
2010-08-12	BND	ETF	82.07	82.18	81.98	82.01	482900.0
2010-08-12	BNE	ETF	11.16	11.2	11.16	11.18	324316.0
2010-08-12	BNO	ETF	25.83	25.915	25.58	25.58	32000.0
2010-08-12	BRF	ETF	47.92	48.82	47.75	48.57	228974.0
2010-08-12	BSCE	ETF	20.8118	20.82	20.8099	20.8199	2180.0
2010-08-12	BSV	ETF	81.53	81.53	81.41	81.44	212900.0
2010-08-12	BTF	ETF	68.6	69.19999999999999	68.5495	69.1	2918.8
2010-08-12	BWX	ETF	28.4	29.1525	28.4	28.55	136530.0
2010-08-12	BWZ	ETF	35.2	35.27	35.06	35.208	10974.0
2010-08-12	BZQ	ETF	3632.0	3648.0	3504.0	3520.0	1857.0
2010-08-12	CEF	ETF	14.74	14.84	14.72	14.83	631000.0
2010-08-12	CEW	ETF	21.95	21.97	21.9	21.92	71237.0

> showing 50 of 767 rows — these rows as CSV

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