PREVIEW / stock_daily / 2009-02-18

all stock daily files

  file:    by_date/stock_daily/2009/2009-02-18.parquet
  size:    174 KB
  rows:    5,742
  symbols: 3,432

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-02-18	AAPL	Stock	3.3946	3.4232	3.3114	3.3704	684779200.0
2009-02-18	MSFT	Stock	18.22	18.45	18.0	18.12	54946900.0
2009-02-18	NVDA	Stock	0.1958	0.2075	0.1955	0.201	646252000.0
2009-02-18	AMZN	Stock	3.1135	3.139	3.026	3.1175	147320000.0
2009-02-18	TLT	Stock	106.06	106.56	104.3	104.7	2768774.0
2009-02-18	CL	Stock	30.76	30.875	30.25	30.445	5025200.0
2009-02-18	A	Stock	11.4449	12.3176	11.3519	11.4807	14968246.0
2009-02-18	AABA-DELISTED	Stock	12.08	12.53	12.07	12.21	12295774.0
2009-02-18	AACC-DELISTED	Stock	4.22	4.67	3.81	3.81	31479.0
2009-02-18	AACG	Stock	4.27	4.95	4.21	4.26	18100.0
2009-02-18	AAI-DELISTED	Stock	4.28	4.3706	4.11	4.12	2727877.0
2009-02-18	AAIC-DELISTED	Stock	4.4	4.452	4.0	4.0	215781.0
2009-02-18	AAME	Stock	0.67	0.9	0.67	0.9	10600.0
2009-02-18	AAON	Stock	3.2474	3.2474	3.0775	3.1032	475369.0
2009-02-18	AAP	Stock	32.22	33.08	31.83	32.63	3238800.0
2009-02-18	AATI-DELISTED	Stock	3.09	3.239	2.95	3.14	119876.0
2009-02-18	AAU-DELISTED	Stock	0.92	0.92	0.86	0.87	137589.0
2009-02-18	AAUAF-DELISTED	Stock	0.92	0.92	0.86	0.87	137689.0
2009-02-18	AAV-DELISTED	Stock	2.87	2.91	2.56	2.61	1227757.0
2009-02-18	AAWW-DELISTED	Stock	15.02	15.09	13.66	14.0	116107.0
2009-02-18	AAXJ	Stock	30.04	30.04	29.31	29.53	36792.0
2009-02-18	AAXN-DELISTED	Stock	4.9	4.99	4.6516	4.68	597055.0
2009-02-18	AB	Stock	14.35	14.74	13.62	13.94	652700.0
2009-02-18	ABAX-DELISTED	Stock	17.26	17.7	17.0	17.4	166160.0
2009-02-18	ABB-DELISTED	Stock	12.37	12.39	12.03	12.17	8412766.0
2009-02-18	ABBC-DELISTED	Stock	6.73	6.8	6.5	6.7	154396.0
2009-02-18	ABBNY-DELISTED	Stock	12.37	12.39	12.03	12.18	9244541.0
2009-02-18	ABC-DELISTED	Stock	18.16	18.22	17.89	18.04	2785112.0
2009-02-18	ABCB	Stock	5.7483	5.8845	4.9702	5.2814	33209.0
2009-02-18	ABCO-DELISTED	Stock	8.005	8.08	7.86	7.94	331982.0
2009-02-18	ABCW-DELISTED	Stock	1.2	1.26	0.83	1.06	425290.0
2009-02-18	ABD-DELISTED	Stock	1.3991	1.3991	1.2907	1.34	117300.0
2009-02-18	ABE-DELISTED	Stock	11.54	11.9	11.5	11.89	47416.0
2009-02-18	ABEO	Stock	1212.5	1237.5	1212.5	1237.5	21.0
2009-02-18	ABFS-DELISTED	Stock	21.69	21.69	20.7	20.96	363391.0
2009-02-18	ABG	Stock	3.63	3.63	3.18	3.18	156800.0
2009-02-18	ABII-DELISTED	Stock	69.61	72.4	68.48	72.33	15837.0
2009-02-18	ABK-DELISTED	Stock	1.36	1.36	1.12	1.21	22210784.0
2009-02-18	ABM	Stock	12.5	12.72	12.06	12.58	494600.0
2009-02-18	ABMD-DELISTED	Stock	8.37	8.38	7.98	8.07	251909.0
2009-02-18	ABR	Stock	1.46	1.58	1.25	1.25	128500.0
2009-02-18	ABT	Stock	25.986	26.1299	25.7317	26.0052	13083785.0
2009-02-18	ABTL-DELISTED	Stock	1.817	2.15	1.817	2.0	2180.0
2009-02-18	ABV-DELISTED	Stock	42.05	42.93	41.17	42.75	729790.0
2009-02-18	ABVA-DELISTED	Stock	2.89	3.0	2.65	2.8001	93290.0
2009-02-18	ABX-DELISTED	Stock	37.36	38.76	36.18	38.51	20748459.0
2009-02-18	ACAD	Stock	0.98	0.98	0.87	0.87	59000.0
2009-02-18	ACAP-DELISTED	Stock	46.73	47.85	46.16	46.33	50090.0
2009-02-18	ACAS-DELISTED	Stock	2.02	2.2	1.66	1.7	5993443.0
2009-02-18	ACAT-DELISTED	Stock	3.59	3.91	3.54	3.58	62541.0

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

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