PREVIEW / stock_daily / 2007-06-18

all stock daily files

  file:    by_date/stock_daily/2007/2007-06-18.parquet
  size:    176 KB
  rows:    5,415
  symbols: 3,260

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-06-18	AAPL	Stock	4.4029	4.4707	4.3764	4.4675	910604800.0
2007-06-18	MSFT	Stock	30.69	30.72	30.42	30.51	45412600.0
2007-06-18	NVDA	Stock	0.6658	0.6682	0.6542	0.6595	685662000.0
2007-06-18	AMZN	Stock	3.617	3.632	3.57	3.5915	156272000.0
2007-06-18	TLT	Stock	83.63	83.65	82.24	83.52	17704600.0
2007-06-18	CL	Stock	33.36	33.395	33.06	33.19	3221200.0
2007-06-18	A	Stock	27.7539	28.0615	27.7039	27.8255	2892462.0
2007-06-18	AABA-DELISTED	Stock	27.72	28.67	27.5	28.13	55324713.0
2007-06-18	AACC-DELISTED	Stock	16.84	17.1	16.76	16.81	176631.0
2007-06-18	AAI-DELISTED	Stock	11.27	11.45	11.25	11.36	964000.0
2007-06-18	AAIC-DELISTED	Stock	128.2	129.8	127.4	128.2	1283688.0
2007-06-18	AAME	Stock	4.01	4.08	3.97	3.97	5300.0
2007-06-18	AAON	Stock	3.8663	3.9045	3.8387	3.9045	265022.0
2007-06-18	AAP	Stock	41.0	41.13	40.67	40.83	714600.0
2007-06-18	AATI-DELISTED	Stock	9.47	9.69	9.41	9.66	315166.0
2007-06-18	AAU-DELISTED	Stock	2.3	2.35	2.29	2.35	66300.0
2007-06-18	AAUAF-DELISTED	Stock	2.3	2.35	2.29	2.35	66300.0
2007-06-18	AAV-DELISTED	Stock	13.54	13.95	13.48	13.9	1226000.0
2007-06-18	AAWW-DELISTED	Stock	58.52	58.58	57.73	58.39	137695.0
2007-06-18	AAXN-DELISTED	Stock	12.48	12.57	12.07	12.1	2143280.0
2007-06-18	AB	Stock	87.54	87.98	85.4	86.53	666300.0
2007-06-18	ABAX-DELISTED	Stock	22.74	23.16	22.54	23.06	110157.0
2007-06-18	ABB-DELISTED	Stock	22.36	22.41	22.02	22.14	1468627.0
2007-06-18	ABBC-DELISTED	Stock	17.7	17.86	17.44	17.44	6655.0
2007-06-18	ABBNY-DELISTED	Stock	22.36	22.41	22.02	22.14	1469027.0
2007-06-18	ABC-DELISTED	Stock	25.2	25.26	25.06	25.2	1886400.0
2007-06-18	ABCB	Stock	22.1081	22.1179	21.651	22.0012	33311.0
2007-06-18	ABCO-DELISTED	Stock	27.21	27.35	26.92	27.28	226244.0
2007-06-18	ABCW-DELISTED	Stock	27.78	27.83	27.41	27.45	78070.0
2007-06-18	ABD-DELISTED	Stock	24.89	24.91	24.59	24.87	344170.0
2007-06-18	ABE-DELISTED	Stock	21.98	22.15	21.6	21.95	29400.0
2007-06-18	ABEO	Stock	6062.5	6437.5	6062.5	6437.5	6.0
2007-06-18	ABFS-DELISTED	Stock	39.9	39.9	39.16	39.8	347738.0
2007-06-18	ABG	Stock	25.29	26.3	25.29	26.19	850700.0
2007-06-18	ABK-DELISTED	Stock	88.49	89.07	87.96	88.42	946200.0
2007-06-18	ABM	Stock	26.56	26.65	26.1	26.26	144300.0
2007-06-18	ABMD-DELISTED	Stock	11.9	11.9	11.51	11.77	170409.0
2007-06-18	ABP-DELISTED	Stock	4.25	4.25	4.1	4.2	187900.0
2007-06-18	ABR	Stock	27.66	27.8	27.39	27.55	132000.0
2007-06-18	ABT	Stock	26.2547	26.3026	26.0004	26.1683	9923510.0
2007-06-18	ABTL-DELISTED	Stock	21.58	21.58	20.67	21.12	28276.0
2007-06-18	ABV-DELISTED	Stock	75.11	75.61	74.61	74.98	487400.0
2007-06-18	ABVA-DELISTED	Stock	13.93	13.93	13.87	13.87	200.0
2007-06-18	ABX-DELISTED	Stock	29.1	29.25	29.02	29.06	3753575.0
2007-06-18	ACAD	Stock	15.19	15.24	14.95	15.03	414100.0
2007-06-18	ACAP-DELISTED	Stock	42.3	42.35	41.55	41.87	30379.0
2007-06-18	ACAS-DELISTED	Stock	45.6	45.94	45.03	45.04	1850939.0
2007-06-18	ACAT-DELISTED	Stock	19.68	20.54	19.62	20.514	83732.0
2007-06-18	ACC-DELISTED	Stock	29.11	29.11	28.55	28.74	120300.0
2007-06-18	ACCL-DELISTED	Stock	6.05	6.15	6.01	6.06	47164.0

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

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