PREVIEW / stock_daily / 2023-01-18

all stock daily files

  file:    by_date/stock_daily/2023/2023-01-18.parquet
  size:    250 KB
  rows:    7,710
  symbols: 1,923

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
2023-01-18	AAPL	Stock	136.82	138.61	135.03	135.21	69672800.0
2023-01-18	MSFT	Stock	241.57	242.38	235.52	235.81	30028700.0
2023-01-18	NVDA	Stock	17.667	17.873	17.282	17.377	439624000.0
2023-01-18	AMZN	Stock	97.25	99.32	95.38	95.46	79570400.0
2023-01-18	GOOGL	Stock	92.14	92.7999	90.64	91.12	29116691.0
2023-01-18	META	Stock	135.81	137.25	132.8	133.02	20215500.0
2023-01-18	TSLA	Stock	136.56	136.68	127.01	128.78	195680300.0
2023-01-18	TLT	Stock	108.46	108.77	107.12	108.63	35497241.0
2023-01-18	ES	Stock	84.04	84.2	80.77	81.21	1766000.0
2023-01-18	CL	Stock	77.99	78.33	76.31	76.32	3996300.0
2023-01-18	A	Stock	156.26	158.16	153.64	154.07	1150700.0
2023-01-18	AA	Stock	56.5	57.609	53.13	53.45	9115400.0
2023-01-18	AAC-DELISTED	Stock	10.12	10.1388	10.12	10.12	251492.0
2023-01-18	AACG	Stock	1.46	1.46	1.36	1.43	5000.0
2023-01-18	AACIW-DELISTED	Stock	0.0701	0.07575	0.0602	0.0744	40844.0
2023-01-18	AAIC-DELISTED	Stock	3.0	3.05	3.0	3.02	91531.0
2023-01-18	AAIC.C-DELISTED	Stock	21.59	21.61	21.58	21.61	700.0
2023-01-18	AAL	Stock	17.53	17.64	16.6	16.64	42352600.0
2023-01-18	AAM.A-DELISTED	Stock	24.6	24.875	24.07	24.07	7056.0
2023-01-18	AAM.B-DELISTED	Stock	24.7	24.7	24.25	24.25	15325.0
2023-01-18	AAMC-DELISTED	Stock	9.15	9.15	8.6265	8.7853	14518.0
2023-01-18	AAME	Stock	2.53	2.63	2.53	2.63	1500.0
2023-01-18	AAMI	Stock	21.75	21.98	21.59	21.69	91800.0
2023-01-18	AAN-DELISTED	Stock	14.01	14.38	13.85	13.88	155200.0
2023-01-18	AAOI	Stock	2.46	2.55	2.36	2.37	138800.0
2023-01-18	AAON	Stock	51.7333	51.74	49.9867	50.2133	272850.0
2023-01-18	AAP	Stock	150.0	150.97	146.85	146.98	654000.0
2023-01-18	AAT	Stock	28.05	28.13	27.24	27.5	128200.0
2023-01-18	AATC	Stock	3.93	4.05	3.93	3.99	47596.0
2023-01-18	AAU-DELISTED	Stock	0.244	0.2498	0.24	0.2414	204660.0
2023-01-18	AAUAF-DELISTED	Stock	0.2445	0.246	0.2401	0.2404	74656.0
2023-01-18	AAWW-DELISTED	Stock	101.71	101.9	101.67	101.82	757948.0
2023-01-18	AAXJ	Stock	70.88	71.07	69.89	69.91	917371.0
2023-01-18	AB	Stock	38.35	38.45	37.6	38.11	208100.0
2023-01-18	ABB-DELISTED	Stock	34.66	34.7	33.965	33.99	1013140.0
2023-01-18	ABBNY-DELISTED	Stock	34.66	34.7	33.965	33.99	1180196.0
2023-01-18	ABBV	Stock	152.12	152.42	149.07	149.2	6190800.0
2023-01-18	ABC-DELISTED	Stock	164.01	164.52	162.92	162.94	834616.0
2023-01-18	ABCB	Stock	48.53	48.83	46.88	46.92	302500.0
2023-01-18	ABCL	Stock	10.64	10.83	10.36	10.38	1422600.0
2023-01-18	ABCM-DELISTED	Stock	16.4	16.54	15.94	15.95	454922.0
2023-01-18	ABEO	Stock	2.69	2.71	2.57	2.61	232900.0
2023-01-18	ABEV	Stock	2.75	2.76	2.64	2.65	21824100.0
2023-01-18	ABG	Stock	186.86	191.46	184.17	184.34	104800.0
2023-01-18	ABGI-DELISTED	Stock	10.14	10.14	10.14	10.14	1867.0
2023-01-18	ABM	Stock	45.84	46.3	45.15	45.27	233800.0
2023-01-18	ABNB	Stock	101.41	103.8	100.32	101.11	6062200.0
2023-01-18	ABOS	Stock	6.14	6.26	5.748	5.9	81800.0
2023-01-18	ABR	Stock	14.33	14.39	14.12	14.17	1251400.0
2023-01-18	ABR.D	Stock	20.06	20.87	20.06	20.38	16761.0

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

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