PREVIEW / stock_daily / 2021-06-03

all stock daily files

  file:    by_date/stock_daily/2021/2021-06-03.parquet
  size:    256 KB
  rows:    7,837
  symbols: 2,910

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-06-03	AAPL	Stock	124.68	124.85	123.13	123.54	76229200.0
2021-06-03	MSFT	Stock	245.22	246.34	243.0	245.71	25307700.0
2021-06-03	NVDA	Stock	16.7008	17.259	16.583	16.9698	580008000.0
2021-06-03	AMZN	Stock	160.2115	160.722	159.2015	159.3505	47966000.0
2021-06-03	GOOGL	Stock	117.2865	117.8508	116.476	117.379	18695920.0
2021-06-03	META	Stock	325.78	327.38	323.48	326.04	12610800.0
2021-06-03	TSLA	Stock	200.6	201.5167	190.4067	190.9467	90335700.0
2021-06-03	TLT	Stock	138.51	138.51	137.845	138.01	10994063.0
2021-06-03	ES	Stock	80.67	82.49	80.27	82.2	2471000.0
2021-06-03	CL	Stock	82.93	83.96	82.73	83.95	3967000.0
2021-06-03	A	Stock	136.0	136.91	135.74	136.37	1228700.0
2021-06-03	AA	Stock	39.02	39.54	38.268	38.72	5030100.0
2021-06-03	AAC-DELISTED	Stock	9.82	9.85	9.8	9.85	166511.0
2021-06-03	AACG	Stock	3.19	3.29	3.01	3.24	130500.0
2021-06-03	AACQ-DELISTED	Stock	9.955	9.97	9.95	9.96	1478635.0
2021-06-03	AACQU-DELISTED	Stock	10.5887	10.5887	10.5887	10.5887	300.0
2021-06-03	AACQW-DELISTED	Stock	1.88	1.9	1.85	1.9	73308.0
2021-06-03	AAIC-DELISTED	Stock	4.04	4.07	4.01	4.01	178533.0
2021-06-03	AAIC.C-DELISTED	Stock	25.25	25.25	25.15	25.15	3361.0
2021-06-03	AAL	Stock	25.42	25.58	24.9	24.93	38254900.0
2021-06-03	AAM.A-DELISTED	Stock	25.97	26.0	25.92	25.99	15935.0
2021-06-03	AAM.B-DELISTED	Stock	27.08	27.25	27.04	27.22	17021.0
2021-06-03	AAMC-DELISTED	Stock	5.2206	5.2206	5.0059	5.0748	28393.0
2021-06-03	AAME	Stock	5.02	5.43	4.35	4.38	880600.0
2021-06-03	AAMI	Stock	22.27	22.45	22.14	22.26	184600.0
2021-06-03	AAN-DELISTED	Stock	35.87	36.09	35.36	35.99	411000.0
2021-06-03	AAOI	Stock	8.62	8.69	8.37	8.39	509500.0
2021-06-03	AAON	Stock	42.2	42.9133	41.8733	42.7867	156150.0
2021-06-03	AAP	Stock	190.79	192.8	188.96	191.14	918300.0
2021-06-03	AAQC-DELISTED	Stock	9.6707	9.74	9.6707	9.74	113545.0
2021-06-03	AAT	Stock	38.51	38.52	37.85	38.15	374100.0
2021-06-03	AAU-DELISTED	Stock	0.5444	0.5444	0.527	0.53	682447.0
2021-06-03	AAUAF-DELISTED	Stock	0.5444	0.5444	0.527	0.531	706203.0
2021-06-03	AAWW-DELISTED	Stock	74.21	74.87	72.8	74.23	245426.0
2021-06-03	AAXJ	Stock	94.88	95.0899	94.57	94.75	694453.0
2021-06-03	AB	Stock	44.89	45.96	44.7	45.39	312300.0
2021-06-03	ABB-DELISTED	Stock	34.6	34.73	34.4	34.62	730914.0
2021-06-03	ABBNY-DELISTED	Stock	34.6	34.73	34.4	34.63	805990.0
2021-06-03	ABBV	Stock	111.12	112.41	110.65	112.21	6286100.0
2021-06-03	ABC-DELISTED	Stock	115.11	117.25	114.96	116.86	697247.0
2021-06-03	ABCB	Stock	55.73	56.72	55.29	56.52	349900.0
2021-06-03	ABCL	Stock	26.7	26.934	25.17	25.57	1042500.0
2021-06-03	ABCM-DELISTED	Stock	19.74	20.3025	19.25	19.49	629485.0
2021-06-03	ABEO	Stock	45.5	48.0	43.5	45.5	93500.0
2021-06-03	ABEV	Stock	3.79	3.81	3.73	3.79	14315200.0
2021-06-03	ABG	Stock	192.67	192.8	188.2	190.02	172600.0
2021-06-03	ABGI-DELISTED	Stock	9.87	9.91	9.87	9.9	4450.0
2021-06-03	ABM	Stock	49.04	49.41	48.29	49.36	221200.0
2021-06-03	ABMD-DELISTED	Stock	278.04	284.5	278.04	283.87	188869.0
2021-06-03	ABNB	Stock	149.55	151.12	143.8	144.19	11083300.0

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

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