PREVIEW / stock_daily / 2007-12-18

all stock daily files

  file:    by_date/stock_daily/2007/2007-12-18.parquet
  size:    182 KB
  rows:    5,676
  symbols: 3,441

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-18	AAPL	Stock	6.6614	6.6904	6.3786	6.535	1222603200.0
2007-12-18	MSFT	Stock	34.64	35.0	34.21	34.74	52791800.0
2007-12-18	NVDA	Stock	0.8448	0.8625	0.8363	0.8532	396896000.0
2007-12-18	AMZN	Stock	4.2915	4.373	4.193	4.3445	145322000.0
2007-12-18	TLT	Stock	91.59	92.2999	91.55	91.96	1417079.0
2007-12-18	CL	Stock	39.735	39.735	38.86	38.9	6664600.0
2007-12-18	A	Stock	25.4864	25.7439	25.0215	25.1144	2798656.0
2007-12-18	AABA-DELISTED	Stock	23.2	23.35	22.8	23.041	27933288.0
2007-12-18	AACC-DELISTED	Stock	10.54	10.78	10.2	10.47	229220.0
2007-12-18	AAI-DELISTED	Stock	7.91	7.91	7.7	7.84	1228833.0
2007-12-18	AAIC-DELISTED	Stock	54.0	59.0	53.4	57.6	2076702.0
2007-12-18	AAME	Stock	1.5	1.5	1.45	1.45	13500.0
2007-12-18	AAON	Stock	3.8716	3.9763	3.8281	3.9585	324000.0
2007-12-18	AAP	Stock	38.2	38.44	37.61	37.91	1541900.0
2007-12-18	AATI-DELISTED	Stock	11.36	11.45	10.56	11.02	620428.0
2007-12-18	AAU-DELISTED	Stock	2.41	2.41	2.34	2.34	47400.0
2007-12-18	AAUAF-DELISTED	Stock	2.41	2.41	2.34	2.34	47700.0
2007-12-18	AAV-DELISTED	Stock	9.46	9.46	9.2	9.25	1404761.0
2007-12-18	AAWW-DELISTED	Stock	53.37	53.71	52.3	53.35	126858.0
2007-12-18	AAXN-DELISTED	Stock	14.0	14.6	13.93	14.58	943487.0
2007-12-18	AB	Stock	76.48	79.59	76.48	79.21	319700.0
2007-12-18	ABAX-DELISTED	Stock	35.21	36.25	34.83	35.85	210573.0
2007-12-18	ABB-DELISTED	Stock	27.42	27.57	26.67	27.18	7205858.0
2007-12-18	ABBC-DELISTED	Stock	9.0	9.05	8.85	9.05	50181.0
2007-12-18	ABBNY-DELISTED	Stock	27.42	27.57	26.67	27.23	7205858.0
2007-12-18	ABC-DELISTED	Stock	21.8	21.9	21.62	21.79	2156000.0
2007-12-18	ABCB	Stock	15.7568	16.8267	15.4456	16.2723	154528.0
2007-12-18	ABCO-DELISTED	Stock	31.27	32.11	31.23	31.52	253407.0
2007-12-18	ABCW-DELISTED	Stock	23.58	24.4	22.8	24.4	107150.0
2007-12-18	ABD-DELISTED	Stock	15.92	16.39	15.61	16.33	373010.0
2007-12-18	ABE-DELISTED	Stock	25.03	25.9899	25.0	25.37	41200.0
2007-12-18	ABEO	Stock	2900.0	3000.0	2825.0	3000.0	4.0
2007-12-18	ABFS-DELISTED	Stock	22.44	22.66	22.0	22.23	568122.0
2007-12-18	ABG	Stock	15.01	15.35	14.58	15.34	262300.0
2007-12-18	ABII-DELISTED	Stock	68.62	70.28	66.0601	69.98	38793.0
2007-12-18	ABK-DELISTED	Stock	26.94	27.95	26.04	27.01	6844546.0
2007-12-18	ABM	Stock	20.0	20.1	19.32	20.09	377400.0
2007-12-18	ABMD-DELISTED	Stock	14.67	14.74	14.32	14.72	202557.0
2007-12-18	ABP-DELISTED	Stock	3.36	3.47	3.23	3.35	194900.0
2007-12-18	ABR	Stock	16.7	17.03	16.5	17.0	211400.0
2007-12-18	ABT	Stock	27.4638	27.814	27.2047	27.6797	12312213.0
2007-12-18	ABTL-DELISTED	Stock	15.025	15.226	14.424	14.625	16776.0
2007-12-18	ABV-DELISTED	Stock	71.38	71.62	69.19	70.65	615200.0
2007-12-18	ABVA-DELISTED	Stock	6.53	6.53	6.4	6.45	7010.0
2007-12-18	ABX-DELISTED	Stock	37.96	38.48	37.08	38.04	6523160.0
2007-12-18	ACAD	Stock	11.38	11.57	10.82	11.49	268800.0
2007-12-18	ACAP-DELISTED	Stock	43.65	43.94	41.26	42.68	109759.0
2007-12-18	ACAS-DELISTED	Stock	34.75	35.1	32.5	33.18	4657295.0
2007-12-18	ACAT-DELISTED	Stock	11.75	12.58	11.64	12.53	173188.0
2007-12-18	ACC-DELISTED	Stock	25.75	26.35	25.32	26.35	231000.0

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

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