PREVIEW / stock_daily / 2022-07-18

all stock daily files

  file:    by_date/stock_daily/2022/2022-07-18.parquet
  size:    252 KB
  rows:    7,897
  symbols: 2,293

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-07-18	AAPL	Stock	150.74	151.57	146.7	147.07	81420900.0
2022-07-18	MSFT	Stock	259.75	260.84	253.3	254.25	20975000.0
2022-07-18	NVDA	Stock	16.302	16.897	16.002	16.101	670517000.0
2022-07-18	AMZN	Stock	115.0	117.24	113.15	113.76	59115400.0
2022-07-18	GOOGL	Stock	112.64	113.68	108.37	109.03	43164588.0
2022-07-18	META	Stock	166.75	171.69	165.64	167.23	23574300.0
2022-07-18	TSLA	Stock	244.9367	250.5167	239.6033	240.5467	82537500.0
2022-07-18	TLT	Stock	115.25	115.32	114.18	114.93	15838268.0
2022-07-18	ES	Stock	83.31	83.34	82.38	82.45	970700.0
2022-07-18	CL	Stock	78.01	78.17	76.97	77.12	3526600.0
2022-07-18	A	Stock	118.95	119.39	114.46	115.11	1178200.0
2022-07-18	AA	Stock	44.47	45.25	43.085	43.42	5707300.0
2022-07-18	AAC-DELISTED	Stock	9.83	9.85	9.83	9.85	2172515.0
2022-07-18	AACG	Stock	1.24	1.29	1.24	1.27	2600.0
2022-07-18	AACIU	Stock	9.97	9.97	9.97	9.97	1200.0
2022-07-18	AACIW-DELISTED	Stock	0.1698	0.19	0.1698	0.1769	1103.0
2022-07-18	AAIC-DELISTED	Stock	3.08	3.1162	3.08	3.11	38006.0
2022-07-18	AAIC.C-DELISTED	Stock	20.92	21.1	20.89	20.89	1200.0
2022-07-18	AAL	Stock	14.83	15.16	14.52	14.54	31995000.0
2022-07-18	AAM.A-DELISTED	Stock	24.25	24.5746	24.25	24.31	5241.0
2022-07-18	AAM.B-DELISTED	Stock	24.58	24.7096	24.27	24.6	26907.0
2022-07-18	AAMC-DELISTED	Stock	3.2176	3.2176	3.2176	3.2176	891.0
2022-07-18	AAME	Stock	2.82	2.89	2.68	2.68	5400.0
2022-07-18	AAMI	Stock	17.77	18.07	17.305	17.36	202600.0
2022-07-18	AAN-DELISTED	Stock	15.01	15.64	15.01	15.38	366600.0
2022-07-18	AAOI	Stock	1.68	1.78	1.65	1.66	285400.0
2022-07-18	AAON	Stock	36.0667	36.0667	34.6667	34.82	207000.0
2022-07-18	AAP	Stock	190.0	191.01	184.89	185.27	904600.0
2022-07-18	AAQC-DELISTED	Stock	9.79	9.79	9.79	9.79	100.0
2022-07-18	AAT	Stock	29.56	29.69	29.4	29.53	254800.0
2022-07-18	AATC	Stock	5.2	5.2	5.03	5.0301	12314.0
2022-07-18	AAU-DELISTED	Stock	0.22	0.2298	0.2152	0.2238	182746.0
2022-07-18	AAUAF-DELISTED	Stock	0.22	0.2298	0.2152	0.2223	192445.0
2022-07-18	AAWW-DELISTED	Stock	62.37	63.2	61.78	62.82	274289.0
2022-07-18	AAXJ	Stock	67.7	68.0	67.03	67.15	3693174.0
2022-07-18	AB	Stock	41.14	41.67	39.91	39.91	369300.0
2022-07-18	ABB-DELISTED	Stock	27.35	27.485	26.9713	27.06	1486354.0
2022-07-18	ABBNY-DELISTED	Stock	27.35	27.485	26.9713	27.05	1632428.0
2022-07-18	ABBV	Stock	153.8	154.47	148.89	149.57	6838400.0
2022-07-18	ABC-DELISTED	Stock	142.36	142.73	139.81	140.38	514291.0
2022-07-18	ABCB	Stock	40.99	41.63	40.3	40.64	299400.0
2022-07-18	ABCL	Stock	10.69	10.86	10.34	10.45	1796700.0
2022-07-18	ABCM-DELISTED	Stock	13.73	13.8993	13.31	13.35	141079.0
2022-07-18	ABEO	Stock	5.0	5.0	4.65	4.7	54800.0
2022-07-18	ABEV	Stock	2.67	2.72	2.63	2.64	34625600.0
2022-07-18	ABG	Stock	163.25	169.61	161.25	166.0	158100.0
2022-07-18	ABM	Stock	42.77	43.04	41.88	42.12	226400.0
2022-07-18	ABMD-DELISTED	Stock	270.06	271.38	261.74	263.11	123834.0
2022-07-18	ABNB	Stock	96.78	101.88	95.98	97.67	7171500.0
2022-07-18	ABOS	Stock	6.36	6.38	5.758	5.87	53700.0

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

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