PREVIEW / stock_daily / 2007-07-25

all stock daily files

  file:    by_date/stock_daily/2007/2007-07-25.parquet
  size:    178 KB
  rows:    5,470
  symbols: 3,299

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-25	AAPL	Stock	4.9054	4.9414	4.8214	4.9021	1496182800.0
2007-07-25	MSFT	Stock	30.99	31.3	30.37	30.71	54950100.0
2007-07-25	NVDA	Stock	0.7393	0.7498	0.7187	0.7357	437196000.0
2007-07-25	AMZN	Stock	4.233	4.44	4.1825	4.309	1209048000.0
2007-07-25	TLT	Stock	86.07	86.39	86.0	86.31	881068.0
2007-07-25	CL	Stock	34.855	35.08	34.065	34.83	10763400.0
2007-07-25	A	Stock	28.4692	28.4692	27.7182	28.0043	3018142.0
2007-07-25	AABA-DELISTED	Stock	25.01	25.32	24.59	24.65	21082217.0
2007-07-25	AACC-DELISTED	Stock	14.45	14.56	14.12	14.13	197698.0
2007-07-25	AAI-DELISTED	Stock	10.4	10.43	10.06	10.16	1795891.0
2007-07-25	AAIC-DELISTED	Stock	96.0	98.4	94.2	98.0	2552165.0
2007-07-25	AAON	Stock	4.1903	4.2403	3.9585	4.0678	659137.0
2007-07-25	AAP	Stock	38.6	38.79	37.74	37.95	1593400.0
2007-07-25	AATI-DELISTED	Stock	9.58	9.89	9.49	9.8	362765.0
2007-07-25	AAU-DELISTED	Stock	2.65	2.75	2.64	2.74	107800.0
2007-07-25	AAUAF-DELISTED	Stock	2.65	2.75	2.64	2.74	107800.0
2007-07-25	AAV-DELISTED	Stock	12.74	13.06	12.65	13.0	1127600.0
2007-07-25	AAWW-DELISTED	Stock	57.93	58.04	55.818	57.17	85041.0
2007-07-25	AAXN-DELISTED	Stock	15.44	15.67	14.2	14.76	7173989.0
2007-07-25	AB	Stock	84.3	86.36	82.72	86.04	537700.0
2007-07-25	ABAX-DELISTED	Stock	18.92	19.01	18.41	18.95	272279.0
2007-07-25	ABB-DELISTED	Stock	23.33	23.42	22.6	23.25	5626700.0
2007-07-25	ABBC-DELISTED	Stock	9.443	9.601	9.296	9.36	60308.0
2007-07-25	ABBNY-DELISTED	Stock	23.33	23.42	22.6	23.26	5684000.0
2007-07-25	ABC-DELISTED	Stock	24.6	24.98	24.48	24.85	3187306.0
2007-07-25	ABCB	Stock	18.7331	19.2486	18.2273	18.6844	77418.0
2007-07-25	ABCO-DELISTED	Stock	27.05	27.26	26.65	26.95	140454.0
2007-07-25	ABCW-DELISTED	Stock	22.53	22.91	22.36	22.8	335990.0
2007-07-25	ABD-DELISTED	Stock	21.08	21.39	20.45	20.86	388970.0
2007-07-25	ABE-DELISTED	Stock	23.58	23.58	22.9	22.99	21500.0
2007-07-25	ABEO	Stock	5625.0	5625.0	5600.0	5625.0	4.0
2007-07-25	ABFS-DELISTED	Stock	38.99	39.95	37.07	37.98	1951960.0
2007-07-25	ABG	Stock	23.27	23.55	22.8	23.12	464500.0
2007-07-25	ABK-DELISTED	Stock	74.0	80.65	74.0	79.82	4553900.0
2007-07-25	ABM	Stock	23.78	25.66	23.55	25.18	732900.0
2007-07-25	ABMD-DELISTED	Stock	10.72	10.8	10.5	10.59	421602.0
2007-07-25	ABP-DELISTED	Stock	3.96	4.1	3.9	4.06	186000.0
2007-07-25	ABR	Stock	23.3	23.67	22.38	22.62	781000.0
2007-07-25	ABT	Stock	25.3142	25.3814	24.8009	25.0935	16452272.0
2007-07-25	ABTL-DELISTED	Stock	18.796	18.993	18.303	18.5	28321.0
2007-07-25	ABV-DELISTED	Stock	74.25	75.15	72.85	73.77	860187.0
2007-07-25	ABVA-DELISTED	Stock	12.43	12.84	12.43	12.81	4375.0
2007-07-25	ABX-DELISTED	Stock	33.61	34.06	33.27	33.97	7654112.0
2007-07-25	ACAD	Stock	13.75	13.96	13.6	13.92	370100.0
2007-07-25	ACAP-DELISTED	Stock	38.25	39.98	38.21	39.71	129988.0
2007-07-25	ACAS-DELISTED	Stock	41.16	41.68	39.43	40.78	4765098.0
2007-07-25	ACAT-DELISTED	Stock	19.09	19.81	18.81	19.09	242370.0
2007-07-25	ACC-DELISTED	Stock	27.49	27.5	26.41	26.9	196700.0
2007-07-25	ACCL-DELISTED	Stock	6.82	7.19	6.8	6.98	48249.0
2007-07-25	ACCO	Stock	21.08	21.39	20.45	20.86	425400.0

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

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