PREVIEW / stock_daily / 2019-12-17

all stock daily files

  file:    by_date/stock_daily/2019/2019-12-17.parquet
  size:    223 KB
  rows:    6,639
  symbols: 2,474

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-17	AAPL	Stock	69.8925	70.4425	69.7	70.1025	114158400.0
2019-12-17	MSFT	Stock	155.45	155.71	154.45	154.69	25425600.0
2019-12-17	NVDA	Stock	5.6475	5.73	5.638	5.7072	321196000.0
2019-12-17	AMZN	Stock	88.9005	89.6	88.8695	89.533	72888000.0
2019-12-17	GOOGL	Stock	68.1205	68.2165	67.5385	67.7445	32970980.0
2019-12-17	META	Stock	198.84	199.0	196.13	198.39	10175700.0
2019-12-17	TSLA	Stock	25.266	25.7	25.06	25.266	127452000.0
2019-12-17	TLT	Stock	138.21	138.34	137.21	137.6	6179893.0
2019-12-17	ES	Stock	82.21	82.97	82.06	82.8	1037400.0
2019-12-17	CL	Stock	68.65	68.65	67.81	67.84	4647600.0
2019-12-17	A	Stock	84.76	84.86	83.78	83.95	1653200.0
2019-12-17	AA	Stock	20.82	20.945	20.52	20.71	3504000.0
2019-12-17	AACG	Stock	1.5	1.5	1.35	1.43	4500.0
2019-12-17	AAIC-DELISTED	Stock	5.52	5.61	5.49	5.5	935179.0
2019-12-17	AAIC.C-DELISTED	Stock	21.516	21.516	21.51	21.51	1516.0
2019-12-17	AAL	Stock	27.97	28.48	27.86	28.28	5920300.0
2019-12-17	AAM.A-DELISTED	Stock	26.6424	26.6788	26.55	26.65	15480.0
2019-12-17	AAM.B-DELISTED	Stock	26.97	27.26	26.97	27.22	38310.0
2019-12-17	AAMC-DELISTED	Stock	4.0588	4.0588	3.8382	4.0062	12787.0
2019-12-17	AAME	Stock	1.8	2.0	1.75	1.9	4000.0
2019-12-17	AAMI	Stock	10.04	10.075	9.92	10.02	430100.0
2019-12-17	AAOI	Stock	11.2	11.45	11.1	11.24	543900.0
2019-12-17	AAON	Stock	32.84	33.5933	32.78	33.46	293550.0
2019-12-17	AAP	Stock	154.51	158.86	153.67	157.98	941700.0
2019-12-17	AAT	Stock	45.0	45.08	44.21	44.36	521100.0
2019-12-17	AAU-DELISTED	Stock	0.51	0.52	0.505	0.5089	132202.0
2019-12-17	AAUAF-DELISTED	Stock	0.51	0.52	0.505	0.5089	135889.0
2019-12-17	AAWW-DELISTED	Stock	27.94	28.59	27.88	28.53	243548.0
2019-12-17	AAXJ	Stock	72.57	72.79	72.47	72.61	330120.0
2019-12-17	AAXN-DELISTED	Stock	72.63	72.87	71.13	71.35	543159.0
2019-12-17	AB	Stock	30.12	30.4	29.8	30.16	326000.0
2019-12-17	ABB-DELISTED	Stock	23.99	23.99	23.845	23.885	4325148.0
2019-12-17	ABBNY-DELISTED	Stock	23.96	23.99	23.845	23.88	4848649.0
2019-12-17	ABBV	Stock	90.0	90.17	89.07	90.08	8750000.0
2019-12-17	ABC-DELISTED	Stock	85.96	86.09	82.98	83.16	1398736.0
2019-12-17	ABCB	Stock	44.66	44.79	44.08	44.31	304900.0
2019-12-17	ABDC-DELISTED	Stock	9.17	9.2343	9.15	9.15	26827.0
2019-12-17	ABEO	Stock	106.5	106.5	98.0	103.25	29268.0
2019-12-17	ABEOW-DELISTED	Stock	0.149	0.149	0.04	0.05	6988.0
2019-12-17	ABEV	Stock	4.67	4.69	4.61	4.62	23050300.0
2019-12-17	ABG	Stock	115.88	117.83	115.47	117.75	105200.0
2019-12-17	ABIL-DELISTED	Stock	0.5072	0.5595	0.501	0.54	90820.0
2019-12-17	ABM	Stock	37.55	37.67	36.85	37.08	463800.0
2019-12-17	ABMD-DELISTED	Stock	176.3	179.455	172.5	178.82	413453.0
2019-12-17	ABR	Stock	14.21	14.46	14.12	14.45	1158600.0
2019-12-17	ABR.A-DELISTED	Stock	26.3692	26.3692	26.2	26.2302	735.0
2019-12-17	ABR.B-DELISTED	Stock	25.69	25.6992	25.65	25.65	9566.0
2019-12-17	ABR.C-DELISTED	Stock	26.55	26.6	26.5	26.6	1131.0
2019-12-17	ABT	Stock	86.58	87.3	86.0	87.06	5368500.0
2019-12-17	ABTC	Stock	327900.0	360450.0	315000.0	330000.0	7.8

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

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