PREVIEW / stock_daily / 2010-03-05

all stock daily files

  file:    by_date/stock_daily/2010/2010-03-05.parquet
  size:    190 KB
  rows:    5,936
  symbols: 3,503

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
2010-03-05	AAPL	Stock	7.6764	7.8464	7.6654	7.8196	899620400.0
2010-03-05	MSFT	Stock	28.66	28.68	28.42	28.59	56001800.0
2010-03-05	NVDA	Stock	0.4135	0.4322	0.4135	0.4293	632832000.0
2010-03-05	AMZN	Stock	6.4565	6.4725	6.3535	6.4455	135386000.0
2010-03-05	TLT	Stock	90.83	90.87	90.12	90.27	3823122.0
2010-03-05	ES	Stock	26.5	26.52	26.28	26.51	970100.0
2010-03-05	CL	Stock	42.19	42.195	41.825	42.105	5870000.0
2010-03-05	A	Stock	23.4835	23.784	23.3405	23.7196	7695291.0
2010-03-05	AABA-DELISTED	Stock	15.89	16.3833	15.89	16.06	21368013.0
2010-03-05	AACC-DELISTED	Stock	5.67	5.79	5.62	5.73	24822.0
2010-03-05	AACG	Stock	3.71	3.71	3.48	3.52	95000.0
2010-03-05	AAI-DELISTED	Stock	5.1	5.15	5.07	5.13	1787968.0
2010-03-05	AAIC-DELISTED	Stock	18.5	18.5	18.02	18.35	15012.0
2010-03-05	AAME	Stock	1.37	1.38	1.37	1.38	1400.0
2010-03-05	AAON	Stock	4.2844	4.2844	4.2035	4.2528	241987.0
2010-03-05	AAP	Stock	41.97	42.29	41.78	42.29	1914300.0
2010-03-05	AATI-DELISTED	Stock	3.38	3.45	3.35	3.39	237290.0
2010-03-05	AAU-DELISTED	Stock	0.9398	0.96	0.9283	0.93	90344.0
2010-03-05	AAUAF-DELISTED	Stock	0.9499	0.97	0.93	0.93	93383.0
2010-03-05	AAV-DELISTED	Stock	7.15	7.45	7.15	7.4	613473.0
2010-03-05	AAWW-DELISTED	Stock	49.96	50.95	48.91	49.12	814706.0
2010-03-05	AAXJ	Stock	54.64	54.94	54.2	54.94	149646.0
2010-03-05	AAXN-DELISTED	Stock	6.84	6.99	6.79	6.95	1048505.0
2010-03-05	AB	Stock	27.75	28.03	27.62	27.72	629800.0
2010-03-05	ABAX-DELISTED	Stock	26.0	26.15	25.83	26.13	115050.0
2010-03-05	ABB-DELISTED	Stock	20.86	21.13	20.82	21.1	2344481.0
2010-03-05	ABBC-DELISTED	Stock	8.15	8.2	8.11	8.14	43574.0
2010-03-05	ABBNY-DELISTED	Stock	20.86	21.13	20.82	21.11	2602281.0
2010-03-05	ABC-DELISTED	Stock	28.02	28.41	27.98	28.4	2714829.0
2010-03-05	ABCB	Stock	9.9557	10.1927	9.7877	9.8272	36855.0
2010-03-05	ABCD-DELISTED	Stock	3.6	3.62	3.58	3.6	397928.0
2010-03-05	ABCO-DELISTED	Stock	15.935	16.09	15.83	16.05	132698.0
2010-03-05	ABCW-DELISTED	Stock	1.1501	1.1897	1.1402	1.16	65790.0
2010-03-05	ABD-DELISTED	Stock	7.88	8.0	7.76	7.85	246930.0
2010-03-05	ABE-DELISTED	Stock	16.28	16.46	16.23	16.41	8758.0
2010-03-05	ABEO	Stock	3212.5	3312.5	3187.5	3312.5	5.0
2010-03-05	ABFS-DELISTED	Stock	27.01	28.12	26.9201	27.6	704381.0
2010-03-05	ABG	Stock	12.66	13.06	12.47	12.9	361500.0
2010-03-05	ABII-DELISTED	Stock	34.81	35.17	34.52	34.98	183230.0
2010-03-05	ABK-DELISTED	Stock	0.682	0.745	0.6752	0.7289	9718581.0
2010-03-05	ABM	Stock	19.82	20.13	19.67	20.02	561100.0
2010-03-05	ABMD-DELISTED	Stock	10.64	10.83	10.55	10.78	209845.0
2010-03-05	ABR	Stock	2.45	2.58	2.45	2.54	147400.0
2010-03-05	ABT	Stock	25.9764	26.0963	25.9668	26.0627	15291788.0
2010-03-05	ABTL-DELISTED	Stock	5.65	5.65	5.25	5.4	10426.0
2010-03-05	ABV-DELISTED	Stock	98.86	99.16	97.01	97.5	564969.0
2010-03-05	ABVA-DELISTED	Stock	2.54	2.69	2.5	2.5	1900.0
2010-03-05	ABVT-DELISTED	Stock	62.21	62.38	61.76	61.88	71576.0
2010-03-05	ABX-DELISTED	Stock	40.24	40.66	40.04	40.29	8182114.0
2010-03-05	ACAD	Stock	1.36	1.37	1.3	1.34	677200.0

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

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