PREVIEW / stock_daily / 2022-02-15

all stock daily files

  file:    by_date/stock_daily/2022/2022-02-15.parquet
  size:    261 KB
  rows:    8,035
  symbols: 2,520

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-15	AAPL	Stock	170.97	172.95	170.25	172.79	62527400.0
2022-02-15	MSFT	Stock	300.01	300.8	297.02	300.47	27058300.0
2022-02-15	NVDA	Stock	24.949	26.545	24.784	26.495	699869000.0
2022-02-15	AMZN	Stock	157.6055	158.007	154.6375	156.5105	56440000.0
2022-02-15	GOOGL	Stock	137.5705	138.1085	135.8215	136.6085	26711260.0
2022-02-15	META	Stock	220.47	221.15	215.06	221.0	42685500.0
2022-02-15	TSLA	Stock	300.0	307.6667	297.7933	307.4767	57286200.0
2022-02-15	TLT	Stock	135.6	135.84	134.94	134.98	18200703.0
2022-02-15	ES	Stock	82.5	82.85	81.72	82.17	2928100.0
2022-02-15	CL	Stock	79.66	79.94	78.2	78.58	4422000.0
2022-02-15	A	Stock	137.25	138.06	134.73	135.91	2368200.0
2022-02-15	AA	Stock	72.45	74.19	70.56	74.04	6823400.0
2022-02-15	AAC-DELISTED	Stock	9.745	9.76	9.74	9.75	86886.0
2022-02-15	AACG	Stock	1.55	1.62	1.5	1.54	65100.0
2022-02-15	AACIU	Stock	10.0	10.0	10.0	10.0	300.0
2022-02-15	AACIW-DELISTED	Stock	0.33	0.33	0.33	0.33	503.0
2022-02-15	AAIC-DELISTED	Stock	3.35	3.4299	3.35	3.4	46803.0
2022-02-15	AAIC.C-DELISTED	Stock	24.85	25.0	24.4	24.5	2338.0
2022-02-15	AAL	Stock	18.32	18.91	18.12	18.84	46447100.0
2022-02-15	AAM.A-DELISTED	Stock	25.22	25.25	25.19	25.22	10351.0
2022-02-15	AAM.B-DELISTED	Stock	25.45	25.54	25.45	25.49	8732.0
2022-02-15	AAME	Stock	2.78	2.92	2.43	2.75	53100.0
2022-02-15	AAMI	Stock	24.71	25.07	24.645	24.83	978800.0
2022-02-15	AAN-DELISTED	Stock	21.11	21.71	20.98	21.62	173100.0
2022-02-15	AAOI	Stock	3.69	3.935	3.69	3.89	272700.0
2022-02-15	AAON	Stock	39.62	40.3667	39.52	40.1533	550050.0
2022-02-15	AAP	Stock	216.38	225.25	214.4	222.6	2268000.0
2022-02-15	AAQC-DELISTED	Stock	9.6973	9.7	9.695	9.6994	4828.0
2022-02-15	AAT	Stock	35.05	35.71	35.05	35.42	188600.0
2022-02-15	AATC	Stock	7.05	7.46	6.81	7.4	36927.0
2022-02-15	AAU-DELISTED	Stock	0.3599	0.3612	0.3461	0.3577	102844.0
2022-02-15	AAUAF-DELISTED	Stock	0.3599	0.3612	0.3461	0.3577	104839.0
2022-02-15	AAWW-DELISTED	Stock	77.23	78.67	77.045	78.36	271088.0
2022-02-15	AAXJ	Stock	81.84	82.4	81.65	82.35	1116344.0
2022-02-15	AB	Stock	47.45	48.02	47.12	47.56	470300.0
2022-02-15	ABB-DELISTED	Stock	34.805	34.99	34.7	34.95	1796376.0
2022-02-15	ABBNY-DELISTED	Stock	34.805	34.99	34.7	34.95	2006687.0
2022-02-15	ABBV	Stock	143.35	145.46	143.2	144.76	9530100.0
2022-02-15	ABC-DELISTED	Stock	141.55	144.1	140.84	141.48	739964.0
2022-02-15	ABCB	Stock	50.24	51.32	50.24	51.21	300800.0
2022-02-15	ABCL	Stock	9.62	10.02	9.62	9.98	1771400.0
2022-02-15	ABCM-DELISTED	Stock	17.4	17.63	17.33	17.6	40437.0
2022-02-15	ABEO	Stock	6.5	6.75	6.25	6.75	29300.0
2022-02-15	ABEV	Stock	2.97	3.03	2.93	2.95	38617600.0
2022-02-15	ABG	Stock	173.59	178.27	163.7	175.44	467800.0
2022-02-15	ABGI-DELISTED	Stock	9.74	9.74	9.74	9.74	901.0
2022-02-15	ABM	Stock	42.29	43.01	42.29	42.77	260400.0
2022-02-15	ABMD-DELISTED	Stock	296.18	307.52	296.18	304.68	196189.0
2022-02-15	ABNB	Stock	172.92	180.632	172.75	180.07	11733900.0
2022-02-15	ABOS	Stock	5.21	5.57	5.05	5.5	185900.0

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

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