PREVIEW / stock_daily / 2019-08-07

all stock daily files

  file:    by_date/stock_daily/2019/2019-08-07.parquet
  size:    221 KB
  rows:    6,613
  symbols: 2,540

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-07	AAPL	Stock	48.8525	49.89	48.455	49.76	133457600.0
2019-08-07	MSFT	Stock	133.79	135.65	131.83	135.28	33414500.0
2019-08-07	NVDA	Stock	3.7475	3.8592	3.73	3.8472	372560000.0
2019-08-07	AMZN	Stock	88.6995	89.9465	87.85	89.67	90538000.0
2019-08-07	GOOGL	Stock	57.89	58.9935	57.542	58.7955	30686940.0
2019-08-07	META	Stock	183.6	186.37	181.22	185.15	15833200.0
2019-08-07	TSLA	Stock	15.1	15.5713	15.0533	15.5613	71647500.0
2019-08-07	TLT	Stock	142.4	143.06	139.78	140.03	32582045.0
2019-08-07	ES	Stock	77.45	78.36	76.63	77.89	1672100.0
2019-08-07	CL	Stock	69.44	70.77	68.47	70.44	4222100.0
2019-08-07	A	Stock	66.87	68.27	66.48	67.97	2172900.0
2019-08-07	AA	Stock	19.53	19.63	19.15	19.58	2949000.0
2019-08-07	AABA-DELISTED	Stock	69.54	70.07	69.27	69.83	4931157.0
2019-08-07	AAC-DELISTED	Stock	0.7938	0.8299	0.79	0.7913	79040.0
2019-08-07	AACG	Stock	2.3	2.41	2.3	2.37	9600.0
2019-08-07	AAIC-DELISTED	Stock	6.18	6.2	5.89	5.89	623803.0
2019-08-07	AAIC.C-DELISTED	Stock	23.13	23.35	22.45	22.45	11528.0
2019-08-07	AAL	Stock	28.0	28.76	27.82	28.63	6771500.0
2019-08-07	AAM.A-DELISTED	Stock	25.94	26.27	25.94	26.27	12180.0
2019-08-07	AAM.B-DELISTED	Stock	26.4736	26.63	26.46	26.6	11316.0
2019-08-07	AAMC-DELISTED	Stock	3.1765	3.2445	2.4412	3.2353	86761.0
2019-08-07	AAME	Stock	2.37	2.44	2.37	2.41	1000.0
2019-08-07	AAMI	Stock	9.07	9.07	8.76	8.91	504700.0
2019-08-07	AAOI	Stock	10.0	10.9	9.954	10.21	1642100.0
2019-08-07	AAON	Stock	29.6	30.02	29.52	29.8267	156750.0
2019-08-07	AAP	Stock	144.41	145.31	142.21	144.04	1524000.0
2019-08-07	AAT	Stock	45.96	46.78	45.41	46.56	298000.0
2019-08-07	AAU-DELISTED	Stock	0.8	0.8151	0.77	0.79	430602.0
2019-08-07	AAUAF-DELISTED	Stock	0.8	0.8151	0.77	0.79	441514.0
2019-08-07	AAWW-DELISTED	Stock	30.31	30.31	29.18	29.63	375493.0
2019-08-07	AAXJ	Stock	63.34	64.25	63.11	64.15	1383792.0
2019-08-07	AAXN-DELISTED	Stock	64.52	65.94	64.1	65.52	885604.0
2019-08-07	AB	Stock	27.7	28.11	27.4	28.0	231000.0
2019-08-07	ABB-DELISTED	Stock	17.8	18.0281	17.71	17.98	1806301.0
2019-08-07	ABBNY-DELISTED	Stock	17.79	18.0281	17.71	17.97	1928597.0
2019-08-07	ABBV	Stock	64.38	64.9	63.31	64.46	10532100.0
2019-08-07	ABC-DELISTED	Stock	83.78	86.04	81.8	85.85	1479121.0
2019-08-07	ABCB	Stock	36.26	36.83	35.89	36.7	250700.0
2019-08-07	ABDC-DELISTED	Stock	8.32	8.32	8.17	8.18	20227.0
2019-08-07	ABEO	Stock	60.0	63.5	59.0	61.25	19312.0
2019-08-07	ABEV	Stock	5.05	5.22	5.03	5.21	27392500.0
2019-08-07	ABG	Stock	91.83	92.82	90.13	91.9	137400.0
2019-08-07	ABIL-DELISTED	Stock	0.73	0.7399	0.6701	0.7036	21139.0
2019-08-07	ABM	Stock	39.75	40.12	39.42	40.07	224100.0
2019-08-07	ABMD-DELISTED	Stock	198.95	199.1	189.625	189.92	765209.0
2019-08-07	ABR	Stock	12.4	12.62	12.23	12.55	1337200.0
2019-08-07	ABR.A-DELISTED	Stock	26.1208	26.18	26.1208	26.18	1290.0
2019-08-07	ABR.B-DELISTED	Stock	25.835	25.85	25.68	25.85	2530.0
2019-08-07	ABR.C-DELISTED	Stock	26.3792	26.55	26.3792	26.55	600.0
2019-08-07	ABT	Stock	83.8	85.0	82.31	84.6	5502600.0

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

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