PREVIEW / stock_daily / 2020-07-27

all stock daily files

  file:    by_date/stock_daily/2020/2020-07-27.parquet
  size:    223 KB
  rows:    6,750
  symbols: 2,411

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-27	AAPL	Stock	93.71	94.905	93.48	94.81	121214000.0
2020-07-27	MSFT	Stock	201.47	203.97	200.86	203.85	30160900.0
2020-07-27	NVDA	Stock	10.2322	10.4418	10.2178	10.4215	292132000.0
2020-07-27	AMZN	Stock	153.1	154.9	150.7885	152.7605	83410000.0
2020-07-27	GOOGL	Stock	75.663	76.878	75.6165	76.4715	27123700.0
2020-07-27	META	Stock	231.46	234.95	230.83	233.5	13163100.0
2020-07-27	TSLA	Stock	95.6667	103.196	94.2	102.64	240730500.0
2020-07-27	TLT	Stock	170.25	170.3	168.99	169.11	6146734.0
2020-07-27	ES	Stock	89.48	89.65	87.8	88.7	1014500.0
2020-07-27	CL	Stock	74.1	74.73	74.0	74.65	3182800.0
2020-07-27	A	Stock	94.96	97.54	94.9	97.27	1177100.0
2020-07-27	AA	Stock	12.81	13.31	12.533	13.24	4692300.0
2020-07-27	AACG	Stock	1.17	1.26	1.13	1.14	13800.0
2020-07-27	AACQU-DELISTED	Stock	10.38	10.43	10.38	10.43	7821.0
2020-07-27	AAIC-DELISTED	Stock	2.91	2.95	2.89	2.95	185734.0
2020-07-27	AAIC.C-DELISTED	Stock	18.99	19.0	18.98	19.0	503.0
2020-07-27	AAL	Stock	11.48	11.79	11.18	11.39	69451700.0
2020-07-27	AAM.A-DELISTED	Stock	26.6	26.6	26.38	26.4	8450.0
2020-07-27	AAM.B-DELISTED	Stock	27.11	27.25	27.08	27.16	12994.0
2020-07-27	AAMC-DELISTED	Stock	4.6294	4.6294	4.5471	4.572	3006.0
2020-07-27	AAME	Stock	1.88	1.89	1.8	1.84	2400.0
2020-07-27	AAMI	Stock	12.55	13.99	12.54	13.92	3000300.0
2020-07-27	AAOI	Stock	13.77	14.22	13.64	13.97	821600.0
2020-07-27	AAON	Stock	38.4733	38.6533	38.2333	38.6133	155700.0
2020-07-27	AAP	Stock	147.39	147.88	146.0	146.83	771300.0
2020-07-27	AAT	Stock	25.36	25.81	24.78	25.72	469700.0
2020-07-27	AAU-DELISTED	Stock	0.65	0.65	0.59	0.6099	1408438.0
2020-07-27	AAUAF-DELISTED	Stock	0.65	0.65	0.59	0.61	1470884.0
2020-07-27	AAWW-DELISTED	Stock	47.88	49.81	47.8	49.74	174953.0
2020-07-27	AAXJ	Stock	74.54	75.23	74.41	75.17	2255688.0
2020-07-27	AAXN-DELISTED	Stock	86.13	87.4	84.97	86.44	382061.0
2020-07-27	AB	Stock	28.47	28.83	28.11	28.61	210000.0
2020-07-27	ABB-DELISTED	Stock	25.9	26.14	25.89	26.06	1122786.0
2020-07-27	ABBNY-DELISTED	Stock	25.9	26.14	25.89	26.05	1178704.0
2020-07-27	ABBV	Stock	96.35	97.89	96.26	97.16	5030700.0
2020-07-27	ABC-DELISTED	Stock	103.38	104.365	102.54	103.99	405715.0
2020-07-27	ABCB	Stock	23.28	24.02	22.56	22.96	709500.0
2020-07-27	ABEO	Stock	72.75	76.25	71.75	76.0	17364.0
2020-07-27	ABEV	Stock	2.89	3.0	2.87	2.99	48253500.0
2020-07-27	ABG	Stock	105.68	109.82	104.57	108.77	366000.0
2020-07-27	ABM	Stock	34.25	35.49	34.1	35.46	566000.0
2020-07-27	ABMD-DELISTED	Stock	293.0	300.37	290.045	298.61	173487.0
2020-07-27	ABR	Stock	8.8	8.88	8.68	8.87	859900.0
2020-07-27	ABR.A-DELISTED	Stock	24.82	24.8367	24.64	24.8367	3761.0
2020-07-27	ABR.B-DELISTED	Stock	23.47	23.785	23.47	23.64	5166.0
2020-07-27	ABR.C-DELISTED	Stock	24.84	24.84	24.5259	24.65	8560.0
2020-07-27	ABT	Stock	98.55	100.28	98.41	99.99	3717900.0
2020-07-27	ABTC	Stock	190800.0	193530.0	182400.0	190200.0	2.146666666666667
2020-07-27	ABTS	Stock	14.34	14.7	12.9	13.755	3960.0
2020-07-27	ABTX-DELISTED	Stock	23.85	23.85	22.69	23.49	19675.0

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

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