PREVIEW / stock_daily / 2007-08-21

all stock daily files

  file:    by_date/stock_daily/2007/2007-08-21.parquet
  size:    177 KB
  rows:    5,500
  symbols: 3,314

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-21	AAPL	Stock	4.3646	4.6057	4.3214	4.5561	1303047200.0
2007-08-21	MSFT	Stock	28.1	28.32	27.87	28.07	50786200.0
2007-08-21	NVDA	Stock	0.7528	0.7948	0.7417	0.7888	715338000.0
2007-08-21	AMZN	Stock	3.7105	3.8915	3.7045	3.8745	168582000.0
2007-08-21	TLT	Stock	87.1	87.4101	87.05	87.26	1517200.0
2007-08-21	CL	Stock	33.04	33.3	32.765	33.19	3431200.0
2007-08-21	A	Stock	23.9628	24.3491	23.8555	24.2775	3034639.0
2007-08-21	AABA-DELISTED	Stock	23.25	23.48	22.91	23.04	23584611.0
2007-08-21	AACC-DELISTED	Stock	9.95	10.0	9.76	9.94	253737.0
2007-08-21	AAI-DELISTED	Stock	9.95	10.27	9.74	10.25	2887000.0
2007-08-21	AAIC-DELISTED	Stock	89.4	91.4	87.4	88.0	2384224.0
2007-08-21	AAME	Stock	3.3	3.41	2.7	2.94	16500.0
2007-08-21	AAON	Stock	4.052	4.1916	4.0283	4.131	168581.0
2007-08-21	AAP	Stock	33.02	33.57	33.0	33.3	1486800.0
2007-08-21	AATI-DELISTED	Stock	8.37	8.8	8.37	8.58	289848.0
2007-08-21	AAU-DELISTED	Stock	2.33	2.33	2.25	2.26	45600.0
2007-08-21	AAUAF-DELISTED	Stock	2.33	2.33	2.25	2.26	45600.0
2007-08-21	AAV-DELISTED	Stock	11.61	11.65	11.42	11.57	502000.0
2007-08-21	AAWW-DELISTED	Stock	50.11	51.02	49.95	50.86	99993.0
2007-08-21	AAXN-DELISTED	Stock	13.5	13.77	13.1	13.44	2434006.0
2007-08-21	AB	Stock	80.9	82.59	80.25	82.37	239500.0
2007-08-21	ABAX-DELISTED	Stock	20.55	21.07	20.55	20.86	92318.0
2007-08-21	ABB-DELISTED	Stock	22.22	22.64	22.16	22.28	2093400.0
2007-08-21	ABBC-DELISTED	Stock	9.22	9.57	9.2	9.52	374761.0
2007-08-21	ABBNY-DELISTED	Stock	22.22	22.6399	22.16	22.28	2094700.0
2007-08-21	ABC-DELISTED	Stock	22.96	23.18	22.73	23.02	3074400.0
2007-08-21	ABCB	Stock	21.7094	21.865	21.3301	21.5926	26526.0
2007-08-21	ABCO-DELISTED	Stock	29.32	29.73	28.83	28.95	178016.0
2007-08-21	ABCW-DELISTED	Stock	26.92	28.09	26.77	27.82	182080.0
2007-08-21	ABD-DELISTED	Stock	24.02	24.74	23.69	23.71	302200.0
2007-08-21	ABE-DELISTED	Stock	19.74	19.89	19.1	19.64	20900.0
2007-08-21	ABEO	Stock	3437.5	4250.0	3437.5	3875.0	10.0
2007-08-21	ABFS-DELISTED	Stock	36.15	36.49	35.44	36.26	323775.0
2007-08-21	ABG	Stock	22.68	23.52	22.48	22.64	1577200.0
2007-08-21	ABK-DELISTED	Stock	64.25	65.5	62.54	62.93	2765200.0
2007-08-21	ABM	Stock	22.8	23.59	22.37	22.49	194300.0
2007-08-21	ABMD-DELISTED	Stock	12.25	12.5	11.73	11.79	126904.0
2007-08-21	ABP-DELISTED	Stock	3.83	3.83	3.65	3.73	71200.0
2007-08-21	ABR	Stock	19.25	19.25	18.63	18.75	308700.0
2007-08-21	ABT	Stock	24.9016	25.2711	24.7769	25.1223	7819925.0
2007-08-21	ABTL-DELISTED	Stock	15.6	15.752	15.296	15.6	11844.0
2007-08-21	ABV-DELISTED	Stock	61.36	63.11	60.27	62.2	784100.0
2007-08-21	ABVA-DELISTED	Stock	9.787	9.89	9.5	9.8	26788.0
2007-08-21	ABVT-DELISTED	Stock	84.0	84.0	75.0	75.0	5700.0
2007-08-21	ABX-DELISTED	Stock	31.72	32.42	31.5	32.06	3904000.0
2007-08-21	ACAD	Stock	15.0	15.2	14.87	15.08	362900.0
2007-08-21	ACAP-DELISTED	Stock	40.12	40.12	39.0	39.49	36730.0
2007-08-21	ACAS-DELISTED	Stock	39.5	40.99	39.2	40.69	1663898.0
2007-08-21	ACAT-DELISTED	Stock	17.41	18.12	16.92	17.87	183615.0
2007-08-21	ACC-DELISTED	Stock	27.66	28.0	27.3	27.92	393200.0

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

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