PREVIEW / stock_daily / 2017-11-10

all stock daily files

  file:    by_date/stock_daily/2017/2017-11-10.parquet
  size:    216 KB
  rows:    6,474
  symbols: 2,910

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-11-10	AAPL	Stock	43.7775	43.845	43.5675	43.6675	100582000.0
2017-11-10	MSFT	Stock	83.79	84.1	83.23	83.87	19397800.0
2017-11-10	NVDA	Stock	5.327	5.4668	5.2908	5.4035	1253256000.0
2017-11-10	AMZN	Stock	56.305	56.5875	56.203	56.2675	43598000.0
2017-11-10	GOOGL	Stock	52.1935	52.3315	52.061	52.2075	19442540.0
2017-11-10	META	Stock	178.35	179.1	177.96	178.46	11070200.0
2017-11-10	TSLA	Stock	20.1667	20.5573	20.1233	20.1993	69381000.0
2017-11-10	TLT	Stock	124.71	124.84	123.96	124.1	11980950.0
2017-11-10	ES	Stock	64.3	64.42	63.85	64.07	1555600.0
2017-11-10	CL	Stock	72.57	73.46	72.51	73.21	2523700.0
2017-11-10	A	Stock	67.35	67.58	66.7	66.81	1704300.0
2017-11-10	AA	Stock	42.93	44.46	42.75	43.01	4465300.0
2017-11-10	AAAP-DELISTED	Stock	80.94	81.1	80.94	81.1	298663.0
2017-11-10	AABA-DELISTED	Stock	70.6	70.745	69.94	70.56	3747916.0
2017-11-10	AAC-DELISTED	Stock	10.9	11.4	10.735	11.27	122052.0
2017-11-10	AACG	Stock	4.31	4.35	4.2	4.35	6100.0
2017-11-10	AAIC-DELISTED	Stock	11.14	11.245	11.09	11.14	374533.0
2017-11-10	AAL	Stock	45.64	46.12	45.56	45.82	2433000.0
2017-11-10	AAM.A-DELISTED	Stock	26.45	26.45	26.26	26.44	13117.0
2017-11-10	AAMC-DELISTED	Stock	24.7647	24.7647	23.5588	23.5588	3563.0
2017-11-10	AAME	Stock	3.65	3.65	3.5	3.5	1700.0
2017-11-10	AAMI	Stock	15.59	16.04	15.58	16.04	376500.0
2017-11-10	AAOI	Stock	42.67	46.072	42.55	45.3	2969900.0
2017-11-10	AAON	Stock	22.1667	22.7667	22.1667	22.5333	201150.0
2017-11-10	AAP	Stock	80.16	81.99	80.0	81.22	1942400.0
2017-11-10	AAT	Stock	39.21	39.56	39.0	39.33	259100.0
2017-11-10	AAU-DELISTED	Stock	0.95	0.9555	0.9055	0.9219	192630.0
2017-11-10	AAUAF-DELISTED	Stock	0.95	0.9555	0.9055	0.9219	198170.0
2017-11-10	AAV-DELISTED	Stock	5.75	5.9	5.7	5.85	151282.0
2017-11-10	AAWW-DELISTED	Stock	54.55	54.625	52.6	53.85	378077.0
2017-11-10	AAXJ	Stock	76.11	76.15	75.87	76.08	619687.0
2017-11-10	AAXN-DELISTED	Stock	21.43	21.46	21.15	21.15	572898.0
2017-11-10	AB	Stock	24.95	25.2	24.7	25.05	154300.0
2017-11-10	ABAC-DELISTED	Stock	3.63	3.649	3.3365	3.48	14641.0
2017-11-10	ABAX-DELISTED	Stock	46.11	46.69	45.29	46.46	116668.0
2017-11-10	ABB-DELISTED	Stock	25.46	25.475	25.27	25.35	1227169.0
2017-11-10	ABBNY-DELISTED	Stock	25.46	25.475	25.27	25.36	1269847.0
2017-11-10	ABBV	Stock	95.35	95.94	93.56	95.43	6170100.0
2017-11-10	ABC-DELISTED	Stock	75.05	76.68	74.05	75.02	2695343.0
2017-11-10	ABCB	Stock	45.75	46.3	45.55	45.8	110000.0
2017-11-10	ABCD-DELISTED	Stock	6.24	6.9958	6.1206	6.81	144484.0
2017-11-10	ABCO-DELISTED	Stock	53.4	53.525	53.225	53.4	4794964.0
2017-11-10	ABDC-DELISTED	Stock	7.21	7.58	7.21	7.33	143181.0
2017-11-10	ABE-DELISTED	Stock	14.25	14.3	14.24	14.3	10487.0
2017-11-10	ABEO	Stock	371.25	385.0	367.5	381.25	25268.0
2017-11-10	ABEOW-DELISTED	Stock	10.2248	10.4	10.2248	10.4	600.0
2017-11-10	ABEV	Stock	6.11	6.15	6.07	6.12	20086700.0
2017-11-10	ABG	Stock	60.6	62.35	60.6	61.95	345100.0
2017-11-10	ABIL-DELISTED	Stock	0.61	0.67	0.5828	0.6499	1963434.0
2017-11-10	ABLX-DELISTED	Stock	20.94	21.11	20.82	20.87	168020.0

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

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