PREVIEW / stock_daily / 2010-07-26

all stock daily files

  file:    by_date/stock_daily/2010/2010-07-26.parquet
  size:    190 KB
  rows:    5,955
  symbols: 3,501

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-07-26	AAPL	Stock	9.2857	9.2893	9.2039	9.26	420551600.0
2010-07-26	MSFT	Stock	25.86	26.2	25.8	26.1	67249900.0
2010-07-26	NVDA	Stock	0.2583	0.2648	0.2543	0.2638	683548000.0
2010-07-26	AMZN	Stock	5.913	5.93	5.744	5.92	222756000.0
2010-07-26	TSLA	Stock	1.4333	1.4333	1.3533	1.3967	13833000.0
2010-07-26	TLT	Stock	99.63	99.81	99.0	99.61	4856312.0
2010-07-26	ES	Stock	27.97	28.16	27.93	28.14	1189500.0
2010-07-26	CL	Stock	41.695	41.99	41.59	41.87	2953800.0
2010-07-26	A	Stock	20.9013	21.2232	20.8226	21.2017	2971729.0
2010-07-26	AABA-DELISTED	Stock	13.96	14.22	13.95	14.14	23160213.0
2010-07-26	AACC-DELISTED	Stock	4.51	4.8	4.51	4.66	49045.0
2010-07-26	AACG	Stock	3.07	3.25	2.98	3.05	4500.0
2010-07-26	AAI-DELISTED	Stock	4.74	4.78	4.6813	4.78	2690654.0
2010-07-26	AAIC-DELISTED	Stock	18.4	19.45	18.24	19.37	69359.0
2010-07-26	AAON	Stock	4.9383	5.1141	4.8869	5.1101	256669.0
2010-07-26	AAP	Stock	54.61	54.87	53.92	54.85	927700.0
2010-07-26	AATI-DELISTED	Stock	3.41	3.5	3.36	3.42	200829.0
2010-07-26	AAU-DELISTED	Stock	0.97	0.97	0.92	0.92	76566.0
2010-07-26	AAUAF-DELISTED	Stock	0.97	0.97	0.92	0.92	77066.0
2010-07-26	AAV-DELISTED	Stock	6.4	6.45	6.35	6.43	321647.0
2010-07-26	AAWW-DELISTED	Stock	57.5	60.0	57.01	59.99	537246.0
2010-07-26	AAXJ	Stock	55.84	56.46	55.72	56.42	688646.0
2010-07-26	AAXN-DELISTED	Stock	4.24	4.38	4.17	4.37	763504.0
2010-07-26	AB	Stock	26.62	27.5	26.54	26.82	335500.0
2010-07-26	ABAC-DELISTED	Stock	4.02	4.22	3.93	3.98	69070.0
2010-07-26	ABAX-DELISTED	Stock	18.64	19.13	18.36	19.06	189359.0
2010-07-26	ABB-DELISTED	Stock	20.07	20.39	19.96	20.32	4937578.0
2010-07-26	ABBC-DELISTED	Stock	9.01	9.16	8.97	9.08	59562.0
2010-07-26	ABBNY-DELISTED	Stock	20.07	20.39	19.96	20.35	6256980.0
2010-07-26	ABC-DELISTED	Stock	30.61	30.9	29.95	30.52	8750546.0
2010-07-26	ABCB	Stock	9.48	9.61	9.18	9.6	90300.0
2010-07-26	ABCD-DELISTED	Stock	3.37	3.4	3.32	3.4	26684.0
2010-07-26	ABCO-DELISTED	Stock	22.02	22.28	21.72	22.24	116750.0
2010-07-26	ABCW-DELISTED	Stock	0.58	0.65	0.56	0.61	99070.0
2010-07-26	ABD-DELISTED	Stock	5.3452	5.7648	5.3152	5.7648	352030.0
2010-07-26	ABE-DELISTED	Stock	17.27	17.3999	17.26	17.39	10143.0
2010-07-26	ABEO	Stock	2500.0	2500.0	2187.5	2312.5	16.0
2010-07-26	ABFS-DELISTED	Stock	22.77	23.7	22.62	23.49	347766.0
2010-07-26	ABG	Stock	12.45	12.76	12.15	12.75	267200.0
2010-07-26	ABII-DELISTED	Stock	74.6	75.07	74.55	74.9	387798.0
2010-07-26	ABK-DELISTED	Stock	0.7773	0.8695	0.75	0.869	19484866.0
2010-07-26	ABM	Stock	21.41	21.99	21.37	21.99	206600.0
2010-07-26	ABMD-DELISTED	Stock	11.29	11.52	11.24	11.46	154359.0
2010-07-26	ABR	Stock	6.22	6.22	6.04	6.2	162200.0
2010-07-26	ABT	Stock	23.4238	23.6877	23.4238	23.6254	12334514.0
2010-07-26	ABTL-DELISTED	Stock	5.35	5.45	5.2	5.25	7717.0
2010-07-26	ABV-DELISTED	Stock	107.74	108.11	106.77	107.99	572995.0
2010-07-26	ABVA-DELISTED	Stock	2.53	2.53	2.53	2.53	400.0
2010-07-26	ABVT-DELISTED	Stock	51.5	53.17	51.45	52.71	238743.0
2010-07-26	ABX-DELISTED	Stock	42.57	42.66	41.69	41.75	7814831.0

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

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