PREVIEW / stock_daily / 2022-06-15

all stock daily files

  file:    by_date/stock_daily/2022/2022-06-15.parquet
  size:    256 KB
  rows:    7,971
  symbols: 2,381

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-06-15	AAPL	Stock	134.29	137.34	132.16	135.43	91533000.0
2022-06-15	MSFT	Stock	248.31	255.3	246.42	251.76	33111700.0
2022-06-15	NVDA	Stock	16.095	16.868	15.926	16.527	563936000.0
2022-06-15	AMZN	Stock	103.86	109.06	103.53	107.67	85011100.0
2022-06-15	GOOGL	Stock	108.545	111.4235	107.6695	109.7645	39698180.0
2022-06-15	META	Stock	167.2	172.16	163.98	169.35	30008300.0
2022-06-15	TSLA	Stock	220.9167	235.6633	218.15	233.0	119131800.0
2022-06-15	TLT	Stock	110.085	110.99	109.03	110.84	25202801.0
2022-06-15	ES	Stock	81.41	81.97	79.75	80.58	2150500.0
2022-06-15	CL	Stock	74.38	75.47	73.06	74.16	6023400.0
2022-06-15	A	Stock	117.24	117.77	113.77	116.47	1886300.0
2022-06-15	AA	Stock	49.55	52.39	49.01	51.11	10392400.0
2022-06-15	AAC-DELISTED	Stock	9.82	9.83	9.82	9.83	100753.0
2022-06-15	AACG	Stock	1.05	1.05	1.0	1.01	17200.0
2022-06-15	AAIC-DELISTED	Stock	3.12	3.24	3.11	3.15	59391.0
2022-06-15	AAIC.C-DELISTED	Stock	22.46	22.97	22.46	22.81	2158.0
2022-06-15	AAL	Stock	13.07	13.68	13.02	13.31	49703400.0
2022-06-15	AAM.A-DELISTED	Stock	24.11	24.11	23.5	23.75	26471.0
2022-06-15	AAM.B-DELISTED	Stock	24.37	24.7999	23.7563	24.1	15876.0
2022-06-15	AAMC-DELISTED	Stock	3.2353	3.2941	3.1618	3.1735	9030.0
2022-06-15	AAME	Stock	2.75	3.0	2.75	2.89	5800.0
2022-06-15	AAMI	Stock	19.04	19.31	18.6	18.94	471100.0
2022-06-15	AAN-DELISTED	Stock	16.6	17.045	16.34	16.49	334100.0
2022-06-15	AAOI	Stock	1.95	2.01	1.91	1.98	352100.0
2022-06-15	AAON	Stock	34.7933	35.2867	34.5533	34.8067	203250.0
2022-06-15	AAP	Stock	172.12	173.64	169.0	172.29	859200.0
2022-06-15	AAQC-DELISTED	Stock	9.76	9.77	9.75	9.765	29496.0
2022-06-15	AAT	Stock	29.14	30.07	28.96	29.53	301700.0
2022-06-15	AATC	Stock	5.4676	5.5199	5.4	5.41	6779.0
2022-06-15	AAU-DELISTED	Stock	0.2535	0.2581	0.24	0.2415	329280.0
2022-06-15	AAUAF-DELISTED	Stock	0.2535	0.2581	0.24	0.2415	331518.0
2022-06-15	AAWW-DELISTED	Stock	64.76	66.12	64.48	65.52	247393.0
2022-06-15	AAXJ	Stock	68.99	70.11	68.67	69.62	2122731.0
2022-06-15	AB	Stock	41.03	42.12	40.55	41.38	385500.0
2022-06-15	ABB-DELISTED	Stock	28.04	28.445	27.555	28.16	2443743.0
2022-06-15	ABBNY-DELISTED	Stock	28.04	28.445	27.555	28.15	2642987.0
2022-06-15	ABBV	Stock	136.57	139.09	136.23	138.09	5981800.0
2022-06-15	ABC-DELISTED	Stock	141.28	144.19	141.09	142.15	861100.0
2022-06-15	ABCB	Stock	42.06	43.07	41.35	41.74	384500.0
2022-06-15	ABCL	Stock	8.84	9.562	8.79	9.27	3058600.0
2022-06-15	ABCM-DELISTED	Stock	13.17	13.75	13.16	13.605	93501.0
2022-06-15	ABEO	Stock	4.0	4.5	3.75	4.0	97920.0
2022-06-15	ABEV	Stock	2.54	2.57	2.49	2.54	41195000.0
2022-06-15	ABG	Stock	176.51	177.39	170.39	172.96	141100.0
2022-06-15	ABGI-DELISTED	Stock	9.8	9.8	9.79	9.79	10117.0
2022-06-15	ABM	Stock	39.9	40.92	39.51	40.55	599300.0
2022-06-15	ABMD-DELISTED	Stock	229.27	238.095	226.92	232.35	235864.0
2022-06-15	ABNB	Stock	100.02	103.65	98.92	101.47	6260400.0
2022-06-15	ABOS	Stock	3.61	3.67	3.53	3.59	209600.0
2022-06-15	ABR	Stock	13.3	13.45	12.85	13.18	6229400.0

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

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