PREVIEW / stock_daily / 2019-12-19

all stock daily files

  file:    by_date/stock_daily/2019/2019-12-19.parquet
  size:    223 KB
  rows:    6,616
  symbols: 2,459

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-19	AAPL	Stock	69.875	70.295	69.7375	70.005	98369200.0
2019-12-19	MSFT	Stock	154.0	155.77	153.75	155.71	24958900.0
2019-12-19	NVDA	Stock	5.7725	5.9	5.7675	5.8865	445360000.0
2019-12-19	AMZN	Stock	89.025	89.6495	88.703	89.614	53056000.0
2019-12-19	GOOGL	Stock	67.5955	67.8763	67.4375	67.822	30421640.0
2019-12-19	META	Stock	202.78	206.3	202.51	206.06	16514600.0
2019-12-19	TSLA	Stock	26.488	27.1233	26.4333	26.936	271606500.0
2019-12-19	TLT	Stock	136.0	136.86	135.7601	136.47	6591083.0
2019-12-19	ES	Stock	83.08	83.91	82.96	83.78	2311600.0
2019-12-19	CL	Stock	67.27	68.48	67.27	68.34	4266400.0
2019-12-19	A	Stock	83.95	84.67	83.56	84.51	1696000.0
2019-12-19	AA	Stock	21.1	21.665	21.0	21.47	4766900.0
2019-12-19	AACG	Stock	1.51	1.68	1.51	1.59	26100.0
2019-12-19	AAIC-DELISTED	Stock	5.73	5.75	5.655	5.69	582759.0
2019-12-19	AAIC.C-DELISTED	Stock	21.51	21.51	21.42	21.445	6925.0
2019-12-19	AAL	Stock	28.0	28.57	27.93	28.55	6295100.0
2019-12-19	AAM.A-DELISTED	Stock	26.55	26.6708	26.55	26.6264	21440.0
2019-12-19	AAM.B-DELISTED	Stock	27.2	27.28	27.1142	27.2796	18759.0
2019-12-19	AAMC-DELISTED	Stock	3.9706	4.1181	3.8625	4.0	41123.0
2019-12-19	AAME	Stock	1.87	1.89	1.85	1.89	3600.0
2019-12-19	AAMI	Stock	10.15	10.17	10.045	10.09	520600.0
2019-12-19	AAOI	Stock	11.15	11.4	11.03	11.3	289900.0
2019-12-19	AAON	Stock	33.2533	33.2533	32.56	32.8667	170400.0
2019-12-19	AAP	Stock	157.47	158.45	156.23	156.48	734700.0
2019-12-19	AAT	Stock	44.68	45.1	44.48	44.89	395200.0
2019-12-19	AAU-DELISTED	Stock	0.5	0.5193	0.4901	0.5174	96092.0
2019-12-19	AAUAF-DELISTED	Stock	0.5	0.5193	0.4901	0.5174	100224.0
2019-12-19	AAWW-DELISTED	Stock	27.34	28.34	27.0675	27.9	197856.0
2019-12-19	AAXJ	Stock	72.59	72.85	72.57	72.77	563531.0
2019-12-19	AAXN-DELISTED	Stock	69.84	70.35	69.1	70.35	310367.0
2019-12-19	AB	Stock	30.03	30.18	29.9	30.01	180800.0
2019-12-19	ABB-DELISTED	Stock	24.03	24.11	24.01	24.085	1686191.0
2019-12-19	ABBNY-DELISTED	Stock	24.03	24.11	24.01	24.08	1957919.0
2019-12-19	ABBV	Stock	89.68	89.68	88.56	88.77	5447000.0
2019-12-19	ABC-DELISTED	Stock	83.58	84.21	83.11	83.79	1168475.0
2019-12-19	ABCB	Stock	43.65	43.7	43.37	43.67	324000.0
2019-12-19	ABDC-DELISTED	Stock	9.17	9.19	9.1505	9.16	12727.0
2019-12-19	ABEO	Stock	100.25	129.75	100.0	125.0	105124.0
2019-12-19	ABEOW-DELISTED	Stock	0.12	0.15	0.12	0.1299	16800.0
2019-12-19	ABEV	Stock	4.64	4.69	4.63	4.69	18311500.0
2019-12-19	ABG	Stock	118.18	119.23	117.31	118.74	104900.0
2019-12-19	ABIL-DELISTED	Stock	0.5398	0.55	0.505	0.55	45848.0
2019-12-19	ABM	Stock	35.54	39.19	35.04	38.96	1099900.0
2019-12-19	ABMD-DELISTED	Stock	172.09	174.75	165.13	169.43	1185782.0
2019-12-19	ABR	Stock	14.48	14.58	14.45	14.54	817300.0
2019-12-19	ABR.A-DELISTED	Stock	26.28	26.375	26.28	26.375	352.0
2019-12-19	ABR.B-DELISTED	Stock	25.7899	25.7899	25.7489	25.7489	218.0
2019-12-19	ABR.C-DELISTED	Stock	26.6535	26.73	26.6535	26.73	296.0
2019-12-19	ABT	Stock	86.74	87.35	86.49	87.35	4643700.0
2019-12-19	ABTC	Stock	343200.0	343500.0	323700.0	323700.0	5.226666666666667

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

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