PREVIEW / stock_daily / 2012-09-10

all stock daily files

  file:    by_date/stock_daily/2012/2012-09-10.parquet
  size:    199 KB
  rows:    6,149
  symbols: 3,485

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-09-10	AAPL	Stock	24.3018	24.4032	23.6464	23.6693	487998000.0
2012-09-10	MSFT	Stock	30.83	30.9	30.51	30.72	40524000.0
2012-09-10	NVDA	Stock	0.3342	0.339	0.3313	0.332	371108000.0
2012-09-10	AMZN	Stock	12.95	13.0	12.841	12.8545	51344000.0
2012-09-10	META	Stock	19.06	19.2	18.55	18.81	24797800.0
2012-09-10	TSLA	Stock	1.9467	1.9567	1.82	1.8247	22249500.0
2012-09-10	TLT	Stock	123.69	124.33	123.51	124.33	4912087.0
2012-09-10	ES	Stock	38.35	38.4	38.1	38.12	736600.0
2012-09-10	CL	Stock	52.91	52.95	51.61	51.85	9646000.0
2012-09-10	A	Stock	27.4106	27.7039	27.2103	27.3677	4021627.0
2012-09-10	AABA-DELISTED	Stock	15.18	15.28	15.11	15.12	10189936.0
2012-09-10	AACC-DELISTED	Stock	6.67	6.74	6.6	6.69	18980.0
2012-09-10	AAIC-DELISTED	Stock	23.02	23.5	22.95	23.41	92199.0
2012-09-10	AAME	Stock	2.66	2.67	2.65	2.67	4200.0
2012-09-10	AAMRQ-DELISTED	Stock	0.4505	0.466	0.4505	0.4516	851890.0
2012-09-10	AAON	Stock	5.6296	5.683	5.5585	5.6178	140400.0
2012-09-10	AAP	Stock	70.45	70.81	69.85	69.86	1478300.0
2012-09-10	AAT	Stock	27.91	27.91	27.47	27.49	128700.0
2012-09-10	AAU-DELISTED	Stock	2.68	2.74	2.66	2.7118	225640.0
2012-09-10	AAUAF-DELISTED	Stock	2.68	2.74	2.66	2.7118	228340.0
2012-09-10	AAV-DELISTED	Stock	3.55	3.63	3.55	3.61	56935.0
2012-09-10	AAWW-DELISTED	Stock	54.49	56.88	54.23	56.25	308283.0
2012-09-10	AAXJ	Stock	54.07	54.22	53.8	53.81	126851.0
2012-09-10	AAXN-DELISTED	Stock	5.45	5.51	5.16	5.17	672122.0
2012-09-10	AB	Stock	14.37	14.44	14.26	14.35	296900.0
2012-09-10	ABAC-DELISTED	Stock	1.18	1.18	1.0901	1.18	5135.0
2012-09-10	ABAX-DELISTED	Stock	36.87	37.02	35.11	36.18	250265.0
2012-09-10	ABB-DELISTED	Stock	18.76	18.77	18.51	18.53	1873816.0
2012-09-10	ABBNY-DELISTED	Stock	18.76	18.77	18.51	18.54	1920291.0
2012-09-10	ABC-DELISTED	Stock	38.37	38.37	38.01	38.025	1965281.0
2012-09-10	ABCB	Stock	12.51	12.51	12.26	12.4	23900.0
2012-09-10	ABCD-DELISTED	Stock	0.96	1.05	0.96	1.05	2452.0
2012-09-10	ABCO-DELISTED	Stock	45.78	46.12	45.77	45.99	136526.0
2012-09-10	ABCW-DELISTED	Stock	0.39	0.44	0.365	0.44	16928.0
2012-09-10	ABE-DELISTED	Stock	20.0	20.14	19.96	19.99	49340.0
2012-09-10	ABEO	Stock	662.5	712.5	650.0	662.5	8.0
2012-09-10	ABFS-DELISTED	Stock	8.22	8.25	7.83	8.0	852379.0
2012-09-10	ABG	Stock	29.75	30.2	29.64	29.82	399500.0
2012-09-10	ABM	Stock	19.14	19.17	18.67	18.68	560900.0
2012-09-10	ABMD-DELISTED	Stock	21.73	21.95	19.95	20.36	1338892.0
2012-09-10	ABR	Stock	5.57	5.69	5.53	5.54	237000.0
2012-09-10	ABT	Stock	32.0506	32.2953	31.9835	32.2378	11429554.0
2012-09-10	ABTL-DELISTED	Stock	3.62	3.65	3.6	3.65	10196.0
2012-09-10	ABUS	Stock	3.25	3.25	3.25	3.25	2500.0
2012-09-10	ABV-DELISTED	Stock	38.12	38.41	37.0775	37.29	2735105.0
2012-09-10	ABVA-DELISTED	Stock	4.65	4.65	4.65	4.65	10000.0
2012-09-10	ABX-DELISTED	Stock	40.09	40.28	39.31	39.38	5658986.0
2012-09-10	ACAD	Stock	1.94	2.09	1.94	2.05	2533000.0
2012-09-10	ACAS-DELISTED	Stock	11.35	11.46	11.32	11.41	2316297.0
2012-09-10	ACAT-DELISTED	Stock	44.13	46.87	44.13	45.58	320369.0

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

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