PREVIEW / stock_daily / 2021-06-16

all stock daily files

  file:    by_date/stock_daily/2021/2021-06-16.parquet
  size:    258 KB
  rows:    7,850
  symbols: 2,903

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-16	AAPL	Stock	130.37	130.89	128.46	130.15	91815000.0
2021-06-16	MSFT	Stock	259.4	260.58	254.42	257.38	27220000.0
2021-06-16	NVDA	Stock	17.7908	17.9548	17.5845	17.8102	307124000.0
2021-06-16	AMZN	Stock	169.6	171.3175	168.0265	170.7625	84056000.0
2021-06-16	GOOGL	Stock	121.572	121.886	119.47	120.7725	26471860.0
2021-06-16	META	Stock	336.7	337.55	328.72	331.08	17232200.0
2021-06-16	TSLA	Stock	199.18	202.8333	197.8333	201.6233	66432300.0
2021-06-16	TLT	Stock	141.4	141.67	140.21	140.93	19676264.0
2021-06-16	ES	Stock	84.24	84.34	81.89	81.97	1652500.0
2021-06-16	CL	Stock	83.9	83.9	81.91	81.95	3615200.0
2021-06-16	A	Stock	144.66	145.08	142.92	143.59	1680800.0
2021-06-16	AA	Stock	35.54	35.85	34.69	35.36	7645700.0
2021-06-16	AAC-DELISTED	Stock	9.79	9.8	9.76	9.76	110911.0
2021-06-16	AACG	Stock	3.12	3.13	3.01	3.01	39100.0
2021-06-16	AACQ-DELISTED	Stock	10.0	10.01	9.98	9.995	1362557.0
2021-06-16	AACQU-DELISTED	Stock	10.93	10.9386	10.88	10.88	11623.0
2021-06-16	AACQW-DELISTED	Stock	2.43	2.5	2.35	2.5	275246.0
2021-06-16	AAIC-DELISTED	Stock	4.08	4.13	4.07	4.09	158119.0
2021-06-16	AAIC.C-DELISTED	Stock	24.78	24.885	24.77	24.8	1547.0
2021-06-16	AAL	Stock	22.74	23.0	22.52	22.83	20296900.0
2021-06-16	AAM.A-DELISTED	Stock	26.35	26.411	26.2101	26.41	44096.0
2021-06-16	AAM.B-DELISTED	Stock	27.25	27.27	27.14	27.27	7545.0
2021-06-16	AAMC-DELISTED	Stock	5.6765	5.6882	5.6029	5.6059	12920.0
2021-06-16	AAME	Stock	4.22	4.27	4.2	4.25	132500.0
2021-06-16	AAMI	Stock	22.69	23.21	22.49	23.18	387900.0
2021-06-16	AAN-DELISTED	Stock	35.84	36.36	35.63	36.29	120000.0
2021-06-16	AAOI	Stock	8.64	8.85	8.51	8.78	356000.0
2021-06-16	AAON	Stock	42.5333	42.8267	41.8333	41.8867	220650.0
2021-06-16	AAP	Stock	200.29	200.76	196.73	196.92	823800.0
2021-06-16	AAQC-DELISTED	Stock	9.69	9.715	9.67	9.71	20740.0
2021-06-16	AAT	Stock	38.43	38.65	38.05	38.25	323700.0
2021-06-16	AAU-DELISTED	Stock	0.525	0.5267	0.5104	0.5162	780422.0
2021-06-16	AAUAF-DELISTED	Stock	0.525	0.5267	0.5104	0.5163	801461.0
2021-06-16	AAWW-DELISTED	Stock	73.02	73.99	71.2	71.5	288240.0
2021-06-16	AAXJ	Stock	93.87	93.99	92.54	92.75	565797.0
2021-06-16	AB	Stock	45.19	45.5	44.97	45.34	158000.0
2021-06-16	ABB-DELISTED	Stock	34.64	34.65	33.95	34.05	1384937.0
2021-06-16	ABBNY-DELISTED	Stock	34.64	34.65	33.95	34.06	1497302.0
2021-06-16	ABBV	Stock	116.22	116.53	115.17	115.53	6670200.0
2021-06-16	ABC-DELISTED	Stock	119.29	119.45	117.79	118.36	378617.0
2021-06-16	ABCB	Stock	54.46	56.36	53.69	55.5	412800.0
2021-06-16	ABCL	Stock	23.6	24.0	22.88	23.04	1910700.0
2021-06-16	ABCM-DELISTED	Stock	18.95	19.05	18.66	18.7	147600.0
2021-06-16	ABEO	Stock	42.0	43.75	41.75	43.25	33572.0
2021-06-16	ABEV	Stock	3.82	3.87	3.74	3.79	23094300.0
2021-06-16	ABG	Stock	171.87	174.31	168.69	173.5	145900.0
2021-06-16	ABGI-DELISTED	Stock	9.9	9.92	9.9	9.92	6865.0
2021-06-16	ABM	Stock	47.94	47.94	46.63	46.75	343700.0
2021-06-16	ABMD-DELISTED	Stock	301.61	304.3834	298.64	303.44	190917.0
2021-06-16	ABNB	Stock	150.95	152.35	146.92	149.15	9632800.0

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

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