PREVIEW / stock_daily / 2022-04-04

all stock daily files

  file:    by_date/stock_daily/2022/2022-04-04.parquet
  size:    262 KB
  rows:    8,065
  symbols: 2,509

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-04	AAPL	Stock	174.57	178.49	174.44	178.44	76468400.0
2022-04-04	MSFT	Stock	310.09	315.11	309.71	314.97	24289600.0
2022-04-04	NVDA	Stock	26.728	27.558	26.613	27.36	397120000.0
2022-04-04	AMZN	Stock	164.125	168.3945	163.2055	168.3465	49882000.0
2022-04-04	GOOGL	Stock	140.3585	143.712	140.3105	142.9715	25970840.0
2022-04-04	META	Stock	225.98	234.35	225.86	233.89	28054800.0
2022-04-04	TSLA	Stock	363.1267	383.3033	357.51	381.8167	82035900.0
2022-04-04	TLT	Stock	131.93	131.98	130.71	131.46	13609923.0
2022-04-04	ES	Stock	89.45	89.58	87.96	89.12	1148600.0
2022-04-04	CL	Stock	75.82	76.63	74.88	76.59	4791900.0
2022-04-04	A	Stock	133.86	135.4	132.89	134.81	1388000.0
2022-04-04	AA	Stock	91.0	91.58	88.85	90.9	3685700.0
2022-04-04	AAC-DELISTED	Stock	9.85	9.85	9.8	9.81	17695.0
2022-04-04	AACG	Stock	1.45	1.46	1.4	1.41	22900.0
2022-04-04	AACIW-DELISTED	Stock	0.2999	0.3	0.2999	0.3	600.0
2022-04-04	AAIC-DELISTED	Stock	3.53	3.5991	3.5	3.55	57595.0
2022-04-04	AAIC.C-DELISTED	Stock	24.75	24.75	24.67	24.67	420.0
2022-04-04	AAL	Stock	18.16	18.37	17.72	18.23	23037400.0
2022-04-04	AAM.A-DELISTED	Stock	25.13	25.24	25.13	25.24	16106.0
2022-04-04	AAM.B-DELISTED	Stock	25.52	25.7372	25.52	25.664	11497.0
2022-04-04	AAMC-DELISTED	Stock	4.2941	4.2941	4.1471	4.1471	8014.0
2022-04-04	AAME	Stock	3.2	3.3	3.2	3.22	10500.0
2022-04-04	AAMI	Stock	24.5	24.58	24.19	24.31	337900.0
2022-04-04	AAN-DELISTED	Stock	20.15	21.04	19.97	20.95	248300.0
2022-04-04	AAOI	Stock	3.31	3.47	3.22	3.41	286300.0
2022-04-04	AAON	Stock	37.4333	37.44	36.4267	37.0867	324450.0
2022-04-04	AAP	Stock	207.53	212.3	205.94	211.92	689100.0
2022-04-04	AAQC-DELISTED	Stock	9.745	9.745	9.74	9.745	40038.0
2022-04-04	AAT	Stock	38.76	38.76	37.53	37.82	234100.0
2022-04-04	AATC	Stock	6.3	6.39	6.3	6.38	11344.0
2022-04-04	AAU-DELISTED	Stock	0.3651	0.3679	0.35	0.3564	463688.0
2022-04-04	AAUAF-DELISTED	Stock	0.3651	0.3679	0.35	0.3595	472200.0
2022-04-04	AAWW-DELISTED	Stock	81.4	82.28	79.42	81.79	499444.0
2022-04-04	AAXJ	Stock	77.38	78.01	77.07	77.92	2893064.0
2022-04-04	AB	Stock	47.93	49.45	47.07	47.55	471500.0
2022-04-04	ABB-DELISTED	Stock	32.63	32.98	32.63	32.93	1421149.0
2022-04-04	ABBNY-DELISTED	Stock	32.63	32.98	32.63	32.93	1678723.0
2022-04-04	ABBV	Stock	162.5	163.84	161.46	161.89	6892400.0
2022-04-04	ABC-DELISTED	Stock	156.01	156.01	153.83	154.75	632329.0
2022-04-04	ABCB	Stock	42.96	43.04	42.05	42.58	394700.0
2022-04-04	ABCL	Stock	10.18	10.545	10.12	10.41	1332600.0
2022-04-04	ABCM-DELISTED	Stock	18.99	19.21	18.85	19.16	76147.0
2022-04-04	ABEO	Stock	8.0	8.5	8.0	8.25	63568.0
2022-04-04	ABEV	Stock	3.3	3.31	3.24	3.28	16319700.0
2022-04-04	ABG	Stock	157.49	160.91	154.94	155.12	377700.0
2022-04-04	ABGI-DELISTED	Stock	9.79	9.8	9.79	9.79	763596.0
2022-04-04	ABM	Stock	46.15	46.36	45.25	46.1	371500.0
2022-04-04	ABMD-DELISTED	Stock	333.0	333.705	324.31	325.54	183276.0
2022-04-04	ABNB	Stock	175.02	177.02	172.585	177.02	3495700.0
2022-04-04	ABOS	Stock	4.09	4.19	3.9	4.09	227100.0

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

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