PREVIEW / stock_daily / 2017-07-07

all stock daily files

  file:    by_date/stock_daily/2017/2017-07-07.parquet
  size:    213 KB
  rows:    6,434
  symbols: 2,972

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-07	AAPL	Stock	35.725	36.1875	35.725	36.045	76806800.0
2017-07-07	MSFT	Stock	68.7	69.84	68.7	69.46	16878300.0
2017-07-07	NVDA	Stock	3.6445	3.6875	3.6212	3.669	654972000.0
2017-07-07	AMZN	Stock	48.4775	49.0055	48.457	48.938	52868000.0
2017-07-07	GOOGL	Stock	46.5492	47.233	46.4895	47.0405	33266040.0
2017-07-07	META	Stock	149.25	151.99	149.19	151.44	13615900.0
2017-07-07	TSLA	Stock	20.9	21.1333	20.492	20.8813	212653500.0
2017-07-07	TLT	Stock	122.84	123.03	122.585	122.72	9401813.0
2017-07-07	ES	Stock	60.07	60.34	59.91	60.07	1164100.0
2017-07-07	CL	Stock	73.69	73.76	73.15	73.34	2670400.0
2017-07-07	A	Stock	59.53	60.07	59.33	59.63	965400.0
2017-07-07	AA	Stock	34.0	34.37	33.265	34.19	3776600.0
2017-07-07	AAAP-DELISTED	Stock	38.55	38.72	38.3	38.51	61832.0
2017-07-07	AABA-DELISTED	Stock	54.65	54.91	54.3099	54.5008	2558556.0
2017-07-07	AAC-DELISTED	Stock	6.42	6.56	6.15	6.3	101221.0
2017-07-07	AACG	Stock	4.7	4.7	4.6	4.62	1700.0
2017-07-07	AAIC-DELISTED	Stock	13.72	13.75	13.6	13.7	288132.0
2017-07-07	AAL	Stock	52.3	53.38	52.18	53.03	6597000.0
2017-07-07	AAM.A-DELISTED	Stock	25.77	25.81	25.73	25.75	32417.0
2017-07-07	AAMC-DELISTED	Stock	27.0588	27.625	26.5	27.3529	9629.0
2017-07-07	AAME	Stock	3.55	3.75	3.5	3.6	5000.0
2017-07-07	AAMI	Stock	14.87	15.19	14.79	15.18	601700.0
2017-07-07	AAOI	Stock	62.12	68.38	62.12	67.3	3757800.0
2017-07-07	AAON	Stock	24.6	25.0333	24.5	24.8	104100.0
2017-07-07	AAP	Stock	102.7	103.17	100.93	101.93	2118500.0
2017-07-07	AAT	Stock	39.06	39.41	38.91	39.26	131100.0
2017-07-07	AAU-DELISTED	Stock	1.16	1.18	1.14	1.15	314421.0
2017-07-07	AAUAF-DELISTED	Stock	1.16	1.18	1.14	1.14	344427.0
2017-07-07	AAV-DELISTED	Stock	6.65	6.65	6.475	6.5	215040.0
2017-07-07	AAWW-DELISTED	Stock	54.9	55.7	54.0	55.1	502497.0
2017-07-07	AAXJ	Stock	67.0	67.08	66.725	66.99	497682.0
2017-07-07	AAXN-DELISTED	Stock	23.95	25.25	23.7739	25.08	665509.0
2017-07-07	AB	Stock	23.55	24.15	23.5	24.0	308100.0
2017-07-07	ABAC-DELISTED	Stock	2.2	2.2	2.09	2.17	12839.0
2017-07-07	ABAX-DELISTED	Stock	52.61	52.75	52.05	52.6	98828.0
2017-07-07	ABB-DELISTED	Stock	24.7	24.775	24.58	24.71	1739919.0
2017-07-07	ABBNY-DELISTED	Stock	24.7	24.775	24.58	24.72	2297376.0
2017-07-07	ABBV	Stock	72.11	72.11	71.63	72.03	4333700.0
2017-07-07	ABC-DELISTED	Stock	93.01	94.26	92.74	93.922	960516.0
2017-07-07	ABCB	Stock	49.25	49.68	48.45	49.2	128700.0
2017-07-07	ABCD-DELISTED	Stock	5.12	5.2669	5.08	5.17	9798.0
2017-07-07	ABCO-DELISTED	Stock	55.65	57.4	55.5	57.1	1392396.0
2017-07-07	ABDC-DELISTED	Stock	13.3	13.59	13.25	13.59	27614.0
2017-07-07	ABE-DELISTED	Stock	13.79	13.79	13.79	13.79	700.0
2017-07-07	ABEO	Stock	200.0	208.75	194.5	208.75	30180.0
2017-07-07	ABEOW-DELISTED	Stock	4.3264	4.4003	4.12	4.4003	3414.0
2017-07-07	ABEV	Stock	5.41	5.5	5.41	5.45	26970400.0
2017-07-07	ABG	Stock	54.8	55.7	54.75	55.45	122500.0
2017-07-07	ABIL-DELISTED	Stock	1.13	1.13	0.97	1.08	248920.0
2017-07-07	ABM	Stock	40.65	41.25	40.65	41.15	133100.0

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

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