PREVIEW / stock_daily / 2011-10-14

all stock daily files

  file:    by_date/stock_daily/2011/2011-10-14.parquet
  size:    193 KB
  rows:    6,063
  symbols: 3,519

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-10-14	AAPL	Stock	14.8868	15.0714	14.8311	15.0714	573367200.0
2011-10-14	MSFT	Stock	27.31	27.5	27.02	27.27	50947700.0
2011-10-14	NVDA	Stock	0.3933	0.3973	0.3835	0.393	702452000.0
2011-10-14	AMZN	Stock	12.0435	12.3355	12.009	12.3355	118474000.0
2011-10-14	TSLA	Stock	1.8667	1.9033	1.8173	1.87	21007500.0
2011-10-14	TLT	Stock	113.88	114.61	113.61	113.95	8410961.0
2011-10-14	ES	Stock	33.11	33.34	32.86	33.31	1596000.0
2011-10-14	CL	Stock	45.93	46.23	45.815	46.17	2951400.0
2011-10-14	A	Stock	23.7196	23.9986	23.6195	23.8484	8137059.0
2011-10-14	AABA-DELISTED	Stock	16.14	16.15	15.66	15.91	21612559.0
2011-10-14	AACC-DELISTED	Stock	3.115	3.125	3.07	3.1	31006.0
2011-10-14	AACG	Stock	9.01	9.16	8.95	9.01	10400.0
2011-10-14	AAIC-DELISTED	Stock	25.0	25.07	24.34	25.04	42455.0
2011-10-14	AAME	Stock	1.86	1.87	1.8	1.85	7700.0
2011-10-14	AAON	Stock	5.5378	5.7719	5.4874	5.7452	178875.0
2011-10-14	AAP	Stock	60.4	60.78	59.62	60.74	519700.0
2011-10-14	AAT	Stock	18.46	18.77	18.46	18.68	87900.0
2011-10-14	AATI-DELISTED	Stock	4.49	4.49	4.45	4.49	121605.0
2011-10-14	AAU-DELISTED	Stock	2.52	2.56	2.48	2.54	158167.0
2011-10-14	AAUAF-DELISTED	Stock	2.52	2.56	2.48	2.54	158967.0
2011-10-14	AAV-DELISTED	Stock	4.73	4.825	4.592	4.76	421470.0
2011-10-14	AAWW-DELISTED	Stock	35.67	35.97	35.01	35.83	149966.0
2011-10-14	AAXJ	Stock	51.66	52.26	51.61	52.15	791768.0
2011-10-14	AAXN-DELISTED	Stock	4.62	4.75	4.56	4.62	808357.0
2011-10-14	AB	Stock	14.21	14.35	13.9	14.3	187900.0
2011-10-14	ABAC-DELISTED	Stock	1.74	1.74	1.65	1.68	8100.0
2011-10-14	ABAX-DELISTED	Stock	24.16	24.23	23.69	24.07	154546.0
2011-10-14	ABB-DELISTED	Stock	19.57	19.63	19.3	19.47	2494366.0
2011-10-14	ABBNY-DELISTED	Stock	19.57	19.63	19.3	19.48	2770954.0
2011-10-14	ABC-DELISTED	Stock	38.29	38.475	37.98	38.16	1504291.0
2011-10-14	ABCB	Stock	9.6	9.71	9.34	9.65	44700.0
2011-10-14	ABCD-DELISTED	Stock	3.12	3.12	3.05	3.08	33851.0
2011-10-14	ABCO-DELISTED	Stock	31.85	32.55	31.74	32.51	66231.0
2011-10-14	ABCW-DELISTED	Stock	0.54	0.55	0.49	0.52	14600.0
2011-10-14	ABD-DELISTED	Stock	5.5849	5.8151	5.5048	5.7951	155210.0
2011-10-14	ABE-DELISTED	Stock	17.54	17.68	17.54	17.6	2560.0
2011-10-14	ABEO	Stock	2250.0	2275.0	2050.0	2250.0	27.0
2011-10-14	ABFS-DELISTED	Stock	17.76	18.32	17.6915	18.29	360837.0
2011-10-14	ABG	Stock	19.45	19.56	18.87	19.3	221300.0
2011-10-14	ABH-DELISTED	Stock	16.19	16.2	15.575	15.8	174008.0
2011-10-14	ABM	Stock	20.08	20.55	19.95	20.51	192600.0
2011-10-14	ABMD-DELISTED	Stock	12.17	12.33	11.95	12.3	151805.0
2011-10-14	ABR	Stock	3.35	3.4	3.26	3.26	59100.0
2011-10-14	ABT	Stock	25.1415	25.3142	25.0983	25.2999	9486661.0
2011-10-14	ABTL-DELISTED	Stock	4.4	4.5825	4.3	4.5	13128.0
2011-10-14	ABUS	Stock	1.85	1.85	1.7	1.8	3100.0
2011-10-14	ABV-DELISTED	Stock	33.2	33.3	32.69	33.04	2230025.0
2011-10-14	ABVA-DELISTED	Stock	5.04	5.2	5.0	5.12	12807.0
2011-10-14	ABVT-DELISTED	Stock	58.75	59.62	58.36	59.22	80017.0
2011-10-14	ABX-DELISTED	Stock	47.59	48.28	47.3	48.25	4523622.0

> showing 50 of 6,063 rows — these rows as CSV

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