PREVIEW / stock_daily / 2009-03-04

all stock daily files

  file:    by_date/stock_daily/2009/2009-03-04.parquet
  size:    173 KB
  rows:    5,749
  symbols: 3,436

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-03-04	AAPL	Stock	3.2207	3.3132	3.1946	3.2561	741403600.0
2009-03-04	MSFT	Stock	16.12	16.4	15.89	16.12	69285100.0
2009-03-04	NVDA	Stock	0.2023	0.2175	0.2005	0.2115	1108668000.0
2009-03-04	AMZN	Stock	3.14	3.2895	3.12	3.2405	239218000.0
2009-03-04	TLT	Stock	101.49	102.25	101.16	102.12	3178305.0
2009-03-04	ES	Stock	20.36	20.64	20.0	20.29	1527400.0
2009-03-04	CL	Stock	28.94	29.715	28.56	29.3	7195200.0
2009-03-04	A	Stock	9.2418	9.6996	9.1059	9.5207	5427595.0
2009-03-04	AABA-DELISTED	Stock	12.72	13.49	12.51	13.14	23874977.0
2009-03-04	AACC-DELISTED	Stock	3.31	3.57	3.3	3.33	47804.0
2009-03-04	AACG	Stock	5.35	5.37	5.04	5.08	14000.0
2009-03-04	AAI-DELISTED	Stock	2.56	2.84	2.47	2.78	7511749.0
2009-03-04	AAIC-DELISTED	Stock	2.8	3.0	2.6	3.0	279136.0
2009-03-04	AAME	Stock	0.61	0.66	0.6	0.66	2100.0
2009-03-04	AAON	Stock	3.0262	3.1625	2.9788	3.1328	661669.0
2009-03-04	AAP	Stock	38.92	38.93	37.34	37.54	3222500.0
2009-03-04	AATI-DELISTED	Stock	3.1	3.37	3.1	3.28	248332.0
2009-03-04	AAU-DELISTED	Stock	0.7	0.74	0.7	0.72	38999.0
2009-03-04	AAUAF-DELISTED	Stock	0.7	0.74	0.7	0.72	39262.0
2009-03-04	AAV-DELISTED	Stock	1.93	2.14	1.93	2.1	1023218.0
2009-03-04	AAWW-DELISTED	Stock	12.31	12.44	11.7	12.04	232028.0
2009-03-04	AAXJ	Stock	28.04	29.2836	28.04	29.01	103127.0
2009-03-04	AAXN-DELISTED	Stock	3.35	3.52	3.25	3.5	1114421.0
2009-03-04	AB	Stock	11.28	11.95	10.92	11.6	580400.0
2009-03-04	ABAX-DELISTED	Stock	15.89	16.76	15.66	16.39	199776.0
2009-03-04	ABB-DELISTED	Stock	11.65	12.18	11.56	11.94	6386303.0
2009-03-04	ABBC-DELISTED	Stock	6.85	6.97	6.78	6.93	63981.0
2009-03-04	ABBNY-DELISTED	Stock	11.65	12.18	11.56	11.92	6386803.0
2009-03-04	ABC-DELISTED	Stock	15.3	15.72	15.075	15.52	4847628.0
2009-03-04	ABCB	Stock	3.8906	4.4741	3.8906	4.2213	33825.0
2009-03-04	ABCO-DELISTED	Stock	7.105	7.305	6.88	7.12	215932.0
2009-03-04	ABCW-DELISTED	Stock	0.5011	0.5625	0.45	0.45	298350.0
2009-03-04	ABD-DELISTED	Stock	1.2	1.4001	1.19	1.35	238210.0
2009-03-04	ABE-DELISTED	Stock	10.44	11.15	10.44	10.94	34828.0
2009-03-04	ABEO	Stock	1375.0	1687.5	1375.0	1687.5	3.0
2009-03-04	ABFS-DELISTED	Stock	16.44	17.84	16.27	17.46	883278.0
2009-03-04	ABG	Stock	2.63	2.69	2.41	2.45	199200.0
2009-03-04	ABII-DELISTED	Stock	59.15	64.86	59.15	59.5	26486.0
2009-03-04	ABK-DELISTED	Stock	0.44	0.48	0.37	0.45	12486168.0
2009-03-04	ABM	Stock	14.82	14.98	13.96	14.08	955100.0
2009-03-04	ABMD-DELISTED	Stock	6.06	6.23	5.8	5.85	613513.0
2009-03-04	ABR	Stock	0.68	0.71	0.66	0.69	228700.0
2009-03-04	ABT	Stock	22.3107	22.9632	21.8453	22.637	24659233.0
2009-03-04	ABTL-DELISTED	Stock	1.6	1.7	1.4	1.4	41690.0
2009-03-04	ABV-DELISTED	Stock	38.25	39.26	37.95	38.77	682224.0
2009-03-04	ABVA-DELISTED	Stock	1.65	2.2	1.545	2.19	26550.0
2009-03-04	ABVT-DELISTED	Stock	39.0	39.1	37.5	39.1	13200.0
2009-03-04	ABX-DELISTED	Stock	28.98	29.29	27.47	27.72	15279714.0
2009-03-04	ACAD	Stock	0.84	0.86	0.79	0.86	41900.0
2009-03-04	ACAP-DELISTED	Stock	39.46	41.06	39.13	40.28	69582.0

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

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