PREVIEW / stock_daily / 2022-07-27

all stock daily files

  file:    by_date/stock_daily/2022/2022-07-27.parquet
  size:    252 KB
  rows:    7,856
  symbols: 2,251

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-27	AAPL	Stock	152.58	157.33	152.16	156.79	78620700.0
2022-07-27	MSFT	Stock	261.16	270.05	258.85	268.74	45994000.0
2022-07-27	NVDA	Stock	17.032	17.936	16.913	17.79	569776000.0
2022-07-27	AMZN	Stock	117.31	121.9	117.16	120.97	61582000.0
2022-07-27	GOOGL	Stock	109.26	113.91	108.01	113.06	59858495.0
2022-07-27	META	Stock	162.59	170.87	162.02	169.58	43846600.0
2022-07-27	TSLA	Stock	263.81	275.9267	261.79	274.82	88110000.0
2022-07-27	TLT	Stock	118.01	118.485	116.71	116.82	15725564.0
2022-07-27	ES	Stock	84.98	85.4	84.56	85.21	781200.0
2022-07-27	CL	Stock	78.18	79.01	77.75	78.76	2421400.0
2022-07-27	A	Stock	125.04	128.33	124.71	127.71	1395900.0
2022-07-27	AA	Stock	47.605	47.96	45.89	47.75	4849000.0
2022-07-27	AAC-DELISTED	Stock	9.87	9.875	9.86	9.86	120348.0
2022-07-27	AACG	Stock	1.54	1.58	1.52	1.53	17700.0
2022-07-27	AACIW-DELISTED	Stock	0.1501	0.16	0.1501	0.15994	2340.0
2022-07-27	AAIC-DELISTED	Stock	3.2	3.2	3.12	3.16	44618.0
2022-07-27	AAIC.C-DELISTED	Stock	20.8999	20.8999	20.29	20.4	4400.0
2022-07-27	AAL	Stock	13.71	14.03	13.35	13.97	36408900.0
2022-07-27	AAM.A-DELISTED	Stock	25.1	25.1	25.01	25.03	14830.0
2022-07-27	AAM.B-DELISTED	Stock	25.48	25.53	25.35	25.38	4482.0
2022-07-27	AAMC-DELISTED	Stock	5.0353	5.6103	4.6176	5.5559	107341.0
2022-07-27	AAME	Stock	2.69	2.82	2.65	2.73	14400.0
2022-07-27	AAMI	Stock	18.71	19.055	18.6	18.87	313800.0
2022-07-27	AAN-DELISTED	Stock	13.14	13.47	12.63	12.83	847000.0
2022-07-27	AAOI	Stock	1.68	1.75	1.68	1.73	190100.0
2022-07-27	AAON	Stock	37.8533	38.7333	37.66	38.38	133350.0
2022-07-27	AAP	Stock	183.41	186.02	179.15	185.91	877100.0
2022-07-27	AAQC-DELISTED	Stock	9.81	9.81	9.8	9.8	13252.0
2022-07-27	AAT	Stock	29.43	29.96	28.75	29.86	319300.0
2022-07-27	AATC	Stock	5.06	5.19	5.06	5.1799	12702.0
2022-07-27	AAU-DELISTED	Stock	0.2232	0.2269	0.2126	0.2254	128653.0
2022-07-27	AAUAF-DELISTED	Stock	0.2232	0.2269	0.2126	0.2254	133744.0
2022-07-27	AAWW-DELISTED	Stock	69.87	71.58	67.8401	71.25	292605.0
2022-07-27	AAXJ	Stock	67.93	68.68	67.6	68.52	731960.0
2022-07-27	AB	Stock	41.54	41.86	41.09	41.65	157200.0
2022-07-27	ABB-DELISTED	Stock	28.43	28.97	28.4214	28.87	1373936.0
2022-07-27	ABBNY-DELISTED	Stock	28.43	28.97	28.4214	28.87	1524382.0
2022-07-27	ABBV	Stock	149.5	151.5	148.93	151.15	4145800.0
2022-07-27	ABC-DELISTED	Stock	144.41	145.46	142.54	145.0	491098.0
2022-07-27	ABCB	Stock	43.0	46.17	42.89	45.77	649100.0
2022-07-27	ABCL	Stock	10.24	10.63	10.025	10.51	1202900.0
2022-07-27	ABCM-DELISTED	Stock	14.33	14.96	14.3	14.86	280058.0
2022-07-27	ABEO	Stock	4.0	4.11	3.85	3.91	85100.0
2022-07-27	ABEV	Stock	2.76	2.83	2.72	2.83	36323500.0
2022-07-27	ABG	Stock	161.46	164.44	157.38	163.53	147500.0
2022-07-27	ABM	Stock	43.87	43.96	42.87	43.66	269300.0
2022-07-27	ABMD-DELISTED	Stock	279.73	287.17	279.28	285.11	162274.0
2022-07-27	ABNB	Stock	105.79	107.985	104.06	107.36	5362700.0
2022-07-27	ABOS	Stock	5.53	5.84	5.37	5.79	27300.0
2022-07-27	ABR	Stock	15.68	15.98	15.62	15.88	1962300.0

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

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