PREVIEW / stock_daily / 2021-05-12

all stock daily files

  file:    by_date/stock_daily/2021/2021-05-12.parquet
  size:    255 KB
  rows:    7,819
  symbols: 2,949

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-12	AAPL	Stock	123.4	124.64	122.25	122.77	112172300.0
2021-05-12	MSFT	Stock	242.17	244.38	238.07	239.0	36684400.0
2021-05-12	NVDA	Stock	14.0095	14.2602	13.7092	13.7585	303408000.0
2021-05-12	AMZN	Stock	159.25	160.397	156.655	157.597	98728000.0
2021-05-12	GOOGL	Stock	111.3095	112.399	109.681	110.0125	46375480.0
2021-05-12	META	Stock	301.13	304.96	298.19	302.55	24645500.0
2021-05-12	TSLA	Stock	200.83	206.8033	195.59	196.63	101470800.0
2021-05-12	TLT	Stock	136.67	136.8	135.36	135.6	20859432.0
2021-05-12	ES	Stock	83.87	84.01	82.66	82.68	1610900.0
2021-05-12	CL	Stock	82.51	82.84	81.93	82.05	4075100.0
2021-05-12	A	Stock	130.34	131.17	128.47	128.64	1256400.0
2021-05-12	AA	Stock	41.13	42.24	39.15	39.51	8252200.0
2021-05-12	AAC-DELISTED	Stock	9.84	9.895	9.83	9.88	1521451.0
2021-05-12	AACG	Stock	2.8	2.88	2.7	2.74	46000.0
2021-05-12	AACQ-DELISTED	Stock	9.83	9.88	9.83	9.86	538180.0
2021-05-12	AACQU-DELISTED	Stock	10.3	10.39	10.27	10.35	3214.0
2021-05-12	AACQW-DELISTED	Stock	1.65	1.65	1.55	1.64	76052.0
2021-05-12	AAIC-DELISTED	Stock	3.98	4.03	3.9	3.91	325739.0
2021-05-12	AAIC.C-DELISTED	Stock	24.46	24.48	24.25	24.3411	2378.0
2021-05-12	AAL	Stock	21.36	21.69	20.69	20.76	34605300.0
2021-05-12	AAM.A-DELISTED	Stock	26.1	26.13	26.05	26.12	39427.0
2021-05-12	AAM.B-DELISTED	Stock	26.86	26.96	26.79	26.84	12481.0
2021-05-12	AAMC-DELISTED	Stock	4.9488	4.9488	4.8294	4.8441	12087.0
2021-05-12	AAME	Stock	3.89	4.2	3.83	4.19	101700.0
2021-05-12	AAMI	Stock	22.39	22.71	21.92	22.0	342300.0
2021-05-12	AAN-DELISTED	Stock	31.39	31.96	28.88	29.48	858900.0
2021-05-12	AAOI	Stock	7.2	7.38	7.04	7.13	783400.0
2021-05-12	AAON	Stock	43.3867	43.88	42.66	42.9867	236700.0
2021-05-12	AAP	Stock	204.75	205.91	201.27	201.79	735400.0
2021-05-12	AAQC-DELISTED	Stock	9.74	9.74	9.71	9.71	404.0
2021-05-12	AAT	Stock	34.01	34.37	33.27	33.4	251100.0
2021-05-12	AAU-DELISTED	Stock	0.53	0.53	0.5121	0.5151	453011.0
2021-05-12	AAUAF-DELISTED	Stock	0.53	0.53	0.5121	0.5211	500724.0
2021-05-12	AAWW-DELISTED	Stock	72.06	72.455	69.83	70.5	383805.0
2021-05-12	AAXJ	Stock	90.4	90.65	89.28	89.35	3942360.0
2021-05-12	AB	Stock	43.41	43.69	41.64	41.71	518400.0
2021-05-12	ABB-DELISTED	Stock	33.02	33.175	32.511	32.57	1294238.0
2021-05-12	ABBNY-DELISTED	Stock	33.02	33.175	32.511	32.57	1413854.0
2021-05-12	ABBV	Stock	114.85	116.0	114.44	114.96	6208300.0
2021-05-12	ABC-DELISTED	Stock	120.04	120.66	119.09	120.1	763061.0
2021-05-12	ABCB	Stock	55.88	56.07	54.1	54.25	593400.0
2021-05-12	ABCL	Stock	28.0	30.97	27.73	30.72	906700.0
2021-05-12	ABCM-DELISTED	Stock	20.52	20.61	20.06	20.39	254465.0
2021-05-12	ABEO	Stock	33.0	36.25	32.25	35.25	75700.0
2021-05-12	ABEV	Stock	3.24	3.32	3.21	3.22	33189100.0
2021-05-12	ABG	Stock	198.56	200.94	192.28	197.66	211800.0
2021-05-12	ABGI-DELISTED	Stock	9.76	9.86	9.76	9.86	600.0
2021-05-12	ABM	Stock	51.5	51.94	50.52	50.59	333100.0
2021-05-12	ABMD-DELISTED	Stock	276.59	280.83	271.64	271.93	151553.0
2021-05-12	ABNB	Stock	140.9	144.77	138.75	140.25	5307500.0

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

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