PREVIEW / stock_daily / 2014-03-10

all stock daily files

  file:    by_date/stock_daily/2014/2014-03-10.parquet
  size:    216 KB
  rows:    6,472
  symbols: 3,527

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-10	AAPL	Stock	18.87	19.0475	18.8693	18.9614	178584000.0
2014-03-10	MSFT	Stock	37.99	38.01	37.72	37.82	19006600.0
2014-03-10	NVDA	Stock	0.4575	0.4595	0.4502	0.4522	300888000.0
2014-03-10	AMZN	Stock	18.6345	18.6365	18.35	18.5265	42116000.0
2014-03-10	META	Stock	70.77	72.15	70.51	72.03	59871600.0
2014-03-10	TSLA	Stock	16.18	16.2	15.7373	15.9227	115921500.0
2014-03-10	TLT	Stock	105.94	106.105	105.775	106.04	3744495.0
2014-03-10	ES	Stock	43.73	43.73	43.29	43.5	1094500.0
2014-03-10	CL	Stock	62.94	63.2	62.86	63.05	1955500.0
2014-03-10	A	Stock	41.6953	41.731	41.2017	41.5951	3583633.0
2014-03-10	AABA-DELISTED	Stock	38.59	38.785	37.9101	38.06	11413999.0
2014-03-10	AACG	Stock	4.76	4.86	4.49	4.54	72900.0
2014-03-10	AAIC-DELISTED	Stock	26.87	27.21	26.71	27.15	102571.0
2014-03-10	AAL	Stock	38.7	39.88	38.55	38.96	11413500.0
2014-03-10	AAMC-DELISTED	Stock	243.5294	244.1176	233.6324	236.7441	103047.0
2014-03-10	AAME	Stock	3.96	3.96	3.85	3.85	10800.0
2014-03-10	AAOI	Stock	25.31	27.52	25.05	27.42	108800.0
2014-03-10	AAON	Stock	13.6	13.7111	13.3333	13.5333	159075.0
2014-03-10	AAP	Stock	126.82	127.87	125.96	126.78	612800.0
2014-03-10	AAT	Stock	32.89	33.01	32.51	32.76	135000.0
2014-03-10	AAU-DELISTED	Stock	1.522	1.525	1.48	1.49	266581.0
2014-03-10	AAUAF-DELISTED	Stock	1.54	1.5429	1.49	1.49	266874.0
2014-03-10	AAV-DELISTED	Stock	4.1	4.13	4.0	4.01	118904.0
2014-03-10	AAWW-DELISTED	Stock	31.9	32.53	31.71	32.52	190456.0
2014-03-10	AAXJ	Stock	57.86	57.99	57.58	57.97	515193.0
2014-03-10	AAXN-DELISTED	Stock	18.91	19.525	18.65	19.5	1120537.0
2014-03-10	AB	Stock	23.78	24.22	23.78	23.91	271100.0
2014-03-10	ABAC-DELISTED	Stock	2.11	2.13	2.03	2.05	28960.0
2014-03-10	ABAX-DELISTED	Stock	39.16	39.706	38.76	39.29	81613.0
2014-03-10	ABB-DELISTED	Stock	25.4	25.4	25.17	25.32	1287704.0
2014-03-10	ABBNY-DELISTED	Stock	25.4	25.4	25.17	25.34	1910929.0
2014-03-10	ABBV	Stock	51.9	51.9	50.86	51.66	3086000.0
2014-03-10	ABC-DELISTED	Stock	68.91	69.65	68.75	69.095	1141881.0
2014-03-10	ABCB	Stock	21.48	21.73	21.13	21.56	39600.0
2014-03-10	ABCD-DELISTED	Stock	2.1	2.1	1.98	2.05	70789.0
2014-03-10	ABCO-DELISTED	Stock	67.28	68.39	66.82	68.1	309790.0
2014-03-10	ABE-DELISTED	Stock	12.55	12.62	12.47	12.55	17254.0
2014-03-10	ABEO	Stock	462.5	462.5	462.5	462.5	32.0
2014-03-10	ABEV	Stock	7.16	7.16	6.98	7.05	6170800.0
2014-03-10	ABFS-DELISTED	Stock	37.21	37.3	36.5675	37.17	258161.0
2014-03-10	ABG	Stock	54.72	55.22	54.37	55.02	280000.0
2014-03-10	ABGB-DELISTED	Stock	24.7	24.7	24.0001	24.15	18790.0
2014-03-10	ABIL-DELISTED	Stock	9.62	9.62	9.62	9.62	138.0
2014-03-10	ABM	Stock	28.47	28.56	28.27	28.56	201800.0
2014-03-10	ABMD-DELISTED	Stock	29.4	29.89	29.2601	29.7	302649.0
2014-03-10	ABR	Stock	6.88	6.91	6.73	6.8	64700.0
2014-03-10	ABR.A-DELISTED	Stock	24.44	24.44	24.26	24.41	405.0
2014-03-10	ABR.B-DELISTED	Stock	22.9999	23.0	22.8901	22.8901	9342.0
2014-03-10	ABR.C-DELISTED	Stock	24.5	24.5	24.2999	24.4	12054.0
2014-03-10	ABT	Stock	39.5	39.89	39.41	39.82	5576300.0

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

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