PREVIEW / stock_daily / 2010-06-16

all stock daily files

  file:    by_date/stock_daily/2010/2010-06-16.parquet
  size:    189 KB
  rows:    5,910
  symbols: 3,481

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-06-16	AAPL	Stock	9.325	9.5625	9.3082	9.5446	783678000.0
2010-06-16	MSFT	Stock	26.47	26.58	26.23	26.32	48698000.0
2010-06-16	NVDA	Stock	0.296	0.2988	0.2902	0.2942	366480000.0
2010-06-16	AMZN	Stock	6.2695	6.399	6.268	6.345	79286000.0
2010-06-16	TLT	Stock	97.19	97.22	96.39	97.06	4011079.0
2010-06-16	ES	Stock	26.39	26.73	26.32	26.65	1817600.0
2010-06-16	CL	Stock	40.09	40.375	40.09	40.315	2863400.0
2010-06-16	A	Stock	22.8827	23.4478	22.7396	23.3405	4280816.0
2010-06-16	AABA-DELISTED	Stock	15.58	15.65	15.3375	15.49	15769500.0
2010-06-16	AACC-DELISTED	Stock	4.54	4.61	4.48	4.57	77049.0
2010-06-16	AACG	Stock	3.47	3.5	3.38	3.38	1100.0
2010-06-16	AAI-DELISTED	Stock	5.86	5.8999	5.48	5.52	7100902.0
2010-06-16	AAIC-DELISTED	Stock	19.96	20.66	19.96	20.45	15119.0
2010-06-16	AAME	Stock	1.42	1.46	1.42	1.46	900.0
2010-06-16	AAON	Stock	4.7664	4.8494	4.7447	4.8237	273375.0
2010-06-16	AAP	Stock	52.14	52.33	51.58	51.98	885800.0
2010-06-16	AATI-DELISTED	Stock	3.75	3.8	3.71	3.72	437264.0
2010-06-16	AAU-DELISTED	Stock	0.95	0.96	0.92	0.92	26118.0
2010-06-16	AAUAF-DELISTED	Stock	0.95	0.96	0.92	0.92	26218.0
2010-06-16	AAV-DELISTED	Stock	6.9	7.08	6.86	6.98	788507.0
2010-06-16	AAWW-DELISTED	Stock	53.01	54.3	51.597	53.38	212142.0
2010-06-16	AAXJ	Stock	54.21	54.68	53.9	54.53	374695.0
2010-06-16	AAXN-DELISTED	Stock	4.15	4.18	4.055	4.14	941044.0
2010-06-16	AB	Stock	28.65	28.99	28.45	28.99	247700.0
2010-06-16	ABAX-DELISTED	Stock	23.14	23.5	22.93	22.93	121168.0
2010-06-16	ABB-DELISTED	Stock	18.345	18.51	18.32	18.44	3009112.0
2010-06-16	ABBC-DELISTED	Stock	8.8	8.98	8.8	8.93	56579.0
2010-06-16	ABBNY-DELISTED	Stock	18.345	18.51	18.32	18.44	3019634.0
2010-06-16	ABC-DELISTED	Stock	32.43	32.975	32.33	32.74	4586696.0
2010-06-16	ABCB	Stock	10.3308	10.5995	10.3308	10.4005	71238.0
2010-06-16	ABCD-DELISTED	Stock	4.43	4.45	4.32	4.41	9432.0
2010-06-16	ABCO-DELISTED	Stock	20.18	20.62	20.15	20.62	126841.0
2010-06-16	ABCW-DELISTED	Stock	0.72	0.7207	0.66	0.68	72760.0
2010-06-16	ABD-DELISTED	Stock	5.47	5.53	5.26	5.34	703410.0
2010-06-16	ABE-DELISTED	Stock	15.98	16.1632	15.98	16.11	9835.0
2010-06-16	ABEO	Stock	2950.0	3062.5	2875.0	3062.5	17.0
2010-06-16	ABFS-DELISTED	Stock	21.86	22.2	21.59	21.71	624155.0
2010-06-16	ABG	Stock	13.46	13.65	13.13	13.29	200300.0
2010-06-16	ABII-DELISTED	Stock	62.6	63.75	61.55	62.32	63275.0
2010-06-16	ABK-DELISTED	Stock	0.8595	0.8595	0.7405	0.7611	18229831.0
2010-06-16	ABM	Stock	22.04	22.45	21.92	22.29	306000.0
2010-06-16	ABMD-DELISTED	Stock	9.62	9.85	9.61	9.8	122779.0
2010-06-16	ABR	Stock	4.84	5.02	4.8	5.0	149100.0
2010-06-16	ABT	Stock	22.9296	23.4478	22.8721	23.4094	19606503.0
2010-06-16	ABTL-DELISTED	Stock	6.0502	6.3503	5.9002	6.2498	14997.0
2010-06-16	ABV-DELISTED	Stock	102.66	105.0	102.25	104.3	428121.0
2010-06-16	ABVA-DELISTED	Stock	2.65	2.65	2.65	2.65	5303.0
2010-06-16	ABVT-DELISTED	Stock	46.62	47.46	46.62	47.34	113527.0
2010-06-16	ABX-DELISTED	Stock	42.81	43.47	42.71	43.19	7011244.0
2010-06-16	ACAD	Stock	1.28	1.43	1.26	1.33	2174400.0

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

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