PREVIEW / stock_daily / 2022-07-12

all stock daily files

  file:    by_date/stock_daily/2022/2022-07-12.parquet
  size:    250 KB
  rows:    7,848
  symbols: 2,267

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-12	AAPL	Stock	145.76	148.45	145.05	145.86	77588800.0
2022-07-12	MSFT	Stock	265.88	265.94	252.04	253.67	35868500.0
2022-07-12	NVDA	Stock	15.268	15.431	14.877	15.082	458483000.0
2022-07-12	AMZN	Stock	112.16	113.23	108.34	109.22	54280300.0
2022-07-12	GOOGL	Stock	116.215	116.974	113.6902	114.0205	29959700.0
2022-07-12	META	Stock	164.8	165.91	162.1	163.27	16639700.0
2022-07-12	TSLA	Stock	236.8467	239.7733	228.37	233.07	87930900.0
2022-07-12	TLT	Stock	115.51	116.23	114.97	115.12	18547318.0
2022-07-12	ES	Stock	83.37	84.43	82.99	83.38	1184900.0
2022-07-12	CL	Stock	78.61	79.33	77.95	78.31	3074500.0
2022-07-12	A	Stock	122.43	123.41	118.75	119.24	1196800.0
2022-07-12	AA	Stock	41.65	42.95	41.161	42.25	4309900.0
2022-07-12	AAC-DELISTED	Stock	9.83	9.8403	9.83	9.84	7590.0
2022-07-12	AACG	Stock	1.43	1.43	1.35	1.38	23100.0
2022-07-12	AACIW-DELISTED	Stock	0.16	0.1893	0.16	0.1893	1200.0
2022-07-12	AAIC-DELISTED	Stock	3.2182	3.22	3.1201	3.14	30992.0
2022-07-12	AAIC.C-DELISTED	Stock	20.73	20.89	20.2672	20.775	8059.0
2022-07-12	AAL	Stock	13.63	15.04	13.56	14.77	74980100.0
2022-07-12	AAM.A-DELISTED	Stock	24.75	24.87	24.65	24.76	13618.0
2022-07-12	AAM.B-DELISTED	Stock	24.86	24.94	24.72	24.88	6977.0
2022-07-12	AAMC-DELISTED	Stock	3.0559	3.3147	3.0559	3.1463	12339.0
2022-07-12	AAME	Stock	3.1	3.18	3.02	3.11	3600.0
2022-07-12	AAMI	Stock	17.19	17.7	17.185	17.27	332400.0
2022-07-12	AAN-DELISTED	Stock	14.69	15.5	14.509	14.88	185400.0
2022-07-12	AAOI	Stock	1.56	1.57	1.5	1.52	131300.0
2022-07-12	AAON	Stock	36.3467	37.4133	36.3467	36.7467	267450.0
2022-07-12	AAP	Stock	181.76	186.4	181.76	183.84	790400.0
2022-07-12	AAQC-DELISTED	Stock	9.779	9.779	9.77	9.77	3519.0
2022-07-12	AAT	Stock	29.02	29.9	29.02	29.87	202800.0
2022-07-12	AATC	Stock	5.26	5.26	5.15	5.15	12329.0
2022-07-12	AAU-DELISTED	Stock	0.2351	0.24	0.22	0.2202	300697.0
2022-07-12	AAUAF-DELISTED	Stock	0.2351	0.24	0.22	0.2202	311966.0
2022-07-12	AAWW-DELISTED	Stock	59.97	61.46	59.89	60.42	140446.0
2022-07-12	AAXJ	Stock	67.09	67.44	66.81	67.05	1772839.0
2022-07-12	AB	Stock	41.0	41.37	40.75	41.01	211400.0
2022-07-12	ABB-DELISTED	Stock	26.57	26.83	26.365	26.44	2468996.0
2022-07-12	ABBNY-DELISTED	Stock	26.57	26.83	26.365	26.42	2693882.0
2022-07-12	ABBV	Stock	153.0	154.57	152.06	152.46	5319500.0
2022-07-12	ABC-DELISTED	Stock	141.17	143.81	140.6	141.37	525390.0
2022-07-12	ABCB	Stock	40.32	41.54	40.27	40.94	309800.0
2022-07-12	ABCL	Stock	11.2	11.485	10.91	11.39	1599300.0
2022-07-12	ABCM-DELISTED	Stock	14.29	14.39	14.06	14.11	69450.0
2022-07-12	ABEO	Stock	5.47	5.74	5.14	5.46	447700.0
2022-07-12	ABEV	Stock	2.47	2.54	2.46	2.51	32763500.0
2022-07-12	ABG	Stock	163.69	171.0	163.69	165.9	161000.0
2022-07-12	ABGI-DELISTED	Stock	9.8	9.8	9.795	9.8	477766.0
2022-07-12	ABM	Stock	43.1	43.92	42.45	42.75	213300.0
2022-07-12	ABMD-DELISTED	Stock	262.57	265.79	254.46	256.13	72625.0
2022-07-12	ABNB	Stock	95.3	97.686	93.32	96.55	4170200.0
2022-07-12	ABOS	Stock	5.9	6.005	5.604	5.91	64000.0

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

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