PREVIEW / stock_daily / 2022-08-12

all stock daily files

  file:    by_date/stock_daily/2022/2022-08-12.parquet
  size:    254 KB
  rows:    7,872
  symbols: 2,213

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-08-12	AAPL	Stock	169.82	172.17	169.4	172.1	68039400.0
2022-08-12	MSFT	Stock	288.48	291.91	286.94	291.91	22619700.0
2022-08-12	NVDA	Stock	18.16	18.718	17.953	18.709	478094000.0
2022-08-12	AMZN	Stock	142.05	143.57	140.12	143.55	47643500.0
2022-08-12	GOOGL	Stock	120.26	121.68	119.46	121.68	19096268.0
2022-08-12	META	Stock	180.81	181.46	178.91	180.5	21274000.0
2022-08-12	TSLA	Stock	289.4167	300.16	285.0333	300.03	79657200.0
2022-08-12	TLT	Stock	115.1	115.57	114.43	115.55	12178401.0
2022-08-12	ES	Stock	92.19	93.13	91.93	93.11	1105200.0
2022-08-12	CL	Stock	79.68	80.5	79.59	80.29	3277500.0
2022-08-12	A	Stock	132.26	133.63	131.43	133.55	865800.0
2022-08-12	AA	Stock	52.4	53.43	51.77	52.76	4262700.0
2022-08-12	AAC-DELISTED	Stock	9.88	9.89	9.88	9.88	153390.0
2022-08-12	AACG	Stock	1.97	1.97	1.8	1.82	26900.0
2022-08-12	AACIW-DELISTED	Stock	0.1498	0.1555	0.139	0.15	16615.0
2022-08-12	AAIC-DELISTED	Stock	3.39	3.43	3.35	3.4	57268.0
2022-08-12	AAIC.C-DELISTED	Stock	21.2	21.2	21.025	21.2	8247.0
2022-08-12	AAL	Stock	15.16	15.29	15.03	15.25	21151000.0
2022-08-12	AAM.A-DELISTED	Stock	25.27	25.34	25.27	25.33	8298.0
2022-08-12	AAM.B-DELISTED	Stock	25.55	25.57	25.4	25.45	4519.0
2022-08-12	AAMC-DELISTED	Stock	5.8382	6.7647	5.4032	6.6353	85935.0
2022-08-12	AAME	Stock	3.09	3.09	2.91	3.0	9700.0
2022-08-12	AAMI	Stock	19.52	20.11	19.37	20.03	123900.0
2022-08-12	AAN-DELISTED	Stock	14.74	14.767	14.3	14.6	179300.0
2022-08-12	AAOI	Stock	2.23	2.68	2.19	2.6	677400.0
2022-08-12	AAON	Stock	40.4267	41.28	39.6933	41.1467	300450.0
2022-08-12	AAP	Stock	197.54	202.58	197.18	202.53	530400.0
2022-08-12	AAQC-DELISTED	Stock	9.82	9.82	9.82	9.82	5045.0
2022-08-12	AAT	Stock	30.27	30.49	30.19	30.43	246600.0
2022-08-12	AATC	Stock	4.9501	5.0	4.9201	4.97	18322.0
2022-08-12	AAU-DELISTED	Stock	0.244	0.2495	0.2343	0.2437	137466.0
2022-08-12	AAUAF-DELISTED	Stock	0.244	0.2495	0.2343	0.2437	153604.0
2022-08-12	AAWW-DELISTED	Stock	100.59	100.75	99.95	100.11	776333.0
2022-08-12	AAXJ	Stock	68.57	69.25	68.52	69.22	1484189.0
2022-08-12	AB	Stock	44.48	45.41	44.45	45.11	192000.0
2022-08-12	ABB-DELISTED	Stock	30.39	30.76	30.34	30.75	1157294.0
2022-08-12	ABBNY-DELISTED	Stock	30.39	30.76	30.34	30.75	1289671.0
2022-08-12	ABBV	Stock	141.89	143.09	140.27	142.6	5208700.0
2022-08-12	ABC-DELISTED	Stock	148.16	150.62	147.77	150.47	563526.0
2022-08-12	ABCB	Stock	49.32	50.0	48.75	49.69	211300.0
2022-08-12	ABCL	Stock	13.51	13.97	13.14	13.68	1836400.0
2022-08-12	ABCM-DELISTED	Stock	15.05	15.71	15.04	15.69	266138.0
2022-08-12	ABEO	Stock	4.62	4.99	4.38	4.43	339800.0
2022-08-12	ABEV	Stock	2.93	2.97	2.91	2.96	17985400.0
2022-08-12	ABG	Stock	180.93	184.96	180.49	184.81	113500.0
2022-08-12	ABGI-DELISTED	Stock	9.86	9.87	9.86	9.87	3400.0
2022-08-12	ABM	Stock	46.0	47.17	45.86	47.17	197400.0
2022-08-12	ABMD-DELISTED	Stock	291.88	295.6	288.07	293.84	67117.0
2022-08-12	ABNB	Stock	122.8	125.0	121.12	124.51	5012500.0
2022-08-12	ABOS	Stock	5.33	5.505	5.25	5.4	22500.0

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

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