PREVIEW / stock_daily / 2007-10-01

all stock daily files

  file:    by_date/stock_daily/2007/2007-10-01.parquet
  size:    179 KB
  rows:    5,526
  symbols: 3,340

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-10-01	AAPL	Stock	5.5225	5.6218	5.4618	5.5836	837068400.0
2007-10-01	MSFT	Stock	29.46	29.79	29.41	29.77	43875100.0
2007-10-01	NVDA	Stock	0.9138	0.9488	0.9128	0.9443	398200000.0
2007-10-01	AMZN	Stock	4.671	4.705	4.6415	4.6705	107948000.0
2007-10-01	TLT	Stock	88.69	88.98	88.43	88.88	1399400.0
2007-10-01	CL	Stock	35.85	35.91	35.565	35.78	7214800.0
2007-10-01	A	Stock	26.4449	26.824	26.3948	26.4735	5086903.0
2007-10-01	AABA-DELISTED	Stock	26.85	27.1	26.73	27.05	16939662.0
2007-10-01	AACC-DELISTED	Stock	11.62	12.01	11.61	12.01	202007.0
2007-10-01	AAI-DELISTED	Stock	9.79	9.98	9.79	9.92	1166800.0
2007-10-01	AAIC-DELISTED	Stock	91.4	96.8	91.4	96.8	1648500.0
2007-10-01	AAME	Stock	2.75	2.79	2.53	2.62	10000.0
2007-10-01	AAON	Stock	3.8894	3.9605	3.8637	3.9506	273375.0
2007-10-01	AAP	Stock	33.45	33.56	32.73	33.35	835700.0
2007-10-01	AATI-DELISTED	Stock	10.62	11.51	10.61	11.31	1050463.0
2007-10-01	AAU-DELISTED	Stock	2.32	2.35	2.28	2.33	31400.0
2007-10-01	AAUAF-DELISTED	Stock	2.32	2.35	2.28	2.33	31400.0
2007-10-01	AAV-DELISTED	Stock	12.37	12.43	12.15	12.27	723500.0
2007-10-01	AAWW-DELISTED	Stock	51.63	52.78	51.18	52.71	71934.0
2007-10-01	AAXN-DELISTED	Stock	15.63	16.5	15.63	16.224	3346468.0
2007-10-01	AB	Stock	88.06	90.56	87.85	90.28	350900.0
2007-10-01	ABAX-DELISTED	Stock	22.55	22.89	22.07	22.76	220733.0
2007-10-01	ABB-DELISTED	Stock	26.62	27.48	26.62	27.17	5250100.0
2007-10-01	ABBC-DELISTED	Stock	9.73	9.84	9.71	9.79	139631.0
2007-10-01	ABBNY-DELISTED	Stock	26.62	27.48	26.62	27.15	4858200.0
2007-10-01	ABC-DELISTED	Stock	22.49	22.54	22.18	22.44	3226800.0
2007-10-01	ABCB	Stock	17.5562	18.4315	17.5562	18.0425	42667.0
2007-10-01	ABCO-DELISTED	Stock	29.27	30.85	29.19	30.14	270130.0
2007-10-01	ABCW-DELISTED	Stock	26.97	27.7	26.94	27.47	91610.0
2007-10-01	ABD-DELISTED	Stock	22.39	23.24	22.39	23.13	234290.0
2007-10-01	ABE-DELISTED	Stock	23.98	24.66	23.8	24.39	24700.0
2007-10-01	ABEO	Stock	5600.0	5600.0	5125.0	5237.5	82.0
2007-10-01	ABFS-DELISTED	Stock	32.66	33.31	32.66	32.89	609183.0
2007-10-01	ABG	Stock	19.77	19.91	19.15	19.37	784000.0
2007-10-01	ABK-DELISTED	Stock	63.6	65.06	62.8	64.59	1576900.0
2007-10-01	ABM	Stock	19.9	20.69	19.82	20.43	289400.0
2007-10-01	ABMD-DELISTED	Stock	12.39	12.54	12.27	12.43	206108.0
2007-10-01	ABP-DELISTED	Stock	3.85	3.99	3.83	3.99	209500.0
2007-10-01	ABR	Stock	19.08	20.5	18.94	20.07	237800.0
2007-10-01	ABT	Stock	25.6981	26.5281	25.6981	26.4898	13657566.0
2007-10-01	ABTL-DELISTED	Stock	16.0	16.65	16.0	16.5	7631.0
2007-10-01	ABV-DELISTED	Stock	73.13	77.95	73.13	77.25	706232.0
2007-10-01	ABVA-DELISTED	Stock	9.94	10.13	9.9	10.13	9130.0
2007-10-01	ABVT-DELISTED	Stock	78.9	79.5	75.0	75.0	15679.0
2007-10-01	ABX-DELISTED	Stock	40.54	41.38	40.54	41.19	6668671.0
2007-10-01	ACAD	Stock	15.08	15.64	15.01	15.56	475300.0
2007-10-01	ACAP-DELISTED	Stock	38.87	40.2	37.92	40.15	57655.0
2007-10-01	ACAS-DELISTED	Stock	42.94	43.5	42.73	43.5	2324268.0
2007-10-01	ACAT-DELISTED	Stock	16.33	16.77	16.11	16.69	112138.0
2007-10-01	ACC-DELISTED	Stock	29.2	30.44	28.94	29.96	169400.0

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

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