PREVIEW / stock_daily / 2012-06-11

all stock daily files

  file:    by_date/stock_daily/2012/2012-06-11.parquet
  size:    198 KB
  rows:    6,170
  symbols: 3,531

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-11	AAPL	Stock	20.99	21.0179	20.3796	20.3989	591264800.0
2012-06-11	MSFT	Stock	29.73	29.81	28.82	28.9	46361900.0
2012-06-11	NVDA	Stock	0.3128	0.3183	0.3058	0.3065	839080000.0
2012-06-11	AMZN	Stock	10.8745	11.0435	10.76	10.825	74982000.0
2012-06-11	META	Stock	27.18	28.07	26.84	27.01	28219600.0
2012-06-11	TSLA	Stock	2.0207	2.0667	1.9307	1.9413	9540000.0
2012-06-11	TLT	Stock	124.79	126.21	124.77	125.78	10693793.0
2012-06-11	ES	Stock	37.47	37.82	37.3	37.32	1658900.0
2012-06-11	CL	Stock	50.275	50.34	49.935	49.995	3559800.0
2012-06-11	A	Stock	28.6481	28.7196	27.8398	27.8827	2853038.0
2012-06-11	AABA-DELISTED	Stock	15.73	15.73	15.27	15.3	16852033.0
2012-06-11	AACC-DELISTED	Stock	5.92	5.93	5.57	5.67	44547.0
2012-06-11	AACG	Stock	5.01	5.1	5.0	5.1	3900.0
2012-06-11	AAIC-DELISTED	Stock	22.52	22.52	21.89	21.91	67333.0
2012-06-11	AAME	Stock	2.72	2.74	2.63	2.74	2000.0
2012-06-11	AAMRQ-DELISTED	Stock	0.444	0.45	0.44	0.442	340262.0
2012-06-11	AAON	Stock	5.9259	5.9259	5.68	5.7037	166725.0
2012-06-11	AAP	Stock	74.87	74.87	72.11	72.17	946600.0
2012-06-11	AAT	Stock	23.86	23.86	22.89	22.93	176500.0
2012-06-11	AAU-DELISTED	Stock	2.19	2.23	2.16	2.18	152562.0
2012-06-11	AAUAF-DELISTED	Stock	2.21	2.2501	2.18	2.18	160168.0
2012-06-11	AAV-DELISTED	Stock	2.86	2.93	2.68	2.68	525109.0
2012-06-11	AAWW-DELISTED	Stock	46.55	47.37	43.66	43.68	306828.0
2012-06-11	AAXJ	Stock	51.42	51.43	50.42	50.46	274820.0
2012-06-11	AAXN-DELISTED	Stock	5.3	5.3707	5.26	5.26	435052.0
2012-06-11	AB	Stock	12.07	12.08	11.8	11.91	1001000.0
2012-06-11	ABAC-DELISTED	Stock	1.51	1.51	1.42	1.46	801.0
2012-06-11	ABAX-DELISTED	Stock	32.79	32.97	32.27	32.7	125847.0
2012-06-11	ABB-DELISTED	Stock	16.54	16.56	16.08	16.11	2339449.0
2012-06-11	ABBNY-DELISTED	Stock	16.54	16.56	16.08	16.11	2349319.0
2012-06-11	ABC-DELISTED	Stock	37.29	37.29	36.46	36.47	1548269.0
2012-06-11	ABCB	Stock	11.85	11.85	11.28	11.29	40400.0
2012-06-11	ABCD-DELISTED	Stock	1.39	1.39	1.3	1.3	32456.0
2012-06-11	ABCO-DELISTED	Stock	48.0	48.14	47.27	47.35	290106.0
2012-06-11	ABCW-DELISTED	Stock	0.5321	0.5321	0.4026	0.4026	39080.0
2012-06-11	ABE-DELISTED	Stock	18.07	18.07	17.77	17.83	10970.0
2012-06-11	ABEO	Stock	862.5	950.0	825.0	937.5	23.0
2012-06-11	ABFS-DELISTED	Stock	12.4	12.4	11.92	11.92	143278.0
2012-06-11	ABG	Stock	25.75	25.79	24.13	24.18	226000.0
2012-06-11	ABM	Stock	20.86	21.01	20.3	20.3	375900.0
2012-06-11	ABMD-DELISTED	Stock	22.39	23.01	21.14	21.19	577125.0
2012-06-11	ABR	Stock	5.4	5.4	5.3	5.31	118600.0
2012-06-11	ABT	Stock	29.7812	29.8436	29.5029	29.5125	8332013.0
2012-06-11	ABTL-DELISTED	Stock	3.9368	4.004	3.85	3.85	19083.0
2012-06-11	ABUS	Stock	2.0	2.06	2.0	2.0	9500.0
2012-06-11	ABV-DELISTED	Stock	37.4	37.53	36.01	36.05	2561222.0
2012-06-11	ABVA-DELISTED	Stock	4.3	4.35	4.25	4.34	3962.0
2012-06-11	ABVT-DELISTED	Stock	83.55	83.68	83.52	83.63	205766.0
2012-06-11	ABX-DELISTED	Stock	39.3	39.36	38.27	38.32	7419316.0
2012-06-11	ACAD	Stock	1.36	1.4	1.34	1.38	193000.0

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

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