PREVIEW / stock_daily / 2014-12-05

all stock daily files

  file:    by_date/stock_daily/2014/2014-12-05.parquet
  size:    222 KB
  rows:    6,658
  symbols: 3,565

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-05	AAPL	Stock	28.9975	29.02	28.66	28.75	153275600.0
2014-12-05	MSFT	Stock	48.82	48.97	48.38	48.42	27313400.0
2014-12-05	NVDA	Stock	0.524	0.5295	0.5238	0.5268	165680000.0
2014-12-05	AMZN	Stock	15.84	15.8465	15.542	15.6315	65304000.0
2014-12-05	GOOGL	Stock	26.835	26.91	26.363	26.404	61402360.0
2014-12-05	META	Stock	75.8	76.76	75.36	76.36	24306400.0
2014-12-05	TSLA	Stock	15.2447	15.2927	14.8173	14.914	90954000.0
2014-12-05	TLT	Stock	121.57	121.6	120.52	121.09	8030737.0
2014-12-05	ES	Stock	51.27	51.5	51.02	51.33	1929300.0
2014-12-05	CL	Stock	69.25	69.38	68.56	69.37	2521900.0
2014-12-05	A	Stock	42.23	42.49	42.08	42.3	1019500.0
2014-12-05	AA.B-DELISTED	Stock	53.68	55.0	52.53	52.68	743923.0
2014-12-05	AABA-DELISTED	Stock	51.03	51.25	50.51	50.985	14851726.0
2014-12-05	AAC-DELISTED	Stock	30.7	32.13	30.7	31.71	42694.0
2014-12-05	AACG	Stock	3.29	3.45	3.11	3.11	15400.0
2014-12-05	AAIC-DELISTED	Stock	28.0	28.17	27.74	27.79	238836.0
2014-12-05	AAL	Stock	50.09	51.75	50.01	51.01	15588200.0
2014-12-05	AAMC-DELISTED	Stock	145.7471	145.7471	134.3971	145.5912	38291.0
2014-12-05	AAME	Stock	3.87	3.88	3.87	3.88	1700.0
2014-12-05	AAMI	Stock	15.53	16.0	15.53	15.79	117000.0
2014-12-05	AAOI	Stock	10.05	10.33	9.93	10.14	401000.0
2014-12-05	AAON	Stock	13.8267	14.2467	13.8267	14.1133	244800.0
2014-12-05	AAP	Stock	154.21	154.37	152.38	154.18	909200.0
2014-12-05	AAT	Stock	39.15	39.44	38.88	39.1	162700.0
2014-12-05	AAU-DELISTED	Stock	1.06	1.081	1.04	1.05	60380.0
2014-12-05	AAUAF-DELISTED	Stock	1.02	1.05	1.0	1.05	64510.0
2014-12-05	AAV-DELISTED	Stock	4.3	4.62	4.3	4.62	156346.0
2014-12-05	AAVL-DELISTED	Stock	42.38	44.35	42.29	43.5	126797.0
2014-12-05	AAWW-DELISTED	Stock	47.42	47.78	46.6	46.73	162989.0
2014-12-05	AAXJ	Stock	62.68	62.8	62.4675	62.77	1074773.0
2014-12-05	AAXN-DELISTED	Stock	24.5	25.02	24.1	24.81	4789657.0
2014-12-05	AB	Stock	26.0	26.31	25.5	25.97	572700.0
2014-12-05	ABAC-DELISTED	Stock	2.0504	2.06	2.0301	2.04	6221.0
2014-12-05	ABAX-DELISTED	Stock	57.3	58.055	56.876	57.46	124065.0
2014-12-05	ABB-DELISTED	Stock	21.65	21.83	21.63	21.76	1470266.0
2014-12-05	ABBNY-DELISTED	Stock	21.65	21.83	21.63	21.74	1712035.0
2014-12-05	ABBV	Stock	69.52	70.17	69.34	69.71	4360100.0
2014-12-05	ABC-DELISTED	Stock	92.38	92.56	91.86	92.21	623185.0
2014-12-05	ABCB	Stock	25.0	25.49	24.89	25.45	144400.0
2014-12-05	ABCD-DELISTED	Stock	1.66	1.72	1.66	1.69	12282.0
2014-12-05	ABCO-DELISTED	Stock	39.65	40.4	38.87	38.96	310093.0
2014-12-05	ABDC-DELISTED	Stock	12.57	12.69	12.5	12.53	32057.0
2014-12-05	ABE-DELISTED	Stock	13.99	14.14	13.8	14.01	15325.0
2014-12-05	ABEO	Stock	162.5	174.75	162.5	174.75	16.0
2014-12-05	ABEV	Stock	6.08	6.2	6.06	6.13	9529000.0
2014-12-05	ABG	Stock	77.18	78.3	76.68	76.95	203400.0
2014-12-05	ABGB-DELISTED	Stock	13.08	13.1	12.55	12.57	55397.0
2014-12-05	ABIL-DELISTED	Stock	9.83	9.92	9.83	9.92	9300.0
2014-12-05	ABM	Stock	27.14	27.5	27.14	27.32	244900.0
2014-12-05	ABMD-DELISTED	Stock	35.62	36.85	35.6	36.6	279997.0

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

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