PREVIEW / stock_daily / 2009-12-09

all stock daily files

  file:    by_date/stock_daily/2009/2009-12-09.parquet
  size:    186 KB
  rows:    5,847
  symbols: 3,459

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-12-09	AAPL	Stock	6.8314	7.0771	6.7968	7.0643	684782000.0
2009-12-09	MSFT	Stock	29.47	29.81	29.25	29.71	44713300.0
2009-12-09	NVDA	Stock	0.3868	0.3953	0.383	0.3922	671588000.0
2009-12-09	AMZN	Stock	6.73	6.7355	6.491	6.5655	252658000.0
2009-12-09	TLT	Stock	93.69	94.05	92.68	93.17	3494456.0
2009-12-09	ES	Stock	24.75	24.79	24.48	24.6	1875500.0
2009-12-09	CL	Stock	41.07	41.61	41.07	41.25	6148200.0
2009-12-09	A	Stock	21.1302	21.1302	20.7296	20.9227	4349597.0
2009-12-09	AABA-DELISTED	Stock	15.59	15.59	15.12	15.19	25010557.0
2009-12-09	AACC-DELISTED	Stock	6.05	6.09	6.0	6.0	27042.0
2009-12-09	AACG	Stock	4.82	4.91	4.82	4.91	900.0
2009-12-09	AAI-DELISTED	Stock	5.07	5.08	4.92	5.03	2051445.0
2009-12-09	AAIC-DELISTED	Stock	14.6	14.83	14.41	14.55	60380.0
2009-12-09	AAME	Stock	1.25	1.25	1.21	1.21	1000.0
2009-12-09	AAON	Stock	3.7314	3.7393	3.6622	3.6978	601425.0
2009-12-09	AAP	Stock	40.5	40.5	39.87	39.99	1652300.0
2009-12-09	AATI-DELISTED	Stock	3.66	3.66	3.53	3.58	382267.0
2009-12-09	AAU-DELISTED	Stock	1.18	1.2332	1.16	1.2	297345.0
2009-12-09	AAUAF-DELISTED	Stock	1.06	1.2	1.04	1.2	334255.0
2009-12-09	AAV-DELISTED	Stock	5.69	5.98	5.69	5.88	782277.0
2009-12-09	AAWW-DELISTED	Stock	35.51	36.81	35.24	35.69	626465.0
2009-12-09	AAXJ	Stock	55.19	55.55	54.97	55.55	162862.0
2009-12-09	AAXN-DELISTED	Stock	4.36	4.37	4.25	4.33	154237.0
2009-12-09	AB	Stock	26.14	26.41	25.53	25.9	287900.0
2009-12-09	ABAX-DELISTED	Stock	23.84	23.84	23.32	23.4	121273.0
2009-12-09	ABB-DELISTED	Stock	17.85	17.94	17.61	17.89	3948776.0
2009-12-09	ABBC-DELISTED	Stock	6.86	6.98	6.69	6.71	66936.0
2009-12-09	ABBNY-DELISTED	Stock	17.85	17.94	17.61	17.91	3952521.0
2009-12-09	ABC-DELISTED	Stock	24.17	24.5	24.14	24.48	3524481.0
2009-12-09	ABCB	Stock	6.5178	6.5178	6.4297	6.4884	52034.0
2009-12-09	ABCD-DELISTED	Stock	4.0	4.0	3.65	3.65	3000.0
2009-12-09	ABCO-DELISTED	Stock	13.168	13.193	12.937	13.168	45693.0
2009-12-09	ABCW-DELISTED	Stock	0.71	0.72	0.66	0.68	87160.0
2009-12-09	ABD-DELISTED	Stock	6.95	7.29	6.67	7.27	368870.0
2009-12-09	ABE-DELISTED	Stock	16.76	16.76	16.58	16.69	7629.0
2009-12-09	ABEO	Stock	3575.0	3750.0	3375.0	3625.0	19.0
2009-12-09	ABFS-DELISTED	Stock	28.65	29.2	27.93	28.41	505544.0
2009-12-09	ABG	Stock	11.62	11.64	11.15	11.63	365600.0
2009-12-09	ABII-DELISTED	Stock	37.63	37.67	37.05	37.49	19947.0
2009-12-09	ABK-DELISTED	Stock	0.82	0.8306	0.801	0.81	4363834.0
2009-12-09	ABM	Stock	19.95	20.13	19.6	19.72	123900.0
2009-12-09	ABMD-DELISTED	Stock	9.12	9.21	8.7	8.73	133879.0
2009-12-09	ABR	Stock	1.79	1.92	1.76	1.91	339500.0
2009-12-09	ABT	Stock	25.6693	25.7509	25.4966	25.7221	9618383.0
2009-12-09	ABTL-DELISTED	Stock	5.25	5.6995	5.0	5.35	12622.0
2009-12-09	ABV-DELISTED	Stock	97.11	97.97	95.89	96.96	712733.0
2009-12-09	ABVT-DELISTED	Stock	57.34	58.5	57.295	58.1	131616.0
2009-12-09	ABX-DELISTED	Stock	40.91	41.52	40.15	41.23	17091161.0
2009-12-09	ACAD	Stock	1.21	1.21	1.16	1.19	691400.0
2009-12-09	ACAP-DELISTED	Stock	28.29	28.42	27.74	28.18	58427.0

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

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