PREVIEW / stock_daily / 2019-08-12

all stock daily files

  file:    by_date/stock_daily/2019/2019-08-12.parquet
  size:    220 KB
  rows:    6,579
  symbols: 2,500

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-08-12	AAPL	Stock	49.905	50.5125	49.7875	50.12	89927600.0
2019-08-12	MSFT	Stock	137.07	137.86	135.24	135.79	20484300.0
2019-08-12	NVDA	Stock	3.802	3.8545	3.7642	3.7862	279200000.0
2019-08-12	AMZN	Stock	89.7995	90.049	88.85	89.246	58110000.0
2019-08-12	GOOGL	Stock	59.0	59.2805	58.436	58.725	22064860.0
2019-08-12	META	Stock	186.85	187.59	184.46	185.37	10930900.0
2019-08-12	TSLA	Stock	15.5327	15.718	15.25	15.2673	69958500.0
2019-08-12	TLT	Stock	141.72	143.43	141.5115	142.97	14094307.0
2019-08-12	ES	Stock	78.63	78.67	77.54	77.75	1181900.0
2019-08-12	CL	Stock	71.4	71.4	70.26	70.73	2457900.0
2019-08-12	A	Stock	68.22	68.38	66.5	66.63	1961900.0
2019-08-12	AA	Stock	19.03	19.05	18.39	18.52	2600300.0
2019-08-12	AABA-DELISTED	Stock	70.0	70.07	69.88	69.99	2619691.0
2019-08-12	AAC-DELISTED	Stock	0.886	0.8989	0.79	0.8165	61625.0
2019-08-12	AACG	Stock	2.22	2.28	2.2	2.23	17600.0
2019-08-12	AAIC-DELISTED	Stock	5.95	5.96	5.74	5.8	396495.0
2019-08-12	AAIC.C-DELISTED	Stock	22.311	22.3814	22.27	22.3	2425.0
2019-08-12	AAL	Stock	28.5	28.51	27.52	27.64	8015000.0
2019-08-12	AAM.A-DELISTED	Stock	26.25	26.28	26.2	26.22	16055.0
2019-08-12	AAM.B-DELISTED	Stock	26.59	26.6287	26.5598	26.6139	9780.0
2019-08-12	AAMC-DELISTED	Stock	3.2647	3.3088	3.1776	3.1776	14593.0
2019-08-12	AAME	Stock	2.45	2.47	2.45	2.47	300.0
2019-08-12	AAMI	Stock	8.72	8.84	8.67	8.83	337800.0
2019-08-12	AAOI	Stock	10.55	10.55	9.66	9.75	662600.0
2019-08-12	AAON	Stock	29.04	29.44	28.8933	29.2133	167400.0
2019-08-12	AAP	Stock	143.4	145.35	140.81	142.16	1681100.0
2019-08-12	AAT	Stock	47.22	47.28	46.5	46.75	190800.0
2019-08-12	AAU-DELISTED	Stock	0.8	0.81	0.775	0.7755	251542.0
2019-08-12	AAUAF-DELISTED	Stock	0.8	0.81	0.7725	0.7791	273885.0
2019-08-12	AAWW-DELISTED	Stock	28.97	29.0	27.98	28.07	261876.0
2019-08-12	AAXJ	Stock	63.62	63.78	63.43	63.49	1608794.0
2019-08-12	AAXN-DELISTED	Stock	58.59	60.27	56.88	57.47	892608.0
2019-08-12	AB	Stock	27.5	27.74	26.85	26.97	264200.0
2019-08-12	ABB-DELISTED	Stock	18.76	18.76	18.49	18.495	2233534.0
2019-08-12	ABBNY-DELISTED	Stock	18.76	18.76	18.49	18.5	3358127.0
2019-08-12	ABBV	Stock	65.24	65.48	64.08	64.53	5258900.0
2019-08-12	ABC-DELISTED	Stock	87.37	87.87	86.55	87.37	619015.0
2019-08-12	ABCB	Stock	37.13	37.13	36.4	36.42	251900.0
2019-08-12	ABDC-DELISTED	Stock	8.09	8.26	8.09	8.12	50202.0
2019-08-12	ABEO	Stock	53.75	59.25	53.0	57.0	37764.0
2019-08-12	ABEOW-DELISTED	Stock	0.15	0.15	0.15	0.15	2500.0
2019-08-12	ABEV	Stock	4.87	4.9	4.82	4.88	25714700.0
2019-08-12	ABG	Stock	92.34	93.43	91.01	91.46	102100.0
2019-08-12	ABIL-DELISTED	Stock	0.6835	0.6835	0.6027	0.6202	36225.0
2019-08-12	ABM	Stock	40.35	40.36	39.65	39.78	183200.0
2019-08-12	ABMD-DELISTED	Stock	188.67	193.415	187.434	191.61	352854.0
2019-08-12	ABR	Stock	12.64	12.8	12.58	12.63	1464800.0
2019-08-12	ABR.A-DELISTED	Stock	26.4	26.4	26.2601	26.3	3199.0
2019-08-12	ABR.B-DELISTED	Stock	26.0	26.0	26.0	26.0	1000.0
2019-08-12	ABR.C-DELISTED	Stock	26.9	27.3	26.74	27.29	2805.0

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

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