PREVIEW / stock_daily / 2009-06-04

all stock daily files

  file:    by_date/stock_daily/2009/2009-06-04.parquet
  size:    181 KB
  rows:    5,777
  symbols: 3,451

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-06-04	AAPL	Stock	5.0046	5.1493	5.0014	5.1336	550634000.0
2009-06-04	MSFT	Stock	21.77	21.9	21.58	21.83	42330000.0
2009-06-04	NVDA	Stock	0.2635	0.2728	0.2632	0.2723	673180000.0
2009-06-04	AMZN	Stock	4.271	4.32	4.2285	4.276	109308000.0
2009-06-04	TLT	Stock	91.43	91.72	90.24	90.53	5438563.0
2009-06-04	ES	Stock	21.09	21.2	20.93	21.04	790000.0
2009-06-04	CL	Stock	35.345	35.66	35.075	35.66	10542800.0
2009-06-04	A	Stock	13.8698	14.4635	13.8698	14.3348	4408174.0
2009-06-04	AABA-DELISTED	Stock	16.4	16.71	16.04	16.67	18797030.0
2009-06-04	AACC-DELISTED	Stock	9.18	9.4	8.99	9.05	24629.0
2009-06-04	AACG	Stock	5.51	5.84	5.5	5.67	16100.0
2009-06-04	AAI-DELISTED	Stock	6.3	6.36	6.01	6.2	2618324.0
2009-06-04	AAIC-DELISTED	Stock	8.2	9.0	8.2	8.6	385416.0
2009-06-04	AAME	Stock	0.98	0.98	0.76	0.76	7800.0
2009-06-04	AAON	Stock	4.3259	4.3259	4.2351	4.2825	365512.0
2009-06-04	AAP	Stock	45.15	45.25	43.74	44.56	1526700.0
2009-06-04	AATI-DELISTED	Stock	4.8	4.85	4.65	4.85	311886.0
2009-06-04	AAU-DELISTED	Stock	0.78	0.84	0.78	0.8301	122832.0
2009-06-04	AAUAF-DELISTED	Stock	0.78	0.84	0.78	0.8301	123132.0
2009-06-04	AAV-DELISTED	Stock	4.36	4.74	4.35	4.73	873647.0
2009-06-04	AAWW-DELISTED	Stock	25.89	26.6	25.61	26.31	211920.0
2009-06-04	AAXJ	Stock	45.31	45.5599	44.88	45.5	617580.0
2009-06-04	AAXN-DELISTED	Stock	4.71	4.73	4.65	4.69	326809.0
2009-06-04	AB	Stock	19.9	20.34	19.71	20.18	366000.0
2009-06-04	ABAX-DELISTED	Stock	18.45	18.61	17.8804	18.27	243847.0
2009-06-04	ABB-DELISTED	Stock	16.72	16.86	16.5	16.77	2769160.0
2009-06-04	ABBC-DELISTED	Stock	9.03	9.26	9.015	9.19	50373.0
2009-06-04	ABBNY-DELISTED	Stock	16.72	16.86	16.5	16.76	2783926.0
2009-06-04	ABC-DELISTED	Stock	18.57	18.7	17.92	18.18	5347578.0
2009-06-04	ABCB	Stock	6.8085	7.0517	6.3903	7.0517	18403.0
2009-06-04	ABCO-DELISTED	Stock	12.765	12.845	12.46	12.565	273194.0
2009-06-04	ABCW-DELISTED	Stock	1.5496	1.6205	1.5496	1.58	88070.0
2009-06-04	ABD-DELISTED	Stock	3.18	3.4204	3.03	3.37	199670.0
2009-06-04	ABE-DELISTED	Stock	15.47	15.81	15.12	15.73	64966.0
2009-06-04	ABEO	Stock	2812.5	2812.5	2687.5	2750.0	31.0
2009-06-04	ABFS-DELISTED	Stock	29.66	29.66	28.79	29.53	401733.0
2009-06-04	ABG	Stock	10.98	10.98	9.81	10.58	385000.0
2009-06-04	ABII-DELISTED	Stock	41.9	42.71	41.03	41.76	28222.0
2009-06-04	ABK-DELISTED	Stock	1.29	1.33	1.28	1.33	5086640.0
2009-06-04	ABM	Stock	17.49	17.62	17.13	17.52	268600.0
2009-06-04	ABMD-DELISTED	Stock	6.47	6.85	6.47	6.85	554278.0
2009-06-04	ABR	Stock	1.6	1.8	1.6	1.77	356200.0
2009-06-04	ABT	Stock	21.6774	21.7349	21.2791	21.4711	16699041.0
2009-06-04	ABTL-DELISTED	Stock	2.023	2.2253	2.023	2.2	6790.0
2009-06-04	ABV-DELISTED	Stock	65.04	66.04	64.91	65.66	550318.0
2009-06-04	ABVT-DELISTED	Stock	71.95	74.0	71.0	72.0	87752.0
2009-06-04	ABX-DELISTED	Stock	37.03	38.05	36.95	37.66	7735262.0
2009-06-04	ACAD	Stock	1.98	2.47	1.98	2.37	879000.0
2009-06-04	ACAP-DELISTED	Stock	41.66	42.04	41.48	42.0	34813.0
2009-06-04	ACAS-DELISTED	Stock	2.84	2.97	2.78	2.96	2858086.0

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

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