PREVIEW / stock_daily / 2007-05-10

all stock daily files

  file:    by_date/stock_daily/2007/2007-05-10.parquet
  size:    169 KB
  rows:    5,106
  symbols: 3,137

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
2007-05-10	AAPL	Stock	3.8082	3.8871	3.7829	3.8336	1197257600.0
2007-05-10	MSFT	Stock	30.68	30.93	30.53	30.58	55398600.0
2007-05-10	NVDA	Stock	0.5597	0.567	0.5422	0.547	802584000.0
2007-05-10	AMZN	Stock	3.122	3.1325	3.0425	3.046	201040000.0
2007-05-10	TLT	Stock	88.4	88.5899	88.31	88.5	519452.0
2007-05-10	CL	Stock	33.9	33.93	33.56	33.56	4552200.0
2007-05-10	A	Stock	26.4664	26.588	25.7368	25.7582	4749006.0
2007-05-10	AABA-DELISTED	Stock	30.52	30.69	29.61	29.69	24564073.0
2007-05-10	AACC-DELISTED	Stock	19.0	19.07	18.66	18.73	191648.0
2007-05-10	AAI-DELISTED	Stock	11.68	11.95	11.58	11.61	1301647.0
2007-05-10	AAIC-DELISTED	Stock	115.0	115.4	111.0	112.6	1356500.0
2007-05-10	AAME	Stock	4.92	5.24	4.87	5.14	10800.0
2007-05-10	AAON	Stock	3.7531	3.8163	3.6504	3.7926	705459.0
2007-05-10	AAP	Stock	41.8	42.25	41.58	41.68	726800.0
2007-05-10	AATI-DELISTED	Stock	7.59	7.65	7.46	7.51	393991.0
2007-05-10	AAU-DELISTED	Stock	2.52	2.5399	2.35	2.38	166700.0
2007-05-10	AAUAF-DELISTED	Stock	2.52	2.5399	2.35	2.38	166700.0
2007-05-10	AAV-DELISTED	Stock	11.8	11.86	11.55	11.58	628100.0
2007-05-10	AAWW-DELISTED	Stock	58.63	59.5	58.14	59.0099	130388.0
2007-05-10	AAXN-DELISTED	Stock	9.58	9.69	9.15	9.4	1989157.0
2007-05-10	AB	Stock	88.43	90.87	88.43	88.95	424400.0
2007-05-10	ABAX-DELISTED	Stock	22.56	22.57	21.48	21.51	279533.0
2007-05-10	ABB-DELISTED	Stock	19.85	19.96	19.46	19.55	2601850.0
2007-05-10	ABBC-DELISTED	Stock	18.56	18.62	18.4	18.41	14844.0
2007-05-10	ABBNY-DELISTED	Stock	19.85	19.96	19.46	19.56	2604450.0
2007-05-10	ABC-DELISTED	Stock	25.92	25.92	25.6	25.71	2292000.0
2007-05-10	ABCB	Stock	21.8455	21.9234	21.0091	21.2912	62202.0
2007-05-10	ABCO-DELISTED	Stock	24.59	24.8	24.25	24.51	441450.0
2007-05-10	ABCW-DELISTED	Stock	28.48	28.69	28.27	28.4	114710.0
2007-05-10	ABD-DELISTED	Stock	22.7	22.7	22.12	22.35	258000.0
2007-05-10	ABE-DELISTED	Stock	20.75	21.2	20.68	20.68	37700.0
2007-05-10	ABFS-DELISTED	Stock	39.1	39.15	38.1	38.1199	665551.0
2007-05-10	ABG	Stock	26.55	27.12	26.38	26.94	1040400.0
2007-05-10	ABK-DELISTED	Stock	94.12	94.7	93.9	94.04	527000.0
2007-05-10	ABM	Stock	29.2	29.2	28.18	28.26	448900.0
2007-05-10	ABMD-DELISTED	Stock	12.68	12.68	12.19	12.34	165948.0
2007-05-10	ABP-DELISTED	Stock	3.96	3.99	3.76	3.86	192500.0
2007-05-10	ABR	Stock	29.92	29.95	29.36	29.52	161500.0
2007-05-10	ABT	Stock	28.1547	28.1547	27.5069	27.5069	10251980.0
2007-05-10	ABTL-DELISTED	Stock	17.15	17.349	16.701	17.15	28791.0
2007-05-10	ABV-DELISTED	Stock	62.7	62.94	60.62	61.01	539740.0
2007-05-10	ABVA-DELISTED	Stock	13.25	13.33	12.9	12.92	16448.0
2007-05-10	ABX-DELISTED	Stock	30.47	30.7	29.78	29.9	5186900.0
2007-05-10	ACAD	Stock	13.92	14.06	13.52	13.81	607800.0
2007-05-10	ACAP-DELISTED	Stock	40.03	40.03	38.12	38.18	61699.0
2007-05-10	ACAS-DELISTED	Stock	46.27	46.61	46.0	46.01	964472.0
2007-05-10	ACAT-DELISTED	Stock	18.43	18.85	18.32	18.34	69407.0
2007-05-10	ACC-DELISTED	Stock	29.37	29.41	28.77	28.77	116600.0
2007-05-10	ACCL-DELISTED	Stock	6.3	6.38	6.24	6.35	102689.0
2007-05-10	ACCO	Stock	22.7	22.7	22.12	22.35	258000.0

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

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