PREVIEW / stock_daily / 2007-04-04

all stock daily files

  file:    by_date/stock_daily/2007/2007-04-04.parquet
  size:    161 KB
  rows:    4,860
  symbols: 3,050

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-04-04	AAPL	Stock	3.3907	3.3979	3.3618	3.3668	476784000.0
2007-04-04	MSFT	Stock	28.01	28.78	27.9	28.5	63244200.0
2007-04-04	NVDA	Stock	0.4767	0.4805	0.475	0.4763	361692000.0
2007-04-04	AMZN	Stock	2.061	2.0775	2.046	2.0765	81294000.0
2007-04-04	TLT	Stock	88.17	88.34	87.9	88.08	576886.0
2007-04-04	CL	Stock	33.11	33.15	33.005	33.09	2780400.0
2007-04-04	A	Stock	24.7997	24.9142	24.7282	24.8999	3376729.0
2007-04-04	AABA-DELISTED	Stock	31.6100006103516	31.8700008392334	31.4799995422363	31.6200008392334	7836200.0
2007-04-04	AACC-DELISTED	Stock	15.5	15.68	15.5	15.63	81021.0
2007-04-04	AACQ-DELISTED	Stock	4.3	4.34	4.3	4.34	22700.0
2007-04-04	AACQW-DELISTED	Stock	0.56	0.56	0.56	0.56	10000.0
2007-04-04	AAI-DELISTED	Stock	10.91	11.02	10.69	10.71	1940500.0
2007-04-04	AAIC-DELISTED	Stock	111.2	111.6	109.4	110.2	1139700.0
2007-04-04	AAME	Stock	4.17	4.21	4.01	4.21	12600.0
2007-04-04	AAON	Stock	3.3778	3.4173	3.3712	3.416	69862.0
2007-04-04	AAP	Stock	39.06	39.06	38.57	38.65	630800.0
2007-04-04	AATI-DELISTED	Stock	6.73	7.03	6.51	6.91	510090.0
2007-04-04	AAU-DELISTED	Stock	2.39	2.43	2.31	2.36	102800.0
2007-04-04	AAUAF-DELISTED	Stock	2.39	2.43	2.31	2.36	102800.0
2007-04-04	AAV-DELISTED	Stock	10.26	10.46	10.26	10.32	399800.0
2007-04-04	AAWW-DELISTED	Stock	55.15	55.6	53.98	55.58	117699.0
2007-04-04	AAXN-DELISTED	Stock	8.23999977111816	8.25	8.0600004196167	8.07999992370605	1138200.0
2007-04-04	AB	Stock	90.5	91.36	89.92	91.36	213000.0
2007-04-04	ABAX-DELISTED	Stock	24.7	24.91	24.49	24.73	117977.0
2007-04-04	ABB-DELISTED	Stock	17.84	18.01	17.83	18.0	2464130.0
2007-04-04	ABBC-DELISTED	Stock	20.1	20.2	20.09	20.18	20810.0
2007-04-04	ABC-DELISTED	Stock	27.03	27.03	26.69	26.89	1270600.0
2007-04-04	ABCB	Stock	24.0728	24.2966	23.5963	23.6255	16347.0
2007-04-04	ABCO-DELISTED	Stock	25.6	25.66	25.49	25.58	114986.0
2007-04-04	ABCW-DELISTED	Stock	28.3	28.3	27.89	27.89	45760.0
2007-04-04	ABD-DELISTED	Stock	24.7	25.15	24.55	25.06	556320.0
2007-04-04	ABE-DELISTED	Stock	19.57	19.8	19.57	19.79	20600.0
2007-04-04	ABFS-DELISTED	Stock	35.89	36.1	35.5	35.89	578616.0
2007-04-04	ABG	Stock	27.65	27.65	27.19	27.2	1043500.0
2007-04-04	ABK-DELISTED	Stock	87.03	87.49	86.4	86.75	497400.0
2007-04-04	ABM	Stock	26.38	26.4	26.13	26.19	233800.0
2007-04-04	ABMD-DELISTED	Stock	13.45	13.63	13.27	13.5	213113.0
2007-04-04	ABP-DELISTED	Stock	3.12	3.22	3.04	3.11	139800.0
2007-04-04	ABR	Stock	29.85	29.99	29.58	29.8	99700.0
2007-04-04	ABT	Stock	27.1615	27.3294	26.9264	27.0079	10351188.0
2007-04-04	ABTL-DELISTED	Stock	17.55	18.0	17.4	17.95	20661.0
2007-04-04	ABV-DELISTED	Stock	56.94	56.94	55.67	55.75	545500.0
2007-04-04	ABVA-DELISTED	Stock	14.91	14.94	14.9	14.9375	2200.0
2007-04-04	ABVT-DELISTED	Stock	59.0	59.0	59.0	59.0	300.0
2007-04-04	ABX-DELISTED	Stock	29.39	29.5552	29.17	29.32	4705883.0
2007-04-04	ACAD	Stock	16.43	17.08	15.51	15.6	1349200.0
2007-04-04	ACAP-DELISTED	Stock	39.42	39.74	38.71	39.0	57264.0
2007-04-04	ACAS-DELISTED	Stock	45.41	45.62	45.12	45.38	1686925.0
2007-04-04	ACAT-DELISTED	Stock	19.24	19.39	18.88	18.97	108906.0
2007-04-04	ACC-DELISTED	Stock	30.7	30.7	30.16	30.53	105900.0

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

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