PREVIEW / stock_daily / 2012-05-18

all stock daily files

  file:    by_date/stock_daily/2012/2012-05-18.parquet
  size:    199 KB
  rows:    6,161
  symbols: 3,522

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-05-18	AAPL	Stock	19.07	19.4075	18.6493	18.9421	732292400.0
2012-05-18	MSFT	Stock	29.79	29.81	29.17	29.27	56205300.0
2012-05-18	NVDA	Stock	0.317	0.3185	0.3005	0.302	567288000.0
2012-05-18	AMZN	Stock	10.9705	10.9815	10.6405	10.6925	104634000.0
2012-05-18	TSLA	Stock	1.8913	1.8973	1.7887	1.8373	24247500.0
2012-05-18	TLT	Stock	123.27	124.44	123.11	124.2001	10137901.0
2012-05-18	ES	Stock	35.13	35.29	34.84	34.94	1654700.0
2012-05-18	CL	Stock	50.06	50.115	49.26	49.395	6050600.0
2012-05-18	A	Stock	28.6123	28.7768	27.6252	27.7039	7216057.0
2012-05-18	AABA-DELISTED	Stock	15.78	15.87	15.36	15.42	31199275.0
2012-05-18	AACC-DELISTED	Stock	5.58	5.604	5.36	5.51	15810.0
2012-05-18	AAIC-DELISTED	Stock	22.83	22.9	22.38	22.5	39849.0
2012-05-18	AAME	Stock	2.68	2.77	2.47	2.75	3300.0
2012-05-18	AAMRQ-DELISTED	Stock	0.49	0.5	0.48	0.4801	2018955.0
2012-05-18	AAON	Stock	5.6089	5.7126	5.5615	5.6326	255825.0
2012-05-18	AAP	Stock	68.15	68.25	66.25	66.68	1912500.0
2012-05-18	AAT	Stock	23.25	23.57	22.57	22.6	154800.0
2012-05-18	AAU-DELISTED	Stock	1.93	2.05	1.82	1.9	147406.0
2012-05-18	AAUAF-DELISTED	Stock	1.86	2.05	1.82	1.9	149506.0
2012-05-18	AAV-DELISTED	Stock	2.83	2.97	2.8183	2.87	178808.0
2012-05-18	AAWW-DELISTED	Stock	45.68	46.5	45.62	45.8	284985.0
2012-05-18	AAXJ	Stock	50.8	50.942	50.25	50.31	673314.0
2012-05-18	AAXN-DELISTED	Stock	5.08	5.2	5.07	5.14	457618.0
2012-05-18	AB	Stock	14.12	14.17	13.75	13.78	132100.0
2012-05-18	ABAC-DELISTED	Stock	1.36	1.44	1.36	1.44	8650.0
2012-05-18	ABAX-DELISTED	Stock	33.47	33.62	32.77	32.79	102825.0
2012-05-18	ABB-DELISTED	Stock	16.14	16.16	15.92	15.97	2981192.0
2012-05-18	ABBNY-DELISTED	Stock	16.14	16.16	15.92	15.99	3005674.0
2012-05-18	ABC-DELISTED	Stock	36.45	36.66	35.94	36.01	3491173.0
2012-05-18	ABCB	Stock	11.41	11.67	11.35	11.61	90800.0
2012-05-18	ABCD-DELISTED	Stock	1.36	1.4	1.26	1.26	41537.0
2012-05-18	ABCO-DELISTED	Stock	47.14	47.41	47.09	47.34	339965.0
2012-05-18	ABCW-DELISTED	Stock	0.5321	0.5723	0.4418	0.5723	22580.0
2012-05-18	ABE-DELISTED	Stock	18.18	18.18	18.09	18.1	5396.0
2012-05-18	ABEO	Stock	562.5	687.5	562.5	675.0	52.0
2012-05-18	ABFS-DELISTED	Stock	12.65	12.8	12.375	12.46	285677.0
2012-05-18	ABG	Stock	25.34	25.8	24.95	25.54	575900.0
2012-05-18	ABH-DELISTED	Stock	10.31	10.34	10.15	10.3	147614.0
2012-05-18	ABM	Stock	22.03	22.2	21.5	21.55	272100.0
2012-05-18	ABMD-DELISTED	Stock	23.19	23.47	22.79	23.0	471721.0
2012-05-18	ABR	Stock	6.1	6.11	5.75	5.83	45200.0
2012-05-18	ABT	Stock	29.8771	29.9587	29.4837	29.5413	14998958.0
2012-05-18	ABTL-DELISTED	Stock	3.8634	3.8634	3.5332	3.7866	22080.0
2012-05-18	ABUS	Stock	2.12	2.13	2.0	2.0	1900.0
2012-05-18	ABV-DELISTED	Stock	38.66	38.87	37.89	38.21	3254163.0
2012-05-18	ABVA-DELISTED	Stock	4.3	4.3	3.99	4.1	15093.0
2012-05-18	ABVT-DELISTED	Stock	83.13	83.18	82.97	83.04	353286.0
2012-05-18	ABX-DELISTED	Stock	38.1	38.75	36.93	37.14	10619692.0
2012-05-18	ACAD	Stock	1.51	1.51	1.36	1.42	554400.0
2012-05-18	ACAS-DELISTED	Stock	9.1	9.14	8.63	8.705	7447275.0

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

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