PREVIEW / stock_daily / 2007-09-21

all stock daily files

  file:    by_date/stock_daily/2007/2007-09-21.parquet
  size:    179 KB
  rows:    5,506
  symbols: 3,317

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-09-21	AAPL	Stock	5.0407	5.1661	5.0111	5.1482	1138880400.0
2007-09-21	MSFT	Stock	28.69	28.81	28.44	28.65	135636100.0
2007-09-21	NVDA	Stock	0.8625	0.875	0.854	0.8622	457532000.0
2007-09-21	AMZN	Stock	4.5145	4.595	4.4825	4.565	130490000.0
2007-09-21	TLT	Stock	87.58	88.131	87.58	87.98	2217600.0
2007-09-21	CL	Stock	35.24	35.24	34.85	34.925	5123800.0
2007-09-21	A	Stock	26.5522	26.7525	26.1874	26.402	4433338.0
2007-09-21	AABA-DELISTED	Stock	25.54	26.21	25.31	26.04	41227947.0
2007-09-21	AACC-DELISTED	Stock	10.95	11.2	10.91	10.98	422993.0
2007-09-21	AAI-DELISTED	Stock	10.52	10.52	10.32	10.37	1211400.0
2007-09-21	AAIC-DELISTED	Stock	101.2	101.6	98.4	100.0	1537200.0
2007-09-21	AAME	Stock	2.8	2.81	2.52	2.61	14900.0
2007-09-21	AAON	Stock	4.1284	4.1995	4.1027	4.1323	524475.0
2007-09-21	AAP	Stock	34.6	34.6	33.55	33.58	883000.0
2007-09-21	AATI-DELISTED	Stock	11.15	11.19	10.64	10.68	738795.0
2007-09-21	AAU-DELISTED	Stock	2.44	2.44	2.32	2.35	46100.0
2007-09-21	AAUAF-DELISTED	Stock	2.44	2.44	2.32	2.35	46100.0
2007-09-21	AAV-DELISTED	Stock	11.33	11.57	11.33	11.55	458100.0
2007-09-21	AAWW-DELISTED	Stock	54.1	54.42	53.77	53.8	119967.0
2007-09-21	AAXN-DELISTED	Stock	15.93	15.97	15.25	15.31	1966848.0
2007-09-21	AB	Stock	85.72	86.21	84.46	84.98	301000.0
2007-09-21	ABAX-DELISTED	Stock	21.4	21.58	20.77	20.79	326002.0
2007-09-21	ABB-DELISTED	Stock	25.36	25.65	25.3	25.54	1788900.0
2007-09-21	ABBC-DELISTED	Stock	9.85	9.85	9.73	9.75	71102.0
2007-09-21	ABBNY-DELISTED	Stock	25.36	25.65	25.3	25.58	1868100.0
2007-09-21	ABC-DELISTED	Stock	23.06	23.1	22.52	22.62	2891000.0
2007-09-21	ABCB	Stock	19.2	19.268	18.5775	18.7233	74848.0
2007-09-21	ABCO-DELISTED	Stock	29.55	29.89	29.11	29.36	328829.0
2007-09-21	ABCW-DELISTED	Stock	28.12	28.84	28.12	28.46	122210.0
2007-09-21	ABD-DELISTED	Stock	22.73	22.97	22.55	22.75	531570.0
2007-09-21	ABE-DELISTED	Stock	22.41	22.84	22.41	22.53	22400.0
2007-09-21	ABEO	Stock	5850.0	5937.5	5687.5	5687.5	5.0
2007-09-21	ABFS-DELISTED	Stock	34.0	34.0	33.46	33.47	560097.0
2007-09-21	ABG	Stock	21.78	21.82	20.78	20.96	781900.0
2007-09-21	ABK-DELISTED	Stock	66.4	66.51	64.57	65.15	1888300.0
2007-09-21	ABM	Stock	20.74	20.91	20.33	20.56	352300.0
2007-09-21	ABMD-DELISTED	Stock	11.95	12.07	11.57	11.9	192189.0
2007-09-21	ABP-DELISTED	Stock	3.63	3.73	3.55	3.65	146800.0
2007-09-21	ABR	Stock	20.54	20.65	19.95	20.0	234400.0
2007-09-21	ABT	Stock	26.0435	26.2547	25.7605	26.1203	15136098.0
2007-09-21	ABTL-DELISTED	Stock	16.15	16.25	15.6	16.25	6345.0
2007-09-21	ABV-DELISTED	Stock	72.1	72.99	71.8	72.5	499300.0
2007-09-21	ABVA-DELISTED	Stock	9.81	10.05	9.73	9.95	64560.0
2007-09-21	ABVT-DELISTED	Stock	75.0	77.0	75.0	77.0	69863.0
2007-09-21	ABX-DELISTED	Stock	40.79	40.94	39.81	39.94	9976150.0
2007-09-21	ACAD	Stock	15.96	15.99	15.62	15.73	266500.0
2007-09-21	ACAP-DELISTED	Stock	40.13	40.89	39.78	40.49	114405.0
2007-09-21	ACAS-DELISTED	Stock	41.3	41.5	40.92	41.1	2949168.0
2007-09-21	ACAT-DELISTED	Stock	16.55	16.655	16.28	16.46	126286.0
2007-09-21	ACC-DELISTED	Stock	28.79	29.14	28.6	28.97	203833.0

> showing 50 of 5,506 rows — these rows as CSV

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