PREVIEW / stock_daily / 2014-07-14

all stock daily files

  file:    by_date/stock_daily/2014/2014-07-14.parquet
  size:    221 KB
  rows:    6,617
  symbols: 3,589

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-14	AAPL	Stock	23.965	24.2225	23.9125	24.1125	171240000.0
2014-07-14	MSFT	Stock	42.22	42.45	42.04	42.14	21881100.0
2014-07-14	NVDA	Stock	0.4782	0.4835	0.4765	0.4822	272636000.0
2014-07-14	AMZN	Stock	17.3515	17.7885	17.268	17.766	112198000.0
2014-07-14	GOOGL	Stock	29.53	29.743	29.3346	29.713	39092240.0
2014-07-14	META	Stock	67.13	68.17	66.9	67.9	38537000.0
2014-07-14	TSLA	Stock	14.666	15.2527	14.3633	15.1133	108048000.0
2014-07-14	TLT	Stock	113.28	113.41	112.93	113.09	4743333.0
2014-07-14	ES	Stock	45.8	45.98	45.16	45.17	1265400.0
2014-07-14	CL	Stock	69.78	70.11	69.73	69.79	2198500.0
2014-07-14	A	Stock	40.7153	40.8226	40.5007	40.6438	2079944.0
2014-07-14	AABA-DELISTED	Stock	35.8	35.95	35.45	35.7	17522417.0
2014-07-14	AACG	Stock	4.35	4.4	4.2	4.26	1600.0
2014-07-14	AAIC-DELISTED	Stock	26.85	27.0	26.76	26.92	120055.0
2014-07-14	AAL	Stock	43.26	43.59	42.73	42.98	7214700.0
2014-07-14	AAMC-DELISTED	Stock	212.6412	224.5529	212.6412	216.8	90845.0
2014-07-14	AAME	Stock	3.9	4.0	3.88	4.0	20800.0
2014-07-14	AAOI	Stock	23.61	24.1	22.85	22.97	332500.0
2014-07-14	AAON	Stock	14.7333	14.7378	14.5022	14.5644	194175.0
2014-07-14	AAP	Stock	133.65	135.27	133.65	134.81	731500.0
2014-07-14	AAT	Stock	35.1	35.27	34.74	35.25	202100.0
2014-07-14	AAU-DELISTED	Stock	1.38	1.4461	1.38	1.4461	310803.0
2014-07-14	AAUAF-DELISTED	Stock	1.38	1.45	1.38	1.45	315545.0
2014-07-14	AAV-DELISTED	Stock	5.9	5.99	5.86	5.9	332148.0
2014-07-14	AAWW-DELISTED	Stock	34.84	34.95	34.45	34.82	129770.0
2014-07-14	AAXJ	Stock	63.68	63.85	63.68	63.79	404925.0
2014-07-14	AAXN-DELISTED	Stock	11.32	11.4	11.14	11.2	948308.0
2014-07-14	AB	Stock	27.17	27.35	27.0	27.27	324000.0
2014-07-14	ABAC-DELISTED	Stock	2.13	2.13	2.1	2.12	19300.0
2014-07-14	ABAX-DELISTED	Stock	43.44	43.68	43.0	43.39	154241.0
2014-07-14	ABB-DELISTED	Stock	23.03	23.04	22.86	22.86	1167208.0
2014-07-14	ABBNY-DELISTED	Stock	23.03	23.04	22.86	22.87	1255800.0
2014-07-14	ABBV	Stock	53.89	55.05	53.72	54.85	30823300.0
2014-07-14	ABC-DELISTED	Stock	73.32	73.5	72.85	73.08	588479.0
2014-07-14	ABCB	Stock	21.69	21.69	21.33	21.5	44300.0
2014-07-14	ABCD-DELISTED	Stock	2.0	2.06	1.99	2.05	25422.0
2014-07-14	ABCO-DELISTED	Stock	51.19	51.79	50.55	51.53	110562.0
2014-07-14	ABDC-DELISTED	Stock	14.05	14.3	13.88	13.96	100838.0
2014-07-14	ABE-DELISTED	Stock	14.4	14.6	14.4	14.51	24134.0
2014-07-14	ABEO	Stock	337.5	337.5	312.5	325.0	10.0
2014-07-14	ABEV	Stock	7.04	7.04	6.95	7.02	16725000.0
2014-07-14	ABG	Stock	71.68	72.17	71.08	71.34	156500.0
2014-07-14	ABGB-DELISTED	Stock	25.28	25.57	25.22	25.42	14007.0
2014-07-14	ABM	Stock	26.29	26.31	26.05	26.06	125500.0
2014-07-14	ABMD-DELISTED	Stock	25.09	25.27	24.89	25.07	86323.0
2014-07-14	ABR	Stock	6.88	7.0	6.88	6.93	96000.0
2014-07-14	ABR.A-DELISTED	Stock	24.8	24.8	24.7	24.7499	9040.0
2014-07-14	ABR.B-DELISTED	Stock	24.21	24.65	24.21	24.65	8072.0
2014-07-14	ABR.C-DELISTED	Stock	25.1701	25.1795	25.17	25.1795	886.0
2014-07-14	ABRN-DELISTED	Stock	25.02	25.02	24.95	25.0099	2966.0

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

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