PREVIEW / stock_daily / 2022-02-14

all stock daily files

  file:    by_date/stock_daily/2022/2022-02-14.parquet
  size:    259 KB
  rows:    8,046
  symbols: 2,538

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-02-14	AAPL	Stock	167.37	169.58	166.56	168.88	86185500.0
2022-02-14	MSFT	Stock	293.77	296.76	291.35	295.0	36359500.0
2022-02-14	NVDA	Stock	23.934	24.875	23.755	24.267	440424000.0
2022-02-14	AMZN	Stock	151.751	158.4485	151.65	155.167	83230000.0
2022-02-14	GOOGL	Stock	133.2565	136.3	133.2565	135.526	34301080.0
2022-02-14	META	Stock	219.31	221.0	214.78	217.7	38184000.0
2022-02-14	TSLA	Stock	287.19	299.6267	284.3833	291.92	67756500.0
2022-02-14	TLT	Stock	137.13	137.74	135.97	136.53	23157421.0
2022-02-14	ES	Stock	83.95	84.3	81.7	82.21	3978500.0
2022-02-14	CL	Stock	79.56	79.94	78.01	79.26	5624200.0
2022-02-14	A	Stock	136.96	137.69	134.1	135.21	2205300.0
2022-02-14	AA	Stock	74.54	75.23	71.92	73.86	7813300.0
2022-02-14	AAC-DELISTED	Stock	9.7	9.76	9.7	9.75	17205.0
2022-02-14	AACG	Stock	1.59	1.66	1.51	1.54	27200.0
2022-02-14	AACIW-DELISTED	Stock	0.33	0.33	0.33	0.33	700.0
2022-02-14	AAIC-DELISTED	Stock	3.37	3.42	3.34	3.34	92167.0
2022-02-14	AAIC.C-DELISTED	Stock	24.68	24.7	24.54	24.62	5533.0
2022-02-14	AAL	Stock	17.85	18.31	17.35	17.43	37446600.0
2022-02-14	AAM.A-DELISTED	Stock	25.21	25.23	25.15	25.22	21003.0
2022-02-14	AAM.B-DELISTED	Stock	25.51	25.56	25.385	25.43	13748.0
2022-02-14	AAME	Stock	2.71	2.89	2.64	2.72	30900.0
2022-02-14	AAMI	Stock	23.81	24.55	23.81	24.34	914300.0
2022-02-14	AAN-DELISTED	Stock	20.7	21.35	20.4	20.96	324600.0
2022-02-14	AAOI	Stock	3.78	3.81	3.633	3.64	449400.0
2022-02-14	AAON	Stock	39.1667	39.8667	38.7	39.18	616350.0
2022-02-14	AAP	Stock	222.99	225.84	220.08	224.28	1495100.0
2022-02-14	AAQC-DELISTED	Stock	9.69	9.7	9.69	9.7	4366.0
2022-02-14	AAT	Stock	35.44	35.54	34.66	34.88	251300.0
2022-02-14	AATC	Stock	7.37	7.48	7.3508	7.395	14410.0
2022-02-14	AAU-DELISTED	Stock	0.36	0.3705	0.351	0.354	319619.0
2022-02-14	AAUAF-DELISTED	Stock	0.36	0.3705	0.351	0.3599	327111.0
2022-02-14	AAWW-DELISTED	Stock	76.08	77.54	76.08	76.765	277401.0
2022-02-14	AAXJ	Stock	80.96	81.07	80.26	80.66	922797.0
2022-02-14	AB	Stock	48.6	48.99	46.6	46.66	943100.0
2022-02-14	ABB-DELISTED	Stock	33.85	34.07	33.6	33.93	1899038.0
2022-02-14	ABBNY-DELISTED	Stock	33.85	34.07	33.6	33.95	2154430.0
2022-02-14	ABBV	Stock	141.78	143.19	139.44	143.0	9931900.0
2022-02-14	ABC-DELISTED	Stock	140.0	140.93	137.7	140.18	928891.0
2022-02-14	ABCB	Stock	50.78	51.13	49.36	49.59	418200.0
2022-02-14	ABCL	Stock	9.64	10.078	9.42	9.5	2106000.0
2022-02-14	ABCM-DELISTED	Stock	16.92	16.96	16.755	16.87	58541.0
2022-02-14	ABEO	Stock	6.5	6.5	6.0	6.0	28288.0
2022-02-14	ABEV	Stock	2.87	2.9	2.83	2.9	33498700.0
2022-02-14	ABG	Stock	161.59	165.15	160.58	161.18	293000.0
2022-02-14	ABGI-DELISTED	Stock	9.72	9.74	9.72	9.74	4038.0
2022-02-14	ABM	Stock	41.56	42.32	41.46	41.86	504300.0
2022-02-14	ABMD-DELISTED	Stock	294.4	300.06	287.7	290.45	303279.0
2022-02-14	ABNB	Stock	166.63	171.8	165.03	169.66	4847600.0
2022-02-14	ABOS	Stock	5.39	5.54	5.06	5.13	125100.0
2022-02-14	ABR	Stock	17.0	17.2	16.68	16.75	1648100.0

> showing 50 of 8,046 rows — these rows as CSV

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