PREVIEW / stock_daily / 2012-10-05

all stock daily files

  file:    by_date/stock_daily/2012/2012-10-05.parquet
  size:    199 KB
  rows:    6,150
  symbols: 3,474

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-10-05	AAPL	Stock	23.7571	23.7857	23.26	23.3068	594006000.0
2012-10-05	MSFT	Stock	30.23	30.25	29.74	29.85	41133900.0
2012-10-05	NVDA	Stock	0.3415	0.345	0.3313	0.3325	483068000.0
2012-10-05	AMZN	Stock	13.06	13.095	12.8745	12.9255	56130000.0
2012-10-05	META	Stock	21.49	21.63	20.88	20.91	40529300.0
2012-10-05	TSLA	Stock	1.98	1.9873	1.912	1.926	14079000.0
2012-10-05	TLT	Stock	121.57	121.68	120.92	121.15	8341111.0
2012-10-05	ES	Stock	39.16	39.49	38.93	39.14	1923500.0
2012-10-05	CL	Stock	54.295	54.34	53.94	54.225	3713200.0
2012-10-05	A	Stock	28.2189	28.3119	27.6896	27.7969	3912163.0
2012-10-05	AABA-DELISTED	Stock	16.27	16.38	16.09	16.09	9027045.0
2012-10-05	AACC-DELISTED	Stock	7.68	8.0	7.67	7.96	27370.0
2012-10-05	AACG	Stock	5.4	5.42	5.2	5.21	7700.0
2012-10-05	AAIC-DELISTED	Stock	24.11	24.19	23.9	24.08	139703.0
2012-10-05	AAME	Stock	2.77	2.79	2.7	2.79	3100.0
2012-10-05	AAMRQ-DELISTED	Stock	0.3905	0.3955	0.3855	0.39	803371.0
2012-10-05	AAON	Stock	5.7185	5.917	5.7126	5.8281	193725.0
2012-10-05	AAP	Stock	69.73	70.64	69.52	69.87	519200.0
2012-10-05	AAT	Stock	27.63	27.91	27.53	27.69	125400.0
2012-10-05	AAU-DELISTED	Stock	2.65	2.7	2.4976	2.503	192960.0
2012-10-05	AAUAF-DELISTED	Stock	2.65	2.7	2.5	2.5	193277.0
2012-10-05	AAV-DELISTED	Stock	4.08	4.12	3.9501	3.98	144691.0
2012-10-05	AAWW-DELISTED	Stock	52.72	53.0	52.27	52.97	240156.0
2012-10-05	AAXJ	Stock	57.55	57.71	57.13	57.27	339515.0
2012-10-05	AAXN-DELISTED	Stock	5.97	6.0	5.85	5.95	454508.0
2012-10-05	AB	Stock	15.31	15.63	15.23	15.57	208700.0
2012-10-05	ABAC-DELISTED	Stock	1.47	1.51	1.46	1.46	3840.0
2012-10-05	ABAX-DELISTED	Stock	38.0	38.64	37.88	38.0	92204.0
2012-10-05	ABB-DELISTED	Stock	19.52	19.57	19.32	19.39	1863111.0
2012-10-05	ABBNY-DELISTED	Stock	19.52	19.57	19.32	19.4	1920993.0
2012-10-05	ABC-DELISTED	Stock	39.44	39.85	39.29	39.52	3000173.0
2012-10-05	ABCB	Stock	12.52	12.81	12.46	12.59	25300.0
2012-10-05	ABCD-DELISTED	Stock	0.98	1.05	0.98	0.99	7306.0
2012-10-05	ABCO-DELISTED	Stock	48.91	49.57	47.96	48.08	118164.0
2012-10-05	ABCW-DELISTED	Stock	0.4	0.405	0.38	0.405	37175.0
2012-10-05	ABE-DELISTED	Stock	20.89	20.9299	20.89	20.9283	3140.0
2012-10-05	ABEO	Stock	512.5	512.5	475.0	475.0	11.0
2012-10-05	ABFS-DELISTED	Stock	7.8	8.04	7.75	7.89	275204.0
2012-10-05	ABG	Stock	29.35	30.08	29.35	29.77	174800.0
2012-10-05	ABM	Stock	19.02	19.02	18.46	18.49	512900.0
2012-10-05	ABMD-DELISTED	Stock	20.89	21.13	20.62	20.7	290864.0
2012-10-05	ABR	Stock	5.71	5.75	5.66	5.7	3677700.0
2012-10-05	ABT	Stock	34.157	34.5024	34.1426	34.3585	13432889.0
2012-10-05	ABTL-DELISTED	Stock	3.85	3.87	3.84	3.87	8390.0
2012-10-05	ABUS	Stock	4.35	4.35	3.6	3.6	20600.0
2012-10-05	ABV-DELISTED	Stock	40.1	40.49	40.03	40.23	1531906.0
2012-10-05	ABVA-DELISTED	Stock	4.68	4.75	4.53	4.6	6463.0
2012-10-05	ABX-DELISTED	Stock	41.97	42.46	41.78	42.0	6259937.0
2012-10-05	ACAD	Stock	2.77	3.06	2.48	2.62	7261600.0
2012-10-05	ACAS-DELISTED	Stock	11.7	11.86	11.7	11.825	2078335.0

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

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