PREVIEW / stock_daily / 2007-02-14

all stock daily files

  file:    by_date/stock_daily/2007/2007-02-14.parquet
  size:    163 KB
  rows:    4,867
  symbols: 3,068

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-02-14	AAPL	Stock	3.0225	3.0586	3.0204	3.0464	507981600.0
2007-02-14	MSFT	Stock	29.17	29.69	29.15	29.4	55588600.0
2007-02-14	NVDA	Stock	0.5717	0.575	0.5578	0.5592	1081848000.0
2007-02-14	AMZN	Stock	1.9615	2.014	1.957	2.007	136282000.0
2007-02-14	TLT	Stock	87.52	88.19	87.52	88.07	2262500.0
2007-02-14	CL	Stock	33.755	33.985	33.675	33.95	3465400.0
2007-02-14	A	Stock	23.4979	23.8913	23.4979	23.5622	4033230.0
2007-02-14	AABA-DELISTED	Stock	29.6900005340576	30.8600006103516	29.6399993896484	30.6599998474121	30821100.0
2007-02-14	AACC-DELISTED	Stock	15.49	15.79	15.29	15.35	96611.0
2007-02-14	AACQ-DELISTED	Stock	5.55	5.6	5.54	5.59	797462.0
2007-02-14	AACQU-DELISTED	Stock	6.99	6.99	6.98	6.99	5000.0
2007-02-14	AACQW-DELISTED	Stock	0.72	0.72	0.72	0.72	37480.0
2007-02-14	AAI-DELISTED	Stock	11.61	11.86	11.55	11.71	802419.0
2007-02-14	AAIC-DELISTED	Stock	145.0	147.0	143.2	144.8	1545208.0
2007-02-14	AAME	Stock	3.56	3.8	3.56	3.8	9300.0
2007-02-14	AAON	Stock	3.736	3.7452	3.6872	3.7333	464737.0
2007-02-14	AAP	Stock	37.6	37.79	36.93	37.02	1235300.0
2007-02-14	AATI-DELISTED	Stock	5.68	6.0	5.63	5.84	617209.0
2007-02-14	AAU-DELISTED	Stock	2.29	2.36	2.29	2.31	57397.0
2007-02-14	AAUAF-DELISTED	Stock	2.27	2.34	2.27	2.29	57900.0
2007-02-14	AAV-DELISTED	Stock	10.76	10.86	10.66	10.71	507167.0
2007-02-14	AAWW-DELISTED	Stock	50.19	50.8	49.79	50.53	110494.0
2007-02-14	AAXN-DELISTED	Stock	7.8600001335144	8.14999961853027	7.80000019073486	8.02999973297119	1654600.0
2007-02-14	AB	Stock	91.0	92.38	90.5	91.54	217700.0
2007-02-14	ABAX-DELISTED	Stock	21.62	22.9	21.46	22.83	380715.0
2007-02-14	ABB-DELISTED	Stock	18.66	19.25	18.65	19.16	2116556.0
2007-02-14	ABBC-DELISTED	Stock	19.62	19.62	19.3	19.36	14974.0
2007-02-14	ABC-DELISTED	Stock	27.2	27.34	26.94	26.96	1569858.0
2007-02-14	ABCB	Stock	23.7713	23.82	23.1099	23.1781	30638.0
2007-02-14	ABCO-DELISTED	Stock	27.1	27.1	26.73	26.81	251056.0
2007-02-14	ABCW-DELISTED	Stock	29.01	29.29	28.86	28.87	43100.0
2007-02-14	ABD-DELISTED	Stock	23.15	23.16	22.85	22.9	473500.0
2007-02-14	ABE-DELISTED	Stock	18.5	18.85	18.5	18.81	26700.0
2007-02-14	ABFS-DELISTED	Stock	40.25	41.48	40.1	41.37	663650.0
2007-02-14	ABG	Stock	25.14	25.5	25.01	25.5	214800.0
2007-02-14	ABK-DELISTED	Stock	89.43	91.53	89.14	91.33	937180.0
2007-02-14	ABM	Stock	26.83	26.99	26.72	26.78	136900.0
2007-02-14	ABMD-DELISTED	Stock	14.96	15.1	14.78	14.98	299241.0
2007-02-14	ABP-DELISTED	Stock	3.09	3.19	3.04	3.07	182193.0
2007-02-14	ABR	Stock	32.9	33.05	32.4	32.4	90200.0
2007-02-14	ABT	Stock	25.2855	25.5158	25.2711	25.2855	10593997.0
2007-02-14	ABTL-DELISTED	Stock	18.75	18.9	18.2	18.75	11341.0
2007-02-14	ABV-DELISTED	Stock	52.38	53.5394	52.2	53.35	352972.0
2007-02-14	ABVA-DELISTED	Stock	15.9	15.948	15.84	15.84	2098.0
2007-02-14	ABX-DELISTED	Stock	31.33	31.91	31.3	31.44	5939313.0
2007-02-14	ACAD	Stock	6.98	7.13	6.91	7.05	216800.0
2007-02-14	ACAP-DELISTED	Stock	38.45	38.46	37.65	38.07	48345.0
2007-02-14	ACAS-DELISTED	Stock	47.72	48.5	47.01	47.94	2703462.0
2007-02-14	ACAT-DELISTED	Stock	17.57	18.19	17.57	17.86	44038.0
2007-02-14	ACC-DELISTED	Stock	31.77	31.78	31.39	31.46	164124.0

> showing 50 of 4,867 rows — these rows as CSV

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