PREVIEW / stock_daily / 2006-07-10

all stock daily files

  file:    by_date/stock_daily/2006/2006-07-10.parquet
  size:    148 KB
  rows:    4,451
  symbols: 2,811

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-07-10	AAPL	Stock	1.9893	2.0175	1.9464	1.9643	529345600.0
2006-07-10	MSFT	Stock	23.43	23.66	23.38	23.5	50565100.0
2006-07-10	NVDA	Stock	0.3237	0.326	0.306	0.3088	449922000.0
2006-07-10	AMZN	Stock	1.815	1.835	1.77	1.7895	77534000.0
2006-07-10	CL	Stock	30.45	30.88	30.45	30.81	2051400.0
2006-07-10	A	Stock	22.3033	22.4607	21.8383	21.9957	2189967.0
2006-07-10	AABA-DELISTED	Stock	32.9099998474121	33.1399993896484	32.7299995422363	32.8499984741211	15317600.0
2006-07-10	AACC-DELISTED	Stock	18.87	19.7	18.75	19.54	132828.0
2006-07-10	AACQ-DELISTED	Stock	5.31	5.31	5.27	5.3	27000.0
2006-07-10	AACQU-DELISTED	Stock	6.2	6.2	6.2	6.2	3000.0
2006-07-10	AACQW-DELISTED	Stock	0.46	0.48	0.46	0.46	16000.0
2006-07-10	AAI-DELISTED	Stock	14.35	14.6	14.2	14.29	680500.0
2006-07-10	AAIC-DELISTED	Stock	216.6	219.6	212.8	215.2	652400.0
2006-07-10	AAME	Stock	2.98	2.98	2.98	2.98	200.0
2006-07-10	AAON	Stock	3.1737	3.3593	3.1618	3.1855	207309.0
2006-07-10	AAP	Stock	29.8	30.0	29.27	29.53	1069100.0
2006-07-10	AATI-DELISTED	Stock	9.53	9.57	8.99	9.02	136750.0
2006-07-10	AAU-DELISTED	Stock	2.45	2.56	2.36	2.4208	76800.0
2006-07-10	AAUAF-DELISTED	Stock	2.45	2.56	2.36	2.4208	76800.0
2006-07-10	AAV-DELISTED	Stock	16.3	16.34	15.9	16.01	674200.0
2006-07-10	AAWW-DELISTED	Stock	48.0	49.01	46.9	47.54	42885.0
2006-07-10	AAXN-DELISTED	Stock	8.32999992370605	8.32999992370605	8.14000034332275	8.25	373200.0
2006-07-10	AB	Stock	60.95	61.65	60.39	60.9	166100.0
2006-07-10	ABAX-DELISTED	Stock	21.59	22.27	21.28	21.41	227659.0
2006-07-10	ABB-DELISTED	Stock	12.53	12.62	12.43	12.51	1640900.0
2006-07-10	ABBC-DELISTED	Stock	14.26	14.36	14.22	14.25	7623.0
2006-07-10	ABC-DELISTED	Stock	21.12	21.12	20.88	20.94	1145400.0
2006-07-10	ABCB	Stock	21.7483	22.2249	21.7483	21.972	14805.0
2006-07-10	ABCO-DELISTED	Stock	23.46	23.71	23.34	23.49	84480.0
2006-07-10	ABCW-DELISTED	Stock	29.63	30.09	29.55	29.72	46270.0
2006-07-10	ABD-DELISTED	Stock	21.48	21.6	20.61	21.04	330200.0
2006-07-10	ABE-DELISTED	Stock	12.22	12.4	12.22	12.23	7400.0
2006-07-10	ABFS-DELISTED	Stock	48.15	48.82	47.84	48.04	298739.0
2006-07-10	ABG	Stock	20.78	21.37	20.78	21.13	46200.0
2006-07-10	ABK-DELISTED	Stock	82.99	83.33	82.72	82.9	806000.0
2006-07-10	ABM	Stock	16.55	16.8	16.51	16.61	133800.0
2006-07-10	ABMD-DELISTED	Stock	13.57	13.76	13.53	13.62	129203.0
2006-07-10	ABP-DELISTED	Stock	4.65	4.65	4.46	4.47	105900.0
2006-07-10	ABR	Stock	25.05	25.4	25.05	25.14	53100.0
2006-07-10	ABT	Stock	21.1784	21.2216	20.9049	20.9433	7095248.0
2006-07-10	ABTL-DELISTED	Stock	15.75	16.051	15.399	15.7	35781.0
2006-07-10	ABV-DELISTED	Stock	41.8	42.19	40.79	41.0	249800.0
2006-07-10	ABVA-DELISTED	Stock	16.45	16.45	16.45	16.45	100.0
2006-07-10	ABX-DELISTED	Stock	29.8	30.25	29.54	30.08	2573700.0
2006-07-10	ACAD	Stock	8.33	8.56	8.13	8.22	199300.0
2006-07-10	ACAP-DELISTED	Stock	49.92	51.11	49.8	50.54	29098.0
2006-07-10	ACAS-DELISTED	Stock	33.78	33.96	33.7	33.88	500124.0
2006-07-10	ACAT-DELISTED	Stock	18.56	19.03	18.26	18.55	53077.0
2006-07-10	ACC-DELISTED	Stock	24.95	25.36	24.89	25.31	40997.0
2006-07-10	ACCL-DELISTED	Stock	6.97	7.05	6.77	6.82	70588.0

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

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