PREVIEW / stock_daily / 2021-05-14

all stock daily files

  file:    by_date/stock_daily/2021/2021-05-14.parquet
  size:    255 KB
  rows:    7,818
  symbols: 2,935

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-14	AAPL	Stock	126.25	127.89	125.85	127.45	81918000.0
2021-05-14	MSFT	Stock	245.58	249.18	245.49	248.15	23901100.0
2021-05-14	NVDA	Stock	13.89	14.328	13.7485	14.243	258616000.0
2021-05-14	AMZN	Stock	159.278	161.443	159.15	161.145	66500000.0
2021-05-14	GOOGL	Stock	112.927	114.236	112.5	113.919	31996580.0
2021-05-14	META	Stock	309.54	316.85	309.08	315.94	19245700.0
2021-05-14	TSLA	Stock	194.47	197.6233	190.1533	196.58	100112700.0
2021-05-14	TLT	Stock	136.53	137.08	136.22	137.08	17566732.0
2021-05-14	ES	Stock	85.1	86.34	85.1	85.12	1595400.0
2021-05-14	CL	Stock	83.49	84.01	83.36	83.56	4146500.0
2021-05-14	A	Stock	130.47	131.69	130.45	131.15	775100.0
2021-05-14	AA	Stock	39.1	39.98	38.651	39.7	4718200.0
2021-05-14	AAC-DELISTED	Stock	9.82	9.83	9.76	9.83	153171.0
2021-05-14	AACG	Stock	2.63	2.76	2.61	2.75	59500.0
2021-05-14	AACQ-DELISTED	Stock	9.87	9.8955	9.85	9.85	725469.0
2021-05-14	AACQU-DELISTED	Stock	10.4034	10.4034	10.28	10.3757	3520.0
2021-05-14	AACQW-DELISTED	Stock	1.68	1.68	1.48	1.54	70067.0
2021-05-14	AAIC-DELISTED	Stock	4.0	4.065	4.0	4.05	177332.0
2021-05-14	AAIC.C-DELISTED	Stock	24.16	24.39	24.14	24.3165	2830.0
2021-05-14	AAL	Stock	21.43	22.48	21.43	22.4	39182500.0
2021-05-14	AAM.A-DELISTED	Stock	26.25	26.3	26.17	26.3	11129.0
2021-05-14	AAM.B-DELISTED	Stock	27.01	27.061	26.93	27.0285	6072.0
2021-05-14	AAMC-DELISTED	Stock	4.6935	4.7094	4.6559	4.7094	5260.0
2021-05-14	AAME	Stock	4.14	4.25	4.1	4.13	29200.0
2021-05-14	AAMI	Stock	22.71	23.08	22.56	23.08	163900.0
2021-05-14	AAN-DELISTED	Stock	31.51	32.98	31.14	32.57	247800.0
2021-05-14	AAOI	Stock	7.24	7.525	7.11	7.47	430100.0
2021-05-14	AAON	Stock	44.3733	45.8867	44.04	45.76	203850.0
2021-05-14	AAP	Stock	205.76	206.46	201.14	202.81	602500.0
2021-05-14	AAQC-DELISTED	Stock	9.69	9.8	9.66	9.76	21728.0
2021-05-14	AAT	Stock	34.69	35.05	34.53	34.97	143300.0
2021-05-14	AAU-DELISTED	Stock	0.51	0.51	0.5	0.5099	923954.0
2021-05-14	AAUAF-DELISTED	Stock	0.51	0.51	0.5	0.51	983153.0
2021-05-14	AAWW-DELISTED	Stock	73.51	74.1	72.78	74.0	211194.0
2021-05-14	AAXJ	Stock	90.33	90.94	90.06	90.77	2823060.0
2021-05-14	AB	Stock	43.52	45.01	43.52	44.37	324400.0
2021-05-14	ABB-DELISTED	Stock	33.85	34.32	33.785	34.21	1530668.0
2021-05-14	ABBNY-DELISTED	Stock	33.85	34.32	33.785	34.22	1656300.0
2021-05-14	ABBV	Stock	117.36	117.59	116.38	116.43	6268500.0
2021-05-14	ABC-DELISTED	Stock	119.36	119.36	116.41	116.48	2126941.0
2021-05-14	ABCB	Stock	56.35	57.05	55.89	56.94	367400.0
2021-05-14	ABCL	Stock	31.75	32.88	30.5	31.75	902200.0
2021-05-14	ABCM-DELISTED	Stock	19.81	20.45	19.695	20.14	63234.0
2021-05-14	ABEO	Stock	32.5	36.25	32.5	34.5	57860.0
2021-05-14	ABEV	Stock	3.27	3.33	3.27	3.31	19361500.0
2021-05-14	ABG	Stock	202.48	210.59	201.46	209.85	97700.0
2021-05-14	ABGI-DELISTED	Stock	9.81	9.81	9.81	9.81	654.0
2021-05-14	ABM	Stock	52.89	53.52	52.61	53.45	261500.0
2021-05-14	ABMD-DELISTED	Stock	266.28	272.92	261.271	268.55	148172.0
2021-05-14	ABNB	Stock	137.68	142.25	131.67	141.2	20325400.0

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

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