PREVIEW / stock_daily / 2022-08-19

all stock daily files

  file:    by_date/stock_daily/2022/2022-08-19.parquet
  size:    252 KB
  rows:    7,809
  symbols: 2,190

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-19	AAPL	Stock	173.03	173.74	171.31	171.52	70346300.0
2022-08-19	MSFT	Stock	288.9	289.25	285.56	286.15	20570000.0
2022-08-19	NVDA	Stock	18.406	18.52	17.77	17.849	441588000.0
2022-08-19	AMZN	Stock	140.47	141.11	137.91	138.23	47792800.0
2022-08-19	GOOGL	Stock	119.06	119.15	116.76	117.21	21809528.0
2022-08-19	META	Stock	170.2	172.32	167.05	167.96	26240800.0
2022-08-19	TSLA	Stock	299.0	300.36	292.5	296.6667	61395300.0
2022-08-19	TLT	Stock	113.23	113.335	112.74	113.04	16330898.0
2022-08-19	ES	Stock	94.15	94.39	93.25	93.63	1217800.0
2022-08-19	CL	Stock	82.99	83.81	82.58	83.27	4663000.0
2022-08-19	A	Stock	139.35	139.73	137.26	137.62	1477500.0
2022-08-19	AA	Stock	52.53	52.78	50.685	51.01	4467100.0
2022-08-19	AAC-DELISTED	Stock	9.87	9.89	9.87	9.87	1494454.0
2022-08-19	AACG	Stock	2.64	2.64	2.54	2.6	84900.0
2022-08-19	AACIW-DELISTED	Stock	0.149	0.149	0.1489	0.1489	200.0
2022-08-19	AAIC-DELISTED	Stock	3.29	3.3	3.23	3.3	54750.0
2022-08-19	AAIC.C-DELISTED	Stock	20.9684	20.9684	20.78	20.8	3366.0
2022-08-19	AAL	Stock	14.5	14.57	13.96	14.17	31593300.0
2022-08-19	AAM.A-DELISTED	Stock	25.27	25.365	25.26	25.31	6298.0
2022-08-19	AAM.B-DELISTED	Stock	25.48	25.53	25.3739	25.49	6870.0
2022-08-19	AAMC-DELISTED	Stock	5.9706	6.4559	5.9353	5.9853	17112.0
2022-08-19	AAME	Stock	3.16	3.16	2.81	2.86	58300.0
2022-08-19	AAMI	Stock	20.16	20.16	19.39	19.41	126100.0
2022-08-19	AAN-DELISTED	Stock	14.36	14.45	14.01	14.03	195800.0
2022-08-19	AAOI	Stock	2.74	2.74	2.5	2.52	252500.0
2022-08-19	AAON	Stock	41.8467	41.8467	40.5	40.9	121950.0
2022-08-19	AAP	Stock	206.06	207.18	205.14	207.02	585300.0
2022-08-19	AAQC-DELISTED	Stock	9.85	9.85	9.83	9.84	2341.0
2022-08-19	AAT	Stock	30.04	30.04	29.43	29.69	172200.0
2022-08-19	AATC	Stock	5.25	5.25	5.17	5.2486	13458.0
2022-08-19	AAU-DELISTED	Stock	0.22	0.2287	0.216	0.228	168404.0
2022-08-19	AAUAF-DELISTED	Stock	0.22	0.2287	0.216	0.228	172545.0
2022-08-19	AAWW-DELISTED	Stock	100.11	100.29	99.95	100.0	374213.0
2022-08-19	AAXJ	Stock	67.52	67.67	67.135	67.23	591530.0
2022-08-19	AB	Stock	44.2	44.69	43.76	44.38	232900.0
2022-08-19	ABB-DELISTED	Stock	30.05	30.07	29.6847	29.72	839928.0
2022-08-19	ABBNY-DELISTED	Stock	30.05	30.07	29.6847	29.72	957080.0
2022-08-19	ABBV	Stock	141.78	143.36	141.46	141.85	4530700.0
2022-08-19	ABC-DELISTED	Stock	150.52	152.55	150.06	152.01	612825.0
2022-08-19	ABCB	Stock	50.09	50.22	49.48	49.77	351400.0
2022-08-19	ABCL	Stock	12.32	12.39	11.14	11.44	3320000.0
2022-08-19	ABCM-DELISTED	Stock	15.38	15.51	15.31	15.5	163063.0
2022-08-19	ABEO	Stock	4.37	4.41	4.02	4.05	131500.0
2022-08-19	ABEV	Stock	3.05	3.06	2.95	2.99	33415600.0
2022-08-19	ABG	Stock	186.82	186.82	184.07	186.15	114400.0
2022-08-19	ABGI-DELISTED	Stock	9.86	9.86	9.86	9.86	3000.0
2022-08-19	ABM	Stock	48.52	50.2	48.28	48.77	362100.0
2022-08-19	ABMD-DELISTED	Stock	275.94	276.44	269.24	270.66	97551.0
2022-08-19	ABNB	Stock	118.185	119.22	114.1	114.76	5288800.0
2022-08-19	ABOS	Stock	5.07	5.35	4.73	4.78	33700.0

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

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