PREVIEW / stock_daily / 2010-03-19

all stock daily files

  file:    by_date/stock_daily/2010/2010-03-19.parquet
  size:    192 KB
  rows:    5,923
  symbols: 3,498

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-03-19	AAPL	Stock	8.0282	8.0443	7.9011	7.9375	559445600.0
2010-03-19	MSFT	Stock	29.76	29.9	29.35	29.59	81332100.0
2010-03-19	NVDA	Stock	0.443	0.4442	0.4258	0.4312	584612000.0
2010-03-19	AMZN	Stock	6.6855	6.6855	6.483	6.5175	178100000.0
2010-03-19	TLT	Stock	90.92	91.58	90.87	91.26	2976273.0
2010-03-19	ES	Stock	27.16	27.48	27.05	27.16	1317600.0
2010-03-19	CL	Stock	42.42	42.545	42.145	42.42	5987200.0
2010-03-19	A	Stock	23.9056	24.0773	23.6981	23.9056	5882504.0
2010-03-19	AABA-DELISTED	Stock	16.62	16.81	16.34	16.42	15018519.0
2010-03-19	AACC-DELISTED	Stock	6.49	6.49	6.08	6.25	76354.0
2010-03-19	AACG	Stock	4.04	4.05	4.03	4.04	2000.0
2010-03-19	AAI-DELISTED	Stock	5.22	5.24	4.95	5.01	5543827.0
2010-03-19	AAIC-DELISTED	Stock	17.9895	18.98	17.94	18.9	107681.0
2010-03-19	AAME	Stock	1.45	1.5	1.45	1.5	700.0
2010-03-19	AAON	Stock	4.2746	4.3141	4.2607	4.2884	571050.0
2010-03-19	AAP	Stock	43.26	43.27	42.47	43.26	1915600.0
2010-03-19	AATI-DELISTED	Stock	3.51	3.51	3.38	3.46	563258.0
2010-03-19	AAU-DELISTED	Stock	0.9675	0.9695	0.9396	0.94	24740.0
2010-03-19	AAUAF-DELISTED	Stock	0.97	0.972	0.942	0.9424	24800.0
2010-03-19	AAV-DELISTED	Stock	7.42	7.5	7.11	7.12	3905753.0
2010-03-19	AAWW-DELISTED	Stock	50.66	50.66	48.3	48.6	328540.0
2010-03-19	AAXJ	Stock	56.4	56.47	55.75	55.75	112480.0
2010-03-19	AAXN-DELISTED	Stock	6.54	6.55	6.33	6.33	1368361.0
2010-03-19	AB	Stock	28.76	29.6	28.74	28.76	470400.0
2010-03-19	ABAX-DELISTED	Stock	28.15	28.2	27.68	27.68	158102.0
2010-03-19	ABB-DELISTED	Stock	21.41	21.43	21.05	21.13	1902129.0
2010-03-19	ABBC-DELISTED	Stock	8.2	8.32	8.15	8.31	113769.0
2010-03-19	ABBNY-DELISTED	Stock	21.41	21.43	21.05	21.12	2028079.0
2010-03-19	ABC-DELISTED	Stock	28.68	29.11	28.27	28.68	5411706.0
2010-03-19	ABCB	Stock	9.4025	9.5112	9.2841	9.442	80088.0
2010-03-19	ABCD-DELISTED	Stock	3.96	3.96	3.85	3.91	14587.0
2010-03-19	ABCO-DELISTED	Stock	16.578	16.748	16.097	16.127	117272.0
2010-03-19	ABCW-DELISTED	Stock	0.9656	1.0781	0.9562	1.05	516840.0
2010-03-19	ABD-DELISTED	Stock	7.48	7.65	7.06	7.13	1080550.0
2010-03-19	ABE-DELISTED	Stock	16.74	16.74	16.5	16.62	18140.0
2010-03-19	ABEO	Stock	2987.5	3250.0	2987.5	3237.5	13.0
2010-03-19	ABFS-DELISTED	Stock	29.83	29.83	28.95	29.13	566367.0
2010-03-19	ABG	Stock	14.04	14.19	13.79	14.04	505000.0
2010-03-19	ABII-DELISTED	Stock	51.69	52.145	51.4	51.41	82475.0
2010-03-19	ABK-DELISTED	Stock	0.766	0.7799	0.7	0.703	12094700.0
2010-03-19	ABM	Stock	20.26	20.42	20.03	20.26	443400.0
2010-03-19	ABMD-DELISTED	Stock	10.4	10.4	10.08	10.08	321131.0
2010-03-19	ABR	Stock	2.61	3.05	2.61	2.61	578500.0
2010-03-19	ABT	Stock	25.6501	25.8612	25.5206	25.6501	34032097.0
2010-03-19	ABTL-DELISTED	Stock	5.5	5.5	5.3	5.45	16278.0
2010-03-19	ABV-DELISTED	Stock	95.2	95.2	93.02	93.32	545040.0
2010-03-19	ABVA-DELISTED	Stock	2.55	2.55	2.55	2.55	248.0
2010-03-19	ABVT-DELISTED	Stock	55.48	55.73	53.56	55.0	203062.0
2010-03-19	ABX-DELISTED	Stock	39.55	39.72	38.65	39.29	12521661.0
2010-03-19	ACAD	Stock	1.63	1.7	1.54	1.63	752400.0

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

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