PREVIEW / stock_daily / 2011-12-14

all stock daily files

  file:    by_date/stock_daily/2011/2011-12-14.parquet
  size:    195 KB
  rows:    6,135
  symbols: 3,551

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-12-14	AAPL	Stock	13.8107	13.835	13.4886	13.5782	406887600.0
2011-12-14	MSFT	Stock	25.72	25.86	25.57	25.59	47926400.0
2011-12-14	NVDA	Stock	0.3502	0.3522	0.3358	0.3395	636020000.0
2011-12-14	AMZN	Stock	8.95	9.0375	8.5125	9.0105	232284000.0
2011-12-14	TSLA	Stock	1.9667	1.9787	1.8667	1.902	17458500.0
2011-12-14	TLT	Stock	119.7901	121.39	119.494	121.36	11247671.0
2011-12-14	ES	Stock	34.66	34.75	34.25	34.29	1785300.0
2011-12-14	CL	Stock	44.905	45.22	44.565	44.65	3762200.0
2011-12-14	A	Stock	23.6052	23.927	23.2546	23.5551	4577751.0
2011-12-14	AABA-DELISTED	Stock	15.2	15.28	14.8	15.02	25424047.0
2011-12-14	AACC-DELISTED	Stock	3.52	3.54	3.41	3.5	34226.0
2011-12-14	AACG	Stock	8.92	8.92	8.45	8.45	7000.0
2011-12-14	AAIC-DELISTED	Stock	21.35	21.71	21.11	21.6	60915.0
2011-12-14	AAME	Stock	2.05	2.05	2.0	2.0	900.0
2011-12-14	AAON	Stock	6.0119	6.2015	5.9852	6.1481	439088.0
2011-12-14	AAP	Stock	67.84	67.86	66.71	66.9	818900.0
2011-12-14	AAT	Stock	19.85	20.17	19.73	19.97	211000.0
2011-12-14	AATI-DELISTED	Stock	5.75	5.76	5.74	5.75	867649.0
2011-12-14	AAU-DELISTED	Stock	2.17	2.22	2.0	2.03	486322.0
2011-12-14	AAUAF-DELISTED	Stock	2.17	2.22	2.0	2.03	487322.0
2011-12-14	AAV-DELISTED	Stock	3.88	3.92	3.75	3.8	421781.0
2011-12-14	AAWW-DELISTED	Stock	36.14	36.356	34.45	35.79	389599.0
2011-12-14	AAXJ	Stock	49.39	49.71	49.01	49.16	558928.0
2011-12-14	AAXN-DELISTED	Stock	5.74	5.85	5.62	5.74	751653.0
2011-12-14	AB	Stock	13.03	13.17	12.8	12.85	467300.0
2011-12-14	ABAC-DELISTED	Stock	1.38	1.5	1.35	1.35	15202.0
2011-12-14	ABAX-DELISTED	Stock	26.37	26.77	26.05	26.32	116184.0
2011-12-14	ABB-DELISTED	Stock	17.8	17.9	17.51	17.61	3369124.0
2011-12-14	ABBNY-DELISTED	Stock	17.8	17.9	17.51	17.6	3377318.0
2011-12-14	ABC-DELISTED	Stock	35.63	35.95	35.56	35.58	2455276.0
2011-12-14	ABCB	Stock	9.62	10.3	9.62	10.24	78300.0
2011-12-14	ABCD-DELISTED	Stock	2.73	2.89	2.65	2.86	68447.0
2011-12-14	ABCO-DELISTED	Stock	34.91	35.4	34.43	34.55	168296.0
2011-12-14	ABCW-DELISTED	Stock	0.3569	0.3815	0.3524	0.362	104880.0
2011-12-14	ABD-DELISTED	Stock	9.765	9.995	9.625	9.765	455520.0
2011-12-14	ABE-DELISTED	Stock	17.12	17.12	16.78	16.78	8759.0
2011-12-14	ABEO	Stock	1750.0	1800.0	1750.0	1762.5	11.0
2011-12-14	ABFS-DELISTED	Stock	17.75	17.86	16.77	17.01	641529.0
2011-12-14	ABG	Stock	19.85	20.3	19.6	19.8	393200.0
2011-12-14	ABH-DELISTED	Stock	14.57	14.83	14.46	14.7	329811.0
2011-12-14	ABM	Stock	20.45	20.82	20.31	20.44	613900.0
2011-12-14	ABMD-DELISTED	Stock	20.16	20.36	19.6	20.0	382643.0
2011-12-14	ABR	Stock	3.29	3.33	3.22	3.25	26800.0
2011-12-14	ABT	Stock	25.9764	26.1299	25.9044	26.0196	13358900.0
2011-12-14	ABTL-DELISTED	Stock	3.9527	4.1055	3.8473	3.9	1861.0
2011-12-14	ABUS	Stock	1.6	1.61	1.58	1.61	10800.0
2011-12-14	ABV-DELISTED	Stock	35.02	35.26	34.9	35.0	2348309.0
2011-12-14	ABVT-DELISTED	Stock	64.74	65.03	63.788	63.89	154945.0
2011-12-14	ABX-DELISTED	Stock	45.53	45.81	44.14	44.67	13732669.0
2011-12-14	ACAD	Stock	1.0	1.02	0.98	1.01	389100.0

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

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