PREVIEW / stock_daily / 2006-08-04

all stock daily files

  file:    by_date/stock_daily/2006/2006-08-04.parquet
  size:    147 KB
  rows:    4,433
  symbols: 2,784

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
2006-08-04	AAPL	Stock	2.3946	2.4504	2.32	2.4393	1852866400.0
2006-08-04	MSFT	Stock	24.4	24.49	24.15	24.29	45690400.0
2006-08-04	NVDA	Stock	0.416	0.4167	0.3895	0.3998	818232000.0
2006-08-04	AMZN	Stock	1.347	1.3795	1.34	1.3645	205048000.0
2006-08-04	CL	Stock	29.15	29.3	29.005	29.22	4852000.0
2006-08-04	A	Stock	20.4649	20.7439	19.8498	20.0644	2121325.0
2006-08-04	AABA-DELISTED	Stock	27.2000007629395	27.5799999237061	26.8299999237061	26.9899997711182	11607900.0
2006-08-04	AACC-DELISTED	Stock	19.0	19.16	18.62	18.74	152628.0
2006-08-04	AACQ-DELISTED	Stock	5.37	5.37	5.37	5.37	20000.0
2006-08-04	AAI-DELISTED	Stock	13.39	13.49	12.63	12.8773	1007200.0
2006-08-04	AAIC-DELISTED	Stock	187.0	191.0	183.4	185.4	1217100.0
2006-08-04	AAME	Stock	2.73	2.89	2.73	2.73	1000.0
2006-08-04	AAON	Stock	3.2	3.2645	2.9524	3.1816	381966.0
2006-08-04	AAP	Stock	30.77	31.06	30.05	30.5	885100.0
2006-08-04	AATI-DELISTED	Stock	8.65	8.75	8.31	8.57	104942.0
2006-08-04	AAU-DELISTED	Stock	2.55	2.64	2.49	2.63	32600.0
2006-08-04	AAUAF-DELISTED	Stock	2.55	2.64	2.49	2.63	32600.0
2006-08-04	AAV-DELISTED	Stock	16.55	16.58	16.36	16.45	268400.0
2006-08-04	AAWW-DELISTED	Stock	40.79	41.39	39.2	39.78	110391.0
2006-08-04	AAXN-DELISTED	Stock	7.30000019073486	7.32999992370605	7.05000019073486	7.1399998664856	562600.0
2006-08-04	AB	Stock	66.34	66.89	66.13	66.5	142500.0
2006-08-04	ABAX-DELISTED	Stock	23.72	24.15	22.767	23.21	222355.0
2006-08-04	ABB-DELISTED	Stock	12.81	13.0	12.8	12.88	3205500.0
2006-08-04	ABBC-DELISTED	Stock	15.0	15.2	14.75	14.83	19011.0
2006-08-04	ABC-DELISTED	Stock	21.8	21.87	21.3	21.36	2938600.0
2006-08-04	ABCB	Stock	25.9988	26.3586	25.3957	25.9209	67342.0
2006-08-04	ABCO-DELISTED	Stock	26.0	26.17	25.06	25.27	107925.0
2006-08-04	ABCW-DELISTED	Stock	30.77	31.03	29.98	30.39	33850.0
2006-08-04	ABD-DELISTED	Stock	19.64	19.99	19.19	19.32	176700.0
2006-08-04	ABE-DELISTED	Stock	12.94	12.95	12.76	12.89	4700.0
2006-08-04	ABFS-DELISTED	Stock	46.91	48.26	44.57	44.96	501267.0
2006-08-04	ABG	Stock	20.95	21.2	20.33	20.67	115500.0
2006-08-04	ABK-DELISTED	Stock	82.65	83.32	82.23	82.38	590800.0
2006-08-04	ABM	Stock	16.87	17.0	16.4	16.65	133300.0
2006-08-04	ABMD-DELISTED	Stock	13.73	13.73	13.17	13.39	96851.0
2006-08-04	ABP-DELISTED	Stock	4.3	4.38	4.22	4.33	119100.0
2006-08-04	ABR	Stock	25.45	25.7	25.2	25.6	127900.0
2006-08-04	ABT	Stock	22.8385	22.8385	22.5314	22.6658	9422885.0
2006-08-04	ABTL-DELISTED	Stock	16.4	17.052	16.049	16.15	10099.0
2006-08-04	ABV-DELISTED	Stock	41.75	41.94	41.1	41.28	300600.0
2006-08-04	ABVA-DELISTED	Stock	16.5	16.5	16.5	16.5	1980.0
2006-08-04	ABX-DELISTED	Stock	32.31	32.54	31.76	31.88	3681672.0
2006-08-04	ACAD	Stock	6.31	6.31	5.76	5.8	331300.0
2006-08-04	ACAP-DELISTED	Stock	45.44	45.66	44.99	45.33	35715.0
2006-08-04	ACAS-DELISTED	Stock	36.0	36.3	35.96	36.2	1113081.0
2006-08-04	ACAT-DELISTED	Stock	17.82	18.26	17.4	17.57	127515.0
2006-08-04	ACC-DELISTED	Stock	25.65	25.82	25.26	25.69	63987.0
2006-08-04	ACCL-DELISTED	Stock	6.33	6.45	6.3	6.38	39403.0
2006-08-04	ACCO	Stock	19.64	19.99	19.19	19.32	202000.0
2006-08-04	ACCP-DELISTED	Stock	0.86	0.99	0.86	0.99	707.0

> showing 50 of 4,433 rows — these rows as CSV

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