PREVIEW / stock_daily / 2009-07-21

all stock daily files

  file:    by_date/stock_daily/2009/2009-07-21.parquet
  size:    181 KB
  rows:    5,762
  symbols: 3,427

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
2009-07-21	AAPL	Stock	5.4746	5.4796	5.3482	5.4111	874781600.0
2009-07-21	MSFT	Stock	24.69	24.83	24.37	24.83	52028400.0
2009-07-21	NVDA	Stock	0.3048	0.306	0.2922	0.2992	941296000.0
2009-07-21	AMZN	Stock	4.426	4.4505	4.37	4.4505	154572000.0
2009-07-21	TLT	Stock	91.45	93.7	91.29	93.55	3895225.0
2009-07-21	ES	Stock	22.25	22.38	21.94	22.29	1221400.0
2009-07-21	CL	Stock	36.95	37.215	36.525	36.9	5915000.0
2009-07-21	A	Stock	15.515	15.6295	15.3505	15.3648	5834273.0
2009-07-21	AABA-DELISTED	Stock	17.05	17.11	16.44	16.7	33252014.0
2009-07-21	AACC-DELISTED	Stock	8.14	8.21	7.5	8.2	44282.0
2009-07-21	AACG	Stock	8.2	8.56	8.0	8.04	23200.0
2009-07-21	AAI-DELISTED	Stock	6.39	6.39	5.75	5.76	5746373.0
2009-07-21	AAIC-DELISTED	Stock	7.6	9.2	7.4	7.4	192334.0
2009-07-21	AAME	Stock	0.7	0.82	0.7	0.82	2600.0
2009-07-21	AAON	Stock	4.0375	4.0375	3.9388	3.9862	258187.0
2009-07-21	AAP	Stock	46.21	46.36	45.37	46.13	1212100.0
2009-07-21	AATI-DELISTED	Stock	4.39	4.86	4.39	4.78	1043010.0
2009-07-21	AAU-DELISTED	Stock	0.73	0.73	0.67	0.67	84501.0
2009-07-21	AAUAF-DELISTED	Stock	0.73	0.73	0.67	0.67	85501.0
2009-07-21	AAV-DELISTED	Stock	5.05	5.1	4.94	5.04	778623.0
2009-07-21	AAWW-DELISTED	Stock	23.72	23.75	22.67	23.11	208390.0
2009-07-21	AAXJ	Stock	48.02	48.02	47.227	47.91	622950.0
2009-07-21	AAXN-DELISTED	Stock	5.14	5.16	5.01	5.15	294574.0
2009-07-21	AB	Stock	22.26	22.49	21.91	22.13	655300.0
2009-07-21	ABAX-DELISTED	Stock	19.76	20.0189	19.6	19.67	123125.0
2009-07-21	ABB-DELISTED	Stock	17.03	17.08	16.63	16.78	3824393.0
2009-07-21	ABBC-DELISTED	Stock	8.88	8.88	8.45	8.51	54164.0
2009-07-21	ABBNY-DELISTED	Stock	17.0	17.08	16.63	16.77	3827143.0
2009-07-21	ABC-DELISTED	Stock	18.75	19.2	18.75	19.13	3206084.0
2009-07-21	ABCB	Stock	6.1763	6.2249	6.0303	6.1374	27143.0
2009-07-21	ABCO-DELISTED	Stock	12.49	12.595	12.185	12.295	143020.0
2009-07-21	ABCW-DELISTED	Stock	1.1103	1.159	1.081	1.12	34470.0
2009-07-21	ABD-DELISTED	Stock	3.14	3.17	2.88	3.1	234760.0
2009-07-21	ABE-DELISTED	Stock	16.15	16.39	16.024	16.235	25866.0
2009-07-21	ABEO	Stock	2562.5	2562.5	2325.0	2375.0	9.0
2009-07-21	ABFS-DELISTED	Stock	26.66	26.66	24.85	25.66	805065.0
2009-07-21	ABG	Stock	12.15	12.25	11.59	11.93	374000.0
2009-07-21	ABII-DELISTED	Stock	31.97	32.24	30.86	31.94	45390.0
2009-07-21	ABK-DELISTED	Stock	1.01	1.01	0.91	0.93	2586965.0
2009-07-21	ABM	Stock	19.29	19.43	18.92	19.41	179600.0
2009-07-21	ABMD-DELISTED	Stock	7.93	7.93	7.66	7.71	204763.0
2009-07-21	ABR	Stock	1.6	1.63	1.57	1.57	46200.0
2009-07-21	ABT	Stock	21.687	21.7781	21.3559	21.591	17015632.0
2009-07-21	ABTL-DELISTED	Stock	2.5771	2.7094	2.5495	2.55	33369.0
2009-07-21	ABV-DELISTED	Stock	71.03	71.69	69.28	70.31	553766.0
2009-07-21	ABVT-DELISTED	Stock	77.25	77.98	76.87	77.4	27326.0
2009-07-21	ABX-DELISTED	Stock	36.01	36.04	34.72	35.37	5647765.0
2009-07-21	ACAD	Stock	2.42	2.45	2.36	2.44	409000.0
2009-07-21	ACAP-DELISTED	Stock	38.63	39.67	38.57	38.72	20032.0
2009-07-21	ACAS-DELISTED	Stock	2.86	2.88	2.72	2.76	1938915.0

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

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