PREVIEW / stock_daily / 2012-09-17

all stock daily files

  file:    by_date/stock_daily/2012/2012-09-17.parquet
  size:    199 KB
  rows:    6,130
  symbols: 3,473

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-17	AAPL	Stock	24.9768	24.9929	24.8075	24.9921	398031200.0
2012-09-17	MSFT	Stock	31.19	31.26	31.04	31.21	36488500.0
2012-09-17	NVDA	Stock	0.3468	0.3468	0.3328	0.3365	493348000.0
2012-09-17	AMZN	Stock	13.0625	13.0625	12.85	12.9	46126000.0
2012-09-17	META	Stock	22.67	22.75	21.5	21.52	50667600.0
2012-09-17	TSLA	Stock	2.1567	2.1853	2.1007	2.1693	48192000.0
2012-09-17	TLT	Stock	118.87	119.9	118.8	119.72	5573250.0
2012-09-17	ES	Stock	37.67	37.81	37.1	37.28	2750600.0
2012-09-17	CL	Stock	51.345	52.735	51.345	52.575	5985600.0
2012-09-17	A	Stock	28.226	28.4835	28.0687	28.3476	5097807.0
2012-09-17	AABA-DELISTED	Stock	15.82	15.84	15.63	15.69	11461963.0
2012-09-17	AACC-DELISTED	Stock	7.38	7.38	6.97	7.02	33793.0
2012-09-17	AACG	Stock	4.36	4.65	4.36	4.52	6500.0
2012-09-17	AAIC-DELISTED	Stock	24.56	25.24	24.52	24.98	142553.0
2012-09-17	AAME	Stock	2.72	2.75	2.56	2.75	5400.0
2012-09-17	AAMRQ-DELISTED	Stock	0.43	0.432	0.4295	0.4311	1069782.0
2012-09-17	AAON	Stock	6.0059	6.0267	5.8756	5.9141	116775.0
2012-09-17	AAP	Stock	67.57	69.04	67.53	67.89	777100.0
2012-09-17	AAT	Stock	27.73	28.11	27.73	28.0	154600.0
2012-09-17	AAU-DELISTED	Stock	2.91	3.0	2.86	2.89	225724.0
2012-09-17	AAUAF-DELISTED	Stock	2.91	3.0	2.86	2.89	234824.0
2012-09-17	AAV-DELISTED	Stock	3.8	3.82	3.72	3.72	110819.0
2012-09-17	AAWW-DELISTED	Stock	56.3	56.75	54.16	56.12	169551.0
2012-09-17	AAXJ	Stock	56.73	56.77	56.32	56.46	348561.0
2012-09-17	AAXN-DELISTED	Stock	5.7	6.12	5.66	5.995	1341043.0
2012-09-17	AB	Stock	15.54	15.57	15.24	15.32	168500.0
2012-09-17	ABAC-DELISTED	Stock	1.2	1.2	1.14	1.19	33600.0
2012-09-17	ABAX-DELISTED	Stock	35.36	36.41	35.08	36.27	93374.0
2012-09-17	ABB-DELISTED	Stock	19.89	19.95	19.78	19.9	2642670.0
2012-09-17	ABBNY-DELISTED	Stock	19.89	19.95	19.78	19.89	2673563.0
2012-09-17	ABC-DELISTED	Stock	37.53	38.03	37.41	38.02	3072742.0
2012-09-17	ABCB	Stock	12.38	12.65	12.38	12.63	22400.0
2012-09-17	ABCD-DELISTED	Stock	1.07	1.09	1.02	1.07	19648.0
2012-09-17	ABCO-DELISTED	Stock	46.17	46.95	46.17	46.75	147075.0
2012-09-17	ABCW-DELISTED	Stock	0.44	0.44	0.38	0.43	22795.0
2012-09-17	ABE-DELISTED	Stock	20.71	20.76	20.45	20.45	16509.0
2012-09-17	ABEO	Stock	637.5	637.5	562.5	637.5	37.0
2012-09-17	ABFS-DELISTED	Stock	8.43	8.46	8.325	8.38	331457.0
2012-09-17	ABG	Stock	29.76	29.82	29.07	29.11	175700.0
2012-09-17	ABM	Stock	18.78	18.9	18.67	18.82	159700.0
2012-09-17	ABMD-DELISTED	Stock	20.25	20.589	20.08	20.27	431342.0
2012-09-17	ABR	Stock	6.2	6.55	6.2	6.44	90600.0
2012-09-17	ABT	Stock	32.7032	33.1974	32.6984	33.1638	13707586.0
2012-09-17	ABTL-DELISTED	Stock	3.56	3.6	3.5	3.6	5557.0
2012-09-17	ABUS	Stock	3.7	3.75	3.65	3.66	7200.0
2012-09-17	ABV-DELISTED	Stock	38.14	38.67	38.1	38.33	1926887.0
2012-09-17	ABX-DELISTED	Stock	42.49	42.76	41.58	42.17	8850085.0
2012-09-17	ACAD	Stock	2.15	2.28	2.15	2.22	2046000.0
2012-09-17	ACAS-DELISTED	Stock	11.89	11.89	11.74	11.84	1763006.0
2012-09-17	ACAT-DELISTED	Stock	44.18	44.42	43.28	43.86	84660.0

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

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