PREVIEW / stock_daily / 2014-12-10

all stock daily files

  file:    by_date/stock_daily/2014/2014-12-10.parquet
  size:    223 KB
  rows:    6,640
  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
2014-12-10	AAPL	Stock	28.6025	28.7125	27.885	27.9875	178261200.0
2014-12-10	MSFT	Stock	47.58	47.66	46.7	46.9	30431800.0
2014-12-10	NVDA	Stock	0.5168	0.5188	0.5062	0.5068	204364000.0
2014-12-10	AMZN	Stock	15.6	15.6595	15.234	15.292	64918000.0
2014-12-10	GOOGL	Stock	26.795	26.968	26.3745	26.402	46324080.0
2014-12-10	META	Stock	76.65	77.55	76.07	76.18	32210500.0
2014-12-10	TSLA	Stock	14.2753	14.4513	13.8467	13.9893	109711500.0
2014-12-10	TLT	Stock	123.18	124.4	123.08	124.11	6439191.0
2014-12-10	ES	Stock	52.31	52.6	51.62	51.65	1627700.0
2014-12-10	CL	Stock	69.42	69.69	68.82	68.87	2323100.0
2014-12-10	A	Stock	41.36	41.36	40.31	40.34	2650000.0
2014-12-10	AA.B-DELISTED	Stock	50.42	51.05	49.62	49.91	321534.0
2014-12-10	AABA-DELISTED	Stock	50.4	50.69	49.19	49.2	15220441.0
2014-12-10	AAC-DELISTED	Stock	32.08	32.76	28.578	29.49	78270.0
2014-12-10	AACG	Stock	3.47	3.47	3.38	3.42	4000.0
2014-12-10	AAIC-DELISTED	Stock	28.02	28.05	27.538	27.59	208862.0
2014-12-10	AAL	Stock	49.8	50.4	48.25	48.94	18500000.0
2014-12-10	AAMC-DELISTED	Stock	130.8441	131.1765	126.3294	129.6824	37414.0
2014-12-10	AAME	Stock	3.82	3.88	3.81	3.87	4100.0
2014-12-10	AAMI	Stock	15.87	16.155	15.72	15.96	297000.0
2014-12-10	AAOI	Stock	10.19	10.19	9.58	9.77	395100.0
2014-12-10	AAON	Stock	14.3867	14.6	14.0867	14.1	210150.0
2014-12-10	AAP	Stock	158.16	159.12	156.81	157.24	658000.0
2014-12-10	AAT	Stock	39.83	39.93	39.12	39.44	169100.0
2014-12-10	AAU-DELISTED	Stock	1.07	1.07	1.02	1.02	56357.0
2014-12-10	AAUAF-DELISTED	Stock	1.05	1.05	1.0	1.02	57938.0
2014-12-10	AAV-DELISTED	Stock	4.45	4.54	4.36	4.44	303424.0
2014-12-10	AAVL-DELISTED	Stock	47.0	47.04	45.52	46.77	112638.0
2014-12-10	AAWW-DELISTED	Stock	46.36	47.55	46.1	46.68	276823.0
2014-12-10	AAXJ	Stock	61.49	61.49	60.71	60.75	847130.0
2014-12-10	AAXN-DELISTED	Stock	23.14	23.73	22.3	22.52	3544126.0
2014-12-10	AB	Stock	24.86	25.23	24.15	24.6	583400.0
2014-12-10	ABAC-DELISTED	Stock	1.9901	2.01	1.96	2.0	15050.0
2014-12-10	ABAX-DELISTED	Stock	57.19	57.39	55.4	55.6	84893.0
2014-12-10	ABB-DELISTED	Stock	21.39	21.415	21.1	21.2	1551574.0
2014-12-10	ABBNY-DELISTED	Stock	21.39	21.415	21.1	21.2	1652366.0
2014-12-10	ABBV	Stock	69.44	69.44	67.53	67.58	8575700.0
2014-12-10	ABC-DELISTED	Stock	91.92	92.28	90.81	90.95	1120912.0
2014-12-10	ABCB	Stock	25.76	25.9	25.18	25.27	90200.0
2014-12-10	ABCD-DELISTED	Stock	1.65	1.7	1.65	1.66	6855.0
2014-12-10	ABCO-DELISTED	Stock	38.13	38.74	37.47	37.76	243719.0
2014-12-10	ABDC-DELISTED	Stock	12.09	12.14	12.06	12.08	58390.0
2014-12-10	ABE-DELISTED	Stock	13.87	13.93	13.65	13.7029	9604.0
2014-12-10	ABEO	Stock	165.0	172.5	160.0	172.5	92.0
2014-12-10	ABEV	Stock	6.04	6.08	5.97	6.03	12454600.0
2014-12-10	ABG	Stock	76.53	77.81	75.56	75.59	418800.0
2014-12-10	ABGB-DELISTED	Stock	12.47	12.49	12.0999	12.22	40399.0
2014-12-10	ABIL-DELISTED	Stock	9.8	9.93	9.78	9.93	700.0
2014-12-10	ABM	Stock	27.97	27.99	27.22	27.22	258300.0
2014-12-10	ABMD-DELISTED	Stock	37.76	37.92	36.73	36.795	322642.0

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

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