PREVIEW / stock_daily / 2019-12-23

all stock daily files

  file:    by_date/stock_daily/2019/2019-12-23.parquet
  size:    221 KB
  rows:    6,590
  symbols: 2,423

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-23	AAPL	Stock	70.1325	71.0625	70.0925	71.0	98572000.0
2019-12-23	MSFT	Stock	158.12	158.12	157.27	157.41	17718200.0
2019-12-23	NVDA	Stock	6.013	6.0452	5.9598	5.9705	355060000.0
2019-12-23	AMZN	Stock	89.413	89.65	89.2255	89.65	42728000.0
2019-12-23	GOOGL	Stock	67.9365	68.0927	67.4	67.5315	19939340.0
2019-12-23	META	Stock	206.7	208.59	205.68	206.18	13348900.0
2019-12-23	TSLA	Stock	27.452	28.134	27.3333	27.948	199794000.0
2019-12-23	TLT	Stock	136.81	136.9687	136.0	136.45	5175177.0
2019-12-23	ES	Stock	84.7	84.82	83.3	83.73	1920800.0
2019-12-23	CL	Stock	69.01	69.06	68.6	68.72	2776000.0
2019-12-23	A	Stock	85.42	85.44	84.76	85.26	816000.0
2019-12-23	AA	Stock	21.3	21.55	21.26	21.48	2262200.0
2019-12-23	AACG	Stock	1.44	1.52	1.4	1.49	12400.0
2019-12-23	AAIC-DELISTED	Stock	5.73	5.87	5.7	5.86	545964.0
2019-12-23	AAIC.C-DELISTED	Stock	21.43	21.4999	21.42	21.42	13806.0
2019-12-23	AAL	Stock	29.25	29.72	29.2	29.3	9291100.0
2019-12-23	AAM.A-DELISTED	Stock	26.51	26.86	26.51	26.86	11194.0
2019-12-23	AAM.B-DELISTED	Stock	27.1082	27.39	27.1082	27.39	6645.0
2019-12-23	AAMC-DELISTED	Stock	3.8441	4.0	3.8441	3.9604	2200.0
2019-12-23	AAME	Stock	1.93	1.93	1.85	1.89	1000.0
2019-12-23	AAMI	Stock	10.23	10.29	10.06	10.1	300700.0
2019-12-23	AAOI	Stock	11.17	11.23	10.91	11.15	466600.0
2019-12-23	AAON	Stock	33.3467	33.4667	32.58	33.3067	137250.0
2019-12-23	AAP	Stock	158.22	160.2	156.9	159.97	683600.0
2019-12-23	AAT	Stock	44.91	44.91	44.57	44.8	235800.0
2019-12-23	AAU-DELISTED	Stock	0.51	0.5199	0.5	0.5199	173837.0
2019-12-23	AAUAF-DELISTED	Stock	0.51	0.5199	0.5	0.5151	178786.0
2019-12-23	AAWW-DELISTED	Stock	27.66	27.885	27.15	27.32	190846.0
2019-12-23	AAXJ	Stock	72.96	73.03	72.81	73.03	244800.0
2019-12-23	AAXN-DELISTED	Stock	71.74	72.2512	71.1	72.24	228913.0
2019-12-23	AB	Stock	30.14	30.15	29.89	30.1	183100.0
2019-12-23	ABB-DELISTED	Stock	23.99	24.03	23.94	23.98	2445344.0
2019-12-23	ABBNY-DELISTED	Stock	23.99	24.03	23.94	23.96	2535165.0
2019-12-23	ABBV	Stock	89.53	90.47	89.33	90.25	5907200.0
2019-12-23	ABC-DELISTED	Stock	86.02	86.11	84.98	85.6	726017.0
2019-12-23	ABCB	Stock	43.44	43.44	42.69	43.09	225000.0
2019-12-23	ABDC-DELISTED	Stock	9.08	9.175	9.08	9.175	18359.0
2019-12-23	ABEO	Stock	82.75	93.75	80.0	90.75	179840.0
2019-12-23	ABEV	Stock	4.61	4.63	4.58	4.58	5995300.0
2019-12-23	ABG	Stock	117.68	117.71	113.56	114.12	104800.0
2019-12-23	ABIL-DELISTED	Stock	0.56	0.56	0.51	0.5342	181482.0
2019-12-23	ABM	Stock	38.64	38.65	37.45	37.74	520000.0
2019-12-23	ABMD-DELISTED	Stock	164.09	170.84	161.6733	170.62	807510.0
2019-12-23	ABR	Stock	14.69	14.69	14.34	14.37	942500.0
2019-12-23	ABR.A-DELISTED	Stock	26.2866	26.2922	26.28	26.28	1360.0
2019-12-23	ABR.B-DELISTED	Stock	25.68	25.825	25.66	25.825	1795.0
2019-12-23	ABR.C-DELISTED	Stock	26.6338	26.6338	26.6338	26.6338	100.0
2019-12-23	ABT	Stock	86.31	87.46	86.28	87.35	4067800.0
2019-12-23	ABTC	Stock	312600.0	315000.0	251400.0	252000.0	14.933333333333334
2019-12-23	ABTS	Stock	28.5	30.0	28.5	30.0	200.0

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

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