PREVIEW / stock_daily / 2010-07-30

all stock daily files

  file:    by_date/stock_daily/2010/2010-07-30.parquet
  size:    190 KB
  rows:    5,936
  symbols: 3,488

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-30	AAPL	Stock	9.1389	9.275	9.1036	9.1875	448210000.0
2010-07-30	MSFT	Stock	25.75	25.84	25.35	25.81	83534800.0
2010-07-30	NVDA	Stock	0.2265	0.2338	0.223	0.2298	984288000.0
2010-07-30	AMZN	Stock	5.7765	5.937	5.7255	5.8945	141550000.0
2010-07-30	TSLA	Stock	1.3467	1.3627	1.3033	1.3293	6403500.0
2010-07-30	TLT	Stock	100.2	100.61	99.85	100.48	7683171.0
2010-07-30	ES	Stock	27.93	28.12	27.73	27.84	1330500.0
2010-07-30	CL	Stock	38.91	39.74	38.905	39.49	17946000.0
2010-07-30	A	Stock	19.8712	20.1502	19.7854	19.9785	5164771.0
2010-07-30	AABA-DELISTED	Stock	13.7	13.9823	13.68	13.87	18378796.0
2010-07-30	AACC-DELISTED	Stock	4.3	4.65	4.2	4.45	28885.0
2010-07-30	AACG	Stock	2.98	2.98	2.98	2.98	300.0
2010-07-30	AAI-DELISTED	Stock	4.7	4.82	4.65	4.82	1418369.0
2010-07-30	AAIC-DELISTED	Stock	19.64	20.1	19.56	20.07	40711.0
2010-07-30	AAME	Stock	1.26	1.27	1.22	1.27	400.0
2010-07-30	AAON	Stock	4.8672	5.0133	4.8533	4.9106	232369.0
2010-07-30	AAP	Stock	52.65	53.72	52.35	53.53	639800.0
2010-07-30	AATI-DELISTED	Stock	3.15	3.23	3.15	3.19	47850.0
2010-07-30	AAU-DELISTED	Stock	0.96	0.96	0.9237	0.93	54513.0
2010-07-30	AAUAF-DELISTED	Stock	0.96	0.96	0.9237	0.93	54913.0
2010-07-30	AAV-DELISTED	Stock	6.28	6.33	6.2107	6.32	264859.0
2010-07-30	AAWW-DELISTED	Stock	57.66	59.53	57.5	58.46	364897.0
2010-07-30	AAXJ	Stock	55.75	56.36	55.55	56.17	229779.0
2010-07-30	AAXN-DELISTED	Stock	3.87	4.14	3.87	4.11	828206.0
2010-07-30	AB	Stock	27.22	27.72	26.39	26.68	636200.0
2010-07-30	ABAC-DELISTED	Stock	4.0	4.08	3.95	3.99	23560.0
2010-07-30	ABAX-DELISTED	Stock	18.87	21.08	18.87	20.05	462371.0
2010-07-30	ABB-DELISTED	Stock	19.94	20.225	19.91	20.17	2938002.0
2010-07-30	ABBC-DELISTED	Stock	9.07	9.62	9.07	9.54	71834.0
2010-07-30	ABBNY-DELISTED	Stock	19.94	20.225	19.91	20.18	2953263.0
2010-07-30	ABC-DELISTED	Stock	28.65	30.2	28.53	29.96	10078604.0
2010-07-30	ABCB	Stock	9.19	9.9	9.14	9.84	162000.0
2010-07-30	ABCD-DELISTED	Stock	3.33	3.45	3.33	3.44	8682.0
2010-07-30	ABCO-DELISTED	Stock	21.81	22.13	21.35	21.93	199134.0
2010-07-30	ABCW-DELISTED	Stock	0.7008	0.73	0.6813	0.73	32500.0
2010-07-30	ABD-DELISTED	Stock	5.81	6.14	5.73	5.92	239040.0
2010-07-30	ABE-DELISTED	Stock	17.04	17.11	17.0	17.08	7009.0
2010-07-30	ABEO	Stock	2375.0	2437.5	2375.0	2437.5	18.0
2010-07-30	ABFS-DELISTED	Stock	22.24	22.82	22.03	22.57	169767.0
2010-07-30	ABG	Stock	13.02	13.72	12.84	13.46	350100.0
2010-07-30	ABII-DELISTED	Stock	74.45	75.3	74.45	75.3	193793.0
2010-07-30	ABK-DELISTED	Stock	0.8491	0.868	0.8028	0.8351	11881205.0
2010-07-30	ABM	Stock	21.66	22.22	21.54	21.7	138700.0
2010-07-30	ABMD-DELISTED	Stock	11.2	11.32	11.05	11.0975	300131.0
2010-07-30	ABR	Stock	5.89	6.2	5.81	6.19	84100.0
2010-07-30	ABT	Stock	23.3759	23.6829	23.1743	23.5486	16298041.0
2010-07-30	ABTL-DELISTED	Stock	5.0956	5.3529	5.0956	5.25	6519.0
2010-07-30	ABV-DELISTED	Stock	109.17	110.3099	108.16	109.32	487998.0
2010-07-30	ABVA-DELISTED	Stock	2.5	2.58	2.46	2.46	3421.0
2010-07-30	ABVT-DELISTED	Stock	51.86	53.3	51.62	53.19	158860.0

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

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