PREVIEW / stock_daily / 2007-07-05

all stock daily files

  file:    by_date/stock_daily/2007/2007-07-05.parquet
  size:    175 KB
  rows:    5,387
  symbols: 3,237

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-05	AAPL	Stock	4.6	4.7489	4.5961	4.7411	1453051600.0
2007-07-05	MSFT	Stock	30.05	30.22	29.83	29.99	47838500.0
2007-07-05	NVDA	Stock	0.7185	0.7283	0.715	0.726	373290000.0
2007-07-05	AMZN	Stock	3.468	3.4825	3.403	3.4365	89758000.0
2007-07-05	TLT	Stock	84.31	84.42	83.72	83.82	4589941.0
2007-07-05	CL	Stock	33.0	33.07	32.85	33.025	4479200.0
2007-07-05	A	Stock	28.5265	28.5265	27.99	28.3047	3547705.0
2007-07-05	AABA-DELISTED	Stock	26.92	27.14	26.9	26.99	15565160.0
2007-07-05	AACC-DELISTED	Stock	17.81	17.81	17.28	17.29	185698.0
2007-07-05	AAI-DELISTED	Stock	11.38	11.42	10.99	11.02	2774474.0
2007-07-05	AAIC-DELISTED	Stock	110.0	110.6	105.0	107.4	2176200.0
2007-07-05	AAME	Stock	3.95	3.95	3.88	3.89	3500.0
2007-07-05	AAON	Stock	4.2048	4.2232	4.1481	4.2166	562697.0
2007-07-05	AAP	Stock	41.22	41.6	41.03	41.52	337800.0
2007-07-05	AATI-DELISTED	Stock	9.75	9.93	9.74	9.8	307764.0
2007-07-05	AAU-DELISTED	Stock	2.55	2.62	2.46	2.52	129800.0
2007-07-05	AAUAF-DELISTED	Stock	2.55	2.62	2.462	2.516	130200.0
2007-07-05	AAV-DELISTED	Stock	14.01	14.13	13.85	14.08	705600.0
2007-07-05	AAWW-DELISTED	Stock	60.23	60.58	59.77	59.99	68988.0
2007-07-05	AAXN-DELISTED	Stock	14.35	14.38	14.04	14.1	2328516.0
2007-07-05	AB	Stock	89.82	89.82	88.44	88.66	130000.0
2007-07-05	ABAX-DELISTED	Stock	21.55	21.56	21.156	21.35	192286.0
2007-07-05	ABB-DELISTED	Stock	23.7	23.78	23.65	23.76	2660300.0
2007-07-05	ABBC-DELISTED	Stock	9.708	9.836	9.688	9.812	176037.0
2007-07-05	ABBNY-DELISTED	Stock	23.7	23.78	23.65	23.76	2867500.0
2007-07-05	ABC-DELISTED	Stock	25.29	25.29	24.84	24.9	1294200.0
2007-07-05	ABCB	Stock	22.6528	22.6528	21.7872	22.2444	24161.0
2007-07-05	ABCO-DELISTED	Stock	28.45	28.72	28.31	28.63	223039.0
2007-07-05	ABCW-DELISTED	Stock	26.4	26.44	25.89	26.09	101040.0
2007-07-05	ABD-DELISTED	Stock	23.99	24.02	23.7	23.73	182500.0
2007-07-05	ABE-DELISTED	Stock	21.38	21.59	21.3	21.56	27200.0
2007-07-05	ABEO	Stock	6250.0	6437.5	6250.0	6437.5	2.0
2007-07-05	ABFS-DELISTED	Stock	39.36	39.47	38.85	39.09	283213.0
2007-07-05	ABG	Stock	25.23	25.24	24.56	24.9	308700.0
2007-07-05	ABK-DELISTED	Stock	87.87	88.06	86.32	86.45	1058300.0
2007-07-05	ABM	Stock	25.7	26.06	25.35	26.03	307200.0
2007-07-05	ABMD-DELISTED	Stock	10.38	10.85	10.23	10.81	277584.0
2007-07-05	ABP-DELISTED	Stock	4.58	4.66	4.45	4.51	259000.0
2007-07-05	ABR	Stock	26.24	26.36	25.91	26.06	301800.0
2007-07-05	ABT	Stock	26.1203	26.2355	25.7892	26.0196	6923301.0
2007-07-05	ABTL-DELISTED	Stock	22.3	22.3	21.8	21.9	36906.0
2007-07-05	ABV-DELISTED	Stock	71.15	72.18	71.03	72.06	442000.0
2007-07-05	ABVA-DELISTED	Stock	13.46	13.47	13.02	13.02	80000.0
2007-07-05	ABX-DELISTED	Stock	29.76	30.1	29.41	30.02	3685569.0
2007-07-05	ACAD	Stock	13.91	13.91	13.5	13.63	405200.0
2007-07-05	ACAP-DELISTED	Stock	40.87	41.04	39.8	40.2	43392.0
2007-07-05	ACAS-DELISTED	Stock	45.2	45.56	45.1	45.5	3502288.0
2007-07-05	ACAT-DELISTED	Stock	20.39	20.49	20.1	20.35	54858.0
2007-07-05	ACC-DELISTED	Stock	28.89	29.39	28.87	29.25	125500.0
2007-07-05	ACCL-DELISTED	Stock	6.18	6.2	6.06	6.17	42742.0

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

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