PREVIEW / stock_daily / 2007-04-26

all stock daily files

  file:    by_date/stock_daily/2007/2007-04-26.parquet
  size:    164 KB
  rows:    4,955
  symbols: 3,116

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-26	AAPL	Stock	3.6279	3.6607	3.5107	3.53	1737778000.0
2007-04-26	MSFT	Stock	29.09	29.35	28.91	29.1	68760300.0
2007-04-26	NVDA	Stock	0.5518	0.5628	0.5468	0.5587	500070000.0
2007-04-26	AMZN	Stock	2.825	3.152	2.8035	3.139	1243590000.0
2007-04-26	TLT	Stock	88.43	88.43	87.85	87.85	2048304.0
2007-04-26	CL	Stock	33.595	33.69	33.255	33.28	7773200.0
2007-04-26	A	Stock	25.2432	25.3147	25.0501	25.0858	6102689.0
2007-04-26	AABA-DELISTED	Stock	27.9799995422363	28.6499996185303	27.7299995422363	28.4899997711182	32331000.0
2007-04-26	AACC-DELISTED	Stock	18.63	18.92	18.37	18.6	423322.0
2007-04-26	AACQ-DELISTED	Stock	4.65	4.65	4.55	4.59	1600.0
2007-04-26	AAI-DELISTED	Stock	11.69	11.88	11.56	11.6	2956686.0
2007-04-26	AAIC-DELISTED	Stock	111.8	119.0	110.0	118.6	3445200.0
2007-04-26	AAME	Stock	5.3	5.3	4.87	5.02	18000.0
2007-04-26	AAON	Stock	3.4765	3.5134	3.4199	3.4884	169341.0
2007-04-26	AAP	Stock	42.35	42.52	41.58	41.77	1188600.0
2007-04-26	AATI-DELISTED	Stock	7.79	7.87	7.54	7.63	983759.0
2007-04-26	AAU-DELISTED	Stock	2.55	2.6	2.5	2.5201	96900.0
2007-04-26	AAUAF-DELISTED	Stock	2.55	2.6	2.5	2.5201	96900.0
2007-04-26	AAV-DELISTED	Stock	11.41	11.41	11.2	11.22	640000.0
2007-04-26	AAWW-DELISTED	Stock	59.1	59.42	57.83	59.38	70910.0
2007-04-26	AAXN-DELISTED	Stock	8.1899995803833	8.28999996185303	8.0	8.01000022888184	1379000.0
2007-04-26	AB	Stock	91.25	94.5	89.3	92.38	433500.0
2007-04-26	ABAX-DELISTED	Stock	25.34	25.34	24.45	24.53	340549.0
2007-04-26	ABB-DELISTED	Stock	20.18	20.35	20.01	20.31	8745734.0
2007-04-26	ABBC-DELISTED	Stock	19.57	19.59	19.39	19.53	8957.0
2007-04-26	ABC-DELISTED	Stock	27.0	27.0	25.26	25.41	5743982.0
2007-04-26	ABCB	Stock	23.82	23.8881	23.1002	23.1488	22619.0
2007-04-26	ABCO-DELISTED	Stock	23.92	24.05	23.35	23.77	434252.0
2007-04-26	ABCW-DELISTED	Stock	28.27	28.27	27.77	28.12	31550.0
2007-04-26	ABD-DELISTED	Stock	24.23	24.55	23.99	24.31	719620.0
2007-04-26	ABE-DELISTED	Stock	22.25	22.25	21.6001	21.64	30900.0
2007-04-26	ABFS-DELISTED	Stock	41.41	41.5	39.7	40.0	907600.0
2007-04-26	ABG	Stock	29.51	29.82	29.28	29.57	709700.0
2007-04-26	ABK-DELISTED	Stock	90.87	93.03	90.87	92.72	1081225.0
2007-04-26	ABM	Stock	28.55	28.85	28.4	28.65	308700.0
2007-04-26	ABMD-DELISTED	Stock	13.8	13.8	13.33	13.45	83391.0
2007-04-26	ABP-DELISTED	Stock	3.34	3.35	3.27	3.32	257100.0
2007-04-26	ABR	Stock	31.55	32.13	31.38	31.72	90600.0
2007-04-26	ABT	Stock	26.8688	27.6557	26.7105	27.3054	11577949.0
2007-04-26	ABTL-DELISTED	Stock	16.825	16.875	16.375	16.775	19092.0
2007-04-26	ABV-DELISTED	Stock	59.87	59.96	58.94	59.33	421200.0
2007-04-26	ABVA-DELISTED	Stock	14.55	14.55	14.55	14.55	200.0
2007-04-26	ABVT-DELISTED	Stock	63.0	63.0	63.0	63.0	100.0
2007-04-26	ABX-DELISTED	Stock	28.5	28.6	28.31	28.36	5634512.0
2007-04-26	ACAD	Stock	14.21	14.21	13.85	13.89	363300.0
2007-04-26	ACAP-DELISTED	Stock	40.0	41.0	39.56	40.27	145254.0
2007-04-26	ACAS-DELISTED	Stock	48.3	48.74	47.9	48.52	1023987.0
2007-04-26	ACAT-DELISTED	Stock	18.16	18.28	17.76	18.22	54552.0
2007-04-26	ACC-DELISTED	Stock	30.9	31.08	30.85	30.96	69800.0
2007-04-26	ACCL-DELISTED	Stock	6.39	6.54	6.39	6.52	149544.0

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

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