PREVIEW / stock_daily / 2006-04-18

all stock daily files

  file:    by_date/stock_daily/2006/2006-04-18.parquet
  size:    148 KB
  rows:    4,412
  symbols: 2,790

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-04-18	AAPL	Stock	2.3229	2.3739	2.3139	2.365	794844400.0
2006-04-18	MSFT	Stock	26.94	27.5	26.82	27.22	56272700.0
2006-04-18	NVDA	Stock	0.4858	0.486	0.4698	0.483	1165488000.0
2006-04-18	AMZN	Stock	1.7695	1.8225	1.76	1.814	91914000.0
2006-04-18	CL	Stock	28.14	28.41	28.1	28.37	3049200.0
2006-04-18	A	Stock	26.5236	27.3319	26.4306	27.1745	5097248.0
2006-04-18	AABA-DELISTED	Stock	31.1700000762939	31.3799991607666	30.5300006866455	31.2999992370605	38604500.0
2006-04-18	AACC-DELISTED	Stock	20.43	21.11	20.43	21.08	176464.0
2006-04-18	AACQU-DELISTED	Stock	6.8	6.8	6.8	6.8	1000.0
2006-04-18	AACQW-DELISTED	Stock	0.73	0.75	0.725	0.75	67900.0
2006-04-18	AAI-DELISTED	Stock	15.49	15.76	15.4	15.5	1854200.0
2006-04-18	AAIC-DELISTED	Stock	179.2	188.4	178.6	186.8	2473700.0
2006-04-18	AAME	Stock	2.78	2.9	2.78	2.87	20900.0
2006-04-18	AAON	Stock	3.2658	3.2658	3.2	3.2579	302991.0
2006-04-18	AAP	Stock	39.33	39.43	38.35	38.93	1993200.0
2006-04-18	AATI-DELISTED	Stock	10.75	11.07	10.5057	11.06	161313.0
2006-04-18	AAU-DELISTED	Stock	3.0	3.1	2.97	2.97	102200.0
2006-04-18	AAUAF-DELISTED	Stock	3.0	3.1	2.97	2.97	102200.0
2006-04-18	AAV-DELISTED	Stock	20.1	20.34	20.04	20.18	401100.0
2006-04-18	AAWW-DELISTED	Stock	44.5	46.0	44.5	46.0	2700.0
2006-04-18	AAXN-DELISTED	Stock	10.1099996566772	10.3800001144409	9.98999977111816	10.289999961853	982300.0
2006-04-18	AB	Stock	69.9	70.5	69.5	70.0	162300.0
2006-04-18	ABAX-DELISTED	Stock	24.86	25.4	24.42	25.36	294626.0
2006-04-18	ABB-DELISTED	Stock	13.01	13.11	12.94	13.11	1263400.0
2006-04-18	ABBC-DELISTED	Stock	13.27	13.48	13.27	13.47	4174.0
2006-04-18	ABC-DELISTED	Stock	23.46	23.86	23.4	23.74	2916400.0
2006-04-18	ABCB	Stock	20.9409	22.1762	20.9409	22.1762	27143.0
2006-04-18	ABCO-DELISTED	Stock	27.22	27.9	27.0	27.85	239100.0
2006-04-18	ABCW-DELISTED	Stock	28.72	29.06	28.52	29.06	74920.0
2006-04-18	ABD-DELISTED	Stock	22.14	22.23	21.86	21.89	298600.0
2006-04-18	ABE-DELISTED	Stock	13.02	13.1899	13.0	13.13	31000.0
2006-04-18	ABFS-DELISTED	Stock	39.42	40.58	39.42	40.49	329845.0
2006-04-18	ABG	Stock	18.52	18.7	18.35	18.61	53800.0
2006-04-18	ABK-DELISTED	Stock	78.4	78.68	77.77	78.26	1019200.0
2006-04-18	ABM	Stock	17.27	17.44	17.24	17.25	337600.0
2006-04-18	ABMD-DELISTED	Stock	13.2	13.98	13.2	13.89	164009.0
2006-04-18	ABP-DELISTED	Stock	5.3	5.73	5.22	5.73	851900.0
2006-04-18	ABR	Stock	25.24	25.75	25.23	25.55	161300.0
2006-04-18	ABT	Stock	19.7054	20.0316	19.7054	19.9981	9045019.0
2006-04-18	ABTL-DELISTED	Stock	21.8	22.3	21.65	22.3	30622.0
2006-04-18	ABV-DELISTED	Stock	45.25	46.55	45.25	46.44	407800.0
2006-04-18	ABX-DELISTED	Stock	30.33	30.65	30.1	30.42	5241900.0
2006-04-18	ACAD	Stock	14.84	15.16	14.71	15.15	156000.0
2006-04-18	ACAP-DELISTED	Stock	46.36	48.35	46.36	48.33	26610.0
2006-04-18	ACAS-DELISTED	Stock	34.14	34.72	34.06	34.66	940427.0
2006-04-18	ACAT-DELISTED	Stock	20.79	20.98	20.59	20.89	84699.0
2006-04-18	ACC-DELISTED	Stock	25.33	25.89	25.2	25.69	106700.0
2006-04-18	ACCL-DELISTED	Stock	7.37	7.4	7.145	7.4	81581.0
2006-04-18	ACCO	Stock	22.14	22.23	21.86	21.89	298900.0
2006-04-18	ACCP-DELISTED	Stock	1.1	1.15	1.1	1.1	2800.0

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

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