PREVIEW / stock_daily / 2022-08-18

all stock daily files

  file:    by_date/stock_daily/2022/2022-08-18.parquet
  size:    252 KB
  rows:    7,811
  symbols: 2,184

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-18	AAPL	Stock	173.75	174.9	173.12	174.15	62290100.0
2022-08-18	MSFT	Stock	290.19	291.91	289.08	290.17	17186200.0
2022-08-18	NVDA	Stock	18.301	18.865	18.183	18.773	415447000.0
2022-08-18	AMZN	Stock	141.32	142.77	140.38	142.3	37458700.0
2022-08-18	GOOGL	Stock	119.43	120.82	118.72	120.17	17987660.0
2022-08-18	META	Stock	174.34	175.76	171.86	174.66	18844500.0
2022-08-18	TSLA	Stock	306.0	306.5	301.8533	302.87	47500500.0
2022-08-18	TLT	Stock	114.97	115.64	114.585	114.89	10738208.0
2022-08-18	ES	Stock	94.0	94.41	93.59	93.96	737200.0
2022-08-18	CL	Stock	81.92	82.98	81.74	82.85	2634300.0
2022-08-18	A	Stock	141.88	141.96	138.76	139.97	1740300.0
2022-08-18	AA	Stock	52.57	54.2	52.36	53.84	4021500.0
2022-08-18	AAC-DELISTED	Stock	9.88	9.88	9.87	9.87	125875.0
2022-08-18	AACG	Stock	2.4	2.64	2.31	2.6	325800.0
2022-08-18	AAIC-DELISTED	Stock	3.31	3.32	3.2668	3.31	18066.0
2022-08-18	AAIC.C-DELISTED	Stock	20.85	21.15	20.85	21.03	3490.0
2022-08-18	AAL	Stock	14.98	15.02	14.73	14.84	19271200.0
2022-08-18	AAM.A-DELISTED	Stock	25.26	25.4	25.26	25.3356	6766.0
2022-08-18	AAM.B-DELISTED	Stock	25.5	25.5	25.36	25.36	1935.0
2022-08-18	AAMC-DELISTED	Stock	6.0735	6.3588	6.0265	6.0265	19156.0
2022-08-18	AAME	Stock	3.01	3.17	3.0	3.12	6000.0
2022-08-18	AAMI	Stock	20.36	20.56	20.2	20.43	104400.0
2022-08-18	AAN-DELISTED	Stock	14.52	14.58	14.27	14.45	198900.0
2022-08-18	AAOI	Stock	2.8	2.8	2.63	2.74	249300.0
2022-08-18	AAON	Stock	41.9933	42.16	41.5667	41.9133	100950.0
2022-08-18	AAP	Stock	209.78	210.23	205.77	207.49	528000.0
2022-08-18	AAT	Stock	30.01	30.24	29.89	30.16	174200.0
2022-08-18	AATC	Stock	5.177	5.25	5.07	5.25	24548.0
2022-08-18	AAU-DELISTED	Stock	0.2336	0.2394	0.2202	0.221	213543.0
2022-08-18	AAUAF-DELISTED	Stock	0.2336	0.2394	0.2202	0.221	220186.0
2022-08-18	AAWW-DELISTED	Stock	100.05	100.35	100.01	100.19	382995.0
2022-08-18	AAXJ	Stock	68.28	68.28	67.87	68.08	661371.0
2022-08-18	AB	Stock	45.03	45.06	44.06	44.71	262100.0
2022-08-18	ABB-DELISTED	Stock	30.31	30.4	30.205	30.3	930144.0
2022-08-18	ABBNY-DELISTED	Stock	30.31	30.4	30.205	30.3	1027086.0
2022-08-18	ABBV	Stock	141.49	141.58	139.82	141.29	3525200.0
2022-08-18	ABC-DELISTED	Stock	149.92	150.47	147.77	150.03	356424.0
2022-08-18	ABCB	Stock	50.13	50.71	49.77	50.67	227000.0
2022-08-18	ABCL	Stock	12.97	12.99	12.12	12.45	1978800.0
2022-08-18	ABCM-DELISTED	Stock	15.02	15.45	15.01	15.35	170068.0
2022-08-18	ABEO	Stock	4.61	4.61	4.23	4.36	111500.0
2022-08-18	ABEV	Stock	3.0	3.05	2.98	3.03	26681800.0
2022-08-18	ABG	Stock	190.08	190.43	185.92	188.42	105400.0
2022-08-18	ABGI-DELISTED	Stock	9.86	9.86	9.86	9.86	210.0
2022-08-18	ABM	Stock	47.18	48.64	47.09	48.47	235400.0
2022-08-18	ABMD-DELISTED	Stock	282.22	283.85	277.26	278.35	131493.0
2022-08-18	ABNB	Stock	121.5	122.2	120.28	121.27	3373900.0
2022-08-18	ABOS	Stock	5.57	5.72	5.0	5.22	63100.0
2022-08-18	ABR	Stock	15.64	15.88	15.64	15.69	1548600.0
2022-08-18	ABR.D	Stock	21.505	21.56	21.302	21.39	4795.0

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

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