PREVIEW / stock_daily / 2017-07-25

all stock daily files

  file:    by_date/stock_daily/2017/2017-07-25.parquet
  size:    215 KB
  rows:    6,482
  symbols: 2,980

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-25	AAPL	Stock	37.95	38.46	37.95	38.185	75415600.0
2017-07-25	MSFT	Stock	73.8	74.31	73.5	74.19	22018700.0
2017-07-25	NVDA	Stock	4.1305	4.1482	4.0895	4.1338	496556000.0
2017-07-25	AMZN	Stock	51.9025	52.1665	51.624	51.9935	48952000.0
2017-07-25	GOOGL	Stock	48.535	48.8365	48.19	48.4515	118672040.0
2017-07-25	META	Stock	165.01	165.54	163.86	165.28	15383200.0
2017-07-25	TSLA	Stock	23.0	23.04	22.2767	22.64	104838000.0
2017-07-25	TLT	Stock	124.14	124.19	123.47	123.57	9743266.0
2017-07-25	ES	Stock	60.78	60.82	60.38	60.48	886400.0
2017-07-25	CL	Stock	72.33	72.33	71.47	72.05	3923400.0
2017-07-25	A	Stock	61.57	61.66	60.38	60.54	1692000.0
2017-07-25	AA	Stock	37.07	37.38	36.865	37.3	3425500.0
2017-07-25	AAAP-DELISTED	Stock	42.21	42.41	40.0	41.85	71129.0
2017-07-25	AABA-DELISTED	Stock	57.98	58.365	57.865	58.035	2948527.0
2017-07-25	AAC-DELISTED	Stock	6.8	6.8	6.58	6.67	31410.0
2017-07-25	AACG	Stock	4.79	4.8	4.54	4.65	1400.0
2017-07-25	AAIC-DELISTED	Stock	13.24	13.25	12.63	12.82	1765931.0
2017-07-25	AAL	Stock	51.5	51.9	50.55	50.61	4484900.0
2017-07-25	AAM.A-DELISTED	Stock	26.05	26.1832	25.8	25.83	114748.0
2017-07-25	AAMC-DELISTED	Stock	27.5	27.6471	27.3529	27.3529	3274.0
2017-07-25	AAME	Stock	3.65	3.65	3.5	3.5	3100.0
2017-07-25	AAMI	Stock	15.04	15.17	15.01	15.06	488800.0
2017-07-25	AAOI	Stock	97.69	97.71	93.57	96.8	2911300.0
2017-07-25	AAON	Stock	23.6	23.8667	23.2333	23.3333	576000.0
2017-07-25	AAP	Stock	103.59	105.96	103.47	105.29	1249100.0
2017-07-25	AAT	Stock	39.78	40.19	39.21	40.09	334300.0
2017-07-25	AAU-DELISTED	Stock	1.22	1.25	1.2	1.25	143275.0
2017-07-25	AAUAF-DELISTED	Stock	1.22	1.25	1.2	1.25	145532.0
2017-07-25	AAV-DELISTED	Stock	6.95	7.15	6.925	7.05	98672.0
2017-07-25	AAWW-DELISTED	Stock	58.8	59.45	58.55	58.9	167247.0
2017-07-25	AAXJ	Stock	71.0	71.0	70.77	70.81	390587.0
2017-07-25	AAXN-DELISTED	Stock	25.42	25.521	25.18	25.42	336807.0
2017-07-25	AB	Stock	24.75	25.15	24.7	25.1	260700.0
2017-07-25	ABAC-DELISTED	Stock	2.2	2.2	2.1	2.1	1181.0
2017-07-25	ABAX-DELISTED	Stock	51.61	51.94	51.17	51.89	74359.0
2017-07-25	ABB-DELISTED	Stock	23.52	23.57	23.45	23.47	2191224.0
2017-07-25	ABBNY-DELISTED	Stock	23.53	23.57	23.45	23.47	2248554.0
2017-07-25	ABBV	Stock	74.4	74.55	72.47	72.52	6354200.0
2017-07-25	ABC-DELISTED	Stock	93.47	95.11	92.6	94.66	1172844.0
2017-07-25	ABCB	Stock	47.5	47.85	46.9	47.2	186300.0
2017-07-25	ABCD-DELISTED	Stock	4.91	4.98	4.81	4.87	22987.0
2017-07-25	ABCO-DELISTED	Stock	57.2	57.45	56.85	57.1	228920.0
2017-07-25	ABDC-DELISTED	Stock	12.16	12.25	12.05	12.06	130113.0
2017-07-25	ABE-DELISTED	Stock	13.87	14.2084	13.87	14.0896	5605.0
2017-07-25	ABEO	Stock	233.75	235.0	211.0	227.5	36028.0
2017-07-25	ABEOW-DELISTED	Stock	4.75	4.75	4.25	4.75	1045.0
2017-07-25	ABEV	Stock	5.96	6.0	5.9	5.92	13061200.0
2017-07-25	ABG	Stock	53.95	54.85	52.2	53.5	759700.0
2017-07-25	ABIL-DELISTED	Stock	0.9527	0.965	0.88	0.91	49817.0
2017-07-25	ABM	Stock	44.01	44.6	43.81	44.34	209900.0

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

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