PREVIEW / stock_daily / 2009-09-18

all stock daily files

  file:    by_date/stock_daily/2009/2009-09-18.parquet
  size:    188 KB
  rows:    5,863
  symbols: 3,490

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
2009-09-18	AAPL	Stock	6.6368	6.6625	6.5986	6.6079	601582800.0
2009-09-18	MSFT	Stock	25.46	25.48	25.1	25.26	68016500.0
2009-09-18	NVDA	Stock	0.3848	0.3875	0.3775	0.3805	604740000.0
2009-09-18	AMZN	Stock	4.537	4.55	4.4735	4.514	135390000.0
2009-09-18	TLT	Stock	96.2	96.53	95.67	95.76	2813277.0
2009-09-18	ES	Stock	24.68	24.68	24.32	24.47	1926800.0
2009-09-18	CL	Stock	37.85	38.32	37.8	38.05	8068600.0
2009-09-18	A	Stock	20.5222	20.5508	19.8999	20.2933	6202507.0
2009-09-18	AABA-DELISTED	Stock	17.69	17.7	16.85	17.35	80729667.0
2009-09-18	AACC-DELISTED	Stock	7.86	7.86	7.438	7.78	89355.0
2009-09-18	AACG	Stock	6.78	6.85	6.74	6.74	4800.0
2009-09-18	AAI-DELISTED	Stock	6.73	6.73	6.4	6.63	2207002.0
2009-09-18	AAIC-DELISTED	Stock	9.8	10.2	9.4	9.4	455846.0
2009-09-18	AAME	Stock	0.82	0.85	0.8	0.81	33800.0
2009-09-18	AAON	Stock	4.16	4.1877	4.1323	4.1462	656100.0
2009-09-18	AAP	Stock	38.76	39.29	38.76	39.28	2637000.0
2009-09-18	AATI-DELISTED	Stock	4.37	4.43	4.2	4.25	492607.0
2009-09-18	AAU-DELISTED	Stock	0.67	0.7026	0.67	0.688	208720.0
2009-09-18	AAUAF-DELISTED	Stock	0.67	0.7	0.67	0.685	210787.0
2009-09-18	AAV-DELISTED	Stock	6.81	6.87	6.64	6.73	2345380.0
2009-09-18	AAWW-DELISTED	Stock	31.94	32.14	31.5	32.01	297239.0
2009-09-18	AAXJ	Stock	53.32	53.32	52.51	52.51	215723.0
2009-09-18	AAXN-DELISTED	Stock	4.7	4.76	4.63	4.74	465723.0
2009-09-18	AB	Stock	25.06	25.71	25.06	25.63	587000.0
2009-09-18	ABAX-DELISTED	Stock	28.9	28.94	28.53	28.73	164726.0
2009-09-18	ABB-DELISTED	Stock	20.37	20.5601	20.28	20.48	2539307.0
2009-09-18	ABBC-DELISTED	Stock	7.79	7.92	7.69	7.92	98194.0
2009-09-18	ABBNY-DELISTED	Stock	20.37	20.5601	20.28	20.48	2548240.0
2009-09-18	ABC-DELISTED	Stock	21.61	21.77	21.5	21.75	2891159.0
2009-09-18	ABCB	Stock	6.4875	6.6626	6.3221	6.6626	72380.0
2009-09-18	ABCO-DELISTED	Stock	13.423	13.553	13.302	13.407	171129.0
2009-09-18	ABCW-DELISTED	Stock	1.4321	1.4321	1.3195	1.34	97680.0
2009-09-18	ABD-DELISTED	Stock	7.29	7.29	6.94	7.14	907430.0
2009-09-18	ABE-DELISTED	Stock	17.59	17.59	17.145	17.27	7598.0
2009-09-18	ABEO	Stock	4312.5	4312.5	4062.5	4062.5	42.0
2009-09-18	ABFS-DELISTED	Stock	32.95	33.49	32.65	32.88	400998.0
2009-09-18	ABG	Stock	14.1	14.1	13.08	13.21	342400.0
2009-09-18	ABII-DELISTED	Stock	29.67	29.67	28.54	29.46	77292.0
2009-09-18	ABK-DELISTED	Stock	1.66	1.7	1.6	1.64	8666605.0
2009-09-18	ABM	Stock	20.97	21.44	20.72	21.38	429700.0
2009-09-18	ABMD-DELISTED	Stock	9.22	9.22	8.83	8.85	341634.0
2009-09-18	ABR	Stock	2.66	2.74	2.37	2.69	620900.0
2009-09-18	ABT	Stock	22.2963	22.2963	21.9748	22.0564	31271988.0
2009-09-18	ABTL-DELISTED	Stock	3.4471	3.7464	3.1524	3.1529	37369.0
2009-09-18	ABV-DELISTED	Stock	80.08	80.08	79.5	79.93	612866.0
2009-09-18	ABVA-DELISTED	Stock	2.51	2.51	2.51	2.51	650.0
2009-09-18	ABVT-DELISTED	Stock	44.25	46.09	44.01	45.88	393779.0
2009-09-18	ABX-DELISTED	Stock	38.11	38.26	36.66	37.0	18773427.0
2009-09-18	ACAD	Stock	1.95	1.97	1.92	1.94	924200.0
2009-09-18	ACAP-DELISTED	Stock	30.88	30.88	29.395	29.53	107735.0

> showing 50 of 5,863 rows — these rows as CSV

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