PREVIEW / stock_daily / 2021-06-01

all stock daily files

  file:    by_date/stock_daily/2021/2021-06-01.parquet
  size:    257 KB
  rows:    7,881
  symbols: 2,952

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-01	AAPL	Stock	125.08	125.35	123.94	124.28	67637100.0
2021-06-01	MSFT	Stock	251.23	251.29	246.96	247.4	23213300.0
2021-06-01	NVDA	Stock	16.27	16.3882	15.9032	16.2645	472804000.0
2021-06-01	AMZN	Stock	162.175	162.549	160.453	160.9325	48600000.0
2021-06-01	GOOGL	Stock	118.722	119.2855	117.714	119.059	23358020.0
2021-06-01	META	Stock	330.15	331.42	326.64	329.13	11765900.0
2021-06-01	TSLA	Stock	209.2667	211.2667	206.85	207.9667	54254700.0
2021-06-01	TLT	Stock	137.82	138.26	137.25	138.21	11778666.0
2021-06-01	ES	Stock	81.3	81.49	79.79	79.91	1686000.0
2021-06-01	CL	Stock	84.95	85.01	82.12	82.48	5587000.0
2021-06-01	A	Stock	139.17	140.32	135.57	137.2	2015800.0
2021-06-01	AA	Stock	40.2	41.155	40.14	40.98	7332400.0
2021-06-01	AAC-DELISTED	Stock	9.77	9.86	9.76	9.82	734181.0
2021-06-01	AACG	Stock	3.0	3.06	2.95	3.0	55300.0
2021-06-01	AACQ-DELISTED	Stock	9.97	9.97	9.935	9.945	1576516.0
2021-06-01	AACQU-DELISTED	Stock	10.45	10.5	10.45	10.49	20733.0
2021-06-01	AACQW-DELISTED	Stock	1.75	1.82	1.7	1.73	46562.0
2021-06-01	AAIC-DELISTED	Stock	4.05	4.13	4.05	4.08	167309.0
2021-06-01	AAIC.C-DELISTED	Stock	25.34	25.4	25.2332	25.39	2657.0
2021-06-01	AAL	Stock	24.68	25.09	24.51	24.67	36502400.0
2021-06-01	AAM.A-DELISTED	Stock	25.89	26.0089	25.84	25.97	82655.0
2021-06-01	AAM.B-DELISTED	Stock	26.93	27.02	26.92	27.02	13276.0
2021-06-01	AAMC-DELISTED	Stock	4.9752	5.0853	4.9752	5.0853	25041.0
2021-06-01	AAME	Stock	4.33	4.5	4.28	4.43	54000.0
2021-06-01	AAMI	Stock	22.52	23.0	22.48	22.61	1088200.0
2021-06-01	AAN-DELISTED	Stock	36.05	36.5	35.82	36.08	277900.0
2021-06-01	AAOI	Stock	8.29	8.56	8.13	8.54	580600.0
2021-06-01	AAON	Stock	44.2533	44.76	43.8667	44.2867	287250.0
2021-06-01	AAP	Stock	191.5	195.35	190.09	194.65	1884200.0
2021-06-01	AAQC-DELISTED	Stock	9.66	9.69	9.66	9.68	2668.0
2021-06-01	AAT	Stock	36.79	37.92	36.58	37.83	1327300.0
2021-06-01	AAU-DELISTED	Stock	0.551	0.569	0.546	0.55	1054896.0
2021-06-01	AAUAF-DELISTED	Stock	0.551	0.569	0.546	0.55	1095950.0
2021-06-01	AAWW-DELISTED	Stock	75.7	76.2235	74.6	75.15	266282.0
2021-06-01	AAXJ	Stock	96.34	96.39	95.72	96.06	495427.0
2021-06-01	AB	Stock	45.63	45.63	44.64	45.13	259400.0
2021-06-01	ABB-DELISTED	Stock	34.84	34.87	34.665	34.71	950849.0
2021-06-01	ABBNY-DELISTED	Stock	34.84	34.87	34.665	34.71	1052620.0
2021-06-01	ABBV	Stock	113.7	113.99	112.04	112.21	6846200.0
2021-06-01	ABC-DELISTED	Stock	114.54	114.68	113.47	114.32	569908.0
2021-06-01	ABCB	Stock	55.57	56.5	55.49	56.32	511400.0
2021-06-01	ABCL	Stock	27.25	27.47	26.05	26.44	1149500.0
2021-06-01	ABCM-DELISTED	Stock	19.73	19.85	19.335	19.45	136589.0
2021-06-01	ABEO	Stock	41.75	43.5	41.0	42.75	36724.0
2021-06-01	ABEV	Stock	3.51	3.69	3.5	3.66	41909000.0
2021-06-01	ABG	Stock	201.22	205.71	199.31	204.9	153200.0
2021-06-01	ABGI-DELISTED	Stock	9.95	9.96	9.88	9.95	11605.0
2021-06-01	ABM	Stock	50.29	50.67	49.78	50.66	337900.0
2021-06-01	ABMD-DELISTED	Stock	284.85	286.11	278.97	279.7	155675.0
2021-06-01	ABNB	Stock	143.89	146.089	141.59	144.31	16552100.0

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

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