PREVIEW / stock_daily / 2007-12-20

all stock daily files

  file:    by_date/stock_daily/2007/2007-12-20.parquet
  size:    182 KB
  rows:    5,671
  symbols: 3,437

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-20	AAPL	Stock	6.6225	6.7082	6.5475	6.6861	774057200.0
2007-12-20	MSFT	Stock	35.29	35.79	35.08	35.52	59345000.0
2007-12-20	NVDA	Stock	0.875	0.8812	0.8568	0.8792	279940000.0
2007-12-20	AMZN	Stock	4.507	4.5375	4.4545	4.529	117596000.0
2007-12-20	TLT	Stock	93.26	93.87	93.02	93.03	1659361.0
2007-12-20	CL	Stock	38.98	39.255	38.98	39.185	3243400.0
2007-12-20	A	Stock	25.4793	26.1016	25.4793	26.0515	2766502.0
2007-12-20	AABA-DELISTED	Stock	23.51	23.8	23.24	23.69	21039376.0
2007-12-20	AACC-DELISTED	Stock	10.57	10.77	10.27	10.77	168595.0
2007-12-20	AAI-DELISTED	Stock	7.96	7.99	7.58	7.79	2148218.0
2007-12-20	AAIC-DELISTED	Stock	59.6	63.8	56.2	59.2	2040140.0
2007-12-20	AAME	Stock	1.4	1.4	1.11	1.26	21000.0
2007-12-20	AAON	Stock	3.9546	3.9763	3.8321	3.9625	404494.0
2007-12-20	AAP	Stock	38.12	38.51	37.97	38.51	955900.0
2007-12-20	AATI-DELISTED	Stock	11.48	11.48	11.0399	11.41	328408.0
2007-12-20	AAU-DELISTED	Stock	2.3	2.38	2.3	2.3	42000.0
2007-12-20	AAUAF-DELISTED	Stock	2.3	2.38	2.3	2.3	42900.0
2007-12-20	AAV-DELISTED	Stock	9.25	9.26	9.05	9.06	1154710.0
2007-12-20	AAWW-DELISTED	Stock	53.75	54.29	52.61	54.29	158756.0
2007-12-20	AAXN-DELISTED	Stock	14.84	14.88	14.45	14.84	655936.0
2007-12-20	AB	Stock	77.8	78.3	75.33	76.01	371500.0
2007-12-20	ABAX-DELISTED	Stock	37.07	37.15	35.94	36.67	179409.0
2007-12-20	ABB-DELISTED	Stock	27.1	27.11	26.73	26.93	2669787.0
2007-12-20	ABBC-DELISTED	Stock	9.06	9.4	9.01	9.36	178608.0
2007-12-20	ABBNY-DELISTED	Stock	27.1	27.11	26.73	27.01	2669787.0
2007-12-20	ABC-DELISTED	Stock	21.7	21.88	21.58	21.8	1370846.0
2007-12-20	ABCB	Stock	16.6614	16.8364	16.1556	16.6614	34854.0
2007-12-20	ABCO-DELISTED	Stock	32.01	32.33	31.59	32.09	246624.0
2007-12-20	ABCW-DELISTED	Stock	23.96	24.21	23.09	24.21	81020.0
2007-12-20	ABD-DELISTED	Stock	16.34	16.6	15.98	16.22	376700.0
2007-12-20	ABE-DELISTED	Stock	26.25	26.28	25.35	25.84	13500.0
2007-12-20	ABEO	Stock	3375.0	3575.0	3375.0	3575.0	12.0
2007-12-20	ABFS-DELISTED	Stock	22.03	22.12	21.49	22.01	469090.0
2007-12-20	ABG	Stock	14.98	15.18	14.72	15.09	250400.0
2007-12-20	ABII-DELISTED	Stock	72.0	72.6	68.98	68.98	14767.0
2007-12-20	ABK-DELISTED	Stock	26.26	27.7	25.12	26.99	9078981.0
2007-12-20	ABM	Stock	19.9	20.07	19.3	20.04	252700.0
2007-12-20	ABMD-DELISTED	Stock	15.0	15.69	15.0	15.15	416304.0
2007-12-20	ABP-DELISTED	Stock	3.46	3.47	3.3	3.36	217650.0
2007-12-20	ABR	Stock	17.08	17.08	16.48	16.95	412400.0
2007-12-20	ABT	Stock	27.6029	27.7084	27.4014	27.6365	8182784.0
2007-12-20	ABTL-DELISTED	Stock	14.951	14.951	14.698	14.85	11537.0
2007-12-20	ABV-DELISTED	Stock	70.89	72.16	70.89	71.28	665965.0
2007-12-20	ABVA-DELISTED	Stock	6.55	6.6032	6.5	6.55	6960.0
2007-12-20	ABVT-DELISTED	Stock	74.5	76.0	74.5	76.0	2512.0
2007-12-20	ABX-DELISTED	Stock	37.51	38.01	37.08	37.48	5505868.0
2007-12-20	ACAD	Stock	11.92	12.09	11.58	12.09	140800.0
2007-12-20	ACAP-DELISTED	Stock	43.25	43.92	41.27	43.2	92684.0
2007-12-20	ACAS-DELISTED	Stock	34.07	34.33	32.84	33.27	2797392.0
2007-12-20	ACAT-DELISTED	Stock	12.65	13.03	12.45	12.99	99877.0

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

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