PREVIEW / stock_daily / 2019-10-18

all stock daily files

  file:    by_date/stock_daily/2019/2019-10-18.parquet
  size:    219 KB
  rows:    6,541
  symbols: 2,456

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-10-18	AAPL	Stock	58.6475	59.395	58.5725	59.1025	97433600.0
2019-10-18	MSFT	Stock	139.76	140.0	136.56	137.41	32273500.0
2019-10-18	NVDA	Stock	4.8578	4.8905	4.6875	4.7623	307440000.0
2019-10-18	AMZN	Stock	89.39	89.699	87.46	87.8755	67250000.0
2019-10-18	GOOGL	Stock	62.7345	62.9055	62.007	62.2205	31646400.0
2019-10-18	META	Stock	190.23	191.49	183.92	185.85	16874200.0
2019-10-18	TSLA	Stock	17.38	17.52	17.0067	17.13	86247000.0
2019-10-18	TLT	Stock	139.81	140.23	139.45	139.58	6456407.0
2019-10-18	ES	Stock	84.92	85.76	84.55	85.6	1250300.0
2019-10-18	CL	Stock	68.01	68.29	67.47	68.03	4022600.0
2019-10-18	A	Stock	74.0	74.82	73.77	74.57	2121900.0
2019-10-18	AA	Stock	20.66	21.64	20.34	21.54	6030900.0
2019-10-18	AAC-DELISTED	Stock	0.4	0.41	0.3731	0.3958	97078.0
2019-10-18	AACG	Stock	1.85	1.85	1.77	1.77	12900.0
2019-10-18	AAIC-DELISTED	Stock	5.54	5.67	5.535	5.63	436975.0
2019-10-18	AAIC.C-DELISTED	Stock	21.05	21.1972	21.05	21.1972	1442.0
2019-10-18	AAL	Stock	27.8	28.32	27.71	28.22	5689100.0
2019-10-18	AAM.A-DELISTED	Stock	26.7748	26.79	26.62	26.62	15590.0
2019-10-18	AAM.B-DELISTED	Stock	27.1	27.2955	26.97	26.98	38474.0
2019-10-18	AAMC-DELISTED	Stock	4.1765	4.6176	4.1618	4.5588	90134.0
2019-10-18	AAME	Stock	2.37	2.5	2.34	2.5	900.0
2019-10-18	AAMI	Stock	9.41	9.59	9.41	9.54	377300.0
2019-10-18	AAOI	Stock	10.62	10.88	10.51	10.85	330400.0
2019-10-18	AAON	Stock	31.6467	31.82	31.2	31.38	192000.0
2019-10-18	AAP	Stock	163.52	164.74	160.72	163.5	642900.0
2019-10-18	AAT	Stock	47.59	47.59	47.17	47.2	369900.0
2019-10-18	AAU-DELISTED	Stock	0.67	0.67	0.66	0.66	88962.0
2019-10-18	AAUAF-DELISTED	Stock	0.67	0.67	0.66	0.66	91382.0
2019-10-18	AAWW-DELISTED	Stock	22.41	22.89	22.4	22.63	183073.0
2019-10-18	AAXJ	Stock	68.44	68.52	67.99	68.11	559523.0
2019-10-18	AAXN-DELISTED	Stock	51.42	51.48	49.8	50.54	883099.0
2019-10-18	AB	Stock	27.6	28.22	27.6	28.08	342500.0
2019-10-18	ABB-DELISTED	Stock	19.06	19.18	19.0	19.16	1526244.0
2019-10-18	ABBNY-DELISTED	Stock	19.06	19.18	19.0	19.16	1614250.0
2019-10-18	ABBV	Stock	75.24	77.17	75.21	76.46	9480200.0
2019-10-18	ABC-DELISTED	Stock	89.51	90.0	88.34	89.64	1281019.0
2019-10-18	ABCB	Stock	40.85	42.17	40.66	41.75	634000.0
2019-10-18	ABDC-DELISTED	Stock	8.93	8.9495	8.8439	8.9	10425.0
2019-10-18	ABEO	Stock	55.5	59.75	52.75	54.25	23388.0
2019-10-18	ABEOW-DELISTED	Stock	0.19	0.19	0.19	0.19	1000.0
2019-10-18	ABEV	Stock	4.52	4.57	4.5	4.52	5803700.0
2019-10-18	ABG	Stock	100.58	104.55	100.56	103.32	135000.0
2019-10-18	ABIL-DELISTED	Stock	0.5	0.5399	0.48	0.5108	33839.0
2019-10-18	ABM	Stock	36.82	37.62	36.82	37.51	203300.0
2019-10-18	ABMD-DELISTED	Stock	177.22	178.8557	172.43	175.4	276130.0
2019-10-18	ABR	Stock	13.32	13.44	13.3	13.4	1528100.0
2019-10-18	ABR.B-DELISTED	Stock	26.15	26.34	26.1119	26.34	3000.0
2019-10-18	ABR.C-DELISTED	Stock	26.19	26.4	26.09	26.32	5173.0
2019-10-18	ABT	Stock	82.41	83.32	82.03	82.79	5219800.0
2019-10-18	ABTC	Stock	173400.0	173400.0	168000.0	169500.0	0.5466666666666666

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

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