PREVIEW / stock_daily / 2022-06-06

all stock daily files

  file:    by_date/stock_daily/2022/2022-06-06.parquet
  size:    257 KB
  rows:    7,962
  symbols: 2,367

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
2022-06-06	AAPL	Stock	147.03	148.57	144.9	146.14	71598400.0
2022-06-06	MSFT	Stock	272.06	274.18	267.22	268.75	22400300.0
2022-06-06	NVDA	Stock	19.139	19.337	18.564	18.786	422406000.0
2022-06-06	AMZN	Stock	125.25	128.99	123.81	124.79	135269000.0
2022-06-06	GOOGL	Stock	116.7045	119.347	116.164	116.8205	33541540.0
2022-06-06	META	Stock	193.99	196.92	188.4	194.25	30574200.0
2022-06-06	TSLA	Stock	244.3533	244.8667	234.35	238.28	84204600.0
2022-06-06	TLT	Stock	115.15	115.51	113.81	113.89	20815373.0
2022-06-06	ES	Stock	92.52	93.05	92.12	92.28	672200.0
2022-06-06	CL	Stock	79.2	79.68	78.59	78.78	2715500.0
2022-06-06	A	Stock	129.38	130.0	126.97	127.63	1310600.0
2022-06-06	AA	Stock	62.59	64.25	61.195	64.02	5390900.0
2022-06-06	AAC-DELISTED	Stock	9.85	9.85	9.815	9.82	1043098.0
2022-06-06	AACG	Stock	1.01	1.05	1.01	1.03	1800.0
2022-06-06	AACIW-DELISTED	Stock	0.23	0.23	0.19005	0.19005	203.0
2022-06-06	AAIC-DELISTED	Stock	3.52	3.6199	3.49	3.53	133831.0
2022-06-06	AAIC.C-DELISTED	Stock	23.78	23.78	23.43	23.43	3875.0
2022-06-06	AAL	Stock	16.53	16.57	16.02	16.3	29567800.0
2022-06-06	AAM.A-DELISTED	Stock	24.96	24.96	24.68	24.75	13592.0
2022-06-06	AAM.B-DELISTED	Stock	25.59	25.6054	25.51	25.6	6464.0
2022-06-06	AAMC-DELISTED	Stock	3.1618	3.4	3.0647	3.4	66052.0
2022-06-06	AAME	Stock	3.01	3.01	2.98	2.99	1700.0
2022-06-06	AAMI	Stock	20.8	21.14	20.74	20.94	409200.0
2022-06-06	AAN-DELISTED	Stock	18.7	18.93	18.19	18.91	195600.0
2022-06-06	AAOI	Stock	2.26	2.292	2.16	2.18	136900.0
2022-06-06	AAON	Stock	37.12	37.62	36.72	37.5667	235650.0
2022-06-06	AAP	Stock	191.71	191.88	188.79	190.74	433200.0
2022-06-06	AAQC-DELISTED	Stock	9.75	9.77	9.75	9.77	5766.0
2022-06-06	AAT	Stock	33.18	33.18	32.21	32.24	218100.0
2022-06-06	AATC	Stock	6.03	6.03	5.94	5.99	3647.0
2022-06-06	AAU-DELISTED	Stock	0.2484	0.2694	0.2455	0.2515	253936.0
2022-06-06	AAUAF-DELISTED	Stock	0.2484	0.2694	0.2455	0.2515	256861.0
2022-06-06	AAWW-DELISTED	Stock	70.92	71.8584	70.165	71.7	198914.0
2022-06-06	AAXJ	Stock	72.49	72.71	71.66	71.86	913866.0
2022-06-06	AB	Stock	42.8	43.65	42.7	43.37	220000.0
2022-06-06	ABB-DELISTED	Stock	31.74	31.87	31.435	31.55	1021378.0
2022-06-06	ABBNY-DELISTED	Stock	31.74	31.87	31.435	31.55	1187302.0
2022-06-06	ABBV	Stock	147.0	147.82	145.66	146.53	3912400.0
2022-06-06	ABC-DELISTED	Stock	147.19	147.91	146.16	146.88	466510.0
2022-06-06	ABCB	Stock	46.13	46.28	44.79	45.7	208300.0
2022-06-06	ABCL	Stock	7.71	7.83	7.375	7.67	1970200.0
2022-06-06	ABCM-DELISTED	Stock	14.96	15.2	14.89	15.04	93091.0
2022-06-06	ABEO	Stock	4.0	4.0	3.75	4.0	20324.0
2022-06-06	ABEV	Stock	2.92	2.93	2.86	2.88	18501400.0
2022-06-06	ABG	Stock	183.49	190.17	180.65	187.91	141200.0
2022-06-06	ABGI-DELISTED	Stock	9.8	9.8	9.79	9.79	16085.0
2022-06-06	ABM	Stock	49.94	50.47	49.47	50.34	292600.0
2022-06-06	ABMD-DELISTED	Stock	266.99	267.94	258.91	260.48	70246.0
2022-06-06	ABNB	Stock	123.33	124.18	119.92	122.02	4160200.0
2022-06-06	ABOS	Stock	3.74	3.84	3.67	3.69	166200.0

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

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