PREVIEW / stock_daily / 2006-07-06

all stock daily files

  file:    by_date/stock_daily/2006/2006-07-06.parquet
  size:    148 KB
  rows:    4,438
  symbols: 2,793

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-06	AAPL	Stock	2.0389	2.05	1.9861	1.9918	633208800.0
2006-07-06	MSFT	Stock	23.45	23.61	23.42	23.48	44775200.0
2006-07-06	NVDA	Stock	0.3438	0.3472	0.3297	0.3332	470634000.0
2006-07-06	AMZN	Stock	1.8535	1.887	1.826	1.84	87454000.0
2006-07-06	CL	Stock	29.95	30.53	29.93	30.515	4462200.0
2006-07-06	A	Stock	22.4034	22.7969	22.3963	22.6323	2054221.0
2006-07-06	AABA-DELISTED	Stock	32.7700004577637	33.2200012207031	32.7000007629395	33.1100006103516	13801500.0
2006-07-06	AACC-DELISTED	Stock	18.94	19.44	18.93	19.31	143582.0
2006-07-06	AACQW-DELISTED	Stock	0.46	0.46	0.46	0.46	3300.0
2006-07-06	AAI-DELISTED	Stock	14.83	14.96	14.57	14.66	746000.0
2006-07-06	AAIC-DELISTED	Stock	221.6	223.8	216.2	219.0	1306000.0
2006-07-06	AAME	Stock	3.05	3.15	2.98	2.98	3100.0
2006-07-06	AAON	Stock	3.5147	3.5569	3.2764	3.3396	530044.0
2006-07-06	AAP	Stock	29.5	30.01	29.45	29.96	2461300.0
2006-07-06	AATI-DELISTED	Stock	9.87	9.92	9.55	9.85	224258.0
2006-07-06	AAU-DELISTED	Stock	2.26	2.45	2.26	2.4	85100.0
2006-07-06	AAUAF-DELISTED	Stock	2.26	2.45	2.26	2.4	85100.0
2006-07-06	AAV-DELISTED	Stock	16.64	16.8	16.3	16.42	1127400.0
2006-07-06	AAWW-DELISTED	Stock	49.61	50.0	48.59	49.01	73608.0
2006-07-06	AAXN-DELISTED	Stock	8.27999973297119	8.47999954223633	8.22999954223633	8.27999973297119	757000.0
2006-07-06	AB	Stock	60.99	61.4	60.66	60.99	111500.0
2006-07-06	ABAX-DELISTED	Stock	21.51	21.99	21.47	21.65	298656.0
2006-07-06	ABB-DELISTED	Stock	12.64	12.78	12.6	12.7	1023000.0
2006-07-06	ABBC-DELISTED	Stock	14.47	14.74	14.15	14.41	18940.0
2006-07-06	ABC-DELISTED	Stock	21.0	21.0	20.8	20.98	2794400.0
2006-07-06	ABCB	Stock	21.9915	22.3027	21.7483	22.2444	33311.0
2006-07-06	ABCO-DELISTED	Stock	23.69	23.91	23.58	23.72	94975.0
2006-07-06	ABCW-DELISTED	Stock	30.0	30.47	29.94	30.14	56290.0
2006-07-06	ABD-DELISTED	Stock	22.22	22.31	21.71	21.75	389300.0
2006-07-06	ABE-DELISTED	Stock	12.35	12.48	12.2	12.35	13900.0
2006-07-06	ABFS-DELISTED	Stock	50.12	50.54	49.22	49.76	283659.0
2006-07-06	ABG	Stock	20.67	21.24	20.64	20.89	100600.0
2006-07-06	ABK-DELISTED	Stock	81.27	82.24	81.22	82.21	687400.0
2006-07-06	ABM	Stock	16.95	17.02	16.69	16.82	173100.0
2006-07-06	ABMD-DELISTED	Stock	13.04	13.49	12.94	13.47	70393.0
2006-07-06	ABP-DELISTED	Stock	4.82	4.82	4.65	4.7	195200.0
2006-07-06	ABR	Stock	25.24	25.49	25.15	25.37	77400.0
2006-07-06	ABT	Stock	20.9673	21.1592	20.9193	21.0056	6654231.0
2006-07-06	ABTL-DELISTED	Stock	16.075	16.075	15.524	15.675	111815.0
2006-07-06	ABV-DELISTED	Stock	41.78	42.2	41.29	41.7	623400.0
2006-07-06	ABVT-DELISTED	Stock	48.0	48.0	45.5	45.5	40300.0
2006-07-06	ABX-DELISTED	Stock	30.02	30.49	29.82	30.18	2461600.0
2006-07-06	ACAD	Stock	8.35	8.48	8.35	8.42	76900.0
2006-07-06	ACAP-DELISTED	Stock	50.5	51.22	50.4	50.72	41651.0
2006-07-06	ACAS-DELISTED	Stock	33.6	33.9	33.6	33.78	766960.0
2006-07-06	ACAT-DELISTED	Stock	18.06	18.59	17.74	17.97	75760.0
2006-07-06	ACC-DELISTED	Stock	24.82	25.34	24.78	25.21	78300.0
2006-07-06	ACCL-DELISTED	Stock	7.09	7.09	7.01	7.01	28128.0
2006-07-06	ACCO	Stock	22.22	22.31	21.71	21.75	397800.0
2006-07-06	ACCP-DELISTED	Stock	1.2	1.2	1.15	1.19	22500.0

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

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