PREVIEW / stock_daily / 2010-07-28

all stock daily files

  file:    by_date/stock_daily/2010/2010-07-28.parquet
  size:    189 KB
  rows:    5,910
  symbols: 3,463

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-28	AAPL	Stock	9.4168	9.4996	9.2946	9.32	519985200.0
2010-07-28	MSFT	Stock	26.07	26.19	25.83	25.95	69704800.0
2010-07-28	NVDA	Stock	0.2572	0.2618	0.2525	0.2533	1320808000.0
2010-07-28	AMZN	Stock	5.85	5.91	5.82	5.8565	109446000.0
2010-07-28	TSLA	Stock	1.37	1.3933	1.3673	1.3813	7008000.0
2010-07-28	TLT	Stock	98.49	99.19	98.27	98.97	5507139.0
2010-07-28	ES	Stock	28.78	28.78	28.29	28.39	1349800.0
2010-07-28	CL	Stock	42.295	42.335	41.765	41.93	5583400.0
2010-07-28	A	Stock	20.5937	20.9371	20.5579	20.5866	4355749.0
2010-07-28	AABA-DELISTED	Stock	13.94	13.99	13.85	13.87	13506496.0
2010-07-28	AACC-DELISTED	Stock	4.5	4.51	4.35	4.39	18210.0
2010-07-28	AACG	Stock	2.99	3.08	2.98	3.08	500.0
2010-07-28	AAI-DELISTED	Stock	4.77	4.79	4.64	4.67	1337509.0
2010-07-28	AAIC-DELISTED	Stock	19.3101	19.63	19.13	19.29	37877.0
2010-07-28	AAME	Stock	1.21	1.21	1.2	1.2	600.0
2010-07-28	AAON	Stock	5.0054	5.0094	4.877	4.9106	205537.0
2010-07-28	AAP	Stock	54.36	54.62	53.32	53.64	600300.0
2010-07-28	AATI-DELISTED	Stock	3.35	3.35	3.26	3.27	121909.0
2010-07-28	AAU-DELISTED	Stock	0.92	0.92	0.9	0.9	20458.0
2010-07-28	AAUAF-DELISTED	Stock	0.92	0.92	0.9	0.9	20658.0
2010-07-28	AAV-DELISTED	Stock	6.35	6.45	6.3	6.4	380345.0
2010-07-28	AAWW-DELISTED	Stock	58.79	59.42	56.34	58.55	252934.0
2010-07-28	AAXJ	Stock	56.11	56.22	55.83	55.89	284889.0
2010-07-28	AAXN-DELISTED	Stock	4.26	4.28	4.05	4.1	636875.0
2010-07-28	AB	Stock	27.43	27.79	27.05	27.16	131600.0
2010-07-28	ABAC-DELISTED	Stock	4.09	4.19	4.06	4.09	32250.0
2010-07-28	ABAX-DELISTED	Stock	19.3	19.38	18.42	18.54	132403.0
2010-07-28	ABB-DELISTED	Stock	20.07	20.24	19.94	20.05	4113411.0
2010-07-28	ABBC-DELISTED	Stock	9.09	9.2	9.04	9.07	23491.0
2010-07-28	ABBNY-DELISTED	Stock	20.07	20.24	19.94	20.04	4144330.0
2010-07-28	ABC-DELISTED	Stock	29.17	29.21	28.14	28.91	8344524.0
2010-07-28	ABCB	Stock	9.45	9.45	9.13	9.27	105100.0
2010-07-28	ABCD-DELISTED	Stock	3.4	3.4	3.3	3.37	20741.0
2010-07-28	ABCO-DELISTED	Stock	22.15	22.15	20.92	21.08	175556.0
2010-07-28	ABCW-DELISTED	Stock	0.5842	0.6885	0.5842	0.68	61040.0
2010-07-28	ABD-DELISTED	Stock	5.78	5.87	5.44	5.55	320520.0
2010-07-28	ABE-DELISTED	Stock	17.28	17.28	17.04	17.04	8488.0
2010-07-28	ABEO	Stock	2250.0	2375.0	2237.5	2312.5	47.0
2010-07-28	ABFS-DELISTED	Stock	23.28	23.55	22.49	22.59	302779.0
2010-07-28	ABG	Stock	13.68	13.86	13.18	13.36	259600.0
2010-07-28	ABII-DELISTED	Stock	74.77	75.0	74.3	74.45	56328.0
2010-07-28	ABK-DELISTED	Stock	1.05	1.05	0.88	0.8851	32115170.0
2010-07-28	ABM	Stock	22.05	22.22	21.58	21.64	214600.0
2010-07-28	ABMD-DELISTED	Stock	11.4	11.54	11.34	11.45	227385.0
2010-07-28	ABR	Stock	6.14	6.14	5.76	6.07	99500.0
2010-07-28	ABT	Stock	23.6589	23.7405	23.4382	23.6158	14290746.0
2010-07-28	ABTL-DELISTED	Stock	5.1562	5.3093	5.003	5.1	21802.0
2010-07-28	ABV-DELISTED	Stock	108.32	109.37	107.3	108.87	389178.0
2010-07-28	ABVA-DELISTED	Stock	2.53	2.599	2.53	2.599	1300.0
2010-07-28	ABVT-DELISTED	Stock	52.52	52.75	52.01	52.42	115618.0

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

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