PREVIEW / stock_daily / 2007-09-12

all stock daily files

  file:    by_date/stock_daily/2007/2007-09-12.parquet
  size:    176 KB
  rows:    5,477
  symbols: 3,305

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-12	AAPL	Stock	4.8568	4.9786	4.8482	4.8875	1022770000.0
2007-09-12	MSFT	Stock	28.81	29.17	28.8	28.93	42364700.0
2007-09-12	NVDA	Stock	0.8738	0.878	0.822	0.8305	554452000.0
2007-09-12	AMZN	Stock	4.3035	4.4445	4.2985	4.365	180606000.0
2007-09-12	TLT	Stock	90.9	90.94	90.42	90.59	4458250.0
2007-09-12	CL	Stock	33.61	34.195	33.395	34.075	4619600.0
2007-09-12	A	Stock	25.8441	26.1087	25.7439	25.9585	2526046.0
2007-09-12	AABA-DELISTED	Stock	23.64	23.94	23.53	23.54	15142747.0
2007-09-12	AACC-DELISTED	Stock	10.06	10.1	9.57	9.83	121132.0
2007-09-12	AAI-DELISTED	Stock	10.39	10.53	10.25	10.27	849600.0
2007-09-12	AAIC-DELISTED	Stock	93.6	97.8	91.8	96.8	2184700.0
2007-09-12	AAME	Stock	2.92	3.13	2.9	3.0	2800.0
2007-09-12	AAON	Stock	3.8578	3.923	3.8321	3.84	237431.0
2007-09-12	AAP	Stock	33.62	33.92	32.93	33.01	947200.0
2007-09-12	AATI-DELISTED	Stock	9.63	9.83	9.6	9.79	476757.0
2007-09-12	AAU-DELISTED	Stock	2.29	2.36	2.25	2.25	49900.0
2007-09-12	AAUAF-DELISTED	Stock	2.29	2.36	2.25	2.25	49900.0
2007-09-12	AAV-DELISTED	Stock	11.38	11.52	11.38	11.51	322930.0
2007-09-12	AAWW-DELISTED	Stock	49.91	51.92	49.63	51.43	814745.0
2007-09-12	AAXN-DELISTED	Stock	14.5	14.71	14.41	14.44	828607.0
2007-09-12	AB	Stock	81.1	81.42	79.87	80.37	134000.0
2007-09-12	ABAX-DELISTED	Stock	20.34	20.49	20.11	20.38	101671.0
2007-09-12	ABB-DELISTED	Stock	23.5	23.82	23.47	23.52	4087100.0
2007-09-12	ABBC-DELISTED	Stock	9.48	9.6	9.46	9.5	98805.0
2007-09-12	ABBNY-DELISTED	Stock	23.5	23.82	23.47	23.51	4181900.0
2007-09-12	ABC-DELISTED	Stock	23.4	23.4	22.95	22.98	2116600.0
2007-09-12	ABCB	Stock	18.4315	18.4315	17.6146	17.6632	54080.0
2007-09-12	ABCO-DELISTED	Stock	28.45	28.62	27.86	28.08	180014.0
2007-09-12	ABCW-DELISTED	Stock	27.18	27.52	26.89	27.34	121060.0
2007-09-12	ABD-DELISTED	Stock	21.06	21.54	20.68	20.9	375850.0
2007-09-12	ABE-DELISTED	Stock	21.56	21.76	21.39	21.62	22800.0
2007-09-12	ABEO	Stock	5937.5	5937.5	5312.5	5625.0	36.0
2007-09-12	ABFS-DELISTED	Stock	33.5	33.5	33.06	33.25	188858.0
2007-09-12	ABG	Stock	20.32	20.49	20.09	20.12	329200.0
2007-09-12	ABK-DELISTED	Stock	60.4	62.03	59.94	61.13	1348600.0
2007-09-12	ABM	Stock	20.25	20.34	19.95	20.15	315600.0
2007-09-12	ABMD-DELISTED	Stock	12.05	12.1	11.48	11.49	80401.0
2007-09-12	ABP-DELISTED	Stock	3.34	3.5	3.33	3.45	232200.0
2007-09-12	ABR	Stock	18.61	19.17	18.61	18.77	103700.0
2007-09-12	ABT	Stock	24.9112	25.2135	24.8584	25.0696	8935181.0
2007-09-12	ABTL-DELISTED	Stock	15.0	15.0	14.8	14.85	5149.0
2007-09-12	ABV-DELISTED	Stock	66.7	68.58	66.49	68.05	484500.0
2007-09-12	ABVA-DELISTED	Stock	10.09	10.15	9.93	9.95	12000.0
2007-09-12	ABVT-DELISTED	Stock	73.0	73.75	72.99	73.75	7700.0
2007-09-12	ABX-DELISTED	Stock	37.31	37.57	36.8	37.34	5324229.0
2007-09-12	ACAD	Stock	15.39	16.11	15.16	15.88	333600.0
2007-09-12	ACAP-DELISTED	Stock	37.73	37.73	36.3	36.68	90849.0
2007-09-12	ACAS-DELISTED	Stock	38.99	39.0	38.6	38.75	1486768.0
2007-09-12	ACAT-DELISTED	Stock	16.0	16.22	15.96	16.03	123599.0
2007-09-12	ACC-DELISTED	Stock	27.62	28.26	27.6	27.83	90100.0

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

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