PREVIEW / stock_daily / 2007-03-06

all stock daily files

  file:    by_date/stock_daily/2007/2007-03-06.parquet
  size:    161 KB
  rows:    4,861
  symbols: 3,054

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-03-06	AAPL	Stock	3.1357	3.1539	3.1214	3.1496	723186800.0
2007-03-06	MSFT	Stock	27.8	27.94	27.65	27.83	49361800.0
2007-03-06	NVDA	Stock	0.4898	0.5132	0.4878	0.5077	805974000.0
2007-03-06	AMZN	Stock	1.8845	1.933	1.8705	1.929	256964000.0
2007-03-06	TLT	Stock	90.06	90.36	89.99	90.08	837400.0
2007-03-06	CL	Stock	33.405	33.5	33.15	33.295	4574600.0
2007-03-06	A	Stock	22.0601	22.1745	21.7454	22.0529	4189107.0
2007-03-06	AABA-DELISTED	Stock	30.8899993896484	31.0599994659424	30.5200004577637	30.7999992370605	33472600.0
2007-03-06	AACC-DELISTED	Stock	15.19	15.42	15.12	15.12	132833.0
2007-03-06	AACQ-DELISTED	Stock	4.8	4.8	4.67	4.67	4930.0
2007-03-06	AACQW-DELISTED	Stock	0.62	0.62	0.54	0.57	159500.0
2007-03-06	AAI-DELISTED	Stock	10.23	10.23	9.99	10.0	1956800.0
2007-03-06	AAIC-DELISTED	Stock	121.0	139.0	119.8	122.8	3273500.0
2007-03-06	AAME	Stock	3.24	3.44	3.22	3.31	7500.0
2007-03-06	AAON	Stock	3.4397	3.47	3.4239	3.4634	197437.0
2007-03-06	AAP	Stock	36.52	37.59	36.51	37.41	1085000.0
2007-03-06	AATI-DELISTED	Stock	5.81	6.19	5.81	6.09	271848.0
2007-03-06	AAU-DELISTED	Stock	2.17	2.33	2.14	2.29	144700.0
2007-03-06	AAUAF-DELISTED	Stock	2.17	2.33	2.14	2.29	144700.0
2007-03-06	AAV-DELISTED	Stock	10.11	10.21	10.09	10.1044	609700.0
2007-03-06	AAWW-DELISTED	Stock	47.66	48.51	47.2	47.27	73970.0
2007-03-06	AAXN-DELISTED	Stock	7.65999984741211	7.90000009536743	7.6399998664856	7.8899998664856	1484000.0
2007-03-06	AB	Stock	80.7	84.05	80.4	83.76	468400.0
2007-03-06	ABAX-DELISTED	Stock	21.42	22.27	21.22	22.15	227544.0
2007-03-06	ABB-DELISTED	Stock	16.23	16.3	16.05	16.25	3301800.0
2007-03-06	ABBC-DELISTED	Stock	19.44	19.5	19.2	19.25	7338.0
2007-03-06	ABC-DELISTED	Stock	25.52	26.26	25.52	26.2	2450400.0
2007-03-06	ABCB	Stock	23.2656	24.9482	23.2656	24.4911	75362.0
2007-03-06	ABCO-DELISTED	Stock	25.55	25.96	25.34	25.78	123599.0
2007-03-06	ABCW-DELISTED	Stock	27.46	28.19	27.46	27.99	72460.0
2007-03-06	ABD-DELISTED	Stock	21.29	21.48	21.18	21.36	465460.0
2007-03-06	ABE-DELISTED	Stock	16.5	17.18	16.5	17.07	55200.0
2007-03-06	ABFS-DELISTED	Stock	37.91	38.0	37.48	37.5	447486.0
2007-03-06	ABG	Stock	26.42	26.62	26.24	26.5	245500.0
2007-03-06	ABK-DELISTED	Stock	86.92	87.97	86.92	87.74	943500.0
2007-03-06	ABM	Stock	28.0	28.84	26.85	27.0	842800.0
2007-03-06	ABMD-DELISTED	Stock	13.19	13.36	12.94	13.22	82172.0
2007-03-06	ABP-DELISTED	Stock	2.85	2.98	2.81	2.97	199300.0
2007-03-06	ABR	Stock	28.7	29.65	28.7	29.42	180700.0
2007-03-06	ABT	Stock	25.4294	25.4678	25.1271	25.367	20521259.0
2007-03-06	ABTL-DELISTED	Stock	18.5	19.35	18.5	18.7	17320.0
2007-03-06	ABV-DELISTED	Stock	49.0	50.98	49.0	50.82	754100.0
2007-03-06	ABVA-DELISTED	Stock	15.75	15.891	15.5	15.5	5298.0
2007-03-06	ABX-DELISTED	Stock	28.33	28.59	28.06	28.32	7627700.0
2007-03-06	ACAD	Stock	6.77	7.07	6.77	6.99	142600.0
2007-03-06	ACAP-DELISTED	Stock	36.37	37.58	36.14	37.45	33863.0
2007-03-06	ACAS-DELISTED	Stock	41.64	43.52	41.51	43.06	3098034.0
2007-03-06	ACAT-DELISTED	Stock	18.925	19.005	18.575	18.875	51923.0
2007-03-06	ACC-DELISTED	Stock	28.78	29.77	28.71	29.58	187700.0
2007-03-06	ACCL-DELISTED	Stock	6.32	6.4	6.28	6.3	60135.0

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

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