PREVIEW / stock_daily / 2011-09-12

all stock daily files

  file:    by_date/stock_daily/2011/2011-09-12.parquet
  size:    193 KB
  rows:    6,094
  symbols: 3,535

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-09-12	AAPL	Stock	13.3214	13.6029	13.2821	13.5693	467832400.0
2011-09-12	MSFT	Stock	25.44	25.93	25.27	25.89	55046100.0
2011-09-12	NVDA	Stock	0.3422	0.3582	0.3422	0.3553	916480000.0
2011-09-12	AMZN	Stock	10.4375	10.833	10.4325	10.828	106842000.0
2011-09-12	TSLA	Stock	1.5	1.554	1.4967	1.5253	8499000.0
2011-09-12	TLT	Stock	113.57	114.25	113.1	113.83	7602169.0
2011-09-12	ES	Stock	32.8	33.36	32.72	33.33	1371300.0
2011-09-12	CL	Stock	44.255	44.35	43.125	43.86	7486400.0
2011-09-12	A	Stock	23.3763	23.9914	22.9471	23.8984	7395839.0
2011-09-12	AABA-DELISTED	Stock	14.12	14.28	13.92	14.265	26963965.0
2011-09-12	AACC-DELISTED	Stock	4.0	4.04	3.91	3.95	10219.0
2011-09-12	AACG	Stock	9.13	9.27	8.91	9.27	6900.0
2011-09-12	AAIC-DELISTED	Stock	23.89	24.27	23.75	24.21	92496.0
2011-09-12	AAME	Stock	1.98	2.04	1.96	2.04	1500.0
2011-09-12	AAON	Stock	4.6163	4.797	4.6163	4.7793	163350.0
2011-09-12	AAP	Stock	59.91	60.41	59.34	60.41	989700.0
2011-09-12	AAT	Stock	18.45	18.83	18.25	18.62	101600.0
2011-09-12	AATI-DELISTED	Stock	4.55	4.69	4.35	4.61	2334324.0
2011-09-12	AAU-DELISTED	Stock	3.44	3.44	3.17	3.29	140892.0
2011-09-12	AAUAF-DELISTED	Stock	3.44	3.44	3.17	3.3	144392.0
2011-09-12	AAV-DELISTED	Stock	5.04	5.15	4.93	5.07	381486.0
2011-09-12	AAWW-DELISTED	Stock	43.07	44.31	43.006	43.88	244100.0
2011-09-12	AAXJ	Stock	52.38	53.19	51.79	53.13	715354.0
2011-09-12	AAXN-DELISTED	Stock	4.16	4.33	4.16	4.32	223304.0
2011-09-12	AB	Stock	16.25	16.56	15.99	16.48	250500.0
2011-09-12	ABAC-DELISTED	Stock	2.15	2.15	2.1	2.1	9900.0
2011-09-12	ABAX-DELISTED	Stock	23.93	24.5	23.57	24.21	68184.0
2011-09-12	ABB-DELISTED	Stock	17.65	18.03	17.52	18.0	4753998.0
2011-09-12	ABBC-DELISTED	Stock	7.72	8.03	7.72	8.01	25985.0
2011-09-12	ABBNY-DELISTED	Stock	17.65	18.03	17.52	17.99	4875685.0
2011-09-12	ABC-DELISTED	Stock	37.71	38.17	37.34	38.07	2706060.0
2011-09-12	ABCB	Stock	8.36	8.68	8.31	8.64	47000.0
2011-09-12	ABCD-DELISTED	Stock	2.89	3.2	2.89	2.98	483308.0
2011-09-12	ABCO-DELISTED	Stock	28.76	29.39	28.5	29.39	163769.0
2011-09-12	ABCW-DELISTED	Stock	0.55	0.62	0.54	0.55	43990.0
2011-09-12	ABD-DELISTED	Stock	5.6	5.87	5.49	5.53	350600.0
2011-09-12	ABE-DELISTED	Stock	17.83	17.87	17.6	17.69	10557.0
2011-09-12	ABFS-DELISTED	Stock	18.2	19.16	18.2	19.12	466172.0
2011-09-12	ABG	Stock	17.65	18.39	17.65	18.35	679000.0
2011-09-12	ABH-DELISTED	Stock	15.67	16.27	15.42	15.94	263637.0
2011-09-12	ABM	Stock	18.57	19.05	18.37	18.97	421700.0
2011-09-12	ABMD-DELISTED	Stock	10.57	10.9	10.45	10.72	240870.0
2011-09-12	ABR	Stock	4.08	4.14	3.99	4.11	46300.0
2011-09-12	ABT	Stock	24.0188	24.2443	23.8125	24.2347	15190913.0
2011-09-12	ABTL-DELISTED	Stock	4.2517	4.3	4.0111	4.3	5543.0
2011-09-12	ABUS	Stock	1.94	2.04	1.9	2.0	8700.0
2011-09-12	ABV-DELISTED	Stock	32.01	32.3764	31.5701	32.11	3573670.0
2011-09-12	ABVA-DELISTED	Stock	5.48	5.54	4.74	4.75	3444.0
2011-09-12	ABVT-DELISTED	Stock	54.71	55.78	54.28	55.76	217590.0
2011-09-12	ABX-DELISTED	Stock	53.62	54.72	52.21	53.31	8768312.0

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

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