PREVIEW / stock_daily / 2014-11-19

all stock daily files

  file:    by_date/stock_daily/2014/2014-11-19.parquet
  size:    222 KB
  rows:    6,650
  symbols: 3,571

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-11-19	AAPL	Stock	28.86	28.935	28.45	28.6675	167476800.0
2014-11-19	MSFT	Stock	48.66	48.75	47.93	48.22	26177500.0
2014-11-19	NVDA	Stock	0.5025	0.504	0.495	0.5003	240300000.0
2014-11-19	AMZN	Stock	16.3625	16.42	16.201	16.327	65632000.0
2014-11-19	GOOGL	Stock	27.2375	27.411	26.9595	27.36	30345720.0
2014-11-19	META	Stock	74.01	74.54	73.11	73.33	25441200.0
2014-11-19	TSLA	Stock	16.7073	16.792	16.3733	16.516	118777500.0
2014-11-19	TLT	Stock	118.88	119.58	118.76	118.76	5792474.0
2014-11-19	ES	Stock	49.63	50.02	49.42	49.94	1267500.0
2014-11-19	CL	Stock	67.92	68.32	67.64	68.29	2136700.0
2014-11-19	A	Stock	40.82	41.33	40.7	40.8	4012100.0
2014-11-19	AA.B-DELISTED	Stock	53.0	53.0	51.92	52.13	79958.0
2014-11-19	AABA-DELISTED	Stock	51.22	51.37	50.0	50.58	27768565.0
2014-11-19	AAC-DELISTED	Stock	29.55	30.08	29.15	29.29	88088.0
2014-11-19	AACG	Stock	3.9	3.98	3.85	3.9	4900.0
2014-11-19	AAIC-DELISTED	Stock	27.35	27.44	27.22	27.39	173864.0
2014-11-19	AAL	Stock	44.83	45.4	44.04	44.1	11291100.0
2014-11-19	AAMC-DELISTED	Stock	145.0	145.2941	137.4	139.4118	70764.0
2014-11-19	AAME	Stock	3.85	3.88	3.81	3.88	4800.0
2014-11-19	AAMI	Stock	15.7	15.813	14.76	15.13	277300.0
2014-11-19	AAOI	Stock	12.63	12.63	12.19	12.33	317700.0
2014-11-19	AAON	Stock	13.82	13.82	13.2933	13.3733	403050.0
2014-11-19	AAP	Stock	146.0	146.15	144.08	144.74	813100.0
2014-11-19	AAT	Stock	38.78	38.79	38.29	38.54	123400.0
2014-11-19	AAU-DELISTED	Stock	1.13	1.13	1.05	1.08	190798.0
2014-11-19	AAUAF-DELISTED	Stock	1.13	1.13	1.05	1.08	191266.0
2014-11-19	AAV-DELISTED	Stock	4.87	4.93	4.712	4.84	206222.0
2014-11-19	AAVL-DELISTED	Stock	33.84	33.84	32.57	32.63	29113.0
2014-11-19	AAWW-DELISTED	Stock	41.89	42.3	41.01	42.15	176262.0
2014-11-19	AAXJ	Stock	61.78	61.98	61.5601	61.83	261639.0
2014-11-19	AAXN-DELISTED	Stock	20.08	20.3646	19.8	20.05	1683042.0
2014-11-19	AB	Stock	26.0	26.03	25.7	25.87	238200.0
2014-11-19	ABAC-DELISTED	Stock	2.27	2.29	2.24	2.2699	19593.0
2014-11-19	ABAX-DELISTED	Stock	54.45	54.45	53.78	54.02	125097.0
2014-11-19	ABB-DELISTED	Stock	22.67	22.7	22.5	22.59	1120522.0
2014-11-19	ABBNY-DELISTED	Stock	22.67	22.7	22.5	22.59	1175521.0
2014-11-19	ABBV	Stock	65.88	66.15	65.22	65.5	5710900.0
2014-11-19	ABC-DELISTED	Stock	89.44	89.9399	88.89	89.31	2058719.0
2014-11-19	ABCB	Stock	25.6	25.62	25.11	25.26	68300.0
2014-11-19	ABCO-DELISTED	Stock	43.36	43.87	41.64	41.69	326013.0
2014-11-19	ABCW-DELISTED	Stock	30.12	31.31	30.0	31.31	3800.0
2014-11-19	ABDC-DELISTED	Stock	12.61	12.7	12.45	12.46	32899.0
2014-11-19	ABE-DELISTED	Stock	13.8	13.8906	13.8	13.88	1658.0
2014-11-19	ABEO	Stock	164.75	177.5	162.75	177.5	200.0
2014-11-19	ABEV	Stock	6.39	6.46	6.26	6.43	13861400.0
2014-11-19	ABG	Stock	73.9	74.37	73.01	73.93	173600.0
2014-11-19	ABGB-DELISTED	Stock	15.48	15.4899	14.54	15.27	539337.0
2014-11-19	ABM	Stock	27.06	27.07	26.55	26.7	123800.0
2014-11-19	ABMD-DELISTED	Stock	34.96	34.98	34.45	34.6	273208.0
2014-11-19	ABR	Stock	6.89	6.89	6.78	6.78	26300.0

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

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