PREVIEW / stock_daily / 2012-11-20

all stock daily files

  file:    by_date/stock_daily/2012/2012-11-20.parquet
  size:    200 KB
  rows:    6,194
  symbols: 3,489

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
2012-11-20	AAPL	Stock	20.4254	20.4268	19.8064	20.0325	642754000.0
2012-11-20	MSFT	Stock	26.76	26.8	26.46	26.71	47070400.0
2012-11-20	NVDA	Stock	0.2895	0.2908	0.2842	0.2872	336976000.0
2012-11-20	AMZN	Stock	11.5	11.691	11.475	11.689	55434000.0
2012-11-20	META	Stock	22.73	23.9	22.7	23.1	46655300.0
2012-11-20	TSLA	Stock	2.1867	2.2067	2.1273	2.2	13837500.0
2012-11-20	TLT	Stock	125.48	125.67	124.38	124.4	4659214.0
2012-11-20	ES	Stock	38.22	38.53	37.69	38.09	1740800.0
2012-11-20	CL	Stock	53.305	53.545	53.0	53.455	2351200.0
2012-11-20	A	Stock	25.7082	26.4092	25.608	25.9514	14707939.0
2012-11-20	AABA-DELISTED	Stock	18.44	18.5	18.19	18.25	25302535.0
2012-11-20	AACC-DELISTED	Stock	4.49	4.49	4.03	4.42	15114.0
2012-11-20	AACG	Stock	4.62	4.62	4.41	4.5	2800.0
2012-11-20	AAIC-DELISTED	Stock	21.01	21.21	20.43	20.65	128259.0
2012-11-20	AAME	Stock	2.9	2.94	2.88	2.94	800.0
2012-11-20	AAMRQ-DELISTED	Stock	0.374	0.383	0.364	0.383	684051.0
2012-11-20	AAON	Stock	5.763	6.0385	5.7185	5.9852	387450.0
2012-11-20	AAP	Stock	77.53	78.49	77.11	77.65	601900.0
2012-11-20	AAT	Stock	27.23	27.59	26.99	27.52	109300.0
2012-11-20	AAU-DELISTED	Stock	2.57	2.6199	2.5	2.5	83682.0
2012-11-20	AAUAF-DELISTED	Stock	2.57	2.6199	2.5	2.5	84082.0
2012-11-20	AAV-DELISTED	Stock	3.35	3.39	3.33	3.35	421420.0
2012-11-20	AAWW-DELISTED	Stock	42.06	42.4	41.57	42.18	129025.0
2012-11-20	AAXJ	Stock	56.19	56.34	55.93	56.34	93973.0
2012-11-20	AAXN-DELISTED	Stock	8.06	8.18	7.9584	8.08	303633.0
2012-11-20	AB	Stock	16.6	17.29	16.43	17.08	263000.0
2012-11-20	ABAC-DELISTED	Stock	0.73	0.918	0.73	0.8299	6800.0
2012-11-20	ABAX-DELISTED	Stock	35.62	36.48	35.49	36.48	68288.0
2012-11-20	ABB-DELISTED	Stock	18.13	18.14	17.945	18.0	3018826.0
2012-11-20	ABBNY-DELISTED	Stock	18.13	18.14	17.945	18.0	3151626.0
2012-11-20	ABC-DELISTED	Stock	40.62	40.8	40.4	40.79	1941101.0
2012-11-20	ABCB	Stock	10.82	11.05	10.76	10.78	27300.0
2012-11-20	ABCD-DELISTED	Stock	1.01	1.01	0.85	0.96	11690.0
2012-11-20	ABCO-DELISTED	Stock	43.54	43.75	42.83	43.13	220720.0
2012-11-20	ABCW-DELISTED	Stock	0.37	0.4198	0.37	0.4196	9897.0
2012-11-20	ABE-DELISTED	Stock	20.18	20.19	20.16	20.1799	7298.0
2012-11-20	ABEO	Stock	300.0	312.5	300.0	300.0	31.0
2012-11-20	ABFS-DELISTED	Stock	7.15	7.23	6.99	7.2	325069.0
2012-11-20	ABG	Stock	29.02	29.6	28.93	29.57	155500.0
2012-11-20	ABM	Stock	18.35	18.53	18.2	18.53	105500.0
2012-11-20	ABMD-DELISTED	Stock	14.07	14.13	13.77	13.9	443353.0
2012-11-20	ABR	Stock	5.04	5.11	5.0	5.09	75800.0
2012-11-20	ABT	Stock	30.1314	30.5009	30.0451	30.2658	17339308.0
2012-11-20	ABTL-DELISTED	Stock	4.12	4.13	3.95	4.1	9236.0
2012-11-20	ABUS	Stock	5.3	5.37	5.14	5.2	103300.0
2012-11-20	ABV-DELISTED	Stock	40.12	40.44	40.09	40.25	806429.0
2012-11-20	ABVA-DELISTED	Stock	4.38	4.5	4.38	4.47	9000.0
2012-11-20	ABX-DELISTED	Stock	34.3	34.57	33.99	34.3	6109541.0
2012-11-20	ACAD	Stock	2.35	2.38	2.1	2.13	2287400.0
2012-11-20	ACAS-DELISTED	Stock	11.6	11.73	11.51	11.68	1840420.0

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

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