PREVIEW / stock_daily / 2014-03-14

all stock daily files

  file:    by_date/stock_daily/2014/2014-03-14.parquet
  size:    217 KB
  rows:    6,481
  symbols: 3,544

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-03-14	AAPL	Stock	18.8854	18.9604	18.6786	18.7389	237199200.0
2014-03-14	MSFT	Stock	37.65	38.14	37.51	37.7	27195600.0
2014-03-14	NVDA	Stock	0.439	0.4495	0.439	0.4455	460048000.0
2014-03-14	AMZN	Stock	18.64	18.9285	18.5775	18.687	88044000.0
2014-03-14	META	Stock	68.49	69.43	67.46	67.72	48227000.0
2014-03-14	TSLA	Stock	15.686	15.796	15.2213	15.398	124345500.0
2014-03-14	TLT	Stock	108.97	108.98	108.32	108.52	9238004.0
2014-03-14	ES	Stock	44.61	45.08	44.41	44.89	1247200.0
2014-03-14	CL	Stock	63.14	63.99	63.06	63.83	3620000.0
2014-03-14	A	Stock	39.7783	40.0429	39.5064	39.6567	2439790.0
2014-03-14	AABA-DELISTED	Stock	36.69	38.188	36.45	37.59	29756648.0
2014-03-14	AACG	Stock	4.31	4.31	4.11	4.11	22500.0
2014-03-14	AAIC-DELISTED	Stock	27.25	27.69	27.17	27.59	146046.0
2014-03-14	AAL	Stock	36.0	37.18	35.67	36.34	7198600.0
2014-03-14	AAMC-DELISTED	Stock	255.8794	257.3529	254.4147	255.3676	16674.0
2014-03-14	AAME	Stock	3.69	3.74	3.56	3.58	10100.0
2014-03-14	AAOI	Stock	26.07	26.3	25.05	25.4	88100.0
2014-03-14	AAON	Stock	12.08	12.3022	11.8889	12.2933	448200.0
2014-03-14	AAP	Stock	124.45	125.48	123.87	124.6	521600.0
2014-03-14	AAT	Stock	32.79	33.17	32.79	32.99	100000.0
2014-03-14	AAU-DELISTED	Stock	1.67	1.67	1.53	1.53	357685.0
2014-03-14	AAUAF-DELISTED	Stock	1.67	1.67	1.53	1.53	359730.0
2014-03-14	AAV-DELISTED	Stock	3.91	4.04	3.87	4.02	125009.0
2014-03-14	AAWW-DELISTED	Stock	31.97	32.46	31.671	31.85	133493.0
2014-03-14	AAXJ	Stock	56.73	57.16	56.66	56.73	490062.0
2014-03-14	AAXN-DELISTED	Stock	18.3	18.486	18.09	18.33	790807.0
2014-03-14	AB	Stock	24.09	25.12	23.95	24.0	596200.0
2014-03-14	ABAC-DELISTED	Stock	1.75	1.815	1.59	1.72	340785.0
2014-03-14	ABAX-DELISTED	Stock	38.23	38.74	38.12	38.32	53183.0
2014-03-14	ABB-DELISTED	Stock	24.6	24.78	24.58	24.63	1500061.0
2014-03-14	ABBNY-DELISTED	Stock	24.6	24.78	24.58	24.61	1586993.0
2014-03-14	ABBV	Stock	51.25	51.42	50.8	51.21	5466700.0
2014-03-14	ABC-DELISTED	Stock	67.66	67.95	67.4032	67.56	1585913.0
2014-03-14	ABCB	Stock	23.38	23.95	22.66	23.68	73400.0
2014-03-14	ABCD-DELISTED	Stock	2.13	2.19	2.13	2.14	9283.0
2014-03-14	ABCO-DELISTED	Stock	66.32	67.23	66.32	66.93	114362.0
2014-03-14	ABE-DELISTED	Stock	12.06	12.48	12.06	12.43	3814.0
2014-03-14	ABEO	Stock	512.5	562.5	512.5	550.0	22.0
2014-03-14	ABEV	Stock	6.91	7.01	6.88	6.93	6859900.0
2014-03-14	ABFS-DELISTED	Stock	35.46	35.938	34.7164	35.56	194282.0
2014-03-14	ABG	Stock	51.22	52.06	51.22	51.55	219200.0
2014-03-14	ABGB-DELISTED	Stock	21.55	21.8199	21.5	21.59	22455.0
2014-03-14	ABIL-DELISTED	Stock	9.64	9.64	9.63	9.63	400.0
2014-03-14	ABM	Stock	28.02	28.38	28.02	28.27	169100.0
2014-03-14	ABMD-DELISTED	Stock	26.72	27.016	25.889	26.01	524455.0
2014-03-14	ABR	Stock	6.71	6.74	6.66	6.74	40400.0
2014-03-14	ABR.A-DELISTED	Stock	24.49	24.49	24.349	24.35	889.0
2014-03-14	ABR.B-DELISTED	Stock	22.87	22.8918	22.8511	22.8511	1920.0
2014-03-14	ABR.C-DELISTED	Stock	24.6	24.68	24.6	24.65	20339.0
2014-03-14	ABT	Stock	39.19	39.52	38.91	38.97	7736000.0

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

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