PREVIEW / stock_daily / 2014-07-10

all stock daily files

  file:    by_date/stock_daily/2014/2014-07-10.parquet
  size:    220 KB
  rows:    6,604
  symbols: 3,579

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-07-10	AAPL	Stock	23.44	23.8875	23.38	23.76	158744000.0
2014-07-10	MSFT	Stock	41.37	42.0	41.05	41.69	21854700.0
2014-07-10	NVDA	Stock	0.4688	0.4772	0.465	0.4753	266308000.0
2014-07-10	AMZN	Stock	16.217	16.499	16.1325	16.396	53300000.0
2014-07-10	GOOGL	Stock	28.65	29.2625	28.605	29.002	28726520.0
2014-07-10	META	Stock	63.31	65.34	63.05	64.87	44422000.0
2014-07-10	TSLA	Stock	14.4787	14.8147	14.4027	14.6307	72958500.0
2014-07-10	TLT	Stock	113.54	113.66	112.82	112.86	7196938.0
2014-07-10	ES	Stock	45.72	46.3	45.67	46.04	1407400.0
2014-07-10	CL	Stock	69.33	69.72	69.3	69.42	2933900.0
2014-07-10	A	Stock	40.3505	40.5079	40.0644	40.4077	1662641.0
2014-07-10	AABA-DELISTED	Stock	34.33	34.97	34.1	34.93	16698323.0
2014-07-10	AACG	Stock	4.5	4.5	4.12	4.16	29800.0
2014-07-10	AAIC-DELISTED	Stock	26.48	26.8	26.4201	26.66	152173.0
2014-07-10	AAL	Stock	41.0	42.98	40.77	42.82	11827200.0
2014-07-10	AAMC-DELISTED	Stock	182.3529	195.6618	182.3529	193.2265	59826.0
2014-07-10	AAME	Stock	3.92	4.0	3.92	3.97	2400.0
2014-07-10	AAOI	Stock	22.54	23.07	22.33	22.69	169100.0
2014-07-10	AAON	Stock	14.2	14.5422	14.0756	14.4533	252675.0
2014-07-10	AAP	Stock	132.51	133.92	132.0	133.16	499100.0
2014-07-10	AAT	Stock	34.49	35.04	34.43	34.97	147000.0
2014-07-10	AAU-DELISTED	Stock	1.59	1.59	1.37	1.41	880130.0
2014-07-10	AAUAF-DELISTED	Stock	1.59	1.59	1.37	1.42	883044.0
2014-07-10	AAV-DELISTED	Stock	6.16	6.26	6.1	6.19	432742.0
2014-07-10	AAWW-DELISTED	Stock	35.08	35.16	34.11	34.81	186654.0
2014-07-10	AAXJ	Stock	62.86	63.61	62.86	63.61	323004.0
2014-07-10	AAXN-DELISTED	Stock	11.19	11.29	10.81	11.25	1770349.0
2014-07-10	AB	Stock	26.02	26.07	25.83	25.96	290500.0
2014-07-10	ABAC-DELISTED	Stock	2.04	2.08	2.04	2.04	11197.0
2014-07-10	ABAX-DELISTED	Stock	42.59	43.65	42.59	43.48	188658.0
2014-07-10	ABB-DELISTED	Stock	22.65	22.81	22.63	22.79	1508584.0
2014-07-10	ABBNY-DELISTED	Stock	22.65	22.81	22.63	22.79	2008273.0
2014-07-10	ABBV	Stock	54.5	55.88	54.28	55.79	7553100.0
2014-07-10	ABC-DELISTED	Stock	72.54	73.14	72.011	72.93	687917.0
2014-07-10	ABCB	Stock	21.47	21.72	21.12	21.52	46200.0
2014-07-10	ABCD-DELISTED	Stock	1.9601	2.07	1.9601	2.0	8197.0
2014-07-10	ABCO-DELISTED	Stock	51.2	51.35	50.25	50.82	180620.0
2014-07-10	ABDC-DELISTED	Stock	14.0	14.2	13.8	14.0	148137.0
2014-07-10	ABE-DELISTED	Stock	14.49	14.49	14.42	14.45	10194.0
2014-07-10	ABEO	Stock	337.5	350.0	337.5	350.0	3.0
2014-07-10	ABEV	Stock	7.11	7.13	6.99	7.03	15327400.0
2014-07-10	ABG	Stock	69.88	71.4	69.55	71.01	173900.0
2014-07-10	ABGB-DELISTED	Stock	25.24	25.471	25.098	25.35	8871.0
2014-07-10	ABM	Stock	25.78	26.23	25.62	26.09	263800.0
2014-07-10	ABMD-DELISTED	Stock	24.5	25.25	24.5	25.0	240265.0
2014-07-10	ABR	Stock	6.89	6.91	6.86	6.9	64400.0
2014-07-10	ABR.A-DELISTED	Stock	24.64	24.74	24.64	24.74	700.0
2014-07-10	ABR.C-DELISTED	Stock	25.19	25.2	25.08	25.163	5910.0
2014-07-10	ABRN-DELISTED	Stock	25.09	25.19	24.98	24.9975	4796.0
2014-07-10	ABT	Stock	41.03	41.3	40.92	41.24	4839200.0

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

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