PREVIEW / stock_daily / 2007-05-14

all stock daily files

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

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-14	AAPL	Stock	3.915	3.9286	3.8661	3.9057	651946400.0
2007-05-14	MSFT	Stock	30.84	30.99	30.81	30.97	70188500.0
2007-05-14	NVDA	Stock	0.5833	0.5888	0.5743	0.5798	731568000.0
2007-05-14	AMZN	Stock	3.084	3.087	3.03	3.085	155208000.0
2007-05-14	TLT	Stock	88.23	88.28	87.96	87.96	315200.0
2007-05-14	CL	Stock	33.505	33.51	33.065	33.105	6198200.0
2007-05-14	A	Stock	26.0801	26.2804	25.5436	25.6867	5061878.0
2007-05-14	AABA-DELISTED	Stock	29.79	30.0	29.08	29.3	19273156.0
2007-05-14	AACC-DELISTED	Stock	18.96	19.02	18.62	18.75	213941.0
2007-05-14	AAI-DELISTED	Stock	11.65	11.74	11.56	11.58	879267.0
2007-05-14	AAIC-DELISTED	Stock	115.8	116.6	113.0	113.6	1061100.0
2007-05-14	AAME	Stock	5.0	5.2	4.87	5.03	8200.0
2007-05-14	AAON	Stock	3.923	3.9691	3.8914	3.9533	621169.0
2007-05-14	AAP	Stock	41.55	41.62	40.77	40.8	407500.0
2007-05-14	AATI-DELISTED	Stock	7.6	7.8	7.6	7.75	518984.0
2007-05-14	AAU-DELISTED	Stock	2.34	2.34	2.28	2.29	79300.0
2007-05-14	AAUAF-DELISTED	Stock	2.34	2.34	2.28	2.29	79300.0
2007-05-14	AAV-DELISTED	Stock	11.56	11.8	11.56	11.71	394210.0
2007-05-14	AAWW-DELISTED	Stock	59.53	59.53	57.78	58.5	68651.0
2007-05-14	AAXN-DELISTED	Stock	9.4	9.48	9.16	9.2	1825504.0
2007-05-14	AB	Stock	89.81	89.92	88.91	89.05	185600.0
2007-05-14	ABAX-DELISTED	Stock	21.84	21.84	21.12	21.13	263034.0
2007-05-14	ABB-DELISTED	Stock	20.01	20.04	19.84	19.96	859900.0
2007-05-14	ABBC-DELISTED	Stock	18.5	18.6	18.4	18.41	7630.0
2007-05-14	ABBNY-DELISTED	Stock	20.01	20.04	19.84	19.97	861600.0
2007-05-14	ABC-DELISTED	Stock	25.0	25.74	24.99	25.66	3993200.0
2007-05-14	ABCB	Stock	22.1276	22.2444	21.5343	21.6219	56239.0
2007-05-14	ABCO-DELISTED	Stock	24.73	24.86	24.51	24.57	377428.0
2007-05-14	ABCW-DELISTED	Stock	28.69	28.74	28.18	28.19	61200.0
2007-05-14	ABD-DELISTED	Stock	22.65	22.65	22.45	22.48	446560.0
2007-05-14	ABE-DELISTED	Stock	20.79	20.8099	20.5	20.7975	43400.0
2007-05-14	ABFS-DELISTED	Stock	38.54	38.6	37.66	37.71	504844.0
2007-05-14	ABG	Stock	26.9	27.12	26.81	27.09	339200.0
2007-05-14	ABK-DELISTED	Stock	94.67	94.76	94.12	94.42	1089723.0
2007-05-14	ABM	Stock	28.59	28.85	28.3	28.36	233600.0
2007-05-14	ABMD-DELISTED	Stock	12.23	12.36	12.14	12.34	121725.0
2007-05-14	ABP-DELISTED	Stock	3.97	4.01	3.85	4.0	266900.0
2007-05-14	ABR	Stock	29.48	29.5	28.69	28.83	116000.0
2007-05-14	ABT	Stock	27.7564	27.8764	27.5645	27.8044	9076699.0
2007-05-14	ABTL-DELISTED	Stock	19.475	19.525	18.874	19.525	38158.0
2007-05-14	ABV-DELISTED	Stock	60.94	61.22	60.37	61.03	488680.0
2007-05-14	ABVA-DELISTED	Stock	13.18	13.18	12.75	12.75	14330.0
2007-05-14	ABX-DELISTED	Stock	30.1	30.47	29.23	29.67	6569570.0
2007-05-14	ACAD	Stock	13.48	13.64	13.21	13.33	416400.0
2007-05-14	ACAP-DELISTED	Stock	39.7	39.7	38.57	38.93	74246.0
2007-05-14	ACAS-DELISTED	Stock	46.4	46.6	45.85	45.94	823463.0
2007-05-14	ACAT-DELISTED	Stock	18.29	18.43	17.84	18.05	85952.0
2007-05-14	ACC-DELISTED	Stock	29.21	29.49	28.57	28.59	149617.0
2007-05-14	ACCL-DELISTED	Stock	6.31	6.38	6.28	6.33	48146.0
2007-05-14	ACCO	Stock	22.65	22.65	22.45	22.48	446800.0

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

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