PREVIEW / stock_daily / 2006-04-05

all stock daily files

  file:    by_date/stock_daily/2006/2006-04-05.parquet
  size:    147 KB
  rows:    4,393
  symbols: 2,779

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-05	AAPL	Stock	2.3111	2.4004	2.2911	2.4004	2233408800.0
2006-04-05	MSFT	Stock	27.88	27.94	27.64	27.74	41539300.0
2006-04-05	NVDA	Stock	0.5042	0.5117	0.4934	0.5092	1112976000.0
2006-04-05	AMZN	Stock	1.833	1.867	1.8135	1.867	111190000.0
2006-04-05	CL	Stock	29.0	29.08	28.86	28.99	3392200.0
2006-04-05	A	Stock	27.2031	27.3963	27.1388	27.3391	2414206.0
2006-04-05	AABA-DELISTED	Stock	32.2999992370605	32.5	31.9599990844727	32.1100006103516	11982500.0
2006-04-05	AACC-DELISTED	Stock	19.47	19.94	19.45	19.83	158473.0
2006-04-05	AACQ-DELISTED	Stock	5.45	5.45	5.45	5.45	1000.0
2006-04-05	AACQU-DELISTED	Stock	6.83	6.83	6.83	6.83	500.0
2006-04-05	AAI-DELISTED	Stock	18.02	18.08	17.78	17.91	854400.0
2006-04-05	AAIC-DELISTED	Stock	184.0	186.4	182.4	183.0	622100.0
2006-04-05	AAME	Stock	2.86	3.18	2.86	3.08	31500.0
2006-04-05	AAON	Stock	3.1605	3.1723	3.117	3.1658	104034.0
2006-04-05	AAP	Stock	40.96	41.48	40.88	41.24	1392500.0
2006-04-05	AATI-DELISTED	Stock	11.04	11.24	11.0	11.14	506192.0
2006-04-05	AAU-DELISTED	Stock	2.93	2.95	2.83	2.91	165100.0
2006-04-05	AAUAF-DELISTED	Stock	2.93	2.95	2.83	2.91	165100.0
2006-04-05	AAV-DELISTED	Stock	19.15	19.21	19.01	19.09	178900.0
2006-04-05	AAWW-DELISTED	Stock	46.0	46.0	44.75	46.0	15300.0
2006-04-05	AAXN-DELISTED	Stock	10.6999998092651	11.0900001525879	10.6999998092651	11.039999961853	1795600.0
2006-04-05	AB	Stock	67.81	68.74	67.03	68.74	436500.0
2006-04-05	ABAX-DELISTED	Stock	22.29	23.85	22.25	23.72	434577.0
2006-04-05	ABB-DELISTED	Stock	12.94	13.05	12.86	13.02	850300.0
2006-04-05	ABBC-DELISTED	Stock	13.52	13.52	13.5	13.51	18364.0
2006-04-05	ABC-DELISTED	Stock	24.07	24.24	24.0	24.194	2937400.0
2006-04-05	ABCB	Stock	22.2346	22.3805	21.7191	22.2638	10178.0
2006-04-05	ABCO-DELISTED	Stock	27.68	27.99	27.28	27.83	130594.0
2006-04-05	ABCW-DELISTED	Stock	29.94	29.99	29.38	29.87	18780.0
2006-04-05	ABD-DELISTED	Stock	21.95	22.55	21.95	22.5	307200.0
2006-04-05	ABE-DELISTED	Stock	13.17	13.19	13.07	13.13	27000.0
2006-04-05	ABFS-DELISTED	Stock	40.4	40.6	40.141	40.42	226284.0
2006-04-05	ABG	Stock	19.12	19.6	19.07	19.5	101700.0
2006-04-05	ABK-DELISTED	Stock	78.4	79.01	78.32	78.78	737400.0
2006-04-05	ABM	Stock	18.44	18.73	18.21	18.47	218800.0
2006-04-05	ABMD-DELISTED	Stock	13.25	13.31	13.0	13.28	81185.0
2006-04-05	ABP-DELISTED	Stock	5.3	5.43	5.27	5.37	482800.0
2006-04-05	ABR	Stock	26.98	27.08	26.61	26.62	96700.0
2006-04-05	ABT	Stock	20.3867	20.5594	20.2092	20.4683	12852647.0
2006-04-05	ABTL-DELISTED	Stock	23.25	23.7	23.25	23.45	22603.0
2006-04-05	ABV-DELISTED	Stock	46.08	46.12	44.77	45.66	463500.0
2006-04-05	ABVT-DELISTED	Stock	36.0	37.0	36.0	36.0	4300.0
2006-04-05	ABX-DELISTED	Stock	28.2	28.87	28.02	28.84	4442319.0
2006-04-05	ACAD	Stock	15.85	16.2	15.85	16.13	317100.0
2006-04-05	ACAP-DELISTED	Stock	47.59	47.87	46.8	46.81	36939.0
2006-04-05	ACAS-DELISTED	Stock	35.27	35.46	35.21	35.45	1309602.0
2006-04-05	ACAT-DELISTED	Stock	24.0	24.04	23.02	23.19	60368.0
2006-04-05	ACC-DELISTED	Stock	25.3	25.36	24.87	25.12	52400.0
2006-04-05	ACCL-DELISTED	Stock	7.26	7.49	7.2	7.26	56888.0
2006-04-05	ACCO	Stock	21.95	22.54	21.95	22.5	307300.0

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

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