PREVIEW / stock_daily / 2012-06-06

all stock daily files

  file:    by_date/stock_daily/2012/2012-06-06.parquet
  size:    199 KB
  rows:    6,192
  symbols: 3,547

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
2012-06-06	AAPL	Stock	20.2775	20.4946	20.1964	20.4093	401455600.0
2012-06-06	MSFT	Stock	28.88	29.37	28.81	29.35	46860500.0
2012-06-06	NVDA	Stock	0.304	0.3105	0.3018	0.3098	368968000.0
2012-06-06	AMZN	Stock	10.7315	10.92	10.726	10.882	54202000.0
2012-06-06	META	Stock	26.07	27.17	25.52	26.81	61489200.0
2012-06-06	TSLA	Stock	1.88	1.9633	1.876	1.948	13648500.0
2012-06-06	TLT	Stock	127.56	127.6	125.05	125.05	20808310.0
2012-06-06	ES	Stock	36.73	37.0	36.5	37.0	1760700.0
2012-06-06	CL	Stock	48.735	49.165	48.545	49.165	4058000.0
2012-06-06	A	Stock	27.7039	28.4478	27.4535	28.4478	5167987.0
2012-06-06	AABA-DELISTED	Stock	15.16	15.41	15.135	15.37	17631725.0
2012-06-06	AACC-DELISTED	Stock	5.67	5.8	5.66	5.75	80875.0
2012-06-06	AACG	Stock	5.71	5.71	5.31	5.65	1900.0
2012-06-06	AAIC-DELISTED	Stock	21.48	22.18	21.34	22.17	61733.0
2012-06-06	AAME	Stock	2.79	2.8	2.78	2.79	7900.0
2012-06-06	AAMRQ-DELISTED	Stock	0.4619	0.467	0.449	0.452	816063.0
2012-06-06	AAON	Stock	5.4993	5.7244	5.4844	5.7126	175163.0
2012-06-06	AAP	Stock	72.64	73.71	72.64	73.71	1023000.0
2012-06-06	AAT	Stock	23.38	23.65	23.28	23.58	210400.0
2012-06-06	AAU-DELISTED	Stock	2.4	2.44	2.21	2.28	208261.0
2012-06-06	AAUAF-DELISTED	Stock	2.4	2.44	2.21	2.31	208462.0
2012-06-06	AAV-DELISTED	Stock	2.79	2.97	2.79	2.97	428634.0
2012-06-06	AAWW-DELISTED	Stock	42.16	45.134	42.16	44.04	482205.0
2012-06-06	AAXJ	Stock	50.26	51.16	50.26	51.13	270063.0
2012-06-06	AAXN-DELISTED	Stock	5.18	5.34	5.18	5.33	423484.0
2012-06-06	AB	Stock	12.48	12.73	12.28	12.28	342900.0
2012-06-06	ABAC-DELISTED	Stock	1.38	1.44	1.35	1.4	8200.0
2012-06-06	ABAX-DELISTED	Stock	31.8	32.18	31.58	31.9	128416.0
2012-06-06	ABB-DELISTED	Stock	15.75	16.17	15.74	16.14	2447892.0
2012-06-06	ABBNY-DELISTED	Stock	15.75	16.17	15.74	16.13	2440375.0
2012-06-06	ABC-DELISTED	Stock	36.91	37.32	36.58	37.32	1612915.0
2012-06-06	ABCB	Stock	11.45	11.62	11.31	11.52	42500.0
2012-06-06	ABCD-DELISTED	Stock	1.29	1.3	1.2	1.2	51665.0
2012-06-06	ABCO-DELISTED	Stock	47.69	48.07	47.25	47.31	465574.0
2012-06-06	ABCW-DELISTED	Stock	0.5121	0.5121	0.4317	0.507	2720.0
2012-06-06	ABE-DELISTED	Stock	17.6	18.25	17.6	18.11	41426.0
2012-06-06	ABEO	Stock	887.5	975.0	887.5	962.5	8.0
2012-06-06	ABFS-DELISTED	Stock	11.91	12.36	11.89	12.3	254348.0
2012-06-06	ABG	Stock	24.29	25.37	24.17	25.33	296600.0
2012-06-06	ABM	Stock	20.92	21.53	20.77	21.53	449800.0
2012-06-06	ABMD-DELISTED	Stock	20.64	21.47	20.3701	21.39	729493.0
2012-06-06	ABR	Stock	5.85	6.07	5.65	5.71	182300.0
2012-06-06	ABT	Stock	29.0279	29.3014	28.74	29.287	13629012.0
2012-06-06	ABTL-DELISTED	Stock	3.8259	3.8776	3.7897	3.8	11296.0
2012-06-06	ABUS	Stock	1.99	1.99	1.93	1.99	4400.0
2012-06-06	ABV-DELISTED	Stock	36.34	37.32	35.96	37.3	5291010.0
2012-06-06	ABVA-DELISTED	Stock	4.31	4.31	4.29	4.3	3661.0
2012-06-06	ABVT-DELISTED	Stock	83.35	83.43	83.25	83.39	279661.0
2012-06-06	ABX-DELISTED	Stock	42.97	43.3	40.06	40.45	19479186.0
2012-06-06	ACAD	Stock	1.3	1.35	1.3	1.34	145500.0

> showing 50 of 6,192 rows — these rows as CSV

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