PREVIEW / stock_daily / 2022-04-20

all stock daily files

  file:    by_date/stock_daily/2022/2022-04-20.parquet
  size:    261 KB
  rows:    8,049
  symbols: 2,481

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-04-20	AAPL	Stock	168.76	168.88	166.1	167.23	67929800.0
2022-04-20	MSFT	Stock	289.4	289.7	285.37	286.36	22906700.0
2022-04-20	NVDA	Stock	22.517	22.67	21.2	21.482	468974000.0
2022-04-20	AMZN	Stock	157.6025	157.6025	153.6035	153.998	59630000.0
2022-04-20	GOOGL	Stock	130.892	131.399	127.5	128.04	31695460.0
2022-04-20	META	Stock	213.61	214.16	198.92	200.42	43036500.0
2022-04-20	TSLA	Stock	343.3333	344.6667	325.0833	325.7333	70711200.0
2022-04-20	TLT	Stock	120.22	121.965	119.92	121.65	31423175.0
2022-04-20	ES	Stock	93.38	93.82	92.86	93.26	933100.0
2022-04-20	CL	Stock	80.24	81.8	80.22	81.53	8789900.0
2022-04-20	A	Stock	127.71	130.32	126.84	129.37	2026100.0
2022-04-20	AA	Stock	85.91	88.01	82.56	86.93	6909100.0
2022-04-20	AAC-DELISTED	Stock	9.83	9.85	9.83	9.85	403298.0
2022-04-20	AACG	Stock	1.16	1.19	1.16	1.16	7300.0
2022-04-20	AACIU	Stock	9.96	9.96	9.96	9.96	209.0
2022-04-20	AACIW-DELISTED	Stock	0.2808	0.2808	0.28	0.2801	1670.0
2022-04-20	AAIC-DELISTED	Stock	3.48	3.5201	3.48	3.51	121479.0
2022-04-20	AAIC.C-DELISTED	Stock	24.625	24.625	24.5	24.5101	960.0
2022-04-20	AAL	Stock	19.66	20.07	19.47	19.48	43515000.0
2022-04-20	AAM.A-DELISTED	Stock	24.98	25.04	24.98	25.02	9191.0
2022-04-20	AAM.B-DELISTED	Stock	25.29	25.34	25.21	25.25	6351.0
2022-04-20	AAMC-DELISTED	Stock	3.2	3.2	2.9706	3.1294	7310.0
2022-04-20	AAME	Stock	3.32	3.32	3.12	3.14	1600.0
2022-04-20	AAMI	Stock	22.67	22.86	22.25	22.33	379700.0
2022-04-20	AAN-DELISTED	Stock	22.15	22.43	21.5	21.57	166500.0
2022-04-20	AAOI	Stock	3.0	3.12	2.97	3.07	292800.0
2022-04-20	AAON	Stock	35.4867	36.4467	34.9733	35.9	244500.0
2022-04-20	AAP	Stock	224.96	229.72	224.4	228.02	586600.0
2022-04-20	AAQC-DELISTED	Stock	9.76	9.77	9.755	9.77	29008.0
2022-04-20	AAT	Stock	36.76	37.25	36.7	36.79	306700.0
2022-04-20	AATC	Stock	6.5	6.849	6.5	6.82	15435.0
2022-04-20	AAU-DELISTED	Stock	0.38	0.38	0.3707	0.3712	237893.0
2022-04-20	AAUAF-DELISTED	Stock	0.38	0.38	0.3707	0.3712	240627.0
2022-04-20	AAWW-DELISTED	Stock	72.17	73.0	69.39	69.66	381099.0
2022-04-20	AAXJ	Stock	72.89	72.89	72.13	72.24	1227269.0
2022-04-20	AB	Stock	44.36	44.62	44.04	44.24	233600.0
2022-04-20	ABB-DELISTED	Stock	31.99	32.125	31.66	31.795	2923121.0
2022-04-20	ABBNY-DELISTED	Stock	31.99	32.125	31.66	31.8	3234453.0
2022-04-20	ABBV	Stock	156.36	158.1	155.52	156.7	6250000.0
2022-04-20	ABC-DELISTED	Stock	163.65	166.47	163.65	165.71	607401.0
2022-04-20	ABCB	Stock	42.8	43.37	42.73	42.74	499000.0
2022-04-20	ABCL	Stock	8.82	8.82	8.37	8.46	758600.0
2022-04-20	ABCM-DELISTED	Stock	18.04	18.32	17.93	18.15	89292.0
2022-04-20	ABEO	Stock	6.5	6.5	6.25	6.5	50736.0
2022-04-20	ABEV	Stock	3.14	3.22	3.13	3.18	13623800.0
2022-04-20	ABG	Stock	166.54	170.0	161.56	161.71	210300.0
2022-04-20	ABGI-DELISTED	Stock	9.82	9.825	9.81	9.81	64100.0
2022-04-20	ABM	Stock	50.98	53.1	50.98	52.78	789600.0
2022-04-20	ABMD-DELISTED	Stock	324.56	331.56	320.56	325.67	106110.0
2022-04-20	ABNB	Stock	172.61	172.61	164.31	164.55	3997900.0

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

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