PREVIEW / stock_daily / 2021-05-04

all stock daily files

  file:    by_date/stock_daily/2021/2021-05-04.parquet
  size:    256 KB
  rows:    7,815
  symbols: 2,953

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-05-04	AAPL	Stock	131.19	131.49	126.7	127.85	137564700.0
2021-05-04	MSFT	Stock	250.97	251.21	245.76	247.79	32756100.0
2021-05-04	NVDA	Stock	14.6373	14.6375	14.0102	14.3512	405324000.0
2021-05-04	AMZN	Stock	167.8095	168.399	163.6065	165.5935	108788000.0
2021-05-04	GOOGL	Stock	115.6775	116.2495	112.834	115.3415	44818640.0
2021-05-04	META	Stock	320.02	322.19	313.12	318.36	24032600.0
2021-05-04	TSLA	Stock	226.3133	227.8167	219.2333	224.5333	89217900.0
2021-05-04	TLT	Stock	139.49	140.16	139.155	139.46	18640004.0
2021-05-04	ES	Stock	86.39	86.79	85.16	86.12	1103500.0
2021-05-04	CL	Stock	81.2	82.0	80.85	81.09	4129500.0
2021-05-04	A	Stock	132.12	132.51	130.35	130.9	1752400.0
2021-05-04	AA	Stock	38.02	39.27	37.65	39.07	6704900.0
2021-05-04	AAC-DELISTED	Stock	9.83	9.8494	9.81	9.82	391110.0
2021-05-04	AACG	Stock	3.03	3.12	2.86	2.9	47500.0
2021-05-04	AACQ-DELISTED	Stock	10.11	10.14	10.03	10.1	868290.0
2021-05-04	AACQU-DELISTED	Stock	10.75	10.75	10.705	10.75	5589.0
2021-05-04	AACQW-DELISTED	Stock	1.9	1.99	1.82	1.95	300808.0
2021-05-04	AAIC-DELISTED	Stock	4.06	4.18	4.06	4.1	158594.0
2021-05-04	AAIC.C-DELISTED	Stock	24.5	24.5926	24.3103	24.4	7543.0
2021-05-04	AAL	Stock	21.78	21.99	20.94	21.42	36050800.0
2021-05-04	AAM.A-DELISTED	Stock	26.07	26.22	26.06	26.195	11793.0
2021-05-04	AAM.B-DELISTED	Stock	27.06	27.19	27.0401	27.18	7924.0
2021-05-04	AAMC-DELISTED	Stock	5.2794	5.285	5.0404	5.0882	129373.0
2021-05-04	AAME	Stock	4.22	4.25	3.91	4.06	257000.0
2021-05-04	AAMI	Stock	22.58	22.71	22.26	22.64	508400.0
2021-05-04	AAN-DELISTED	Stock	30.32	31.17	29.98	30.81	332700.0
2021-05-04	AAOI	Stock	7.19	7.33	6.87	7.26	903300.0
2021-05-04	AAON	Stock	44.0333	44.0333	42.66	42.7067	135900.0
2021-05-04	AAP	Stock	205.01	205.2	201.97	204.15	714500.0
2021-05-04	AAT	Stock	35.08	35.26	34.63	34.78	301300.0
2021-05-04	AAU-DELISTED	Stock	0.57	0.573	0.54	0.5516	1275564.0
2021-05-04	AAUAF-DELISTED	Stock	0.57	0.573	0.54	0.5531	1360333.0
2021-05-04	AAWW-DELISTED	Stock	70.43	70.43	68.2169	69.59	466263.0
2021-05-04	AAXJ	Stock	92.8691	93.04	91.735	92.49	1182727.0
2021-05-04	AB	Stock	44.6	44.95	43.84	44.29	532500.0
2021-05-04	ABB-DELISTED	Stock	32.46	32.66	32.295	32.66	1486215.0
2021-05-04	ABBNY-DELISTED	Stock	32.46	32.66	32.295	32.66	1637804.0
2021-05-04	ABBV	Stock	114.62	115.94	113.05	113.9	8151400.0
2021-05-04	ABC-DELISTED	Stock	123.95	125.86	122.99	125.86	987704.0
2021-05-04	ABCB	Stock	54.07	55.92	53.13	55.86	326000.0
2021-05-04	ABCL	Stock	25.83	28.51	25.58	28.0	1719600.0
2021-05-04	ABCM-DELISTED	Stock	21.51	21.51	20.75	20.94	164576.0
2021-05-04	ABEO	Stock	50.75	51.0	42.5	42.75	188136.0
2021-05-04	ABEV	Stock	2.73	2.74	2.69	2.72	12704900.0
2021-05-04	ABG	Stock	200.18	206.54	198.25	205.43	100600.0
2021-05-04	ABGI-DELISTED	Stock	10.01	10.02	9.95	9.98	18691.0
2021-05-04	ABM	Stock	53.28	53.75	52.28	52.82	465000.0
2021-05-04	ABMD-DELISTED	Stock	307.67	310.19	302.0194	305.0	151630.0
2021-05-04	ABNB	Stock	167.015	169.04	161.96	168.9	4658000.0
2021-05-04	ABR	Stock	17.85	17.95	17.51	17.63	1014100.0

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

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