PREVIEW / stock_daily / 2006-07-25

all stock daily files

  file:    by_date/stock_daily/2006/2006-07-25.parquet
  size:    148 KB
  rows:    4,464
  symbols: 2,815

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-25	AAPL	Stock	2.2064	2.2175	2.1707	2.2118	589069600.0
2006-07-25	MSFT	Stock	24.0	24.29	23.9	24.22	60075800.0
2006-07-25	NVDA	Stock	0.33	0.341	0.3252	0.3375	574104000.0
2006-07-25	AMZN	Stock	1.7	1.708	1.6695	1.6795	344600000.0
2006-07-25	CL	Stock	30.65	30.725	30.005	30.325	7165200.0
2006-07-25	A	Stock	20.7725	21.3305	20.6581	20.8584	3711131.0
2006-07-25	AABA-DELISTED	Stock	26.75	27.1900005340576	26.5699996948242	26.9500007629395	21388800.0
2006-07-25	AACC-DELISTED	Stock	18.52	18.77	18.27	18.58	140596.0
2006-07-25	AACQ-DELISTED	Stock	5.32	5.34	5.32	5.34	4500.0
2006-07-25	AACQW-DELISTED	Stock	0.37	0.37	0.36	0.36	57200.0
2006-07-25	AAI-DELISTED	Stock	12.9	13.09	12.6301	12.83	1318500.0
2006-07-25	AAIC-DELISTED	Stock	199.8	201.0	197.2	198.8	1325100.0
2006-07-25	AAME	Stock	2.83	2.83	2.82	2.82	200.0
2006-07-25	AAON	Stock	3.1289	3.2316	3.0867	3.1829	182250.0
2006-07-25	AAP	Stock	29.82	31.29	29.77	31.28	1558000.0
2006-07-25	AATI-DELISTED	Stock	9.25	9.75	9.2	9.73	61903.0
2006-07-25	AAU-DELISTED	Stock	2.38	2.38	2.3	2.33	20100.0
2006-07-25	AAUAF-DELISTED	Stock	2.38	2.38	2.3	2.33	20100.0
2006-07-25	AAV-DELISTED	Stock	16.02	16.27	16.02	16.25	389900.0
2006-07-25	AAWW-DELISTED	Stock	42.95	43.16	41.16	42.53	68189.0
2006-07-25	AAXN-DELISTED	Stock	8.14999961853027	8.60000038146973	8.07999992370605	8.5	2271900.0
2006-07-25	AB	Stock	61.44	61.81	59.57	59.97	333500.0
2006-07-25	ABAX-DELISTED	Stock	20.64	21.0	20.21	20.72	335564.0
2006-07-25	ABB-DELISTED	Stock	12.05	12.22	12.02	12.17	1467200.0
2006-07-25	ABBC-DELISTED	Stock	14.16	14.5	14.16	14.45	15182.0
2006-07-25	ABC-DELISTED	Stock	21.92	21.98	21.53	21.88	4791200.0
2006-07-25	ABCB	Stock	22.2735	22.5069	22.0304	22.3999	140237.0
2006-07-25	ABCO-DELISTED	Stock	23.79	24.33	23.72	24.23	130568.0
2006-07-25	ABCW-DELISTED	Stock	30.05	30.13	29.46	29.99	21900.0
2006-07-25	ABD-DELISTED	Stock	20.07	20.55	19.57	19.81	217600.0
2006-07-25	ABE-DELISTED	Stock	12.3	12.49	12.26	12.38	12600.0
2006-07-25	ABFS-DELISTED	Stock	48.05	48.07	46.2	47.21	541193.0
2006-07-25	ABG	Stock	20.8	21.29	20.51	20.93	134300.0
2006-07-25	ABK-DELISTED	Stock	83.07	83.92	82.55	83.5	978300.0
2006-07-25	ABM	Stock	16.77	17.12	16.65	16.97	110900.0
2006-07-25	ABMD-DELISTED	Stock	13.45	13.65	13.23	13.64	61844.0
2006-07-25	ABP-DELISTED	Stock	4.15	4.24	4.1	4.13	173700.0
2006-07-25	ABR	Stock	25.58	25.89	25.42	25.73	85600.0
2006-07-25	ABT	Stock	22.8145	23.1216	22.5746	23.0688	20132972.0
2006-07-25	ABTL-DELISTED	Stock	15.952	16.199	15.557	16.1	39774.0
2006-07-25	ABV-DELISTED	Stock	40.63	40.9	39.98	40.69	646900.0
2006-07-25	ABVA-DELISTED	Stock	16.29	16.29	15.84	16.0	6147.0
2006-07-25	ABX-DELISTED	Stock	28.89	29.57	28.63	29.37	3566300.0
2006-07-25	ACAD	Stock	6.84	7.04	6.74	6.77	109400.0
2006-07-25	ACAP-DELISTED	Stock	46.85	46.85	45.22	45.67	86695.0
2006-07-25	ACAS-DELISTED	Stock	34.55	34.83	34.02	34.73	825075.0
2006-07-25	ACAT-DELISTED	Stock	17.2	18.16	16.94	18.01	59108.0
2006-07-25	ACC-DELISTED	Stock	25.4	25.86	25.25	25.39	44200.0
2006-07-25	ACCL-DELISTED	Stock	6.25	6.28	6.09	6.25	21947.0
2006-07-25	ACCO	Stock	20.07	20.55	19.57	19.81	229400.0

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

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