PREVIEW / stock_daily / 2021-01-19

all stock daily files

  file:    by_date/stock_daily/2021/2021-01-19.parquet
  size:    242 KB
  rows:    7,341
  symbols: 2,678

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
2021-01-19	AAPL	Stock	127.78	128.71	126.94	127.83	90757300.0
2021-01-19	MSFT	Stock	213.75	216.98	212.63	216.44	30480900.0
2021-01-19	NVDA	Stock	13.0162	13.094	12.844	13.0252	226188000.0
2021-01-19	AMZN	Stock	155.35	157.25	154.8	156.038	66102000.0
2021-01-19	GOOGL	Stock	87.15	90.192	86.6415	89.2235	41659020.0
2021-01-19	META	Stock	256.9	262.2	252.72	261.1	28028500.0
2021-01-19	TSLA	Stock	279.2667	283.3333	277.6667	281.5167	76101000.0
2021-01-19	TLT	Stock	151.62	152.36	151.505	152.31	9575571.0
2021-01-19	ES	Stock	89.0	89.19	87.02	87.14	1739500.0
2021-01-19	CL	Stock	82.55	82.55	80.74	80.85	4004300.0
2021-01-19	A	Stock	127.38	127.8	126.29	127.35	1677200.0
2021-01-19	AA	Stock	23.89	24.22	22.86	23.09	5737700.0
2021-01-19	AACG	Stock	1.3	1.39	1.27	1.3	63300.0
2021-01-19	AACQ-DELISTED	Stock	10.86	10.9	10.72	10.84	1429783.0
2021-01-19	AACQU-DELISTED	Stock	11.71	11.71	11.46	11.58	109583.0
2021-01-19	AACQW-DELISTED	Stock	2.4	2.47	2.28	2.32	385935.0
2021-01-19	AAIC-DELISTED	Stock	3.91	3.91	3.81	3.86	200284.0
2021-01-19	AAIC.C-DELISTED	Stock	21.3965	21.3999	21.3965	21.3999	210.0
2021-01-19	AAL	Stock	15.99	16.27	15.89	15.97	39740200.0
2021-01-19	AAM.A-DELISTED	Stock	26.4	26.5235	26.4	26.41	15138.0
2021-01-19	AAM.B-DELISTED	Stock	26.74	26.9682	26.74	26.875	9316.0
2021-01-19	AAMC-DELISTED	Stock	6.0941	6.5412	6.0941	6.4191	13807.0
2021-01-19	AAME	Stock	2.45	2.45	2.38	2.4	9600.0
2021-01-19	AAMI	Stock	21.33	21.43	20.96	21.24	252500.0
2021-01-19	AAN-DELISTED	Stock	21.75	21.84	20.98	21.07	366800.0
2021-01-19	AAOI	Stock	10.95	10.95	10.52	10.71	754000.0
2021-01-19	AAON	Stock	47.4733	48.0	47.02	47.0533	176550.0
2021-01-19	AAP	Stock	165.11	167.12	163.19	165.93	951300.0
2021-01-19	AAT	Stock	29.16	29.27	28.55	29.27	270500.0
2021-01-19	AAU-DELISTED	Stock	0.56	0.5699	0.552	0.5594	2943165.0
2021-01-19	AAUAF-DELISTED	Stock	0.56	0.5699	0.552	0.5554	3077786.0
2021-01-19	AAWW-DELISTED	Stock	53.84	54.6326	52.5401	52.69	210150.0
2021-01-19	AAXJ	Stock	97.01	97.1	96.5	96.57	1293242.0
2021-01-19	AAXN-DELISTED	Stock	154.83	159.85	154.0	159.37	1018651.0
2021-01-19	AB	Stock	35.44	36.19	35.41	36.05	308600.0
2021-01-19	ABB-DELISTED	Stock	29.5	29.65	29.4121	29.5	1016340.0
2021-01-19	ABBNY-DELISTED	Stock	29.5	29.65	29.4121	29.5	1116315.0
2021-01-19	ABBV	Stock	111.25	112.31	110.26	112.18	7723800.0
2021-01-19	ABC-DELISTED	Stock	107.49	107.89	103.24	103.5	1074885.0
2021-01-19	ABCB	Stock	44.27	44.93	43.42	44.65	355900.0
2021-01-19	ABCL	Stock	44.94	49.32	44.94	49.08	1252200.0
2021-01-19	ABCM-DELISTED	Stock	23.15	23.61	23.15	23.19	67547.0
2021-01-19	ABEO	Stock	48.75	54.0	48.25	53.5	190360.0
2021-01-19	ABEV	Stock	3.08	3.09	3.03	3.07	22222200.0
2021-01-19	ABG	Stock	163.95	164.02	157.51	160.39	296000.0
2021-01-19	ABM	Stock	41.53	41.54	39.64	39.72	383800.0
2021-01-19	ABMD-DELISTED	Stock	332.63	338.99	325.985	336.3	167132.0
2021-01-19	ABNB	Stock	173.0	178.6	166.6	173.69	4685400.0
2021-01-19	ABR	Stock	14.4	14.45	14.25	14.32	876200.0
2021-01-19	ABR.A-DELISTED	Stock	25.62	25.72	25.62	25.7	1671.0

> showing 50 of 7,341 rows — these rows as CSV

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