PREVIEW / stock_daily / 2020-07-21

all stock daily files

  file:    by_date/stock_daily/2020/2020-07-21.parquet
  size:    224 KB
  rows:    6,758
  symbols: 2,414

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
2020-07-21	AAPL	Stock	99.1725	99.25	96.7425	97.0	103433200.0
2020-07-21	MSFT	Stock	213.66	213.94	208.03	208.75	37990400.0
2020-07-21	NVDA	Stock	10.513	10.56	10.2868	10.3285	277036000.0
2020-07-21	AMZN	Stock	161.6245	162.029	155.286	156.9145	122426000.0
2020-07-21	GOOGL	Stock	79.2515	79.3525	77.631	77.796	27554360.0
2020-07-21	META	Stock	246.22	246.91	240.08	241.75	19364200.0
2020-07-21	TSLA	Stock	109.3287	111.6667	103.8667	104.5573	241608000.0
2020-07-21	TLT	Stock	167.3	167.72	167.075	167.29	8455112.0
2020-07-21	ES	Stock	85.75	88.58	85.25	87.17	1673700.0
2020-07-21	CL	Stock	74.36	74.85	73.97	74.04	2920200.0
2020-07-21	A	Stock	95.57	96.45	95.16	96.02	2169100.0
2020-07-21	AA	Stock	12.83	13.27	12.81	13.16	5730800.0
2020-07-21	AACG	Stock	1.34	1.36	1.31	1.31	41000.0
2020-07-21	AACQU-DELISTED	Stock	10.46	10.49	10.425	10.45	484865.0
2020-07-21	AAIC-DELISTED	Stock	2.97	3.09	2.97	3.07	174538.0
2020-07-21	AAIC.C-DELISTED	Stock	19.45	19.45	19.45	19.45	260.0
2020-07-21	AAL	Stock	11.57	11.79	11.28	11.47	64509800.0
2020-07-21	AAM.A-DELISTED	Stock	26.45	26.595	26.42	26.595	12675.0
2020-07-21	AAM.B-DELISTED	Stock	27.03	27.1302	26.99	26.995	19350.0
2020-07-21	AAMC-DELISTED	Stock	4.2618	4.4265	4.2618	4.2647	20424.0
2020-07-21	AAME	Stock	1.75	1.83	1.73	1.75	2100.0
2020-07-21	AAMI	Stock	12.66	12.82	12.48	12.7	723200.0
2020-07-21	AAOI	Stock	13.01	14.262	12.43	13.925	3150700.0
2020-07-21	AAON	Stock	38.76	38.8933	38.22	38.6	193500.0
2020-07-21	AAP	Stock	145.38	148.08	145.03	147.38	756100.0
2020-07-21	AAT	Stock	25.49	26.06	25.49	25.69	169600.0
2020-07-21	AAU-DELISTED	Stock	0.567	0.5899	0.55	0.5764	1200638.0
2020-07-21	AAUAF-DELISTED	Stock	0.567	0.5899	0.55	0.5806	1289299.0
2020-07-21	AAWW-DELISTED	Stock	50.25	50.79	49.8644	50.41	195793.0
2020-07-21	AAXJ	Stock	75.98	75.98	75.39	75.39	896286.0
2020-07-21	AAXN-DELISTED	Stock	94.01	95.0	91.76	92.17	408534.0
2020-07-21	AB	Stock	28.4	29.04	28.27	28.85	232700.0
2020-07-21	ABB-DELISTED	Stock	24.98	25.0	24.815	24.85	1561040.0
2020-07-21	ABBNY-DELISTED	Stock	24.98	25.0	24.815	24.85	1848493.0
2020-07-21	ABBV	Stock	99.81	99.81	97.17	97.4	8239000.0
2020-07-21	ABC-DELISTED	Stock	102.27	104.25	102.21	104.17	868048.0
2020-07-21	ABCB	Stock	21.31	22.54	21.1	22.42	290400.0
2020-07-21	ABEO	Stock	79.75	79.75	73.75	75.25	48004.0
2020-07-21	ABEV	Stock	2.71	2.87	2.7	2.86	52872800.0
2020-07-21	ABG	Stock	99.22	100.94	99.01	99.79	174300.0
2020-07-21	ABM	Stock	35.37	36.35	35.3	35.8	309600.0
2020-07-21	ABMD-DELISTED	Stock	294.49	300.025	290.93	298.6	427642.0
2020-07-21	ABR	Stock	8.64	8.76	8.57	8.65	850100.0
2020-07-21	ABR.A-DELISTED	Stock	24.79	24.79	24.537	24.75	5685.0
2020-07-21	ABR.B-DELISTED	Stock	23.5	23.6931	23.45	23.45	4250.0
2020-07-21	ABR.C-DELISTED	Stock	24.69	24.7	24.5055	24.66	4085.0
2020-07-21	ABT	Stock	98.88	99.48	97.76	98.19	5063500.0
2020-07-21	ABTC	Stock	203700.0	207000.0	195300.0	197700.0	3.5733333333333333
2020-07-21	ABTS	Stock	16.65	16.65	15.45	15.525	6400.0
2020-07-21	ABTX-DELISTED	Stock	22.8	24.115	22.8	24.0	38480.0

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

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