PREVIEW / stock_daily / 2022-04-14

all stock daily files

  file:    by_date/stock_daily/2022/2022-04-14.parquet
  size:    258 KB
  rows:    7,970
  symbols: 2,455

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-04-14	AAPL	Stock	170.62	171.27	165.04	165.29	75329400.0
2022-04-14	MSFT	Stock	288.09	288.31	279.32	279.83	28221600.0
2022-04-14	NVDA	Stock	22.505	22.777	21.163	21.258	569097000.0
2022-04-14	AMZN	Stock	155.39	155.897	151.472	151.7065	51598000.0
2022-04-14	GOOGL	Stock	130.4795	130.4795	126.601	126.73	31597980.0
2022-04-14	META	Stock	214.89	214.99	210.0	210.18	18379500.0
2022-04-14	TSLA	Stock	333.0967	337.57	327.3967	328.3333	58422300.0
2022-04-14	TLT	Stock	122.86	122.93	120.38	120.75	34274530.0
2022-04-14	ES	Stock	92.76	93.2	92.34	92.6	1191500.0
2022-04-14	CL	Stock	81.36	81.47	80.87	80.94	7663700.0
2022-04-14	A	Stock	128.42	128.96	125.57	126.44	3360700.0
2022-04-14	AA	Stock	87.38	90.08	87.1	87.77	5012800.0
2022-04-14	AAC-DELISTED	Stock	9.87	9.87	9.82	9.82	13817.0
2022-04-14	AACG	Stock	1.23	1.24	1.22	1.23	8700.0
2022-04-14	AAIC-DELISTED	Stock	3.36	3.4	3.32	3.3729	43511.0
2022-04-14	AAIC.C-DELISTED	Stock	24.84	24.84	24.6	24.73	1400.0
2022-04-14	AAL	Stock	18.99	19.49	18.88	19.0	43180700.0
2022-04-14	AAM.A-DELISTED	Stock	25.0	25.07	24.975	25.0	127664.0
2022-04-14	AAM.B-DELISTED	Stock	25.23	25.3559	25.04	25.14	96932.0
2022-04-14	AAMC-DELISTED	Stock	2.9383	3.2286	2.9088	3.0	52030.0
2022-04-14	AAME	Stock	3.35	3.49	3.25	3.43	12000.0
2022-04-14	AAMI	Stock	22.49	22.6	21.92	21.99	495400.0
2022-04-14	AAN-DELISTED	Stock	21.56	21.825	21.32	21.38	148100.0
2022-04-14	AAOI	Stock	3.05	3.12	3.03	3.03	158500.0
2022-04-14	AAON	Stock	35.0733	35.0733	34.4133	34.6533	324900.0
2022-04-14	AAP	Stock	221.0	222.96	218.38	218.68	513000.0
2022-04-14	AAQC-DELISTED	Stock	9.765	9.765	9.765	9.765	4200.0
2022-04-14	AAT	Stock	36.31	36.54	35.97	36.09	182800.0
2022-04-14	AATC	Stock	6.6466	6.68	6.46	6.67	19711.0
2022-04-14	AAU-DELISTED	Stock	0.38	0.3825	0.3643	0.38	709074.0
2022-04-14	AAUAF-DELISTED	Stock	0.38	0.3825	0.3643	0.3794	713380.0
2022-04-14	AAWW-DELISTED	Stock	68.31	70.1	67.985	68.43	281534.0
2022-04-14	AAXJ	Stock	73.98	74.01	73.29	73.29	1211597.0
2022-04-14	AB	Stock	46.05	46.46	44.76	44.81	327900.0
2022-04-14	ABB-DELISTED	Stock	31.33	31.36	30.825	30.84	1417390.0
2022-04-14	ABBNY-DELISTED	Stock	31.33	31.36	30.825	30.83	1616728.0
2022-04-14	ABBV	Stock	157.85	163.87	156.82	162.31	11074800.0
2022-04-14	ABC-DELISTED	Stock	163.29	164.3	160.49	161.0	2452803.0
2022-04-14	ABCB	Stock	41.24	41.98	40.59	40.77	649800.0
2022-04-14	ABCL	Stock	8.98	9.17	8.74	8.99	865400.0
2022-04-14	ABCM-DELISTED	Stock	18.16	18.51	18.01	18.36	155073.0
2022-04-14	ABEO	Stock	7.0	7.0	6.75	6.75	31116.0
2022-04-14	ABEV	Stock	3.1	3.1	3.05	3.1	16902000.0
2022-04-14	ABG	Stock	155.81	159.06	152.23	153.66	230600.0
2022-04-14	ABGI-DELISTED	Stock	9.84	9.84	9.84	9.84	398.0
2022-04-14	ABM	Stock	48.71	49.75	48.6	49.3	497200.0
2022-04-14	ABMD-DELISTED	Stock	306.21	306.35	298.45	306.22	144978.0
2022-04-14	ABNB	Stock	171.66	174.64	170.295	170.7	5125100.0
2022-04-14	ABOS	Stock	3.88	4.0	3.81	3.97	262700.0
2022-04-14	ABR	Stock	17.33	17.61	17.33	17.53	1654400.0

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

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