PREVIEW / stock_daily / 2014-05-06

all stock daily files

  file:    by_date/stock_daily/2014/2014-05-06.parquet
  size:    217 KB
  rows:    6,506
  symbols: 3,529

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-05-06	AAPL	Stock	21.4929	21.5861	21.2289	21.2289	374564400.0
2014-05-06	MSFT	Stock	39.29	39.35	38.95	39.06	27112400.0
2014-05-06	NVDA	Stock	0.4702	0.4742	0.455	0.4562	416188000.0
2014-05-06	AMZN	Stock	15.4765	15.4905	14.852	14.869	93646000.0
2014-05-06	GOOGL	Stock	26.6705	26.7274	26.113	26.1285	36706360.0
2014-05-06	META	Stock	60.98	61.15	58.49	58.53	55901000.0
2014-05-06	TSLA	Stock	14.44	14.5773	13.79	13.8187	84550500.0
2014-05-06	TLT	Stock	112.11	112.7	112.04	112.48	6522638.0
2014-05-06	ES	Stock	46.5	46.68	46.3	46.4	1162500.0
2014-05-06	CL	Stock	66.63	67.15	66.61	66.71	2012900.0
2014-05-06	A	Stock	39.3991	39.6638	38.9557	39.3491	3109432.0
2014-05-06	AABA-DELISTED	Stock	36.94	37.165	36.48	36.5	18421272.0
2014-05-06	AAIC-DELISTED	Stock	26.15	26.1899	25.81	25.87	193628.0
2014-05-06	AAL	Stock	37.14	37.4	36.39	36.67	9492600.0
2014-05-06	AAMC-DELISTED	Stock	282.9412	283.5294	257.3529	260.5147	65793.0
2014-05-06	AAME	Stock	3.49	3.5	3.42	3.5	3500.0
2014-05-06	AAOI	Stock	21.4	21.46	20.89	20.9	133200.0
2014-05-06	AAON	Stock	13.9111	14.1111	13.5511	13.6578	371925.0
2014-05-06	AAP	Stock	120.7	121.59	119.84	120.49	628400.0
2014-05-06	AAT	Stock	33.99	34.16	33.76	33.92	135900.0
2014-05-06	AAU-DELISTED	Stock	1.37	1.39	1.34	1.35	54959.0
2014-05-06	AAUAF-DELISTED	Stock	1.36	1.38	1.34	1.36	55795.0
2014-05-06	AAV-DELISTED	Stock	6.41	6.45	6.31	6.38	322941.0
2014-05-06	AAWW-DELISTED	Stock	37.25	37.465	36.57	36.61	286117.0
2014-05-06	AAXJ	Stock	59.47	59.924	59.47	59.67	176320.0
2014-05-06	AAXN-DELISTED	Stock	14.28	14.28	13.18	13.21	1627304.0
2014-05-06	AB	Stock	24.81	24.91	24.3	24.44	283000.0
2014-05-06	ABAC-DELISTED	Stock	2.1101	2.1101	2.0501	2.0501	6900.0
2014-05-06	ABAX-DELISTED	Stock	40.5	41.13	39.798	40.1	80720.0
2014-05-06	ABB-DELISTED	Stock	23.44	23.47	23.3	23.33	2978612.0
2014-05-06	ABBNY-DELISTED	Stock	23.44	23.47	23.3	23.34	4028968.0
2014-05-06	ABBV	Stock	51.2	51.3	50.83	50.91	3353200.0
2014-05-06	ABC-DELISTED	Stock	64.71	65.0	64.57	64.78	1235332.0
2014-05-06	ABCB	Stock	20.76	20.97	20.03	20.04	146000.0
2014-05-06	ABCD-DELISTED	Stock	2.16	2.229	2.15	2.17	10549.0
2014-05-06	ABCO-DELISTED	Stock	56.35	57.07	55.38	55.53	149692.0
2014-05-06	ABE-DELISTED	Stock	13.6	13.69	13.58	13.61	8523.0
2014-05-06	ABEO	Stock	625.0	625.0	525.0	562.5	4.0
2014-05-06	ABEV	Stock	7.3	7.48	7.27	7.41	13317900.0
2014-05-06	ABG	Stock	62.85	62.91	61.2	61.5	281500.0
2014-05-06	ABGB-DELISTED	Stock	23.15	23.3	23.0048	23.0048	2248.0
2014-05-06	ABIL-DELISTED	Stock	9.74	9.8	9.74	9.76	800.0
2014-05-06	ABM	Stock	27.03	27.12	26.61	26.71	159500.0
2014-05-06	ABMD-DELISTED	Stock	22.11	22.48	21.86	21.99	469765.0
2014-05-06	ABR	Stock	7.14	7.14	7.05	7.06	60100.0
2014-05-06	ABR.A-DELISTED	Stock	25.1699	25.37	25.1699	25.37	5899.0
2014-05-06	ABR.B-DELISTED	Stock	24.01	24.16	24.0	24.04	11397.0
2014-05-06	ABR.C-DELISTED	Stock	25.34	25.444	25.34	25.35	13650.0
2014-05-06	ABT	Stock	38.76	38.82	38.53	38.58	4776500.0
2014-05-06	ABTL-DELISTED	Stock	12.235	12.45	11.97	11.98	206379.0

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

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