PREVIEW / stock_daily / 2022-07-21

all stock daily files

  file:    by_date/stock_daily/2022/2022-07-21.parquet
  size:    252 KB
  rows:    7,865
  symbols: 2,264

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-07-21	AAPL	Stock	154.5	155.57	151.94	155.35	65086600.0
2022-07-21	MSFT	Stock	259.79	264.89	257.03	264.84	22404700.0
2022-07-21	NVDA	Stock	17.885	18.144	17.545	18.05	557049000.0
2022-07-21	AMZN	Stock	123.2	124.85	121.26	124.63	60239900.0
2022-07-21	GOOGL	Stock	114.28	114.55	111.1132	114.34	32676166.0
2022-07-21	META	Stock	180.63	183.85	178.87	183.17	27195800.0
2022-07-21	TSLA	Stock	255.1067	273.2667	254.8667	271.7067	142032300.0
2022-07-21	TLT	Stock	115.19	116.7195	115.01	116.59	14754886.0
2022-07-21	ES	Stock	82.94	83.06	82.27	83.02	1263900.0
2022-07-21	CL	Stock	75.48	76.27	75.28	76.16	4054400.0
2022-07-21	A	Stock	122.12	127.34	122.12	127.19	1682500.0
2022-07-21	AA	Stock	47.33	47.45	43.46	45.15	12226200.0
2022-07-21	AAC-DELISTED	Stock	9.85	9.88	9.85	9.87	4501711.0
2022-07-21	AACG	Stock	1.41	1.65	1.34	1.62	83200.0
2022-07-21	AACIW-DELISTED	Stock	0.1747	0.1997	0.1599	0.17	7901.0
2022-07-21	AAIC-DELISTED	Stock	3.18	3.28	3.18	3.28	57641.0
2022-07-21	AAIC.C-DELISTED	Stock	20.7999	20.7999	20.3	20.3	2400.0
2022-07-21	AAL	Stock	14.67	14.69	13.81	14.08	64624900.0
2022-07-21	AAM.A-DELISTED	Stock	24.61	24.96	24.55	24.75	23368.0
2022-07-21	AAM.B-DELISTED	Stock	24.8	25.04	24.8	24.95	9406.0
2022-07-21	AAMC-DELISTED	Stock	3.2088	3.73	3.1706	3.3824	39763.0
2022-07-21	AAME	Stock	2.84	2.95	2.84	2.95	1200.0
2022-07-21	AAMI	Stock	18.64	18.81	18.56	18.69	236000.0
2022-07-21	AAN-DELISTED	Stock	16.36	16.53	16.05	16.27	171200.0
2022-07-21	AAOI	Stock	1.81	1.88	1.8	1.82	98000.0
2022-07-21	AAON	Stock	37.1333	38.4267	36.62	38.42	208200.0
2022-07-21	AAP	Stock	191.58	192.0	187.24	189.83	791500.0
2022-07-21	AAQC-DELISTED	Stock	9.79	9.8	9.79	9.7928	7059.0
2022-07-21	AAT	Stock	29.74	29.84	29.3	29.79	133200.0
2022-07-21	AATC	Stock	5.0	5.0001	4.9601	4.98	8152.0
2022-07-21	AAU-DELISTED	Stock	0.2296	0.2296	0.2165	0.2269	262535.0
2022-07-21	AAUAF-DELISTED	Stock	0.2296	0.2296	0.2165	0.226	273581.0
2022-07-21	AAWW-DELISTED	Stock	67.49	68.53	67.31	68.42	216422.0
2022-07-21	AAXJ	Stock	67.97	68.52	67.89	68.48	755910.0
2022-07-21	AB	Stock	42.12	42.34	41.32	42.2	237800.0
2022-07-21	ABB-DELISTED	Stock	28.27	28.735	28.11	28.7	1443207.0
2022-07-21	ABBNY-DELISTED	Stock	28.27	28.735	28.11	28.71	1627308.0
2022-07-21	ABBV	Stock	147.24	147.84	146.02	147.75	4066800.0
2022-07-21	ABC-DELISTED	Stock	141.38	142.23	139.62	142.1	517455.0
2022-07-21	ABCB	Stock	42.32	42.89	41.78	42.53	200800.0
2022-07-21	ABCL	Stock	10.65	10.66	10.36	10.47	1399700.0
2022-07-21	ABCM-DELISTED	Stock	14.11	14.76	13.98	14.76	343262.0
2022-07-21	ABEO	Stock	5.12	5.15	4.96	5.1	59300.0
2022-07-21	ABEV	Stock	2.57	2.63	2.56	2.61	31266500.0
2022-07-21	ABG	Stock	170.87	170.87	162.95	167.1	163800.0
2022-07-21	ABGI-DELISTED	Stock	9.85	9.85	9.84	9.84	21828.0
2022-07-21	ABM	Stock	43.37	43.37	42.07	43.13	440800.0
2022-07-21	ABMD-DELISTED	Stock	276.16	285.09	275.11	284.9	113212.0
2022-07-21	ABNB	Stock	106.98	108.5	104.41	108.14	4284900.0
2022-07-21	ABOS	Stock	5.83	6.17	5.786	6.16	20200.0

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

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