PREVIEW / etf_daily / 2011-01-05

all etf daily files

  file:    by_date/etf_daily/2011/2011-01-05.parquet
  size:    35 KB
  rows:    823

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
2011-01-05	SPY	ETF	126.58	127.72	126.46	127.64	133975300.0
2011-01-05	QQQ	ETF	55.11	55.76	55.07	55.74	43787167.0
2011-01-05	IWM	ETF	78.4	79.36	78.11	79.34	47145300.0
2011-01-05	DIA	ETF	116.46	117.19	116.3	117.04	7567800.0
2011-01-05	GLD	ETF	133.5	134.68	133.1	134.37	16700900.0
2011-01-05	TLT	ETF	92.49	92.69	91.19	91.46	17568000.0
2011-01-05	AADR	ETF	29.84	29.9	29.8	29.83	14100.0
2011-01-05	AAXJ	ETF	64.44	64.91	64.44	64.78	314900.0
2011-01-05	ACWI	ETF	46.82	47.14	46.69	47.11	346800.0
2011-01-05	ACWX	ETF	43.76	44.17	43.65	44.13	342209.0
2011-01-05	ADRE	ETF	48.21	48.52	48.12	48.45	34634.0
2011-01-05	AFK	ETF	35.23	35.832	35.181	35.71	81005.0
2011-01-05	AGG	ETF	105.28	105.36	104.94	105.15	864200.0
2011-01-05	AGQ	ETF	282.18	287.28	270.72	284.6	988250.0
2011-01-05	AGZ	ETF	109.4692	109.48	109.13	109.13	41018.0
2011-01-05	AIA	ETF	47.64	47.9	47.5214	47.85	51006.0
2011-01-05	AIQ	ETF	21.45	21.55	21.0	21.3	25184.0
2011-01-05	AIS	ETF	1.74	1.75	1.72	1.75	256843.0
2011-01-05	AIVI	ETF	43.23	43.72	43.21	43.63	136500.0
2011-01-05	AMJ	ETF	36.34	36.4391	36.22	36.39	510397.0
2011-01-05	AMLP	ETF	80.45	80.45	80.15	80.25	135820.0
2011-01-05	AOA	ETF	34.39	34.65	34.39	34.65	19000.0
2011-01-05	AOK	ETF	28.7446	28.81	28.73	28.8	6797.0
2011-01-05	AOM	ETF	29.91	30.0	29.9	29.99	15361.0
2011-01-05	AOR	ETF	31.49	31.62	31.46	31.57	81192.0
2011-01-05	ARB	ETF	41.72	42.81	41.68	42.14	216179.0
2011-01-05	BAB	ETF	24.88	24.94	24.78	24.8498	289053.0
2011-01-05	BAL	ETF	72.92	75.26	72.45	73.95	55287.0
2011-01-05	BALT	ETF	10.34	10.65	10.22	10.6	186388.0
2011-01-05	BBH	ETF	33.68	34.0567	33.68	33.91	60300.0
2011-01-05	BIB	ETF	7.6463	7.6787	7.6463	7.675	9600.0
2011-01-05	BICK	ETF	33.32	33.41	33.225	33.329	47962.0
2011-01-05	BIL	ETF	91.7	91.72	91.7	91.72	184350.0
2011-01-05	BITS	ETF	28.8	29.16	27.68	28.76	1998.0
2011-01-05	BIV	ETF	82.17	82.21	81.77	81.93	139300.0
2011-01-05	BJK	ETF	31.94	32.47	31.94	32.42	14700.0
2011-01-05	BKF	ETF	50.12	50.36	49.86	50.26	117464.0
2011-01-05	BLV	ETF	78.43	78.5	77.63	77.89	31300.0
2011-01-05	BMVP	ETF	14.65	14.78	14.65	14.76	23432.0
2011-01-05	BND	ETF	79.93	79.98	79.68	79.83	837300.0
2011-01-05	BNO	ETF	31.7	31.84	31.7	31.8	8800.0
2011-01-05	BRF	ETF	57.97	58.22	57.8	57.96	365932.0
2011-01-05	BSCE	ETF	20.65	20.67	20.6292	20.646	17077.0
2011-01-05	BSV	ETF	80.24	80.29	80.17	80.21	969900.0
2011-01-05	BTF	ETF	77.89999999999999	78.89999999999999	77.89999999999999	78.2	1549.4
2011-01-05	BWX	ETF	28.795	28.805	28.66	28.665	396386.0
2011-01-05	BWZ	ETF	36.65	36.76	36.49	36.58	19975.0
2011-01-05	BZQ	ETF	2395.2	2396.8	2331.2	2396.8	362.5
2011-01-05	CEF	ETF	19.71	19.93	19.19	19.77	2105300.0
2011-01-05	CEW	ETF	22.4	22.41	22.34	22.4	188199.0

> showing 50 of 823 rows — these rows as CSV

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