PREVIEW / stock_daily / 2014-05-08

all stock daily files

  file:    by_date/stock_daily/2014/2014-05-08.parquet
  size:    218 KB
  rows:    6,518
  symbols: 3,539

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-08	AAPL	Stock	21.0089	21.2289	20.9429	20.9996	230297200.0
2014-05-08	MSFT	Stock	39.34	39.9	38.97	39.64	32120400.0
2014-05-08	NVDA	Stock	0.455	0.4698	0.4528	0.4625	432728000.0
2014-05-08	AMZN	Stock	14.541	14.794	14.3615	14.416	76964000.0
2014-05-08	GOOGL	Stock	25.786	26.3675	25.723	26.0085	49043940.0
2014-05-08	META	Stock	57.23	58.82	56.5	56.76	61251000.0
2014-05-08	TSLA	Stock	12.1333	12.96	11.8667	11.906	300849000.0
2014-05-08	TLT	Stock	112.34	112.76	111.46	111.6	10878828.0
2014-05-08	ES	Stock	46.99	47.17	46.36	46.47	1251600.0
2014-05-08	CL	Stock	67.14	67.36	66.88	67.1	1714000.0
2014-05-08	A	Stock	39.3634	40.1574	39.1202	39.5565	3088322.0
2014-05-08	AABA-DELISTED	Stock	33.88	34.5701	33.61	33.915	28231828.0
2014-05-08	AACG	Stock	4.26	4.35	4.26	4.34	1700.0
2014-05-08	AAIC-DELISTED	Stock	26.29	26.3499	25.95	26.03	272008.0
2014-05-08	AAL	Stock	37.25	38.25	37.05	38.25	14450100.0
2014-05-08	AAMC-DELISTED	Stock	250.5853	252.9412	232.9676	235.2794	64097.0
2014-05-08	AAME	Stock	3.4	3.64	3.23	3.59	5600.0
2014-05-08	AAOI	Stock	19.5	20.01	18.01	19.0	222000.0
2014-05-08	AAON	Stock	13.6756	13.96	13.3689	13.4222	317025.0
2014-05-08	AAP	Stock	120.02	123.1	119.65	122.46	1001400.0
2014-05-08	AAT	Stock	34.56	34.7	34.12	34.58	190800.0
2014-05-08	AAU-DELISTED	Stock	1.3	1.32	1.3	1.3	38095.0
2014-05-08	AAUAF-DELISTED	Stock	1.3	1.32	1.3	1.3	38645.0
2014-05-08	AAV-DELISTED	Stock	6.3	6.42	6.04	6.09	685566.0
2014-05-08	AAWW-DELISTED	Stock	36.15	36.77	35.63	35.8	256303.0
2014-05-08	AAXJ	Stock	59.46	59.75	59.37	59.44	196329.0
2014-05-08	AAXN-DELISTED	Stock	13.05	13.5	13.01	13.14	1707856.0
2014-05-08	AB	Stock	24.03	24.03	23.36	23.51	504100.0
2014-05-08	ABAC-DELISTED	Stock	2.0	2.1	2.0	2.0545	27872.0
2014-05-08	ABAX-DELISTED	Stock	40.01	41.18	39.83	39.94	50529.0
2014-05-08	ABB-DELISTED	Stock	23.35	23.3764	23.09	23.16	2290382.0
2014-05-08	ABBNY-DELISTED	Stock	23.35	23.3764	23.09	23.15	4824587.0
2014-05-08	ABBV	Stock	52.69	53.09	51.96	52.15	4092100.0
2014-05-08	ABC-DELISTED	Stock	64.39	65.255	64.195	64.42	1412244.0
2014-05-08	ABCB	Stock	20.23	20.49	19.99	20.2	148400.0
2014-05-08	ABCD-DELISTED	Stock	2.17	2.24	2.17	2.19	9106.0
2014-05-08	ABCO-DELISTED	Stock	52.13	54.02	51.06	51.27	353906.0
2014-05-08	ABE-DELISTED	Stock	13.68	13.7599	13.68	13.69	6063.0
2014-05-08	ABEO	Stock	562.5	562.5	525.0	550.0	6.0
2014-05-08	ABEV	Stock	7.35	7.42	7.29	7.34	10265800.0
2014-05-08	ABG	Stock	61.11	63.54	61.1	61.36	274300.0
2014-05-08	ABGB-DELISTED	Stock	22.46	22.5064	22.19	22.19	8663.0
2014-05-08	ABM	Stock	26.78	27.1	26.43	26.48	199300.0
2014-05-08	ABMD-DELISTED	Stock	21.12	21.69	20.29	20.9	358757.0
2014-05-08	ABR	Stock	7.09	7.09	7.0	7.02	80100.0
2014-05-08	ABR.A-DELISTED	Stock	25.28	25.31	25.18	25.23	3349.0
2014-05-08	ABR.B-DELISTED	Stock	24.0	24.069	23.9199	24.0	10888.0
2014-05-08	ABR.C-DELISTED	Stock	25.3299	25.389	25.26	25.3498	12690.0
2014-05-08	ABT	Stock	38.69	38.96	38.55	38.73	3962800.0
2014-05-08	ABTL-DELISTED	Stock	10.98	11.28	10.55	10.67	137863.0

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

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