PREVIEW / stock_daily / 2007-01-24

all stock daily files

  file:    by_date/stock_daily/2007/2007-01-24.parquet
  size:    161 KB
  rows:    4,830
  symbols: 3,034

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-01-24	AAPL	Stock	3.0957	3.1125	3.0743	3.0964	927813600.0
2007-01-24	MSFT	Stock	30.78	31.3	30.65	31.09	58527800.0
2007-01-24	NVDA	Stock	0.5383	0.5552	0.5358	0.548	685722000.0
2007-01-24	AMZN	Stock	1.8255	1.868	1.825	1.863	105434000.0
2007-01-24	TLT	Stock	87.66	87.7	87.5	87.61	463700.0
2007-01-24	CL	Stock	33.07	33.26	33.0	33.245	3126200.0
2007-01-24	A	Stock	23.3977	23.6052	23.2189	23.3262	3982063.0
2007-01-24	AABA-DELISTED	Stock	28.3400001525879	29.2000007629395	28.2199993133545	28.9400005340576	81017500.0
2007-01-24	AACC-DELISTED	Stock	15.46	15.59	15.39	15.4	84078.0
2007-01-24	AACQ-DELISTED	Stock	5.58	5.59	5.58	5.59	841329.0
2007-01-24	AACQU-DELISTED	Stock	6.8	7.03	6.8	7.03	6000.0
2007-01-24	AACQW-DELISTED	Stock	0.67	0.72	0.67	0.72	216500.0
2007-01-24	AAI-DELISTED	Stock	11.2	11.32	11.03	11.07	2004200.0
2007-01-24	AAIC-DELISTED	Stock	155.6	158.4	155.4	158.4	601300.0
2007-01-24	AAME	Stock	3.3	3.41	3.29	3.41	9200.0
2007-01-24	AAON	Stock	3.5621	3.678	3.5621	3.6728	123019.0
2007-01-24	AAP	Stock	37.5	37.74	37.29	37.69	280500.0
2007-01-24	AATI-DELISTED	Stock	5.74	5.902	5.66	5.89	332968.0
2007-01-24	AAU-DELISTED	Stock	2.26	2.3	2.16	2.21	47000.0
2007-01-24	AAUAF-DELISTED	Stock	2.26	2.3	2.16	2.21	47000.0
2007-01-24	AAV-DELISTED	Stock	10.92	10.99	10.78	10.96	1020700.0
2007-01-24	AAWW-DELISTED	Stock	46.66	48.01	46.58	47.69	215127.0
2007-01-24	AAXN-DELISTED	Stock	7.82000017166138	7.88000011444092	7.65000009536743	7.75	832700.0
2007-01-24	AB	Stock	88.44	89.54	88.4	89.41	226800.0
2007-01-24	ABAX-DELISTED	Stock	17.73	17.83	17.58	17.71	77433.0
2007-01-24	ABB-DELISTED	Stock	17.79	17.96	17.73	17.91	1672500.0
2007-01-24	ABBC-DELISTED	Stock	18.95	19.1	18.95	19.1	51413.0
2007-01-24	ABC-DELISTED	Stock	25.05	26.12	24.88	26.0	9145400.0
2007-01-24	ABCB	Stock	26.2906	26.8643	26.096	26.4947	29610.0
2007-01-24	ABCO-DELISTED	Stock	27.38	27.62	27.23	27.56	75051.0
2007-01-24	ABCW-DELISTED	Stock	28.52	28.96	28.4	28.88	48570.0
2007-01-24	ABD-DELISTED	Stock	25.0	25.03	24.81	24.95	531300.0
2007-01-24	ABE-DELISTED	Stock	18.12	18.9	18.01	18.4	92600.0
2007-01-24	ABFS-DELISTED	Stock	37.5	39.3	37.15	38.41	1499251.0
2007-01-24	ABG	Stock	23.8	24.05	23.8	23.94	96200.0
2007-01-24	ABK-DELISTED	Stock	87.03	88.5	87.03	88.46	368200.0
2007-01-24	ABM	Stock	24.02	24.46	24.02	24.35	506000.0
2007-01-24	ABMD-DELISTED	Stock	14.46	14.46	14.28	14.37	37211.0
2007-01-24	ABP-DELISTED	Stock	3.2	3.23	3.17	3.19	147800.0
2007-01-24	ABR	Stock	31.43	31.46	31.02	31.2	95500.0
2007-01-24	ABT	Stock	25.6117	25.8372	25.3718	25.6933	15993539.0
2007-01-24	ABTL-DELISTED	Stock	16.55	18.75	16.55	18.65	63048.0
2007-01-24	ABV-DELISTED	Stock	51.53	51.98	51.23	51.93	380600.0
2007-01-24	ABVA-DELISTED	Stock	16.6	16.6	16.57	16.57	450.0
2007-01-24	ABVT-DELISTED	Stock	59.0	59.25	58.9	58.95	5121.0
2007-01-24	ABX-DELISTED	Stock	29.01	29.74	28.9	29.69	5783889.0
2007-01-24	ACAD	Stock	7.09	7.09	7.01	7.06	157400.0
2007-01-24	ACAP-DELISTED	Stock	36.7	37.21	36.41	37.18	73057.0
2007-01-24	ACAS-DELISTED	Stock	47.43	48.05	47.35	48.05	764229.0
2007-01-24	ACAT-DELISTED	Stock	16.48	18.67	16.27	18.09	309959.0

> showing 50 of 4,830 rows — these rows as CSV

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