PREVIEW / stock_daily / 2007-02-23

all stock daily files

  file:    by_date/stock_daily/2007/2007-02-23.parquet
  size:    162 KB
  rows:    4,861
  symbols: 3,063

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-23	AAPL	Stock	3.1843	3.2264	3.1732	3.1811	517893600.0
2007-02-23	MSFT	Stock	29.22	29.28	28.89	28.9	63787100.0
2007-02-23	NVDA	Stock	0.5507	0.551	0.544	0.5442	403050000.0
2007-02-23	AMZN	Stock	2.05	2.06	2.037	2.039	109948000.0
2007-02-23	TLT	Stock	88.53	88.94	88.49	88.84	735700.0
2007-02-23	CL	Stock	34.095	34.22	33.87	34.165	2630600.0
2007-02-23	A	Stock	23.7911	23.8984	23.4979	23.7983	4423412.0
2007-02-23	AABA-DELISTED	Stock	31.6000003814697	32.1800003051758	31.4099998474121	32.0999984741211	21533500.0
2007-02-23	AACC-DELISTED	Stock	15.42	15.55	15.42	15.42	37519.0
2007-02-23	AACQ-DELISTED	Stock	5.41	5.43	5.34	5.34	8815.0
2007-02-23	AACQW-DELISTED	Stock	0.81	0.81	0.77	0.78	216900.0
2007-02-23	AAI-DELISTED	Stock	11.28	11.3	10.94	11.04	1272600.0
2007-02-23	AAIC-DELISTED	Stock	151.8	152.0	145.4	145.6	2334200.0
2007-02-23	AAME	Stock	3.69	4.0	3.69	3.96	5000.0
2007-02-23	AAON	Stock	3.7597	3.7597	3.7109	3.732	183009.0
2007-02-23	AAP	Stock	38.33	38.72	38.21	38.53	970100.0
2007-02-23	AATI-DELISTED	Stock	6.35	6.56	6.35	6.49	205844.0
2007-02-23	AAU-DELISTED	Stock	2.31	2.35	2.31	2.31	59500.0
2007-02-23	AAUAF-DELISTED	Stock	2.31	2.35	2.31	2.31	59500.0
2007-02-23	AAV-DELISTED	Stock	10.74	10.82	10.73	10.8	818700.0
2007-02-23	AAWW-DELISTED	Stock	50.27	50.66	50.27	50.32	66311.0
2007-02-23	AAXN-DELISTED	Stock	8.42000007629395	8.68000030517578	8.26000022888184	8.5600004196167	2447900.0
2007-02-23	AB	Stock	91.07	91.57	89.09	89.84	315900.0
2007-02-23	ABAX-DELISTED	Stock	23.4	24.07	23.25	23.9	215115.0
2007-02-23	ABB-DELISTED	Stock	17.79	17.89	17.77	17.86	1178300.0
2007-02-23	ABBC-DELISTED	Stock	19.36	19.58	19.35	19.4	7635.0
2007-02-23	ABC-DELISTED	Stock	27.4	27.56	27.2	27.5	1471600.0
2007-02-23	ABCB	Stock	23.7324	24.248	23.538	23.8006	52435.0
2007-02-23	ABCO-DELISTED	Stock	26.97	27.16	26.7	26.99	124515.0
2007-02-23	ABCW-DELISTED	Stock	29.25	29.25	28.81	29.01	41970.0
2007-02-23	ABD-DELISTED	Stock	22.61	22.66	22.36	22.62	760020.0
2007-02-23	ABE-DELISTED	Stock	19.47	19.87	19.41	19.76	31800.0
2007-02-23	ABFS-DELISTED	Stock	41.52	42.51	41.5	42.43	451762.0
2007-02-23	ABG	Stock	26.98	27.11	26.9	26.95	196700.0
2007-02-23	ABK-DELISTED	Stock	90.47	90.75	89.05	89.44	816600.0
2007-02-23	ABM	Stock	27.52	27.6	27.32	27.42	145700.0
2007-02-23	ABMD-DELISTED	Stock	14.9	15.0	14.62	14.78	104531.0
2007-02-23	ABP-DELISTED	Stock	3.1	3.16	3.08	3.1	217200.0
2007-02-23	ABR	Stock	33.42	33.67	33.1	33.1	107200.0
2007-02-23	ABT	Stock	25.5829	25.7988	25.5254	25.7125	10441851.0
2007-02-23	ABTL-DELISTED	Stock	20.0	20.0	19.55	19.8	9810.0
2007-02-23	ABV-DELISTED	Stock	53.25	53.25	52.3	52.34	408400.0
2007-02-23	ABVA-DELISTED	Stock	16.09	16.09	15.98	15.98	54231.0
2007-02-23	ABX-DELISTED	Stock	32.0	32.02	31.03	31.06	6934100.0
2007-02-23	ACAD	Stock	7.61	8.0	7.56	7.84	276800.0
2007-02-23	ACAP-DELISTED	Stock	38.56	38.56	37.96	38.0	18052.0
2007-02-23	ACAS-DELISTED	Stock	47.05	47.14	46.64	46.97	953014.0
2007-02-23	ACAT-DELISTED	Stock	18.51	18.73	18.37	18.37	62257.0
2007-02-23	ACC-DELISTED	Stock	31.76	31.83	31.24	31.58	162400.0
2007-02-23	ACCL-DELISTED	Stock	6.22	6.29	6.19	6.24	61524.0

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

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