PREVIEW / stock_daily / 2007-12-21

all stock daily files

  file:    by_date/stock_daily/2007/2007-12-21.parquet
  size:    183 KB
  rows:    5,665
  symbols: 3,426

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-12-21	AAPL	Stock	6.79	6.9254	6.7818	6.9254	993960800.0
2007-12-21	MSFT	Stock	35.9	36.06	35.75	36.06	83240500.0
2007-12-21	NVDA	Stock	0.8898	0.8975	0.871	0.879	433408000.0
2007-12-21	AMZN	Stock	4.5735	4.614	4.5195	4.563	132098000.0
2007-12-21	TLT	Stock	92.9	92.92	91.66	91.67	1767549.0
2007-12-21	CL	Stock	39.23	39.705	39.16	39.365	5547000.0
2007-12-21	A	Stock	26.2876	26.7096	26.1803	26.6023	3690161.0
2007-12-21	AABA-DELISTED	Stock	23.91	24.1	23.74	23.94	24218241.0
2007-12-21	AACC-DELISTED	Stock	10.99	11.25	10.94	11.25	247288.0
2007-12-21	AAI-DELISTED	Stock	7.9	7.92	7.6	7.63	2818600.0
2007-12-21	AAIC-DELISTED	Stock	60.2	67.4	60.2	66.0	4978898.0
2007-12-21	AAME	Stock	1.35	1.45	1.3	1.39	22400.0
2007-12-21	AAON	Stock	4.0277	4.1679	3.9921	4.1679	790256.0
2007-12-21	AAP	Stock	38.54	39.04	38.4	38.48	976900.0
2007-12-21	AATI-DELISTED	Stock	11.58	12.15	11.47	12.11	1181123.0
2007-12-21	AAU-DELISTED	Stock	2.42	2.44	2.33	2.43	53265.0
2007-12-21	AAUAF-DELISTED	Stock	2.42	2.45	2.33	2.43	54760.0
2007-12-21	AAV-DELISTED	Stock	9.0	9.14	8.95	9.14	1364973.0
2007-12-21	AAWW-DELISTED	Stock	55.14	55.63	54.58	55.61	156366.0
2007-12-21	AAXN-DELISTED	Stock	15.07	15.21	14.96	15.16	1541897.0
2007-12-21	AB	Stock	76.5	79.65	76.48	79.32	309300.0
2007-12-21	ABAX-DELISTED	Stock	37.32	38.17	36.99	37.41	433323.0
2007-12-21	ABB-DELISTED	Stock	27.64	28.07	27.57	28.05	4268730.0
2007-12-21	ABBC-DELISTED	Stock	9.39	9.57	9.36	9.49	283437.0
2007-12-21	ABBNY-DELISTED	Stock	27.64	28.07	27.57	28.0	4268930.0
2007-12-21	ABC-DELISTED	Stock	22.08	22.38	21.85	22.32	3013686.0
2007-12-21	ABCB	Stock	17.0796	17.6729	17.0407	17.6729	128105.0
2007-12-21	ABCO-DELISTED	Stock	32.66	33.49	32.48	33.49	394038.0
2007-12-21	ABCW-DELISTED	Stock	24.85	25.06	24.26	24.8	334340.0
2007-12-21	ABD-DELISTED	Stock	16.45	17.65	15.95	16.15	559650.0
2007-12-21	ABE-DELISTED	Stock	26.25	26.4	25.86	26.4	16200.0
2007-12-21	ABEO	Stock	3412.5	3750.0	3125.0	3750.0	17.0
2007-12-21	ABFS-DELISTED	Stock	22.37	22.94	21.99	22.54	581789.0
2007-12-21	ABG	Stock	15.3	15.57	15.02	15.27	351900.0
2007-12-21	ABII-DELISTED	Stock	69.85	70.68	63.99	67.99	32467.0
2007-12-21	ABK-DELISTED	Stock	28.7	28.7	25.5	26.58	5941999.0
2007-12-21	ABM	Stock	20.38	20.66	20.28	20.62	517900.0
2007-12-21	ABMD-DELISTED	Stock	15.46	15.74	15.33	15.48	641380.0
2007-12-21	ABP-DELISTED	Stock	3.54	3.54	3.39	3.42	166330.0
2007-12-21	ABR	Stock	17.24	17.24	16.63	17.19	464000.0
2007-12-21	ABT	Stock	28.1355	28.2458	27.3534	27.9531	19453105.0
2007-12-21	ABTL-DELISTED	Stock	15.094	15.45	14.027	15.45	39297.0
2007-12-21	ABV-DELISTED	Stock	72.54	72.65	71.19	72.31	694941.0
2007-12-21	ABVA-DELISTED	Stock	6.55	6.62	6.55	6.57	16175.0
2007-12-21	ABVT-DELISTED	Stock	76.25	76.25	76.0	76.0	1000.0
2007-12-21	ABX-DELISTED	Stock	38.1	40.0	37.97	39.12	7287684.0
2007-12-21	ACAD	Stock	12.28	12.71	12.16	12.45	417700.0
2007-12-21	ACAP-DELISTED	Stock	44.0	44.28	42.17	43.01	148032.0
2007-12-21	ACAS-DELISTED	Stock	34.4	34.49	33.56	34.13	4521071.0
2007-12-21	ACAT-DELISTED	Stock	13.2	13.25	12.82	12.9	211556.0

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

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