PREVIEW / stock_daily / 2022-08-16

all stock daily files

  file:    by_date/stock_daily/2022/2022-08-16.parquet
  size:    254 KB
  rows:    7,865
  symbols: 2,221

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-08-16	AAPL	Stock	172.78	173.71	171.66	173.03	56377100.0
2022-08-16	MSFT	Stock	291.99	294.04	290.42	292.71	18102900.0
2022-08-16	NVDA	Stock	18.92	19.142	18.501	18.879	451240000.0
2022-08-16	AMZN	Stock	143.91	146.57	142.0	144.78	59102900.0
2022-08-16	GOOGL	Stock	121.52	122.43	120.64	121.7	19041230.0
2022-08-16	META	Stock	179.44	180.99	177.04	179.47	21156700.0
2022-08-16	TSLA	Stock	311.6667	314.6667	302.8833	306.5633	88136400.0
2022-08-16	TLT	Stock	115.25	116.02	114.24	115.93	11065955.0
2022-08-16	ES	Stock	92.95	94.12	92.95	93.58	959600.0
2022-08-16	CL	Stock	81.44	82.38	81.44	82.18	2905800.0
2022-08-16	A	Stock	132.89	133.42	131.66	132.77	1810000.0
2022-08-16	AA	Stock	52.8	53.89	52.59	53.12	4925100.0
2022-08-16	AAC-DELISTED	Stock	9.88	9.89	9.88	9.88	13825.0
2022-08-16	AACG	Stock	1.95	2.15	1.87	2.12	106100.0
2022-08-16	AACIW-DELISTED	Stock	0.13	0.15	0.12	0.1499	9638.0
2022-08-16	AAIC-DELISTED	Stock	3.42	3.42	3.3758	3.38	55202.0
2022-08-16	AAIC.C-DELISTED	Stock	21.0986	21.58	21.0986	21.58	8145.0
2022-08-16	AAL	Stock	15.3	15.71	15.11	15.5	23668500.0
2022-08-16	AAM.A-DELISTED	Stock	25.2746	25.44	25.2746	25.4	4661.0
2022-08-16	AAM.B-DELISTED	Stock	25.45	25.5607	25.44	25.53	5709.0
2022-08-16	AAMC-DELISTED	Stock	5.9118	6.8971	5.9118	6.2206	40980.0
2022-08-16	AAME	Stock	3.12	3.2	2.95	2.98	30100.0
2022-08-16	AAMI	Stock	20.1	20.35	20.0	20.16	197800.0
2022-08-16	AAN-DELISTED	Stock	14.56	15.23	14.43	15.0	387100.0
2022-08-16	AAOI	Stock	2.86	3.05	2.81	2.86	656000.0
2022-08-16	AAON	Stock	41.9067	42.4467	41.76	42.1933	163650.0
2022-08-16	AAP	Stock	205.59	212.25	205.59	209.6	774000.0
2022-08-16	AAQC-DELISTED	Stock	9.82	9.82	9.82	9.82	150000.0
2022-08-16	AAT	Stock	30.48	30.64	30.41	30.57	185500.0
2022-08-16	AATC	Stock	5.0	5.2044	5.0	5.19	23444.0
2022-08-16	AAU-DELISTED	Stock	0.2498	0.2498	0.2407	0.2416	119717.0
2022-08-16	AAUAF-DELISTED	Stock	0.2498	0.2498	0.2407	0.2416	123197.0
2022-08-16	AAWW-DELISTED	Stock	99.9	100.04	99.76	100.0	1743960.0
2022-08-16	AAXJ	Stock	68.71	68.99	68.62	68.83	548216.0
2022-08-16	AB	Stock	44.7	45.27	44.63	44.79	263000.0
2022-08-16	ABB-DELISTED	Stock	30.36	30.6985	30.36	30.615	927067.0
2022-08-16	ABBNY-DELISTED	Stock	30.36	30.6985	30.36	30.61	1073621.0
2022-08-16	ABBV	Stock	142.11	143.98	142.08	142.55	3852300.0
2022-08-16	ABC-DELISTED	Stock	150.47	152.99	150.47	152.72	627957.0
2022-08-16	ABCB	Stock	49.71	50.94	49.71	50.44	177800.0
2022-08-16	ABCL	Stock	13.47	13.53	12.645	12.75	2407500.0
2022-08-16	ABCM-DELISTED	Stock	15.36	15.39	15.2	15.33	137856.0
2022-08-16	ABEO	Stock	4.58	4.83	4.46	4.77	173000.0
2022-08-16	ABEV	Stock	2.96	2.99	2.95	2.97	22021700.0
2022-08-16	ABG	Stock	187.53	203.92	186.91	198.57	290300.0
2022-08-16	ABGI-DELISTED	Stock	9.865	9.87	9.865	9.87	6233.0
2022-08-16	ABM	Stock	47.36	48.26	47.36	47.53	305200.0
2022-08-16	ABMD-DELISTED	Stock	293.38	293.77	286.855	291.23	64217.0
2022-08-16	ABNB	Stock	124.23	125.42	122.62	124.18	4370700.0
2022-08-16	ABOS	Stock	5.26	5.69	5.26	5.65	50200.0

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

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