PREVIEW / stock_daily / 2007-11-29

all stock daily files

  file:    by_date/stock_daily/2007/2007-11-29.parquet
  size:    180 KB
  rows:    5,594
  symbols: 3,388

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-11-29	AAPL	Stock	6.4082	6.6132	6.3982	6.5818	1050926800.0
2007-11-29	MSFT	Stock	33.58	33.93	33.31	33.59	53633600.0
2007-11-29	NVDA	Stock	0.82	0.8525	0.8165	0.828	489084000.0
2007-11-29	AMZN	Stock	4.4945	4.5735	4.434	4.4575	139542000.0
2007-11-29	TLT	Stock	94.82	95.42	94.66	94.89	1595418.0
2007-11-29	CL	Stock	40.0	40.09	39.5	40.075	5051000.0
2007-11-29	A	Stock	27.1102	27.2818	26.774	26.8026	4316465.0
2007-11-29	AABA-DELISTED	Stock	26.13	26.71	25.91	26.63	17961645.0
2007-11-29	AACC-DELISTED	Stock	11.95	11.95	11.44	11.44	149837.0
2007-11-29	AAI-DELISTED	Stock	8.45	8.5	8.16	8.22	1371416.0
2007-11-29	AAIC-DELISTED	Stock	57.6	58.0	53.0	55.6	2182863.0
2007-11-29	AAME	Stock	1.7	1.75	1.6	1.74	6100.0
2007-11-29	AAON	Stock	3.7432	3.7669	3.6543	3.7432	459169.0
2007-11-29	AAP	Stock	34.58	35.77	34.3	35.68	2005400.0
2007-11-29	AATI-DELISTED	Stock	10.82	11.39	10.77	10.93	668291.0
2007-11-29	AAU-DELISTED	Stock	2.44	2.49	2.38	2.44	32850.0
2007-11-29	AAUAF-DELISTED	Stock	2.44	2.49	2.38	2.4401	32900.0
2007-11-29	AAV-DELISTED	Stock	10.51	10.51	10.34	10.35	655600.0
2007-11-29	AAWW-DELISTED	Stock	52.5	53.22	52.14	52.36	121147.0
2007-11-29	AAXN-DELISTED	Stock	14.11	14.16	13.8	13.9	1236605.0
2007-11-29	AB	Stock	82.0	82.0	78.71	80.42	203500.0
2007-11-29	ABAX-DELISTED	Stock	33.5	33.79	32.73	33.2	216071.0
2007-11-29	ABB-DELISTED	Stock	28.28	28.95	28.16	28.67	3935659.0
2007-11-29	ABBC-DELISTED	Stock	9.0	9.06	8.95	9.01	51506.0
2007-11-29	ABBNY-DELISTED	Stock	28.28	28.95	28.16	28.67	3935659.0
2007-11-29	ABC-DELISTED	Stock	18.76	22.37	18.76	22.34	2958568.0
2007-11-29	ABCB	Stock	16.4182	16.5349	16.1653	16.2625	83176.0
2007-11-29	ABCO-DELISTED	Stock	31.92	32.39	31.79	31.91	128588.0
2007-11-29	ABCW-DELISTED	Stock	25.4	25.4	24.34	24.52	121300.0
2007-11-29	ABD-DELISTED	Stock	17.1	17.21	16.56	16.75	242150.0
2007-11-29	ABE-DELISTED	Stock	24.86	25.5	24.86	25.5	11180.0
2007-11-29	ABEO	Stock	3625.0	3750.0	3575.0	3750.0	9.0
2007-11-29	ABFS-DELISTED	Stock	22.89	23.17	22.18	22.5	850006.0
2007-11-29	ABG	Stock	16.95	16.99	16.42	16.79	501700.0
2007-11-29	ABII-DELISTED	Stock	57.1	57.97	57.1	57.22	58355.0
2007-11-29	ABK-DELISTED	Stock	22.27	24.0	21.51	23.43	8007782.0
2007-11-29	ABM	Stock	20.34	21.07	20.13	20.63	265900.0
2007-11-29	ABMD-DELISTED	Stock	12.37	12.5	12.27	12.4	129293.0
2007-11-29	ABP-DELISTED	Stock	3.53	3.6	3.35	3.37	149850.0
2007-11-29	ABR	Stock	16.65	17.2	16.45	17.2	230400.0
2007-11-29	ABT	Stock	27.0895	27.5741	26.7488	27.3486	16180700.0
2007-11-29	ABTL-DELISTED	Stock	15.605	15.605	14.895	15.25	29315.0
2007-11-29	ABV-DELISTED	Stock	75.09	75.82	73.35	73.85	758801.0
2007-11-29	ABVA-DELISTED	Stock	7.42	7.55	7.42	7.55	1200.0
2007-11-29	ABVT-DELISTED	Stock	75.0	76.5	75.0	75.0	22012.0
2007-11-29	ABX-DELISTED	Stock	41.85	42.07	40.94	41.0	4822866.0
2007-11-29	ACAD	Stock	10.55	11.26	10.49	11.22	419900.0
2007-11-29	ACAP-DELISTED	Stock	41.8	42.96	41.47	42.0	73306.0
2007-11-29	ACAS-DELISTED	Stock	37.62	37.66	36.26	36.73	2883404.0
2007-11-29	ACAT-DELISTED	Stock	11.36	11.53	10.75	10.88	114172.0

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

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