PREVIEW / stock_daily / 2007-08-08

all stock daily files

  file:    by_date/stock_daily/2007/2007-08-08.parquet
  size:    179 KB
  rows:    5,513
  symbols: 3,320

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-08-08	AAPL	Stock	4.8843	4.8879	4.7143	4.7861	808096800.0
2007-08-08	MSFT	Stock	29.72	30.01	29.21	30.0	52898600.0
2007-08-08	NVDA	Stock	0.7395	0.7825	0.7338	0.7598	660744000.0
2007-08-08	AMZN	Stock	3.9885	3.994	3.828	3.889	164896000.0
2007-08-08	TLT	Stock	86.89	86.89	85.86	86.16	6471268.0
2007-08-08	CL	Stock	34.345	34.8	33.76	34.18	5553400.0
2007-08-08	A	Stock	27.3963	27.6395	27.1316	27.525	4381332.0
2007-08-08	AABA-DELISTED	Stock	23.46	23.83	23.43	23.8	15757797.0
2007-08-08	AACC-DELISTED	Stock	9.28	9.69	9.0	9.43	710063.0
2007-08-08	AAI-DELISTED	Stock	10.01	10.69	9.98	10.68	3715400.0
2007-08-08	AAIC-DELISTED	Stock	97.0	99.6	94.2	97.8	3541593.0
2007-08-08	AAME	Stock	2.96	3.15	2.95	3.14	3400.0
2007-08-08	AAON	Stock	4.5959	4.6117	4.3101	4.5182	1345612.0
2007-08-08	AAP	Stock	33.75	33.96	32.34	32.44	2522600.0
2007-08-08	AATI-DELISTED	Stock	7.75	8.0	7.71	7.82	1154340.0
2007-08-08	AAU-DELISTED	Stock	2.68	2.71	2.63	2.69	49200.0
2007-08-08	AAUAF-DELISTED	Stock	2.68	2.71	2.63	2.69	47100.0
2007-08-08	AAV-DELISTED	Stock	11.9	12.46	11.89	12.13	829700.0
2007-08-08	AAWW-DELISTED	Stock	54.76	54.8	53.43	54.08	483865.0
2007-08-08	AAXN-DELISTED	Stock	14.75	15.75	14.71	15.64	4987267.0
2007-08-08	AB	Stock	85.46	91.18	85.46	89.13	725000.0
2007-08-08	ABAX-DELISTED	Stock	19.67	21.99	19.5	20.88	676769.0
2007-08-08	ABB-DELISTED	Stock	24.0	24.32	23.78	24.11	2984200.0
2007-08-08	ABBC-DELISTED	Stock	8.96	9.33	8.87	9.14	522492.0
2007-08-08	ABBNY-DELISTED	Stock	24.0	24.32	23.78	24.08	3075900.0
2007-08-08	ABC-DELISTED	Stock	23.08	23.08	22.14	22.58	4970200.0
2007-08-08	ABCB	Stock	18.0717	19.3264	18.0717	19.0443	134376.0
2007-08-08	ABCO-DELISTED	Stock	27.87	29.96	27.66	29.48	649267.0
2007-08-08	ABCW-DELISTED	Stock	23.2	24.49	22.97	23.63	348500.0
2007-08-08	ABD-DELISTED	Stock	25.16	26.09	24.44	24.79	1357560.0
2007-08-08	ABE-DELISTED	Stock	20.82	21.6	20.77	20.86	67000.0
2007-08-08	ABEO	Stock	5000.0	5000.0	4887.5	5000.0	11.0
2007-08-08	ABFS-DELISTED	Stock	36.0	37.14	35.0	35.62	835642.0
2007-08-08	ABG	Stock	20.2	20.5	19.17	19.83	1933000.0
2007-08-08	ABK-DELISTED	Stock	68.5	74.78	65.55	72.53	6026000.0
2007-08-08	ABM	Stock	21.53	21.56	19.54	19.63	1144600.0
2007-08-08	ABMD-DELISTED	Stock	11.81	12.83	11.67	12.69	1284056.0
2007-08-08	ABP-DELISTED	Stock	4.05	4.07	3.89	3.93	302800.0
2007-08-08	ABR	Stock	19.25	22.08	18.27	19.86	788700.0
2007-08-08	ABT	Stock	26.8688	27.0127	26.0771	27.0127	21643602.0
2007-08-08	ABTL-DELISTED	Stock	15.64	15.738	13.042	15.15	61679.0
2007-08-08	ABV-DELISTED	Stock	68.32	71.0	66.58	70.48	781700.0
2007-08-08	ABVA-DELISTED	Stock	10.57	10.66	10.06	10.08	14025.0
2007-08-08	ABVT-DELISTED	Stock	82.5	83.0	82.5	83.0	190000.0
2007-08-08	ABX-DELISTED	Stock	33.96	34.59	33.69	34.03	6743500.0
2007-08-08	ACAD	Stock	16.52	17.33	16.24	16.79	1290400.0
2007-08-08	ACAP-DELISTED	Stock	36.59	36.59	33.1	34.36	177035.0
2007-08-08	ACAS-DELISTED	Stock	41.54	43.63	41.49	42.94	3407224.0
2007-08-08	ACAT-DELISTED	Stock	17.7	18.56	17.0	17.78	445428.0
2007-08-08	ACC-DELISTED	Stock	27.08	27.91	26.79	27.69	338500.0

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

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