PREVIEW / stock_daily / 2010-07-27

all stock daily files

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

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-27	AAPL	Stock	9.3168	9.4571	9.2964	9.4314	584771600.0
2010-07-27	MSFT	Stock	26.14	26.24	25.96	26.16	60672100.0
2010-07-27	NVDA	Stock	0.2645	0.265	0.2583	0.2615	683472000.0
2010-07-27	AMZN	Stock	5.9215	5.925	5.7535	5.8565	155922000.0
2010-07-27	TSLA	Stock	1.394	1.412	1.3507	1.37	9295500.0
2010-07-27	TLT	Stock	98.78	99.179	98.5699	98.65	5329302.0
2010-07-27	ES	Stock	28.22	28.72	28.22	28.69	1487900.0
2010-07-27	CL	Stock	41.925	42.355	41.65	42.295	4770200.0
2010-07-27	A	Stock	21.2661	21.2661	20.608	20.6509	4670858.0
2010-07-27	AABA-DELISTED	Stock	14.02	14.1	13.89	13.93	20886465.0
2010-07-27	AACC-DELISTED	Stock	4.72	4.73	4.48	4.5	25085.0
2010-07-27	AACG	Stock	3.02	3.03	3.02	3.03	3100.0
2010-07-27	AAI-DELISTED	Stock	4.83	4.86	4.72	4.74	2161508.0
2010-07-27	AAIC-DELISTED	Stock	19.49	19.94	19.19	19.31	60750.0
2010-07-27	AAME	Stock	1.21	1.25	1.21	1.25	3000.0
2010-07-27	AAON	Stock	5.12	5.1615	5.0232	5.0252	227812.0
2010-07-27	AAP	Stock	55.01	55.78	54.44	54.54	776200.0
2010-07-27	AATI-DELISTED	Stock	3.47	3.47	3.38	3.39	157427.0
2010-07-27	AAU-DELISTED	Stock	0.93	0.9509	0.9	0.9291	98232.0
2010-07-27	AAUAF-DELISTED	Stock	0.93	0.95	0.9	0.9282	101024.0
2010-07-27	AAV-DELISTED	Stock	6.47	6.56	6.39	6.43	329197.0
2010-07-27	AAWW-DELISTED	Stock	60.0	60.0	58.73	59.18	174373.0
2010-07-27	AAXJ	Stock	56.46	56.6	56.0	56.21	938406.0
2010-07-27	AAXN-DELISTED	Stock	4.29	4.62	4.22	4.23	1693655.0
2010-07-27	AB	Stock	26.76	27.82	26.76	27.61	352600.0
2010-07-27	ABAC-DELISTED	Stock	4.15	4.15	3.97	4.04	11050.0
2010-07-27	ABAX-DELISTED	Stock	19.13	19.48	19.05	19.42	148581.0
2010-07-27	ABB-DELISTED	Stock	20.13	20.15	19.64	19.78	5496995.0
2010-07-27	ABBC-DELISTED	Stock	9.15	9.2	9.05	9.08	50422.0
2010-07-27	ABBNY-DELISTED	Stock	20.13	20.15	19.64	19.75	5756187.0
2010-07-27	ABC-DELISTED	Stock	30.6	30.63	27.82	29.16	19058713.0
2010-07-27	ABCB	Stock	9.68	9.9	9.42	9.48	88700.0
2010-07-27	ABCD-DELISTED	Stock	3.43	3.43	3.39	3.39	21842.0
2010-07-27	ABCO-DELISTED	Stock	22.39	22.39	22.1	22.12	92718.0
2010-07-27	ABCW-DELISTED	Stock	0.62	0.7	0.61	0.65	138890.0
2010-07-27	ABD-DELISTED	Stock	5.85	6.14	5.77	5.82	617220.0
2010-07-27	ABE-DELISTED	Stock	17.13	17.49	17.13	17.4201	12977.0
2010-07-27	ABEO	Stock	2500.0	2500.0	2250.0	2250.0	16.0
2010-07-27	ABFS-DELISTED	Stock	23.61	23.88	23.05	23.26	315275.0
2010-07-27	ABG	Stock	13.61	13.8	13.14	13.61	486100.0
2010-07-27	ABII-DELISTED	Stock	74.75	74.97	73.43	74.73	190744.0
2010-07-27	ABK-DELISTED	Stock	0.95	1.03	0.9	1.0	37999992.0
2010-07-27	ABM	Stock	22.1	22.25	21.95	22.15	214000.0
2010-07-27	ABMD-DELISTED	Stock	11.5	11.51	11.39	11.45	199854.0
2010-07-27	ABR	Stock	6.25	6.25	6.06	6.1	98600.0
2010-07-27	ABT	Stock	23.7501	23.7501	23.491	23.6397	9663610.0
2010-07-27	ABTL-DELISTED	Stock	5.25	5.3	4.9	5.2	26951.0
2010-07-27	ABV-DELISTED	Stock	109.19	109.19	107.5	107.72	392998.0
2010-07-27	ABVA-DELISTED	Stock	2.53	2.53	2.53	2.53	345.0
2010-07-27	ABVT-DELISTED	Stock	53.12	53.3925	52.23	52.54	121339.0

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

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