PREVIEW / stock_daily / 2007-04-10

all stock daily files

  file:    by_date/stock_daily/2007/2007-04-10.parquet
  size:    162 KB
  rows:    4,896
  symbols: 3,079

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
2007-04-10	AAPL	Stock	3.3454	3.3664	3.3361	3.3661	352466800.0
2007-04-10	MSFT	Stock	28.5	28.64	28.22	28.4	38643100.0
2007-04-10	NVDA	Stock	0.505	0.5108	0.4995	0.5005	794220000.0
2007-04-10	AMZN	Stock	2.0785	2.098	2.073	2.093	68436000.0
2007-04-10	TLT	Stock	87.39	87.55	87.31	87.43	674400.0
2007-04-10	CL	Stock	33.325	33.455	32.88	32.985	4631200.0
2007-04-10	A	Stock	24.907	25.0358	24.8641	24.9714	2723863.0
2007-04-10	AABA-DELISTED	Stock	31.6399993896484	32.0200004577637	31.6000003814697	31.6900005340576	12797600.0
2007-04-10	AACC-DELISTED	Stock	15.61	15.65	15.55	15.57	108669.0
2007-04-10	AACQ-DELISTED	Stock	4.38	4.42	4.36	4.42	2325.0
2007-04-10	AACQU-DELISTED	Stock	5.45	5.45	5.45	5.45	200.0
2007-04-10	AACQW-DELISTED	Stock	0.59	0.6	0.57	0.6	72800.0
2007-04-10	AAI-DELISTED	Stock	10.98	11.24	10.78	11.1	3007827.0
2007-04-10	AAIC-DELISTED	Stock	112.0	116.8	110.8	111.4	3896842.0
2007-04-10	AAME	Stock	4.25	4.25	4.08	4.08	15900.0
2007-04-10	AAON	Stock	3.4291	3.4476	3.4107	3.4107	450309.0
2007-04-10	AAP	Stock	39.51	39.88	39.5	39.79	685200.0
2007-04-10	AATI-DELISTED	Stock	6.82	6.88	6.75	6.83	279345.0
2007-04-10	AAU-DELISTED	Stock	2.54	2.55	2.45	2.49	107000.0
2007-04-10	AAUAF-DELISTED	Stock	2.54	2.55	2.45	2.49	107000.0
2007-04-10	AAV-DELISTED	Stock	10.37	10.42	10.26	10.33	355600.0
2007-04-10	AAWW-DELISTED	Stock	56.23	56.4	55.81	56.1	214302.0
2007-04-10	AAXN-DELISTED	Stock	7.82000017166138	7.92000007629395	7.76000022888184	7.90999984741211	491200.0
2007-04-10	AB	Stock	91.04	91.76	90.86	91.21	163900.0
2007-04-10	ABAX-DELISTED	Stock	24.97	25.94	24.91	25.58	279979.0
2007-04-10	ABB-DELISTED	Stock	17.92	18.04	17.91	18.02	1551900.0
2007-04-10	ABBC-DELISTED	Stock	20.25	20.28	20.15	20.21	28828.0
2007-04-10	ABC-DELISTED	Stock	26.81	27.0	26.7	26.96	1708000.0
2007-04-10	ABCB	Stock	23.8881	24.5981	23.8881	24.5009	19946.0
2007-04-10	ABCO-DELISTED	Stock	25.31	25.5	25.25	25.34	85288.0
2007-04-10	ABCW-DELISTED	Stock	27.76	27.94	27.67	27.77	39100.0
2007-04-10	ABD-DELISTED	Stock	25.15	25.3	25.05	25.2	456400.0
2007-04-10	ABE-DELISTED	Stock	19.46	19.89	19.46	19.79	15300.0
2007-04-10	ABFS-DELISTED	Stock	36.42	36.88	36.33	36.72	320735.0
2007-04-10	ABG	Stock	27.05	27.05	26.72	26.9	396200.0
2007-04-10	ABK-DELISTED	Stock	86.05	86.42	85.7	85.75	551600.0
2007-04-10	ABM	Stock	26.42	26.81	26.25	26.76	573300.0
2007-04-10	ABMD-DELISTED	Stock	13.61	13.61	13.33	13.43	141513.0
2007-04-10	ABP-DELISTED	Stock	2.95	3.09	2.95	3.07	223200.0
2007-04-10	ABR	Stock	30.26	30.75	30.2	30.69	174000.0
2007-04-10	ABT	Stock	27.4494	27.5069	27.3006	27.3774	11568570.0
2007-04-10	ABTL-DELISTED	Stock	16.975	17.274	15.976	16.775	23467.0
2007-04-10	ABV-DELISTED	Stock	57.1	57.26	56.78	57.1	174600.0
2007-04-10	ABVA-DELISTED	Stock	14.74	14.74	14.65	14.65	1064.0
2007-04-10	ABX-DELISTED	Stock	29.51	29.64	29.18	29.26	3314958.0
2007-04-10	ACAD	Stock	16.04	16.21	15.5	15.59	718300.0
2007-04-10	ACAP-DELISTED	Stock	38.88	39.87	38.37	39.0	58514.0
2007-04-10	ACAS-DELISTED	Stock	45.63	45.99	45.57	45.93	1372382.0
2007-04-10	ACAT-DELISTED	Stock	19.21	19.29	18.91	19.29	30243.0
2007-04-10	ACC-DELISTED	Stock	29.76	30.02	29.73	29.92	221100.0

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

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