PREVIEW / stock_daily / 2010-04-28

all stock daily files

  file:    by_date/stock_daily/2010/2010-04-28.parquet
  size:    192 KB
  rows:    5,956
  symbols: 3,508

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-04-28	AAPL	Stock	9.4018	9.4286	9.1575	9.3429	758402400.0
2010-04-28	MSFT	Stock	30.92	31.0	30.62	30.91	64557900.0
2010-04-28	NVDA	Stock	0.403	0.4098	0.3958	0.404	672164000.0
2010-04-28	AMZN	Stock	7.1295	7.1375	6.9345	6.9675	184706000.0
2010-04-28	TLT	Stock	91.13	91.35	90.481	90.7	8379444.0
2010-04-28	ES	Stock	27.18	27.4	26.95	27.33	2326300.0
2010-04-28	CL	Stock	41.98	42.57	41.585	42.5	6286000.0
2010-04-28	A	Stock	26.0873	26.3591	26.0372	26.2089	4384408.0
2010-04-28	AABA-DELISTED	Stock	16.98	17.0	16.63	16.75	26204364.0
2010-04-28	AACC-DELISTED	Stock	7.37	7.39	7.13	7.17	22011.0
2010-04-28	AACG	Stock	3.5	3.53	3.43	3.49	6400.0
2010-04-28	AAI-DELISTED	Stock	5.455	5.508	5.25	5.4	5556964.0
2010-04-28	AAIC-DELISTED	Stock	20.53	20.65	20.3	20.62	37477.0
2010-04-28	AAME	Stock	1.65	1.84	1.65	1.82	14900.0
2010-04-28	AAON	Stock	4.5728	4.8395	4.5728	4.7546	863156.0
2010-04-28	AAP	Stock	45.49	45.96	45.14	45.53	1195400.0
2010-04-28	AATI-DELISTED	Stock	3.88	4.03	3.85	3.94	1211597.0
2010-04-28	AAU-DELISTED	Stock	1.18	1.23	1.13	1.13	465719.0
2010-04-28	AAUAF-DELISTED	Stock	1.18	1.23	1.13	1.13	466119.0
2010-04-28	AAV-DELISTED	Stock	7.19	7.3	7.12	7.2	405462.0
2010-04-28	AAWW-DELISTED	Stock	57.29	57.74	56.18	56.48	332024.0
2010-04-28	AAXJ	Stock	57.44	57.44	56.41	56.94	185579.0
2010-04-28	AAXN-DELISTED	Stock	4.99	4.99	4.8	4.81	1490992.0
2010-04-28	AB	Stock	31.8	32.29	31.39	31.49	386300.0
2010-04-28	ABAX-DELISTED	Stock	26.66	27.19	26.6201	26.76	95000.0
2010-04-28	ABB-DELISTED	Stock	19.58	19.67	18.75	19.26	6402696.0
2010-04-28	ABBC-DELISTED	Stock	9.25	9.63	9.15	9.57	77941.0
2010-04-28	ABBNY-DELISTED	Stock	19.58	19.67	18.75	19.28	6472198.0
2010-04-28	ABC-DELISTED	Stock	30.91	31.15	30.68	30.81	3079907.0
2010-04-28	ABCB	Stock	10.9578	11.1569	10.7986	11.0673	108112.0
2010-04-28	ABCD-DELISTED	Stock	5.22	5.43	5.06	5.21	27379.0
2010-04-28	ABCO-DELISTED	Stock	16.613	16.917	16.613	16.807	49008.0
2010-04-28	ABCW-DELISTED	Stock	1.18	1.25	1.07	1.08	305540.0
2010-04-28	ABD-DELISTED	Stock	9.05	9.38	8.89	9.12	509290.0
2010-04-28	ABE-DELISTED	Stock	17.07	17.07	16.73	16.87	38179.0
2010-04-28	ABEO	Stock	3312.5	3375.0	3225.0	3312.5	47.0
2010-04-28	ABFS-DELISTED	Stock	31.43	31.71	29.43	29.47	805575.0
2010-04-28	ABG	Stock	14.46	14.57	13.92	13.97	291300.0
2010-04-28	ABII-DELISTED	Stock	50.72	50.76	50.16	50.36	17701.0
2010-04-28	ABK-DELISTED	Stock	1.75	1.77	1.66	1.71	27444873.0
2010-04-28	ABM	Stock	21.88	21.98	21.75	21.89	224300.0
2010-04-28	ABMD-DELISTED	Stock	9.26	9.33	9.15	9.23	178637.0
2010-04-28	ABR	Stock	4.21	4.23	3.81	3.99	256300.0
2010-04-28	ABT	Stock	23.9612	24.1915	23.7069	24.1195	19404544.0
2010-04-28	ABTL-DELISTED	Stock	4.3974	5.0027	4.2022	4.9526	33384.0
2010-04-28	ABV-DELISTED	Stock	97.49	97.85	94.86	95.66	465073.0
2010-04-28	ABVA-DELISTED	Stock	3.32	3.32	3.1	3.2	3400.0
2010-04-28	ABVT-DELISTED	Stock	49.78	50.46	49.3	49.91	93540.0
2010-04-28	ABX-DELISTED	Stock	41.63	42.8	41.35	42.18	20605293.0
2010-04-28	ACAD	Stock	1.61	1.64	1.55	1.59	416400.0

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

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