PREVIEW / stock_daily / 2022-12-14

all stock daily files

  file:    by_date/stock_daily/2022/2022-12-14.parquet
  size:    250 KB
  rows:    7,760
  symbols: 2,001

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-14	AAPL	Stock	145.35	146.66	141.16	143.21	82291200.0
2022-12-14	MSFT	Stock	257.13	262.59	254.31	257.22	35410900.0
2022-12-14	NVDA	Stock	17.987	18.252	17.42	17.674	496888000.0
2022-12-14	AMZN	Stock	92.5	93.46	89.87	91.58	70298000.0
2022-12-14	GOOGL	Stock	95.2	96.87	93.6	95.07	28733599.0
2022-12-14	META	Stock	119.39	124.14	119.39	121.59	36922000.0
2022-12-14	TSLA	Stock	159.25	161.62	155.31	156.8	140682300.0
2022-12-14	TLT	Stock	107.66	108.32	106.8927	108.16	19517531.0
2022-12-14	ES	Stock	86.27	87.71	85.34	85.85	1339800.0
2022-12-14	CL	Stock	78.94	79.84	78.57	79.34	3692000.0
2022-12-14	A	Stock	157.26	158.44	154.16	154.81	1344400.0
2022-12-14	AA	Stock	45.35	45.95	44.77	45.5	3755300.0
2022-12-14	AAC-DELISTED	Stock	10.06	10.08	10.06	10.07	11044960.0
2022-12-14	AACG	Stock	1.45	1.45	1.36	1.37	2400.0
2022-12-14	AACIW-DELISTED	Stock	0.0152	0.0152	0.0152	0.0152	552.0
2022-12-14	AAIC-DELISTED	Stock	2.99	3.02	2.97	2.98	45728.0
2022-12-14	AAIC.C-DELISTED	Stock	21.65	21.69	21.3	21.37	2411.0
2022-12-14	AAL	Stock	13.58	13.69	13.24	13.35	33728900.0
2022-12-14	AAM.A-DELISTED	Stock	23.22	23.73	23.2	23.37	29570.0
2022-12-14	AAM.B-DELISTED	Stock	23.15	23.18	22.57	22.89	42253.0
2022-12-14	AAMC-DELISTED	Stock	6.1762	6.1762	6.1762	6.1762	524.0
2022-12-14	AAME	Stock	2.51	2.51	2.41	2.41	3400.0
2022-12-14	AAMI	Stock	19.51	19.94	19.18	19.27	155600.0
2022-12-14	AAN-DELISTED	Stock	12.09	12.49	12.06	12.3	439900.0
2022-12-14	AAOI	Stock	2.14	2.2	2.13	2.13	161900.0
2022-12-14	AAON	Stock	53.36	53.9467	52.32	53.18	265650.0
2022-12-14	AAP	Stock	144.99	145.93	141.88	143.46	1311600.0
2022-12-14	AAQC-DELISTED	Stock	10.1897	10.29	10.08	10.115	302562.0
2022-12-14	AAT	Stock	27.24	27.87	27.2	27.58	268000.0
2022-12-14	AATC	Stock	5.0	5.09	5.0	5.01	8687.0
2022-12-14	AAU-DELISTED	Stock	0.24	0.2508	0.24	0.2412	276680.0
2022-12-14	AAUAF-DELISTED	Stock	0.24	0.2508	0.24	0.2412	278864.0
2022-12-14	AAWW-DELISTED	Stock	100.76	100.84	100.55	100.61	215592.0
2022-12-14	AAXJ	Stock	66.5	66.8	66.04	66.47	628177.0
2022-12-14	AB	Stock	39.45	39.81	38.05	39.24	512700.0
2022-12-14	ABB-DELISTED	Stock	31.72	32.03	31.46	31.72	1241185.0
2022-12-14	ABBNY-DELISTED	Stock	31.72	32.03	31.46	31.71	1885618.0
2022-12-14	ABBV	Stock	164.6	165.98	162.83	164.86	4485400.0
2022-12-14	ABC-DELISTED	Stock	165.47	166.4	164.25	165.31	1522126.0
2022-12-14	ABCB	Stock	49.09	49.41	47.65	47.74	331200.0
2022-12-14	ABCL	Stock	10.08	10.34	9.96	10.13	1716900.0
2022-12-14	ABCM-DELISTED	Stock	15.82	16.16	15.5	15.9	1224339.0
2022-12-14	ABEO	Stock	3.0	3.17	2.95	2.97	205700.0
2022-12-14	ABEV	Stock	2.76	2.86	2.73	2.85	53823400.0
2022-12-14	ABG	Stock	175.33	180.57	175.07	177.41	179000.0
2022-12-14	ABGI-DELISTED	Stock	10.06	10.06	10.04	10.04	2600.0
2022-12-14	ABM	Stock	42.35	44.57	41.71	44.21	1159100.0
2022-12-14	ABMD-DELISTED	Stock	380.45	380.59	380.1	380.16	1179106.0
2022-12-14	ABNB	Stock	93.54	95.26	91.21	93.93	6737800.0
2022-12-14	ABOS	Stock	5.87	5.87	5.65	5.76	73100.0

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

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