PREVIEW / stock_daily / 2007-08-13

all stock daily files

  file:    by_date/stock_daily/2007/2007-08-13.parquet
  size:    178 KB
  rows:    5,515
  symbols: 3,331

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-08-13	AAPL	Stock	4.5829	4.6196	4.5179	4.5639	752911600.0
2007-08-13	MSFT	Stock	28.94	28.99	28.44	28.63	55492300.0
2007-08-13	NVDA	Stock	0.739	0.744	0.71	0.7252	700410000.0
2007-08-13	AMZN	Stock	3.8045	3.816	3.735	3.7435	121372000.0
2007-08-13	TLT	Stock	85.92	86.4	85.9	86.33	1312600.0
2007-08-13	CL	Stock	33.65	33.65	32.78	33.15	6015400.0
2007-08-13	A	Stock	25.7511	26.5308	25.7511	25.9871	4556501.0
2007-08-13	AABA-DELISTED	Stock	24.21	24.74	24.01	24.58	20307230.0
2007-08-13	AACC-DELISTED	Stock	8.9	9.25	8.68	8.76	588865.0
2007-08-13	AAI-DELISTED	Stock	11.0	11.08	10.17	10.29	6104200.0
2007-08-13	AAIC-DELISTED	Stock	95.0	99.4	87.0	87.0	3834300.0
2007-08-13	AAME	Stock	3.17	3.21	2.93	3.19	7200.0
2007-08-13	AAON	Stock	4.2443	4.43	4.1679	4.1771	407784.0
2007-08-13	AAP	Stock	32.25	34.29	32.03	33.52	5140000.0
2007-08-13	AATI-DELISTED	Stock	8.93	9.1	8.47	8.58	310287.0
2007-08-13	AAU-DELISTED	Stock	2.5	2.65	2.45	2.64	48300.0
2007-08-13	AAUAF-DELISTED	Stock	2.5	2.65	2.45	2.64	48300.0
2007-08-13	AAV-DELISTED	Stock	12.25	12.36	12.06	12.11	570000.0
2007-08-13	AAWW-DELISTED	Stock	53.25	54.91	52.04	52.8	195029.0
2007-08-13	AAXN-DELISTED	Stock	15.63	15.87	15.0	15.04	1711830.0
2007-08-13	AB	Stock	84.25	85.31	83.85	84.11	434500.0
2007-08-13	ABAX-DELISTED	Stock	20.87	20.94	19.74	20.1	272057.0
2007-08-13	ABB-DELISTED	Stock	22.96	23.02	22.59	22.62	2375300.0
2007-08-13	ABBC-DELISTED	Stock	9.19	9.32	9.1	9.19	87088.0
2007-08-13	ABBNY-DELISTED	Stock	22.96	23.02	22.59	22.62	2405800.0
2007-08-13	ABC-DELISTED	Stock	22.5	23.8	22.5	23.38	3860000.0
2007-08-13	ABCB	Stock	20.4352	21.2036	19.5112	19.6279	50481.0
2007-08-13	ABCO-DELISTED	Stock	29.46	29.46	27.82	28.61	294260.0
2007-08-13	ABCW-DELISTED	Stock	24.61	25.0	24.17	24.25	149190.0
2007-08-13	ABD-DELISTED	Stock	22.92	24.92	22.75	24.26	787790.0
2007-08-13	ABE-DELISTED	Stock	19.84	20.2	19.78	20.06	73800.0
2007-08-13	ABEO	Stock	4612.5	4612.5	4250.0	4575.0	5.0
2007-08-13	ABFS-DELISTED	Stock	36.48	37.25	35.0	35.65	513632.0
2007-08-13	ABG	Stock	21.3	22.55	21.14	21.57	999500.0
2007-08-13	ABK-DELISTED	Stock	69.89	69.98	62.31	62.82	4657000.0
2007-08-13	ABM	Stock	23.26	24.7	23.04	23.08	441600.0
2007-08-13	ABMD-DELISTED	Stock	11.65	11.73	10.63	11.08	728044.0
2007-08-13	ABP-DELISTED	Stock	3.79	3.89	3.7	3.76	396600.0
2007-08-13	ABR	Stock	18.35	18.69	17.76	18.21	478500.0
2007-08-13	ABT	Stock	26.4898	26.4898	25.6357	25.8564	16818049.0
2007-08-13	ABTL-DELISTED	Stock	13.547	15.303	13.547	15.203	60960.0
2007-08-13	ABV-DELISTED	Stock	68.27	69.69	66.47	67.0	598700.0
2007-08-13	ABVA-DELISTED	Stock	9.91	10.1	9.91	10.06	12600.0
2007-08-13	ABX-DELISTED	Stock	34.31	34.47	33.53	33.61	4738000.0
2007-08-13	ACAD	Stock	16.46	16.46	15.65	15.84	399100.0
2007-08-13	ACAP-DELISTED	Stock	36.37	38.03	35.98	37.24	144418.0
2007-08-13	ACAS-DELISTED	Stock	40.9	41.62	40.26	40.65	2489128.0
2007-08-13	ACAT-DELISTED	Stock	17.48	17.94	17.12	17.56	256185.0
2007-08-13	ACC-DELISTED	Stock	27.15	27.46	26.26	26.71	274000.0
2007-08-13	ACCL-DELISTED	Stock	6.41	6.86	6.39	6.75	59825.0

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

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