PREVIEW / stock_daily / 2020-11-17

all stock daily files

  file:    by_date/stock_daily/2020/2020-11-17.parquet
  size:    232 KB
  rows:    7,038
  symbols: 2,509

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
2020-11-17	AAPL	Stock	119.55	120.67	118.96	119.39	74271000.0
2020-11-17	MSFT	Stock	216.1	217.68	214.08	214.46	24154100.0
2020-11-17	NVDA	Stock	13.5525	13.5962	13.3038	13.4222	312028000.0
2020-11-17	AMZN	Stock	159.177	159.4625	156.763	156.783	68894000.0
2020-11-17	GOOGL	Stock	88.393	88.857	87.9745	88.083	21320680.0
2020-11-17	META	Stock	277.68	277.68	273.29	275.0	15040300.0
2020-11-17	TSLA	Stock	153.39	154.0	144.3367	147.2033	183564900.0
2020-11-17	TLT	Stock	158.77	159.16	158.59	158.81	7444575.0
2020-11-17	ES	Stock	94.02	94.24	91.39	91.75	961100.0
2020-11-17	CL	Stock	85.39	86.06	85.28	85.35	3406800.0
2020-11-17	A	Stock	110.5	110.77	109.25	109.86	1571500.0
2020-11-17	AA	Stock	17.37	18.3	17.11	18.27	5443300.0
2020-11-17	AACG	Stock	1.15	1.15	1.11	1.13	29900.0
2020-11-17	AACQ-DELISTED	Stock	9.82	9.82	9.75	9.78	14270.0
2020-11-17	AACQU-DELISTED	Stock	10.16	10.16	10.11	10.125	1200.0
2020-11-17	AACQW-DELISTED	Stock	1.15	1.18	1.1	1.1799	53133.0
2020-11-17	AAIC-DELISTED	Stock	2.92	3.045	2.92	3.02	275052.0
2020-11-17	AAIC.C-DELISTED	Stock	19.9501	19.9725	19.95	19.9725	548.0
2020-11-17	AAL	Stock	12.48	12.81	12.23	12.7	61956500.0
2020-11-17	AAM.A-DELISTED	Stock	26.3602	26.62	26.3602	26.53	21622.0
2020-11-17	AAM.B-DELISTED	Stock	27.39	27.52	27.16	27.45	20360.0
2020-11-17	AAMC-DELISTED	Stock	6.7706	7.0529	6.7706	6.9882	7834.0
2020-11-17	AAME	Stock	2.12	2.12	2.12	2.12	300.0
2020-11-17	AAMI	Stock	17.96	18.7	17.82	18.68	948700.0
2020-11-17	AAOI	Stock	7.5	7.62	7.37	7.48	625700.0
2020-11-17	AAON	Stock	44.22	45.0	43.46	44.8267	340200.0
2020-11-17	AAP	Stock	149.92	150.7	147.65	149.3	1073200.0
2020-11-17	AAT	Stock	28.0	29.19	27.71	29.19	478500.0
2020-11-17	AAU-DELISTED	Stock	1.15	1.17	1.08	1.15	371557.0
2020-11-17	AAUAF-DELISTED	Stock	1.15	1.17	1.08	1.15	386577.0
2020-11-17	AAWW-DELISTED	Stock	55.11	57.18	54.26	56.56	397132.0
2020-11-17	AAXJ	Stock	84.91	85.41	84.755	85.18	2079984.0
2020-11-17	AAXN-DELISTED	Stock	118.44	119.545	116.62	118.98	299212.0
2020-11-17	AB	Stock	31.75	31.88	31.06	31.22	490800.0
2020-11-17	ABB-DELISTED	Stock	27.66	27.78	27.47	27.69	2309226.0
2020-11-17	ABBNY-DELISTED	Stock	27.66	27.78	27.47	27.68	2441364.0
2020-11-17	ABBV	Stock	99.37	100.26	98.74	99.21	11593500.0
2020-11-17	ABC-DELISTED	Stock	106.0	108.08	104.31	104.88	1838278.0
2020-11-17	ABCB	Stock	34.55	35.06	33.94	35.04	301000.0
2020-11-17	ABCM-DELISTED	Stock	18.65	18.91	18.54	18.73	53390.0
2020-11-17	ABEO	Stock	32.5	33.0	31.0	32.0	63396.0
2020-11-17	ABEV	Stock	2.83	2.97	2.82	2.91	26253200.0
2020-11-17	ABG	Stock	124.25	126.67	123.4	125.84	137300.0
2020-11-17	ABM	Stock	39.36	39.73	38.4	38.8	334700.0
2020-11-17	ABMD-DELISTED	Stock	269.53	273.03	267.805	269.94	84137.0
2020-11-17	ABR	Stock	12.86	13.25	12.86	13.17	1744700.0
2020-11-17	ABR.A-DELISTED	Stock	25.255	25.5176	25.22	25.35	24066.0
2020-11-17	ABR.B-DELISTED	Stock	25.43	25.4938	25.25	25.44	2480.0
2020-11-17	ABR.C-DELISTED	Stock	26.035	26.035	25.86	25.86	429.0
2020-11-17	ABST-DELISTED	Stock	10.18	10.18	9.97	10.01	126625.0

> showing 50 of 7,038 rows — these rows as CSV

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