PREVIEW / stock_daily / 2009-07-23

all stock daily files

  file:    by_date/stock_daily/2009/2009-07-23.parquet
  size:    183 KB
  rows:    5,797
  symbols: 3,454

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-23	AAPL	Stock	5.5939	5.6586	5.5557	5.6364	526962800.0
2009-07-23	MSFT	Stock	24.93	25.72	24.84	25.56	106060500.0
2009-07-23	NVDA	Stock	0.3073	0.326	0.304	0.325	1046120000.0
2009-07-23	AMZN	Stock	4.492	4.72	4.4795	4.6935	383242000.0
2009-07-23	TLT	Stock	92.76	92.8	90.57	91.01	3819859.0
2009-07-23	ES	Stock	22.13	22.92	22.13	22.86	894400.0
2009-07-23	CL	Stock	36.74	37.63	36.655	37.29	5858400.0
2009-07-23	A	Stock	15.3362	15.9299	15.2647	15.8226	5450243.0
2009-07-23	AABA-DELISTED	Stock	17.42	17.68	17.16	17.36	37269850.0
2009-07-23	AACC-DELISTED	Stock	8.45	8.51	8.14	8.46	77211.0
2009-07-23	AACG	Stock	8.9	8.9	8.51	8.6	7200.0
2009-07-23	AAI-DELISTED	Stock	6.35	6.45	6.24	6.44	3843135.0
2009-07-23	AAIC-DELISTED	Stock	8.4	9.0	8.21	8.6	756110.0
2009-07-23	AAME	Stock	0.82	0.87	0.82	0.83	3700.0
2009-07-23	AAON	Stock	4.0079	4.0138	3.8914	3.9012	874294.0
2009-07-23	AAP	Stock	46.62	47.22	46.02	46.6	1281600.0
2009-07-23	AATI-DELISTED	Stock	5.43	5.59	4.85	5.0	1940550.0
2009-07-23	AAU-DELISTED	Stock	0.7099	0.71	0.68	0.68	26577.0
2009-07-23	AAUAF-DELISTED	Stock	0.7098	0.7099	0.68	0.68	26679.0
2009-07-23	AAV-DELISTED	Stock	5.01	5.25	4.96	5.2	1216451.0
2009-07-23	AAWW-DELISTED	Stock	23.52	24.23	23.28	24.17	245773.0
2009-07-23	AAXJ	Stock	48.18	49.3699	48.14	49.26	186184.0
2009-07-23	AAXN-DELISTED	Stock	5.26	5.43	5.24	5.42	469318.0
2009-07-23	AB	Stock	21.77	23.06	21.7	22.87	871200.0
2009-07-23	ABAX-DELISTED	Stock	19.55	20.25	19.4	19.91	308466.0
2009-07-23	ABB-DELISTED	Stock	16.84	17.3	16.73	17.12	9767698.0
2009-07-23	ABBC-DELISTED	Stock	8.47	8.94	8.38	8.84	56022.0
2009-07-23	ABBNY-DELISTED	Stock	16.82	17.3	16.73	17.16	9769698.0
2009-07-23	ABC-DELISTED	Stock	18.85	19.38	18.69	19.14	3479982.0
2009-07-23	ABCB	Stock	6.2055	6.3124	5.9914	6.3027	40611.0
2009-07-23	ABCO-DELISTED	Stock	11.875	12.125	11.875	11.955	160112.0
2009-07-23	ABCW-DELISTED	Stock	1.1483	1.1581	1.0894	1.11	86100.0
2009-07-23	ABD-DELISTED	Stock	3.04	3.96	2.98	3.84	837230.0
2009-07-23	ABE-DELISTED	Stock	16.05	16.8	16.05	16.57	44903.0
2009-07-23	ABEO	Stock	2725.0	4000.0	2725.0	3937.5	243.0
2009-07-23	ABFS-DELISTED	Stock	24.35	25.61	24.23	25.51	766846.0
2009-07-23	ABG	Stock	12.03	12.88	11.84	12.42	465800.0
2009-07-23	ABII-DELISTED	Stock	32.0	34.79	30.7701	30.95	109766.0
2009-07-23	ABK-DELISTED	Stock	0.9	0.92	0.85	0.89	3788337.0
2009-07-23	ABM	Stock	19.84	20.94	19.55	20.91	379700.0
2009-07-23	ABMD-DELISTED	Stock	7.54	7.78	7.34	7.65	258534.0
2009-07-23	ABR	Stock	1.55	1.66	1.54	1.59	133900.0
2009-07-23	ABT	Stock	21.3079	21.3271	20.8473	21.0344	35071071.0
2009-07-23	ABTL-DELISTED	Stock	2.5	2.5	2.4	2.5	25626.0
2009-07-23	ABV-DELISTED	Stock	68.65	71.85	68.51	70.81	788026.0
2009-07-23	ABVA-DELISTED	Stock	2.335	2.5	2.33	2.5	2638.0
2009-07-23	ABVT-DELISTED	Stock	76.7	82.55	76.7	82.453	275085.0
2009-07-23	ABX-DELISTED	Stock	34.57	35.85	34.53	35.1245	7117305.0
2009-07-23	ACAD	Stock	2.47	2.71	2.45	2.6	597000.0
2009-07-23	ACAP-DELISTED	Stock	39.17	39.93	38.63	38.86	52079.0

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

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