PREVIEW / stock_daily / 2007-04-25

all stock daily files

  file:    by_date/stock_daily/2007/2007-04-25.parquet
  size:    165 KB
  rows:    4,939
  symbols: 3,109

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-25	AAPL	Stock	3.3654	3.4071	3.35	3.4054	1187144000.0
2007-04-25	MSFT	Stock	28.86	29.0	28.69	28.99	39475000.0
2007-04-25	NVDA	Stock	0.5417	0.5548	0.5392	0.5518	509640000.0
2007-04-25	AMZN	Stock	2.656	2.859	2.6475	2.8405	2086584000.0
2007-04-25	TLT	Stock	88.57	88.79	88.11	88.49	569000.0
2007-04-25	CL	Stock	34.3	34.495	33.54	33.72	6581200.0
2007-04-25	A	Stock	25.3076	25.3791	25.1574	25.1574	5173439.0
2007-04-25	AABA-DELISTED	Stock	28.2199993133545	28.2700004577637	27.6800003051758	28.0599994659424	35568600.0
2007-04-25	AACC-DELISTED	Stock	17.44	19.0	17.44	18.75	1235529.0
2007-04-25	AACQ-DELISTED	Stock	4.58	4.59	4.58	4.59	2250.0
2007-04-25	AACQW-DELISTED	Stock	0.65	0.65	0.64	0.65	4000.0
2007-04-25	AAI-DELISTED	Stock	12.0	12.1	11.61	11.72	3750570.0
2007-04-25	AAIC-DELISTED	Stock	123.2	123.2	115.6	117.6	2761400.0
2007-04-25	AAME	Stock	5.26	5.43	5.22	5.32	20400.0
2007-04-25	AAON	Stock	3.4041	3.5108	3.362	3.4858	133650.0
2007-04-25	AAP	Stock	43.0	43.62	42.13	42.26	1986300.0
2007-04-25	AATI-DELISTED	Stock	7.26	7.58	7.26	7.51	981892.0
2007-04-25	AAU-DELISTED	Stock	2.54	2.59	2.51	2.57	88400.0
2007-04-25	AAUAF-DELISTED	Stock	2.54	2.59	2.51	2.57	88400.0
2007-04-25	AAV-DELISTED	Stock	11.45	11.5	11.42	11.5	854900.0
2007-04-25	AAWW-DELISTED	Stock	59.05	59.5	58.92	59.01	95159.0
2007-04-25	AAXN-DELISTED	Stock	8.22000026702881	8.38000011444092	7.92000007629395	8.1899995803833	2773800.0
2007-04-25	AB	Stock	93.25	94.65	92.23	92.98	429600.0
2007-04-25	ABAX-DELISTED	Stock	25.07	25.74	24.68	25.25	255274.0
2007-04-25	ABB-DELISTED	Stock	19.19	19.54	19.17	19.47	3519360.0
2007-04-25	ABBC-DELISTED	Stock	19.43	19.74	19.43	19.57	9451.0
2007-04-25	ABC-DELISTED	Stock	27.5	28.22	25.78	26.15	10093604.0
2007-04-25	ABCB	Stock	23.8978	24.0534	23.6935	23.8784	15730.0
2007-04-25	ABCO-DELISTED	Stock	25.03	25.03	23.8	24.0	753069.0
2007-04-25	ABCW-DELISTED	Stock	27.96	28.4	27.87	28.32	39200.0
2007-04-25	ABD-DELISTED	Stock	24.3	24.46	24.21	24.25	918310.0
2007-04-25	ABE-DELISTED	Stock	21.5	22.27	21.365	21.55	35700.0
2007-04-25	ABFS-DELISTED	Stock	42.25	44.97	41.03	41.52	2555809.0
2007-04-25	ABG	Stock	29.0	29.4	28.14	29.26	1158900.0
2007-04-25	ABK-DELISTED	Stock	91.0	94.85	90.88	92.48	1624746.0
2007-04-25	ABM	Stock	28.08	28.87	28.03	28.55	309000.0
2007-04-25	ABMD-DELISTED	Stock	13.72	13.83	13.66	13.83	87893.0
2007-04-25	ABP-DELISTED	Stock	3.14	3.42	3.14	3.36	381800.0
2007-04-25	ABR	Stock	31.76	31.92	31.5	31.58	29300.0
2007-04-25	ABT	Stock	27.4686	27.7084	27.4302	27.6173	8261150.0
2007-04-25	ABTL-DELISTED	Stock	17.451	17.551	16.849	17.049	25099.0
2007-04-25	ABV-DELISTED	Stock	59.25	60.42	59.18	59.75	362600.0
2007-04-25	ABVA-DELISTED	Stock	14.53	14.67	14.41	14.57	1300.0
2007-04-25	ABVT-DELISTED	Stock	63.0	63.0	57.0	63.0	11781.0
2007-04-25	ABX-DELISTED	Stock	28.57	28.95	28.45	28.86	4146655.0
2007-04-25	ACAD	Stock	14.38	14.47	14.0	14.22	372000.0
2007-04-25	ACAP-DELISTED	Stock	39.06	39.82	38.82	39.5	33440.0
2007-04-25	ACAS-DELISTED	Stock	47.83	48.27	47.78	48.14	1180182.0
2007-04-25	ACAT-DELISTED	Stock	18.37	18.48	18.18	18.22	49610.0
2007-04-25	ACC-DELISTED	Stock	31.03	31.19	30.27	30.92	85500.0

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

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