PREVIEW / stock_daily / 2019-10-14

all stock daily files

  file:    by_date/stock_daily/2019/2019-10-14.parquet
  size:    217 KB
  rows:    6,536
  symbols: 2,456

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
2019-10-14	AAPL	Stock	58.725	59.5325	58.6675	58.9675	96427600.0
2019-10-14	MSFT	Stock	139.69	140.29	139.52	139.55	13304300.0
2019-10-14	NVDA	Stock	4.641	4.6843	4.6098	4.6633	200040000.0
2019-10-14	AMZN	Stock	86.4455	87.0945	86.1	86.8215	38204000.0
2019-10-14	GOOGL	Stock	60.6945	61.294	60.594	60.8885	13678520.0
2019-10-14	META	Stock	184.2	184.62	182.57	183.28	7006000.0
2019-10-14	TSLA	Stock	16.5267	17.2367	16.4753	17.1307	153075000.0
2019-10-14	TLT	Stock	141.48	141.505	141.08	141.46	5937726.0
2019-10-14	ES	Stock	85.79	85.88	84.72	84.76	847400.0
2019-10-14	CL	Stock	70.61	70.79	69.36	69.41	2556400.0
2019-10-14	A	Stock	75.18	75.8	74.99	75.18	829500.0
2019-10-14	AA	Stock	19.02	19.44	18.78	19.17	5806700.0
2019-10-14	AAC-DELISTED	Stock	0.379	0.379	0.345	0.37	347851.0
2019-10-14	AACG	Stock	1.59	1.7	1.59	1.69	20200.0
2019-10-14	AAIC-DELISTED	Stock	5.48	5.54	5.44	5.52	202150.0
2019-10-14	AAIC.C-DELISTED	Stock	21.0	21.1	20.91	21.1	7943.0
2019-10-14	AAL	Stock	27.37	27.66	27.14	27.62	3167100.0
2019-10-14	AAM.A-DELISTED	Stock	26.589	26.63	26.5478	26.55	17982.0
2019-10-14	AAM.B-DELISTED	Stock	27.16	27.16	26.95	26.99	21320.0
2019-10-14	AAMC-DELISTED	Stock	3.6882	3.8235	3.5588	3.7647	15864.0
2019-10-14	AAME	Stock	2.5	2.5	2.5	2.5	1600.0
2019-10-14	AAMI	Stock	9.28	9.39	9.22	9.27	513100.0
2019-10-14	AAOI	Stock	10.37	10.75	10.14	10.56	419400.0
2019-10-14	AAON	Stock	31.2133	31.6667	30.8333	31.22	274050.0
2019-10-14	AAP	Stock	158.14	159.23	157.09	157.32	430100.0
2019-10-14	AAT	Stock	46.87	47.15	46.52	47.06	208400.0
2019-10-14	AAU-DELISTED	Stock	0.6959	0.7175	0.6782	0.7	72855.0
2019-10-14	AAUAF-DELISTED	Stock	0.6959	0.7175	0.6782	0.7	88864.0
2019-10-14	AAWW-DELISTED	Stock	21.59	22.13	21.24	21.7	363272.0
2019-10-14	AAXJ	Stock	67.75	67.85	67.56	67.6	893996.0
2019-10-14	AAXN-DELISTED	Stock	52.98	53.43	51.88	52.8	373300.0
2019-10-14	AB	Stock	28.47	28.67	28.15	28.17	227400.0
2019-10-14	ABB-DELISTED	Stock	18.51	18.62	18.46	18.55	1449154.0
2019-10-14	ABBNY-DELISTED	Stock	18.51	18.62	18.46	18.55	1506718.0
2019-10-14	ABBV	Stock	73.65	74.17	73.39	73.76	5040900.0
2019-10-14	ABC-DELISTED	Stock	81.79	82.15	81.38	81.6	392835.0
2019-10-14	ABCB	Stock	39.81	39.99	39.5	39.88	234700.0
2019-10-14	ABDC-DELISTED	Stock	8.8	8.82	8.77	8.81	15536.0
2019-10-14	ABEO	Stock	55.25	56.25	52.0	54.25	8348.0
2019-10-14	ABEOW-DELISTED	Stock	0.16	0.16	0.15	0.15	1880.0
2019-10-14	ABEV	Stock	4.54	4.56	4.5	4.56	9680000.0
2019-10-14	ABG	Stock	99.55	100.54	97.66	98.64	118600.0
2019-10-14	ABIL-DELISTED	Stock	0.47	0.4859	0.47	0.4789	20002.0
2019-10-14	ABM	Stock	35.87	36.59	35.87	36.46	258200.0
2019-10-14	ABMD-DELISTED	Stock	169.58	177.5	169.3	176.47	555572.0
2019-10-14	ABR	Stock	13.2	13.24	13.15	13.2	589400.0
2019-10-14	ABR.A-DELISTED	Stock	25.9	26.29	25.8532	26.29	3923.0
2019-10-14	ABR.C-DELISTED	Stock	26.0502	26.2916	26.0502	26.2	4625.0
2019-10-14	ABT	Stock	79.69	80.19	79.42	79.82	4228500.0
2019-10-14	ABTC	Stock	169200.0	170850.0	163800.0	165000.0	1.0266666666666666

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

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