PREVIEW / stock_daily / 2019-11-18

all stock daily files

  file:    by_date/stock_daily/2019/2019-11-18.parquet
  size:    222 KB
  rows:    6,636
  symbols: 2,480

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-11-18	AAPL	Stock	66.45	66.8575	66.0575	66.775	86703200.0
2019-11-18	MSFT	Stock	150.07	150.55	148.98	150.34	21534000.0
2019-11-18	NVDA	Stock	5.0972	5.3338	5.0943	5.307	574588000.0
2019-11-18	AMZN	Stock	86.915	87.685	86.1355	87.6265	56790000.0
2019-11-18	GOOGL	Stock	66.617	66.696	65.808	65.992	27987480.0
2019-11-18	META	Stock	194.56	198.63	193.05	197.4	16167200.0
2019-11-18	TSLA	Stock	23.528	23.5433	23.0733	23.3327	66006000.0
2019-11-18	TLT	Stock	138.21	138.61	137.93	138.01	5944030.0
2019-11-18	ES	Stock	81.67	82.89	81.59	82.15	2413700.0
2019-11-18	CL	Stock	66.81	67.94	66.71	67.13	4568200.0
2019-11-18	A	Stock	78.14	78.5	77.5	77.94	1641200.0
2019-11-18	AA	Stock	20.62	20.82	20.0	20.76	3616500.0
2019-11-18	AACG	Stock	1.69	1.7	1.65	1.67	8100.0
2019-11-18	AAIC-DELISTED	Stock	5.64	5.75	5.57	5.73	249495.0
2019-11-18	AAIC.C-DELISTED	Stock	21.76	21.8699	21.76	21.8699	3150.0
2019-11-18	AAL	Stock	28.64	28.89	28.28	28.6	5368800.0
2019-11-18	AAM.A-DELISTED	Stock	26.565	26.5984	26.56	26.58	4707.0
2019-11-18	AAM.B-DELISTED	Stock	26.98	26.98	26.856	26.92	9283.0
2019-11-18	AAMC-DELISTED	Stock	3.4485	3.6765	3.4412	3.6765	9993.0
2019-11-18	AAME	Stock	1.65	1.74	1.57	1.57	3300.0
2019-11-18	AAMI	Stock	9.58	9.7	9.43	9.61	579400.0
2019-11-18	AAOI	Stock	10.82	10.895	10.46	10.54	545700.0
2019-11-18	AAON	Stock	33.4267	33.64	33.1733	33.5	153750.0
2019-11-18	AAP	Stock	162.85	164.06	160.95	163.67	862900.0
2019-11-18	AAT	Stock	47.21	47.47	46.95	46.96	214300.0
2019-11-18	AAU-DELISTED	Stock	0.51	0.53	0.51	0.5217	137964.0
2019-11-18	AAUAF-DELISTED	Stock	0.51	0.53	0.51	0.5217	144064.0
2019-11-18	AAWW-DELISTED	Stock	25.01	25.3	24.59	25.05	302560.0
2019-11-18	AAXJ	Stock	70.31	70.45	70.07	70.21	755012.0
2019-11-18	AAXN-DELISTED	Stock	67.24	67.83	66.35	67.74	398279.0
2019-11-18	AB	Stock	29.6	29.72	29.24	29.45	202200.0
2019-11-18	ABB-DELISTED	Stock	22.0	22.11	21.93	22.09	1164123.0
2019-11-18	ABBNY-DELISTED	Stock	22.0	22.11	21.93	22.09	1300798.0
2019-11-18	ABBV	Stock	88.34	89.41	88.32	88.73	5772300.0
2019-11-18	ABC-DELISTED	Stock	87.04	88.2	87.04	87.78	524953.0
2019-11-18	ABCB	Stock	43.36	43.49	42.53	43.09	405900.0
2019-11-18	ABDC-DELISTED	Stock	8.94	9.02	8.94	9.02	22484.0
2019-11-18	ABEO	Stock	56.75	57.75	55.25	55.75	5916.0
2019-11-18	ABEV	Stock	4.17	4.18	4.13	4.13	8975700.0
2019-11-18	ABG	Stock	110.36	111.5	110.33	110.35	225000.0
2019-11-18	ABIL-DELISTED	Stock	0.35	0.37	0.335	0.345	82210.0
2019-11-18	ABM	Stock	37.82	38.5	37.69	38.39	162400.0
2019-11-18	ABMD-DELISTED	Stock	216.82	218.95	177.54	178.035	2548741.0
2019-11-18	ABR	Stock	15.0	15.1	14.97	15.06	1090000.0
2019-11-18	ABR.A-DELISTED	Stock	25.87	25.9036	25.87	25.9036	264.0
2019-11-18	ABR.B-DELISTED	Stock	25.65	25.65	25.6	25.6	4100.0
2019-11-18	ABR.C-DELISTED	Stock	26.163	26.23	26.163	26.2	2159.0
2019-11-18	ABT	Stock	85.71	85.9	84.02	84.26	5812300.0
2019-11-18	ABTC	Stock	185700.0	185700.0	147000.0	156300.0	14.266666666666666
2019-11-18	ABTS	Stock	35.25	36.0	35.25	36.0	440.0

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

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