PREVIEW / stock_daily / 2012-11-30

all stock daily files

  file:    by_date/stock_daily/2012/2012-11-30.parquet
  size:    203 KB
  rows:    6,213
  symbols: 3,501

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-30	AAPL	Stock	20.9568	21.0143	20.81	20.9029	391319600.0
2012-11-30	MSFT	Stock	27.05	27.13	26.49	26.62	83690200.0
2012-11-30	NVDA	Stock	0.3008	0.303	0.2975	0.2992	460504000.0
2012-11-30	AMZN	Stock	12.519	12.6325	12.4135	12.6025	75948000.0
2012-11-30	META	Stock	27.26	28.0	26.76	28.0	127049600.0
2012-11-30	TSLA	Stock	2.242	2.2853	2.2007	2.2547	21304500.0
2012-11-30	TLT	Stock	125.48	125.54	124.71	124.79	3702398.0
2012-11-30	ES	Stock	38.22	38.77	38.2	38.74	1582400.0
2012-11-30	CL	Stock	54.07	54.375	53.935	54.25	3135000.0
2012-11-30	A	Stock	27.4464	27.525	27.1745	27.3891	3363868.0
2012-11-30	AABA-DELISTED	Stock	18.9	18.95	18.69	18.76	23559162.0
2012-11-30	AACC-DELISTED	Stock	5.36	6.029	5.08	5.65	57154.0
2012-11-30	AACG	Stock	4.12	4.18	4.1	4.18	1300.0
2012-11-30	AAIC-DELISTED	Stock	21.64	21.8749	21.55	21.64	180170.0
2012-11-30	AAME	Stock	2.95	2.95	2.87	2.95	2100.0
2012-11-30	AAMRQ-DELISTED	Stock	0.45	0.505	0.4455	0.502	5131830.0
2012-11-30	AAON	Stock	6.3704	6.4148	6.1926	6.237	259875.0
2012-11-30	AAP	Stock	73.52	73.89	73.0	73.15	1948100.0
2012-11-30	AAT	Stock	27.37	27.59	27.08	27.23	310700.0
2012-11-30	AAU-DELISTED	Stock	2.69	2.819	2.69	2.76	176014.0
2012-11-30	AAUAF-DELISTED	Stock	2.72	2.85	2.72	2.76	180128.0
2012-11-30	AAV-DELISTED	Stock	3.34	3.39	3.32	3.34	222292.0
2012-11-30	AAWW-DELISTED	Stock	43.43	43.579	43.0	43.26	190964.0
2012-11-30	AAXJ	Stock	58.36	58.36	58.02	58.2	193845.0
2012-11-30	AAXN-DELISTED	Stock	8.27	8.48	8.2	8.25	680322.0
2012-11-30	AB	Stock	17.93	18.0	17.5	17.58	241800.0
2012-11-30	ABAC-DELISTED	Stock	0.79	0.91	0.79	0.85	7781.0
2012-11-30	ABAX-DELISTED	Stock	37.93	37.95	37.51	37.74	136277.0
2012-11-30	ABB-DELISTED	Stock	19.52	19.57	19.35	19.43	1588444.0
2012-11-30	ABBNY-DELISTED	Stock	19.52	19.57	19.35	19.42	1701380.0
2012-11-30	ABC-DELISTED	Stock	41.68	42.24	41.46	42.21	2881429.0
2012-11-30	ABCB	Stock	11.41	11.42	11.07	11.39	78900.0
2012-11-30	ABCD-DELISTED	Stock	0.9968	1.22	0.922	0.93	3580.0
2012-11-30	ABCO-DELISTED	Stock	45.0	45.48	44.61	45.25	209998.0
2012-11-30	ABCW-DELISTED	Stock	0.381	0.42	0.381	0.42	28678.0
2012-11-30	ABE-DELISTED	Stock	20.33	20.5	20.29	20.48	25508.0
2012-11-30	ABEO	Stock	375.0	400.0	375.0	400.0	15.0
2012-11-30	ABFS-DELISTED	Stock	8.55	8.61	8.23	8.27	471995.0
2012-11-30	ABG	Stock	30.29	30.58	29.73	30.19	320100.0
2012-11-30	ABM	Stock	19.12	19.24	19.0	19.08	361100.0
2012-11-30	ABMD-DELISTED	Stock	13.94	13.94	13.18	13.34	1774930.0
2012-11-30	ABR	Stock	5.25	5.31	5.18	5.31	99500.0
2012-11-30	ABT	Stock	31.2446	31.3789	31.0239	31.187	13151938.0
2012-11-30	ABTL-DELISTED	Stock	3.79	3.832	3.79	3.83	3277.0
2012-11-30	ABUS	Stock	5.17	5.17	4.9	4.99	57300.0
2012-11-30	ABV-DELISTED	Stock	41.15	41.71	40.94	41.62	3419016.0
2012-11-30	ABVA-DELISTED	Stock	4.6501	4.7	4.56	4.61	4344.0
2012-11-30	ABX-DELISTED	Stock	34.76	35.07	34.13	34.51	5912984.0
2012-11-30	ACAD	Stock	5.15	5.44	5.15	5.2	3900400.0
2012-11-30	ACAS-DELISTED	Stock	11.97	11.993	11.82	11.978	4808469.0

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

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