PREVIEW / stock_daily / 2022-11-25

all stock daily files

  file:    by_date/stock_daily/2022/2022-11-25.parquet
  size:    239 KB
  rows:    7,518
  symbols: 1,901

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-11-25	AAPL	Stock	148.31	148.88	147.12	148.11	35195900.0
2022-11-25	MSFT	Stock	247.31	248.7	246.73	247.49	9200800.0
2022-11-25	NVDA	Stock	16.318	16.487	16.172	16.27	167934000.0
2022-11-25	AMZN	Stock	93.79	94.43	93.07	93.41	35088600.0
2022-11-25	GOOGL	Stock	98.24	98.64	97.4	97.46	9701441.0
2022-11-25	META	Stock	111.3	112.73	111.02	111.41	12007600.0
2022-11-25	TSLA	Stock	185.06	185.2	180.63	182.86	50672700.0
2022-11-25	TLT	Stock	102.61	102.93	102.43	102.9	9486076.0
2022-11-25	ES	Stock	82.52	82.89	82.15	82.44	763200.0
2022-11-25	CL	Stock	77.13	77.23	76.66	76.77	1388800.0
2022-11-25	A	Stock	155.09	156.96	154.71	156.96	642700.0
2022-11-25	AA	Stock	48.55	48.943	47.61	47.89	1687400.0
2022-11-25	AAC-DELISTED	Stock	10.0016	10.01	10.0	10.01	1301.0
2022-11-25	AACG	Stock	1.86	1.86	1.72	1.72	1300.0
2022-11-25	AAIC-DELISTED	Stock	3.1	3.14	3.07	3.11	35057.0
2022-11-25	AAL	Stock	14.4	14.7	14.35	14.5	9903900.0
2022-11-25	AAM.A-DELISTED	Stock	24.2461	24.49	24.2461	24.3	4128.0
2022-11-25	AAM.B-DELISTED	Stock	24.25	24.5	24.0	24.39	1100.0
2022-11-25	AAME	Stock	2.87	2.91	2.84	2.91	1000.0
2022-11-25	AAMI	Stock	19.69	20.01	19.645	19.85	52800.0
2022-11-25	AAN-DELISTED	Stock	11.72	11.94	11.58	11.58	123600.0
2022-11-25	AAOI	Stock	2.18	2.23	2.11	2.19	27400.0
2022-11-25	AAON	Stock	52.3	52.9867	52.2867	52.3733	64050.0
2022-11-25	AAP	Stock	150.76	150.78	148.35	150.0	579400.0
2022-11-25	AAQC-DELISTED	Stock	10.03	10.04	10.03	10.04	808.0
2022-11-25	AAT	Stock	27.89	28.37	27.8	28.36	97100.0
2022-11-25	AATC	Stock	4.84	5.0002	4.84	4.99	12946.0
2022-11-25	AAU-DELISTED	Stock	0.2407	0.2499	0.24	0.2474	32015.0
2022-11-25	AAUAF-DELISTED	Stock	0.2407	0.2499	0.24	0.2474	34889.0
2022-11-25	AAWW-DELISTED	Stock	100.84	100.96	100.64	100.66	58132.0
2022-11-25	AAXJ	Stock	63.13	63.27	63.02	63.13	175239.0
2022-11-25	AB	Stock	40.64	41.49	40.58	41.11	103600.0
2022-11-25	ABB-DELISTED	Stock	31.53	31.61	31.49	31.55	337266.0
2022-11-25	ABBNY-DELISTED	Stock	31.53	31.61	31.49	31.55	390828.0
2022-11-25	ABBV	Stock	159.59	160.75	159.24	159.62	1661900.0
2022-11-25	ABC-DELISTED	Stock	166.58	167.92	165.955	167.7	744218.0
2022-11-25	ABCB	Stock	52.92	53.53	52.54	53.26	57600.0
2022-11-25	ABCL	Stock	13.98	14.14	13.39	13.52	598600.0
2022-11-25	ABCM-DELISTED	Stock	15.97	16.01	15.8	15.86	43055.0
2022-11-25	ABEO	Stock	3.91	3.99	3.75	3.9	168100.0
2022-11-25	ABEV	Stock	2.93	2.95	2.89	2.91	8475600.0
2022-11-25	ABG	Stock	179.98	183.3	179.98	181.56	39300.0
2022-11-25	ABGI-DELISTED	Stock	10.02	10.02	10.01	10.02	50109.0
2022-11-25	ABLV	Stock	10.1	10.18	10.1	10.18	1722.0
2022-11-25	ABM	Stock	45.27	46.19	45.27	45.67	86600.0
2022-11-25	ABMD-DELISTED	Stock	377.36	378.285	377.01	378.08	172026.0
2022-11-25	ABNB	Stock	96.97	98.83	96.76	97.67	2245100.0
2022-11-25	ABOS	Stock	6.48	6.48	6.0	6.19	30900.0
2022-11-25	ABR	Stock	14.47	14.78	14.46	14.64	683700.0
2022-11-25	ABR.E	Stock	17.7	17.82	17.7	17.82	585.0

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

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