PREVIEW / stock_daily / 2021-06-02

all stock daily files

  file:    by_date/stock_daily/2021/2021-06-02.parquet
  size:    257 KB
  rows:    7,839
  symbols: 2,924

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-02	AAPL	Stock	124.28	125.24	124.05	125.06	59278900.0
2021-06-02	MSFT	Stock	248.13	249.27	245.84	247.3	19406700.0
2021-06-02	NVDA	Stock	16.2522	16.9188	16.2355	16.7782	594168000.0
2021-06-02	AMZN	Stock	161.155	161.75	160.4	161.6995	40290000.0
2021-06-02	GOOGL	Stock	119.4575	119.682	117.6178	118.5295	21162920.0
2021-06-02	META	Stock	330.38	331.87	327.12	329.15	11654300.0
2021-06-02	TSLA	Stock	206.71	207.7867	199.7133	201.7067	69908400.0
2021-06-02	TLT	Stock	138.55	138.79	138.32	138.53	7347905.0
2021-06-02	ES	Stock	79.88	81.24	79.8	80.74	1572900.0
2021-06-02	CL	Stock	82.77	83.28	82.51	82.88	3749600.0
2021-06-02	A	Stock	137.12	138.22	135.88	136.57	1395700.0
2021-06-02	AA	Stock	40.7	40.7	39.46	40.0	5504600.0
2021-06-02	AAC-DELISTED	Stock	9.82	9.86	9.79	9.79	641530.0
2021-06-02	AACG	Stock	3.14	3.17	2.96	3.12	157100.0
2021-06-02	AACQ-DELISTED	Stock	9.94	9.97	9.94	9.96	1706885.0
2021-06-02	AACQU-DELISTED	Stock	10.56	10.6199	10.51	10.6199	15461.0
2021-06-02	AACQW-DELISTED	Stock	1.75	1.91	1.68	1.9	106512.0
2021-06-02	AAIC-DELISTED	Stock	4.14	4.14	4.06	4.07	110386.0
2021-06-02	AAIC.C-DELISTED	Stock	25.4	25.4	25.2495	25.2499	1800.0
2021-06-02	AAL	Stock	24.76	26.04	24.65	25.82	57686200.0
2021-06-02	AAM.A-DELISTED	Stock	25.97	26.08	25.89	25.97	54096.0
2021-06-02	AAM.B-DELISTED	Stock	26.94	27.14	26.94	27.13	17046.0
2021-06-02	AAME	Stock	4.43	5.19	4.34	5.0	1649400.0
2021-06-02	AAMI	Stock	22.59	22.59	22.34	22.36	253800.0
2021-06-02	AAN-DELISTED	Stock	36.22	36.35	35.85	36.09	289100.0
2021-06-02	AAOI	Stock	8.56	8.744	8.56	8.64	761000.0
2021-06-02	AAON	Stock	44.36	44.36	42.3133	42.4667	235650.0
2021-06-02	AAP	Stock	195.77	198.0	191.04	191.33	1605400.0
2021-06-02	AAQC-DELISTED	Stock	9.7143	9.7143	9.67	9.71	23597.0
2021-06-02	AAT	Stock	37.99	38.48	37.69	38.4	376400.0
2021-06-02	AAU-DELISTED	Stock	0.5485	0.55	0.5352	0.5444	1205433.0
2021-06-02	AAUAF-DELISTED	Stock	0.5485	0.55	0.5352	0.5467	1224443.0
2021-06-02	AAWW-DELISTED	Stock	75.6	75.75	73.7701	74.42	211343.0
2021-06-02	AAXJ	Stock	95.82	95.94	95.58	95.84	368635.0
2021-06-02	AB	Stock	44.98	45.13	44.61	45.01	208800.0
2021-06-02	ABB-DELISTED	Stock	34.73	34.92	34.65	34.78	778771.0
2021-06-02	ABBNY-DELISTED	Stock	34.73	34.92	34.65	34.78	1012179.0
2021-06-02	ABBV	Stock	112.41	112.66	110.85	111.4	8100700.0
2021-06-02	ABC-DELISTED	Stock	115.25	115.86	114.14	115.1	744149.0
2021-06-02	ABCB	Stock	56.41	56.56	55.39	55.86	323700.0
2021-06-02	ABCL	Stock	26.5	27.6	26.16	26.87	928600.0
2021-06-02	ABCM-DELISTED	Stock	19.22	22.6	19.22	20.65	1272528.0
2021-06-02	ABEO	Stock	43.0	44.25	42.5	44.0	68220.0
2021-06-02	ABEV	Stock	3.65	3.89	3.65	3.81	69064100.0
2021-06-02	ABG	Stock	205.81	205.81	192.5	193.03	136700.0
2021-06-02	ABGI-DELISTED	Stock	9.9	9.9	9.87	9.9	19217.0
2021-06-02	ABM	Stock	50.69	51.0	48.94	49.21	341900.0
2021-06-02	ABMD-DELISTED	Stock	280.17	283.0	276.06	280.57	172204.0
2021-06-02	ABNB	Stock	145.35	152.7	144.4	151.0	16245100.0
2021-06-02	ABR	Stock	18.7	18.84	18.37	18.4	1740600.0

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

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