PREVIEW / stock_daily / 2007-07-19

all stock daily files

  file:    by_date/stock_daily/2007/2007-07-19.parquet
  size:    176 KB
  rows:    5,415
  symbols: 3,254

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-07-19	AAPL	Stock	5.0107	5.0289	4.9875	5.0	732891600.0
2007-07-19	MSFT	Stock	31.05	31.84	30.93	31.51	121159300.0
2007-07-19	NVDA	Stock	0.7717	0.7755	0.7547	0.76	407376000.0
2007-07-19	AMZN	Stock	3.712	3.716	3.656	3.6675	105470000.0
2007-07-19	TLT	Stock	84.9	85.26	84.8	85.19	1020988.0
2007-07-19	CL	Stock	33.925	34.3	33.855	34.25	4506400.0
2007-07-19	A	Stock	28.4621	28.6481	28.3333	28.5265	2842833.0
2007-07-19	AABA-DELISTED	Stock	26.32	26.34	25.92	26.03	28665993.0
2007-07-19	AACC-DELISTED	Stock	15.35	15.49	15.01	15.39	242541.0
2007-07-19	AAI-DELISTED	Stock	10.49	10.6	10.36	10.5	1539255.0
2007-07-19	AAIC-DELISTED	Stock	102.6	103.6	101.4	101.8	1014900.0
2007-07-19	AAME	Stock	3.98	4.0	3.81	3.9	5500.0
2007-07-19	AAON	Stock	4.5156	4.617	4.4932	4.5379	470053.0
2007-07-19	AAP	Stock	39.42	39.62	38.97	38.97	1053900.0
2007-07-19	AATI-DELISTED	Stock	9.84	10.37	9.79	10.31	830702.0
2007-07-19	AAU-DELISTED	Stock	2.69	2.75	2.65	2.68	106400.0
2007-07-19	AAUAF-DELISTED	Stock	2.69	2.75	2.65	2.68	106400.0
2007-07-19	AAV-DELISTED	Stock	13.9	14.0	13.9	13.97	970300.0
2007-07-19	AAWW-DELISTED	Stock	60.48	60.6	59.54	59.84	63924.0
2007-07-19	AAXN-DELISTED	Stock	16.41	17.65	16.25	17.41	10424981.0
2007-07-19	AB	Stock	89.19	90.31	88.34	89.02	223000.0
2007-07-19	ABAX-DELISTED	Stock	19.2	19.29	18.57	18.65	384006.0
2007-07-19	ABB-DELISTED	Stock	24.59	24.73	24.44	24.59	3165700.0
2007-07-19	ABBC-DELISTED	Stock	9.747	9.77	9.678	9.683	164717.0
2007-07-19	ABBNY-DELISTED	Stock	24.59	24.73	24.44	24.59	3166200.0
2007-07-19	ABC-DELISTED	Stock	24.52	24.68	24.48	24.56	1921200.0
2007-07-19	ABCB	Stock	21.9623	22.1956	21.0188	21.2425	47911.0
2007-07-19	ABCO-DELISTED	Stock	28.19	28.27	27.99	28.04	140487.0
2007-07-19	ABCW-DELISTED	Stock	23.67	23.98	23.61	23.98	207260.0
2007-07-19	ABD-DELISTED	Stock	22.35	22.76	22.23	22.59	229870.0
2007-07-19	ABE-DELISTED	Stock	22.3	22.9883	22.28	22.89	55900.0
2007-07-19	ABEO	Stock	5750.0	5750.0	5437.5	5625.0	11.0
2007-07-19	ABFS-DELISTED	Stock	41.62	42.36	41.23	41.36	395931.0
2007-07-19	ABG	Stock	23.89	24.09	23.76	23.85	482500.0
2007-07-19	ABK-DELISTED	Stock	83.17	84.02	81.78	82.51	2108100.0
2007-07-19	ABM	Stock	25.0	25.04	24.81	24.96	124500.0
2007-07-19	ABMD-DELISTED	Stock	11.24	11.44	11.14	11.14	285380.0
2007-07-19	ABP-DELISTED	Stock	4.35	4.38	4.3	4.37	184800.0
2007-07-19	ABR	Stock	25.03	25.16	24.87	24.9	153200.0
2007-07-19	ABT	Stock	26.2115	26.2355	25.7077	26.0627	13099833.0
2007-07-19	ABTL-DELISTED	Stock	20.8	21.2	20.35	20.9	18876.0
2007-07-19	ABV-DELISTED	Stock	75.03	75.86	74.56	75.82	374400.0
2007-07-19	ABVA-DELISTED	Stock	12.26	12.55	12.26	12.55	1700.0
2007-07-19	ABVT-DELISTED	Stock	73.0	78.0	73.0	76.0	4145.0
2007-07-19	ABX-DELISTED	Stock	33.83	34.31	33.68	34.29	9607716.0
2007-07-19	ACAD	Stock	13.47	13.87	13.45	13.77	522500.0
2007-07-19	ACAP-DELISTED	Stock	37.12	37.75	36.25	36.26	130301.0
2007-07-19	ACAS-DELISTED	Stock	44.54	45.49	44.35	44.35	2009470.0
2007-07-19	ACAT-DELISTED	Stock	20.02	20.37	19.96	20.2	63088.0
2007-07-19	ACC-DELISTED	Stock	28.31	28.32	28.07	28.16	46265.0

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

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