PREVIEW / stock_daily / 2017-07-11

all stock daily files

  file:    by_date/stock_daily/2017/2017-07-11.parquet
  size:    214 KB
  rows:    6,452
  symbols: 2,971

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
2017-07-11	AAPL	Stock	36.1825	36.4625	36.095	36.3825	79127200.0
2017-07-11	MSFT	Stock	70.0	70.68	69.75	69.99	17460000.0
2017-07-11	NVDA	Stock	3.8462	3.9048	3.8038	3.897	757956000.0
2017-07-11	AMZN	Stock	49.65	49.7995	49.186	49.7065	59654000.0
2017-07-11	GOOGL	Stock	47.526	47.7445	47.256	47.6765	29224940.0
2017-07-11	META	Stock	153.37	155.42	152.91	155.27	13667700.0
2017-07-11	TSLA	Stock	21.0667	21.8187	20.9533	21.8147	173391000.0
2017-07-11	TLT	Stock	122.86	123.33	122.71	123.11	4425579.0
2017-07-11	ES	Stock	59.98	60.1	59.55	59.82	1244600.0
2017-07-11	CL	Stock	73.09	73.1	72.34	72.4	3099000.0
2017-07-11	A	Stock	59.99	60.16	59.46	59.8	2976000.0
2017-07-11	AA	Stock	34.22	35.08	33.99	35.0	4244100.0
2017-07-11	AAAP-DELISTED	Stock	39.07	39.69	39.06	39.6445	50600.0
2017-07-11	AABA-DELISTED	Stock	54.89	55.35	54.59	55.27	6648033.0
2017-07-11	AAC-DELISTED	Stock	6.75	6.75	6.39	6.65	58837.0
2017-07-11	AACG	Stock	4.41	4.65	4.41	4.62	8700.0
2017-07-11	AAIC-DELISTED	Stock	13.7	13.78	13.675	13.74	208728.0
2017-07-11	AAL	Stock	52.58	52.66	51.47	51.61	4545700.0
2017-07-11	AAM.A-DELISTED	Stock	25.78	25.78	25.75	25.78	25011.0
2017-07-11	AAMC-DELISTED	Stock	26.7941	27.0588	26.6029	27.0585	10703.0
2017-07-11	AAME	Stock	3.7	3.7	3.55	3.55	800.0
2017-07-11	AAMI	Stock	15.41	15.435	15.24	15.26	289700.0
2017-07-11	AAOI	Stock	68.5	71.0	67.8	70.04	2988400.0
2017-07-11	AAON	Stock	24.8	25.0333	24.5	24.8667	244950.0
2017-07-11	AAP	Stock	101.15	101.93	99.37	100.25	1432900.0
2017-07-11	AAT	Stock	38.27	38.6	37.97	38.38	213000.0
2017-07-11	AAU-DELISTED	Stock	1.17	1.17	1.1	1.115	257438.0
2017-07-11	AAUAF-DELISTED	Stock	1.17	1.17	1.1	1.13	263006.0
2017-07-11	AAV-DELISTED	Stock	6.8	6.8	6.65	6.7	101073.0
2017-07-11	AAWW-DELISTED	Stock	56.35	58.35	55.8	58.05	835973.0
2017-07-11	AAXJ	Stock	67.92	68.18	67.76	68.13	444444.0
2017-07-11	AAXN-DELISTED	Stock	24.93	25.55	24.87	25.31	349404.0
2017-07-11	AB	Stock	24.05	24.25	23.8	24.0	212100.0
2017-07-11	ABAC-DELISTED	Stock	2.22	2.32	2.17	2.28	7678.0
2017-07-11	ABAX-DELISTED	Stock	52.37	52.75	51.9	52.46	116797.0
2017-07-11	ABB-DELISTED	Stock	24.62	24.92	24.59	24.87	1532908.0
2017-07-11	ABBNY-DELISTED	Stock	24.62	24.92	24.59	24.86	1932918.0
2017-07-11	ABBV	Stock	71.89	72.17	71.33	71.84	3535100.0
2017-07-11	ABC-DELISTED	Stock	92.65	92.65	91.15	92.16	761675.0
2017-07-11	ABCB	Stock	48.05	48.4	47.15	47.8	245400.0
2017-07-11	ABCD-DELISTED	Stock	4.95	5.06	4.88	4.98	12414.0
2017-07-11	ABCO-DELISTED	Stock	56.35	57.1	55.7	55.8	478353.0
2017-07-11	ABDC-DELISTED	Stock	13.53	13.5759	13.3364	13.35	56015.0
2017-07-11	ABE-DELISTED	Stock	13.82	14.0	13.82	14.0	793.0
2017-07-11	ABEO	Stock	227.5	231.25	216.25	230.0	42212.0
2017-07-11	ABEOW-DELISTED	Stock	7.08	7.08	4.94	5.0	12132.0
2017-07-11	ABEV	Stock	5.6	5.7	5.59	5.64	40935900.0
2017-07-11	ABG	Stock	54.8	55.85	54.65	55.45	160800.0
2017-07-11	ABIL-DELISTED	Stock	1.19	1.19	1.05	1.09	109390.0
2017-07-11	ABM	Stock	40.72	40.99	40.45	40.69	225000.0

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

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