PREVIEW / stock_daily / 2019-12-24

all stock daily files

  file:    by_date/stock_daily/2019/2019-12-24.parquet
  size:    216 KB
  rows:    6,490
  symbols: 2,367

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-12-24	AAPL	Stock	71.1725	71.2225	70.73	71.0675	48478800.0
2019-12-24	MSFT	Stock	157.48	157.71	157.12	157.38	8989200.0
2019-12-24	NVDA	Stock	5.955	5.9828	5.9205	5.9655	138864000.0
2019-12-24	AMZN	Stock	89.6905	89.7785	89.379	89.4605	17626000.0
2019-12-24	GOOGL	Stock	67.5105	67.6005	67.2083	67.2215	13468200.0
2019-12-24	META	Stock	206.3	206.79	205.0	205.12	6046300.0
2019-12-24	TSLA	Stock	27.8907	28.3647	27.5127	28.35	120820500.0
2019-12-24	TLT	Stock	135.92	137.06	135.89	136.84	4667428.0
2019-12-24	ES	Stock	83.69	84.08	83.26	83.96	494500.0
2019-12-24	CL	Stock	68.65	68.73	68.26	68.55	816700.0
2019-12-24	A	Stock	85.45	85.45	84.98	85.3	271900.0
2019-12-24	AA	Stock	21.61	21.92	21.47	21.58	1092200.0
2019-12-24	AACG	Stock	1.45	1.45	1.41	1.43	8700.0
2019-12-24	AAIC-DELISTED	Stock	5.9	5.93	5.84	5.93	346928.0
2019-12-24	AAIC.C-DELISTED	Stock	21.41	21.41	21.33	21.35	4705.0
2019-12-24	AAL	Stock	29.32	29.43	29.1	29.18	2373600.0
2019-12-24	AAM.A-DELISTED	Stock	26.87	26.87	26.66	26.675	7343.0
2019-12-24	AAM.B-DELISTED	Stock	27.39	27.4	27.3102	27.4	2620.0
2019-12-24	AAMC-DELISTED	Stock	3.6765	3.9676	3.6765	3.9118	27608.0
2019-12-24	AAME	Stock	1.85	1.89	1.81	1.89	1700.0
2019-12-24	AAMI	Stock	10.14	10.19	10.08	10.09	52100.0
2019-12-24	AAOI	Stock	11.12	11.18	10.9	11.12	165100.0
2019-12-24	AAON	Stock	33.28	33.4133	32.98	33.2	67650.0
2019-12-24	AAP	Stock	160.12	162.06	159.83	160.57	324200.0
2019-12-24	AAT	Stock	44.79	44.94	44.6	44.73	79000.0
2019-12-24	AAU-DELISTED	Stock	0.52	0.5696	0.519	0.5508	563527.0
2019-12-24	AAUAF-DELISTED	Stock	0.52	0.5696	0.519	0.5508	569315.0
2019-12-24	AAWW-DELISTED	Stock	27.4	27.55	27.21	27.42	54728.0
2019-12-24	AAXJ	Stock	72.88	72.9	72.72	72.81	119265.0
2019-12-24	AAXN-DELISTED	Stock	72.44	73.335	72.3	73.09	230007.0
2019-12-24	AB	Stock	30.1	30.19	30.05	30.15	46200.0
2019-12-24	ABB-DELISTED	Stock	23.96	23.96	23.85	23.91	440788.0
2019-12-24	ABBNY-DELISTED	Stock	23.96	23.96	23.85	23.9	481702.0
2019-12-24	ABBV	Stock	90.4	90.4	89.43	89.85	1798800.0
2019-12-24	ABC-DELISTED	Stock	86.04	86.3	85.28	85.42	214670.0
2019-12-24	ABCB	Stock	43.2	43.25	43.0	43.23	61300.0
2019-12-24	ABDC-DELISTED	Stock	9.13	9.2	9.13	9.14	38963.0
2019-12-24	ABEO	Stock	91.75	92.25	87.5	90.0	45572.0
2019-12-24	ABEV	Stock	4.59	4.59	4.56	4.56	2832200.0
2019-12-24	ABG	Stock	114.14	114.69	113.07	114.45	51300.0
2019-12-24	ABIL-DELISTED	Stock	0.5379	0.5579	0.2756	0.36	910975.0
2019-12-24	ABM	Stock	37.69	38.28	37.4	38.2	166700.0
2019-12-24	ABMD-DELISTED	Stock	171.33	174.4	171.2484	173.0	272230.0
2019-12-24	ABR	Stock	14.39	14.58	14.39	14.54	349700.0
2019-12-24	ABR.A-DELISTED	Stock	26.38	26.38	26.325	26.38	968.0
2019-12-24	ABR.B-DELISTED	Stock	25.7562	25.8217	25.7562	25.8217	657.0
2019-12-24	ABR.C-DELISTED	Stock	26.369	26.73	26.369	26.6242	2460.0
2019-12-24	ABT	Stock	87.37	87.48	86.98	87.28	1067700.0
2019-12-24	ABTC	Stock	255300.0	259500.0	226500.0	236400.0	6.933333333333334
2019-12-24	ABTS	Stock	29.7	29.7	28.5	29.25	400.0

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

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