PREVIEW / stock_daily / 2022-12-05

all stock daily files

  file:    by_date/stock_daily/2022/2022-12-05.parquet
  size:    249 KB
  rows:    7,730
  symbols: 2,038

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-12-05	AAPL	Stock	147.77	150.92	145.77	146.63	68826400.0
2022-12-05	MSFT	Stock	252.01	253.82	248.06	250.2	23435300.0
2022-12-05	NVDA	Stock	16.679	16.995	16.472	16.61	352255000.0
2022-12-05	AMZN	Stock	93.05	94.06	90.82	91.01	71535500.0
2022-12-05	GOOGL	Stock	99.4	101.38	99.0	99.48	24405087.0
2022-12-05	META	Stock	121.75	124.67	121.35	122.43	35474900.0
2022-12-05	TSLA	Stock	189.44	191.27	180.55	182.45	93122700.0
2022-12-05	TLT	Stock	105.84	105.99	104.9	105.59	20159732.0
2022-12-05	ES	Stock	82.87	83.92	82.75	83.65	1234100.0
2022-12-05	CL	Stock	77.48	77.73	76.96	77.12	3160000.0
2022-12-05	A	Stock	153.84	153.89	151.25	152.7	1124700.0
2022-12-05	AA	Stock	50.5	51.25	46.52	46.52	6391800.0
2022-12-05	AAC-DELISTED	Stock	10.05	10.05	10.03	10.03	8806.0
2022-12-05	AACG	Stock	1.7	1.7	1.5	1.51	21000.0
2022-12-05	AACIW-DELISTED	Stock	0.0201	0.0201	0.02	0.02	4700.0
2022-12-05	AAIC-DELISTED	Stock	3.05	3.066	3.02	3.02	45520.0
2022-12-05	AAL	Stock	13.84	14.34	13.82	14.11	27029000.0
2022-12-05	AAM.A-DELISTED	Stock	24.1971	24.1999	23.69	23.8907	12231.0
2022-12-05	AAM.B-DELISTED	Stock	24.85	24.99	24.4955	24.61	6463.0
2022-12-05	AAMC-DELISTED	Stock	5.5882	6.4734	5.5882	6.4412	58358.0
2022-12-05	AAME	Stock	2.87	2.87	2.75	2.75	9100.0
2022-12-05	AAMI	Stock	20.77	20.91	20.53	20.77	213600.0
2022-12-05	AAN-DELISTED	Stock	12.5	12.88	12.3	12.4	289700.0
2022-12-05	AAOI	Stock	2.33	2.44	2.24	2.29	123200.0
2022-12-05	AAON	Stock	53.18	53.18	51.9333	52.4067	190050.0
2022-12-05	AAP	Stock	151.79	152.79	147.95	148.36	970200.0
2022-12-05	AAQC-DELISTED	Stock	10.06	10.08	10.06	10.07	280045.0
2022-12-05	AAT	Stock	27.69	27.93	27.24	27.26	257200.0
2022-12-05	AATC	Stock	5.0999	5.11	5.0	5.11	11465.0
2022-12-05	AAU-DELISTED	Stock	0.24	0.247	0.2335	0.234	158291.0
2022-12-05	AAUAF-DELISTED	Stock	0.24	0.247	0.2335	0.234	162380.0
2022-12-05	AAWW-DELISTED	Stock	100.05	100.53	100.0	100.5	171180.0
2022-12-05	AAXJ	Stock	67.11	67.14	66.23	66.39	763683.0
2022-12-05	AB	Stock	40.02	40.12	39.49	39.87	278800.0
2022-12-05	ABB-DELISTED	Stock	31.43	31.49	31.14	31.155	854547.0
2022-12-05	ABBNY-DELISTED	Stock	31.44	31.49	31.14	31.16	1084251.0
2022-12-05	ABBV	Stock	162.89	165.19	162.89	163.94	4859400.0
2022-12-05	ABC-DELISTED	Stock	173.17	173.17	170.89	171.25	917334.0
2022-12-05	ABCB	Stock	52.49	52.62	49.63	50.38	343900.0
2022-12-05	ABCL	Stock	12.65	12.72	11.85	11.91	5553200.0
2022-12-05	ABCM-DELISTED	Stock	16.37	16.48	15.94	16.13	258291.0
2022-12-05	ABEO	Stock	3.95	4.04	3.7	3.76	180000.0
2022-12-05	ABEV	Stock	3.05	3.05	2.99	3.01	29352900.0
2022-12-05	ABG	Stock	181.5	181.5	175.58	176.55	160600.0
2022-12-05	ABGI-DELISTED	Stock	10.05	10.05	10.05	10.05	200.0
2022-12-05	ABM	Stock	46.11	46.11	44.89	45.84	259200.0
2022-12-05	ABMD-DELISTED	Stock	377.21	378.57	376.84	378.13	679939.0
2022-12-05	ABNB	Stock	100.0	101.17	98.04	98.51	3601500.0
2022-12-05	ABOS	Stock	5.6	5.69	5.56	5.6	228000.0
2022-12-05	ABR	Stock	14.63	14.68	14.38	14.4	1174400.0

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

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