PREVIEW / stock_daily / 2020-06-22

all stock daily files

  file:    by_date/stock_daily/2020/2020-06-22.parquet
  size:    222 KB
  rows:    6,706
  symbols: 2,389

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-06-22	AAPL	Stock	87.835	89.865	87.7875	89.7175	135445200.0
2020-06-22	MSFT	Stock	195.79	200.76	195.23	200.57	32818900.0
2020-06-22	NVDA	Stock	9.3	9.5312	9.2733	9.5268	398468000.0
2020-06-22	AMZN	Stock	134.225	135.75	133.45	135.691	64176000.0
2020-06-22	GOOGL	Stock	71.2505	72.5475	70.9595	72.533	29441440.0
2020-06-22	META	Stock	238.56	240.7	236.91	239.22	18917800.0
2020-06-22	TSLA	Stock	66.6633	67.2587	66.0013	66.288	95436000.0
2020-06-22	TLT	Stock	163.19	163.4184	162.07	162.41	9319961.0
2020-06-22	ES	Stock	82.88	84.97	82.37	84.18	1554800.0
2020-06-22	CL	Stock	73.39	73.46	72.72	73.1	2220400.0
2020-06-22	A	Stock	88.64	89.07	87.77	88.53	1245500.0
2020-06-22	AA	Stock	11.42	11.91	11.33	11.83	7827400.0
2020-06-22	AACG	Stock	1.0	1.17	0.97	1.14	115500.0
2020-06-22	AAIC-DELISTED	Stock	2.82	2.878	2.77	2.85	577849.0
2020-06-22	AAIC.C-DELISTED	Stock	19.6	19.8584	19.6	19.63	4000.0
2020-06-22	AAL	Stock	14.9	15.52	14.72	14.92	118994500.0
2020-06-22	AAM.A-DELISTED	Stock	26.16	26.27	25.97	26.18	16184.0
2020-06-22	AAM.B-DELISTED	Stock	25.92	25.98	25.77	25.91	7249.0
2020-06-22	AAMC-DELISTED	Stock	5.1353	5.1353	4.7	4.7397	24415.0
2020-06-22	AAME	Stock	1.87	1.93	1.85	1.85	12200.0
2020-06-22	AAMI	Stock	10.01	10.29	9.86	10.29	1068000.0
2020-06-22	AAOI	Stock	9.76	10.16	9.75	9.94	635800.0
2020-06-22	AAON	Stock	35.3333	36.1133	34.6733	36.0333	232350.0
2020-06-22	AAP	Stock	145.11	152.27	144.53	151.6	1790600.0
2020-06-22	AAT	Stock	28.02	28.58	27.6	28.34	450200.0
2020-06-22	AAU-DELISTED	Stock	0.47	0.4899	0.4616	0.486	266865.0
2020-06-22	AAUAF-DELISTED	Stock	0.47	0.4899	0.4616	0.4871	294312.0
2020-06-22	AAWW-DELISTED	Stock	40.53	40.6	39.2883	40.48	270124.0
2020-06-22	AAXJ	Stock	69.15	69.77	69.03	69.71	988964.0
2020-06-22	AAXN-DELISTED	Stock	90.35	93.7	88.53	92.66	589702.0
2020-06-22	AB	Stock	26.66	26.93	26.38	26.6	328000.0
2020-06-22	ABB-DELISTED	Stock	21.71	21.94	21.62	21.88	2095260.0
2020-06-22	ABBNY-DELISTED	Stock	21.71	21.94	21.62	21.87	2183971.0
2020-06-22	ABBV	Stock	96.64	97.3	95.82	97.27	6004300.0
2020-06-22	ABC-DELISTED	Stock	101.79	101.86	100.125	101.71	698260.0
2020-06-22	ABCB	Stock	23.74	24.47	23.23	24.31	438600.0
2020-06-22	ABEO	Stock	77.75	77.75	73.75	74.5	46280.0
2020-06-22	ABEV	Stock	2.63	2.74	2.63	2.71	46836100.0
2020-06-22	ABG	Stock	73.79	76.65	72.99	75.88	201300.0
2020-06-22	ABM	Stock	37.88	39.26	37.47	38.99	589800.0
2020-06-22	ABMD-DELISTED	Stock	258.88	259.245	253.615	254.44	239097.0
2020-06-22	ABR	Stock	9.6	9.74	9.45	9.61	1780500.0
2020-06-22	ABR.A-DELISTED	Stock	24.8898	24.8898	24.81	24.81	1901.0
2020-06-22	ABR.B-DELISTED	Stock	23.56	23.728	23.2	23.45	2638.0
2020-06-22	ABR.C-DELISTED	Stock	24.55	24.98	24.55	24.98	2696.0
2020-06-22	ABT	Stock	90.33	90.65	89.16	90.34	5072800.0
2020-06-22	ABTC	Stock	276300.0	284400.0	255000.0	256500.0	7.866666666666666
2020-06-22	ABTS	Stock	16.05	17.25	15.15	15.45	3113.0
2020-06-22	ABTX-DELISTED	Stock	24.14	25.29	24.04	25.11	35322.0
2020-06-22	ABUS	Stock	2.0	2.1	1.86	2.04	1341300.0

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

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