PREVIEW / stock_daily / 2022-09-16

all stock daily files

  file:    by_date/stock_daily/2022/2022-09-16.parquet
  size:    252 KB
  rows:    7,819
  symbols: 2,171

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-09-16	AAPL	Stock	151.21	151.35	148.37	150.7	162278800.0
2022-09-16	MSFT	Stock	244.26	245.3	242.06	244.74	39791800.0
2022-09-16	NVDA	Stock	12.742	13.212	12.617	13.198	670751000.0
2022-09-16	AMZN	Stock	122.78	123.87	120.7	123.53	115667800.0
2022-09-16	GOOGL	Stock	102.07	103.13	100.94	102.8	42797172.0
2022-09-16	META	Stock	148.05	148.58	144.29	146.29	40122800.0
2022-09-16	TSLA	Stock	299.61	303.71	295.6	303.35	87087800.0
2022-09-16	TLT	Stock	107.03	108.05	106.765	107.07	18903848.0
2022-09-16	ES	Stock	88.37	89.44	88.07	88.8	3063500.0
2022-09-16	CL	Stock	75.34	75.79	75.09	75.69	5304400.0
2022-09-16	A	Stock	132.12	132.13	128.28	129.89	2300600.0
2022-09-16	AA	Stock	43.1	43.76	41.61	42.46	11489600.0
2022-09-16	AAC-DELISTED	Stock	9.93	9.93	9.92	9.93	73073.0
2022-09-16	AACG	Stock	1.86	1.95	1.81	1.81	12200.0
2022-09-16	AAIC-DELISTED	Stock	3.1	3.139	3.09	3.12	172189.0
2022-09-16	AAIC.C-DELISTED	Stock	20.86	21.298	20.7	20.85	13760.0
2022-09-16	AAL	Stock	13.94	14.02	13.62	13.75	27319000.0
2022-09-16	AAM.A-DELISTED	Stock	24.19	24.28	23.73	23.985	34323.0
2022-09-16	AAM.B-DELISTED	Stock	24.0	24.1	23.7694	23.94	18711.0
2022-09-16	AAMC-DELISTED	Stock	5.3235	5.5294	5.1912	5.45	57480.0
2022-09-16	AAME	Stock	3.04	3.08	2.99	2.99	3700.0
2022-09-16	AAMI	Stock	16.59	16.9	16.18	16.79	455400.0
2022-09-16	AAN-DELISTED	Stock	12.15	12.23	11.835	12.21	940100.0
2022-09-16	AAOI	Stock	3.01	3.94	2.87	3.76	77414200.0
2022-09-16	AAON	Stock	38.0533	38.2333	36.5133	38.0333	388050.0
2022-09-16	AAP	Stock	166.8	169.56	165.78	166.8	1566500.0
2022-09-16	AAQC-DELISTED	Stock	9.8	9.8	9.8	9.8	2807.0
2022-09-16	AAT	Stock	26.9	27.44	26.49	27.41	510500.0
2022-09-16	AATC	Stock	5.1267	5.2139	5.08	5.08	30681.0
2022-09-16	AAU-DELISTED	Stock	0.2201	0.2224	0.21	0.215	343386.0
2022-09-16	AAUAF-DELISTED	Stock	0.2201	0.2224	0.21	0.215	350602.0
2022-09-16	AAWW-DELISTED	Stock	99.67	99.71	98.94	99.4	1627561.0
2022-09-16	AAXJ	Stock	64.01	64.16	63.68	63.9	1140830.0
2022-09-16	AB	Stock	41.91	42.0	41.48	41.97	151200.0
2022-09-16	ABB-DELISTED	Stock	27.37	27.46	26.955	27.12	1534368.0
2022-09-16	ABBNY-DELISTED	Stock	27.37	27.46	26.955	27.13	1873823.0
2022-09-16	ABBV	Stock	143.4	144.85	141.36	144.06	13887500.0
2022-09-16	ABC-DELISTED	Stock	139.68	141.08	139.12	140.58	2341511.0
2022-09-16	ABCB	Stock	47.21	47.97	46.66	47.9	1514200.0
2022-09-16	ABCL	Stock	10.7	10.76	10.28	10.35	2203400.0
2022-09-16	ABCM-DELISTED	Stock	16.43	16.7	16.24	16.68	302965.0
2022-09-16	ABEO	Stock	4.0	4.07	3.77	4.0	95200.0
2022-09-16	ABEV	Stock	2.85	2.89	2.81	2.83	33513700.0
2022-09-16	ABG	Stock	156.96	160.07	154.98	156.84	241100.0
2022-09-16	ABLV	Stock	9.94	9.94	9.94	9.94	28341.0
2022-09-16	ABM	Stock	40.58	40.94	40.0	40.13	822100.0
2022-09-16	ABMD-DELISTED	Stock	261.3	261.3	254.79	258.72	278407.0
2022-09-16	ABNB	Stock	121.11	122.26	117.59	118.75	13704400.0
2022-09-16	ABOS	Stock	6.13	6.355	5.47	5.49	175400.0
2022-09-16	ABR	Stock	14.61	14.74	14.52	14.67	3627500.0

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

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