PREVIEW / stock_daily / 2022-06-21

all stock daily files

  file:    by_date/stock_daily/2022/2022-06-21.parquet
  size:    255 KB
  rows:    7,977
  symbols: 2,369

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-21	AAPL	Stock	133.42	137.06	133.32	135.87	81000500.0
2022-06-21	MSFT	Stock	250.26	254.75	249.51	253.74	29928300.0
2022-06-21	NVDA	Stock	16.475	17.008	16.407	16.566	483089000.0
2022-06-21	AMZN	Stock	108.2	111.63	103.56	108.68	70901200.0
2022-06-21	GOOGL	Stock	108.9295	112.4892	108.6	111.544	47415800.0
2022-06-21	META	Stock	165.93	167.76	155.97	157.05	50724900.0
2022-06-21	TSLA	Stock	224.6033	243.5767	224.3333	237.0367	122793000.0
2022-06-21	TLT	Stock	110.09	111.015	109.8128	110.18	17663799.0
2022-06-21	ES	Stock	77.98	80.04	77.71	79.56	1563700.0
2022-06-21	CL	Stock	74.9	76.58	74.4	76.46	4456700.0
2022-06-21	A	Stock	114.41	115.57	113.76	113.88	1588200.0
2022-06-21	AA	Stock	50.79	51.94	49.49	50.08	5540900.0
2022-06-21	AAC-DELISTED	Stock	9.83	9.83	9.81	9.825	40410.0
2022-06-21	AACG	Stock	1.02	1.07	1.02	1.05	2500.0
2022-06-21	AACIW-DELISTED	Stock	0.2101	0.2101	0.21	0.21	2839.0
2022-06-21	AAIC-DELISTED	Stock	3.03	3.1599	2.96	3.02	86463.0
2022-06-21	AAIC.C-DELISTED	Stock	22.4534	22.4534	22.4	22.4182	1333.0
2022-06-21	AAL	Stock	13.22	13.24	12.62	13.04	39780800.0
2022-06-21	AAM.A-DELISTED	Stock	23.73	24.0	23.73	24.0	34113.0
2022-06-21	AAM.B-DELISTED	Stock	25.4	25.53	25.1818	25.36	37704.0
2022-06-21	AAMC-DELISTED	Stock	3.0882	3.3176	3.0618	3.2353	82518.0
2022-06-21	AAME	Stock	2.85	3.49	2.8	3.01	39300.0
2022-06-21	AAMI	Stock	19.22	19.24	18.65	18.87	300000.0
2022-06-21	AAN-DELISTED	Stock	15.88	15.88	15.15	15.17	348200.0
2022-06-21	AAOI	Stock	1.86	1.96	1.81	1.93	237800.0
2022-06-21	AAON	Stock	34.1667	34.1733	33.2267	33.3067	258450.0
2022-06-21	AAP	Stock	169.75	173.02	167.94	171.73	753400.0
2022-06-21	AAQC-DELISTED	Stock	9.76	9.76	9.76	9.76	300.0
2022-06-21	AAT	Stock	29.79	30.1	29.21	29.21	235200.0
2022-06-21	AATC	Stock	5.36	5.48	5.3101	5.48	7167.0
2022-06-21	AAU-DELISTED	Stock	0.2389	0.2451	0.236	0.2423	327095.0
2022-06-21	AAUAF-DELISTED	Stock	0.2389	0.2451	0.236	0.241	330992.0
2022-06-21	AAWW-DELISTED	Stock	63.89	64.35	62.65	63.4	154058.0
2022-06-21	AAXJ	Stock	68.95	69.45	68.92	69.2	1334302.0
2022-06-21	AB	Stock	41.04	41.69	40.87	41.4	308300.0
2022-06-21	ABB-DELISTED	Stock	26.84	27.07	26.695	26.76	2816768.0
2022-06-21	ABBNY-DELISTED	Stock	26.84	27.07	26.695	26.75	3023071.0
2022-06-21	ABBV	Stock	139.95	143.97	139.7	143.47	7160500.0
2022-06-21	ABC-DELISTED	Stock	140.67	144.42	140.05	143.21	837061.0
2022-06-21	ABCB	Stock	41.12	41.61	40.31	41.4	512800.0
2022-06-21	ABCL	Stock	10.16	10.46	9.78	9.81	4728600.0
2022-06-21	ABCM-DELISTED	Stock	14.07	14.5	14.07	14.38	116558.0
2022-06-21	ABEO	Stock	4.0	4.5	4.0	4.25	129568.0
2022-06-21	ABEV	Stock	2.49	2.54	2.47	2.51	29142800.0
2022-06-21	ABG	Stock	167.49	169.04	160.13	160.83	180500.0
2022-06-21	ABGI-DELISTED	Stock	9.79	9.795	9.79	9.795	768.0
2022-06-21	ABM	Stock	41.55	41.55	39.77	41.15	632300.0
2022-06-21	ABMD-DELISTED	Stock	237.14	238.295	229.31	232.04	219475.0
2022-06-21	ABNB	Stock	102.69	104.889	101.62	102.27	6532700.0
2022-06-21	ABOS	Stock	3.34	3.48	3.31	3.36	300900.0

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

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