PREVIEW / stock_daily / 2010-07-12

all stock daily files

  file:    by_date/stock_daily/2010/2010-07-12.parquet
  size:    188 KB
  rows:    5,934
  symbols: 3,494

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
2010-07-12	AAPL	Stock	9.2332	9.3518	9.1021	9.1889	562878400.0
2010-07-12	MSFT	Stock	24.43	24.89	24.42	24.83	49854200.0
2010-07-12	NVDA	Stock	0.2588	0.2668	0.2585	0.2635	565396000.0
2010-07-12	AMZN	Stock	5.8905	5.985	5.866	5.9755	95672000.0
2010-07-12	TSLA	Stock	1.1967	1.2047	1.1333	1.1367	33037500.0
2010-07-12	TLT	Stock	99.33	99.84	99.04	99.18	4062097.0
2010-07-12	ES	Stock	26.77	27.09	26.73	26.99	826500.0
2010-07-12	CL	Stock	40.93	41.49	40.885	41.42	6071000.0
2010-07-12	A	Stock	20.3934	20.5436	20.0501	20.1717	5240123.0
2010-07-12	AABA-DELISTED	Stock	14.94	15.21	14.78	14.92	14050696.0
2010-07-12	AACC-DELISTED	Stock	3.97	3.99	3.81	3.85	46339.0
2010-07-12	AACG	Stock	2.87	3.05	2.87	3.05	300.0
2010-07-12	AAI-DELISTED	Stock	4.98	5.0	4.83	4.9	2755888.0
2010-07-12	AAIC-DELISTED	Stock	19.35	19.43	19.09	19.13	21107.0
2010-07-12	AAME	Stock	1.31	1.31	1.25	1.25	6300.0
2010-07-12	AAON	Stock	4.6933	4.6993	4.5768	4.5807	131625.0
2010-07-12	AAP	Stock	51.28	51.72	50.93	51.46	703000.0
2010-07-12	AATI-DELISTED	Stock	3.17	3.1701	3.1	3.13	63962.0
2010-07-12	AAU-DELISTED	Stock	0.91	0.91	0.8525	0.87	60859.0
2010-07-12	AAUAF-DELISTED	Stock	0.91	0.91	0.8525	0.87	61159.0
2010-07-12	AAV-DELISTED	Stock	6.3	6.41	6.16	6.3	470222.0
2010-07-12	AAWW-DELISTED	Stock	50.88	52.09	50.22	51.26	143502.0
2010-07-12	AAXJ	Stock	55.06	55.11	54.58	54.84	635043.0
2010-07-12	AAXN-DELISTED	Stock	3.85	3.94	3.75	3.87	380684.0
2010-07-12	AB	Stock	27.52	28.53	26.79	28.4	422000.0
2010-07-12	ABAX-DELISTED	Stock	20.46	20.71	20.11	20.28	187488.0
2010-07-12	ABB-DELISTED	Stock	18.13	18.25	18.02	18.16	2258889.0
2010-07-12	ABBC-DELISTED	Stock	9.05	9.05	8.851	8.9	46439.0
2010-07-12	ABBNY-DELISTED	Stock	18.13	18.25	18.02	18.14	2260113.0
2010-07-12	ABC-DELISTED	Stock	31.78	31.82	31.58	31.72	2878586.0
2010-07-12	ABCB	Stock	10.42	10.58	10.09	10.15	48200.0
2010-07-12	ABCD-DELISTED	Stock	3.76	3.76	3.51	3.66	49374.0
2010-07-12	ABCO-DELISTED	Stock	20.96	21.09	20.73	20.93	138847.0
2010-07-12	ABCW-DELISTED	Stock	0.4815	0.511	0.4716	0.48	49180.0
2010-07-12	ABD-DELISTED	Stock	5.54	5.65	5.2781	5.34	219530.0
2010-07-12	ABE-DELISTED	Stock	16.69	16.79	16.57	16.57	11732.0
2010-07-12	ABEO	Stock	2250.0	2375.0	2250.0	2375.0	10.0
2010-07-12	ABFS-DELISTED	Stock	21.39	22.22	21.32	21.68	387262.0
2010-07-12	ABG	Stock	10.29	10.39	9.95	10.11	333400.0
2010-07-12	ABII-DELISTED	Stock	74.15	74.99	73.92	74.8	153407.0
2010-07-12	ABK-DELISTED	Stock	0.67	0.69	0.65	0.6511	4259125.0
2010-07-12	ABM	Stock	21.52	21.63	21.07	21.36	120200.0
2010-07-12	ABMD-DELISTED	Stock	10.68	10.7	10.36	10.53	144940.0
2010-07-12	ABR	Stock	5.25	6.29	5.25	5.95	501500.0
2010-07-12	ABT	Stock	23.0784	23.0784	22.8385	22.944	11977282.0
2010-07-12	ABTL-DELISTED	Stock	6.0508	6.0508	5.7966	6.0	10576.0
2010-07-12	ABV-DELISTED	Stock	106.25	106.6	103.91	104.88	375369.0
2010-07-12	ABVA-DELISTED	Stock	2.6	2.605	2.5	2.5	1100.0
2010-07-12	ABVT-DELISTED	Stock	49.52	49.83	48.27	48.4	93234.0
2010-07-12	ABX-DELISTED	Stock	43.44	44.38	43.35	43.52	8741886.0

> showing 50 of 5,934 rows — these rows as CSV

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