PREVIEW / stock_daily / 2022-03-18

all stock daily files

  file:    by_date/stock_daily/2022/2022-03-18.parquet
  size:    261 KB
  rows:    7,985
  symbols: 2,469

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-03-18	AAPL	Stock	160.51	164.48	159.76	163.98	123511700.0
2022-03-18	MSFT	Stock	295.37	301.0	292.73	300.43	43390600.0
2022-03-18	NVDA	Stock	24.799	26.569	24.624	26.453	730719000.0
2022-03-18	AMZN	Stock	156.813	161.594	156.011	161.2505	102962000.0
2022-03-18	GOOGL	Stock	133.4245	136.244	132.2582	136.1255	44566900.0
2022-03-18	META	Stock	206.7	216.8	206.0	216.49	52128000.0
2022-03-18	TSLA	Stock	291.4967	302.6167	289.13	301.7967	100414200.0
2022-03-18	TLT	Stock	132.57	133.535	132.57	133.44	55891681.0
2022-03-18	ES	Stock	84.57	84.86	83.05	83.43	4032300.0
2022-03-18	CL	Stock	75.39	75.4	72.2	72.2	14746300.0
2022-03-18	A	Stock	136.21	139.39	136.21	139.12	2766600.0
2022-03-18	AA	Stock	80.52	82.7	79.21	82.44	7681600.0
2022-03-18	AAC-DELISTED	Stock	9.75	9.775	9.75	9.765	36718.0
2022-03-18	AACG	Stock	1.45	1.45	1.38	1.43	39800.0
2022-03-18	AACIU	Stock	9.85	9.85	9.85	9.85	300.0
2022-03-18	AACIW-DELISTED	Stock	0.28755	0.28755	0.28755	0.28755	403.0
2022-03-18	AAIC-DELISTED	Stock	3.5	3.51	3.42	3.42	221363.0
2022-03-18	AAIC.C-DELISTED	Stock	24.83	24.83	24.795	24.795	500.0
2022-03-18	AAL	Stock	16.35	16.84	16.16	16.75	39040200.0
2022-03-18	AAM.A-DELISTED	Stock	25.16	25.16	25.0775	25.094	7774.0
2022-03-18	AAM.B-DELISTED	Stock	25.45	25.46	25.31	25.39	7945.0
2022-03-18	AAME	Stock	2.49	2.55	2.48	2.55	3100.0
2022-03-18	AAMI	Stock	25.49	25.9	25.06	25.77	3715800.0
2022-03-18	AAN-DELISTED	Stock	22.93	23.63	22.44	23.18	1721200.0
2022-03-18	AAOI	Stock	3.28	3.64	3.28	3.61	378100.0
2022-03-18	AAON	Stock	37.6	39.1	37.34	38.9333	611850.0
2022-03-18	AAP	Stock	206.04	207.69	200.73	206.34	1746300.0
2022-03-18	AAQC-DELISTED	Stock	9.72	9.7236	9.72	9.7236	386.0
2022-03-18	AAT	Stock	37.25	37.25	36.73	37.09	432800.0
2022-03-18	AATC	Stock	6.59	6.75	6.51	6.74	8138.0
2022-03-18	AAU-DELISTED	Stock	0.34	0.355	0.3391	0.3489	712151.0
2022-03-18	AAUAF-DELISTED	Stock	0.34	0.355	0.3391	0.35	722530.0
2022-03-18	AAWW-DELISTED	Stock	85.14	88.44	84.71	88.29	1451852.0
2022-03-18	AAXJ	Stock	74.77	76.715	74.5	76.58	1624680.0
2022-03-18	AB	Stock	45.87	46.99	45.83	46.58	386700.0
2022-03-18	ABB-DELISTED	Stock	34.73	35.51	34.73	35.46	2420375.0
2022-03-18	ABBNY-DELISTED	Stock	34.73	35.51	34.73	35.46	2668623.0
2022-03-18	ABBV	Stock	158.0	159.44	157.14	159.2	9912800.0
2022-03-18	ABC-DELISTED	Stock	152.21	152.45	150.11	151.93	1684885.0
2022-03-18	ABCB	Stock	47.15	47.62	45.71	47.18	960400.0
2022-03-18	ABCL	Stock	8.71	9.0	8.71	8.83	1651600.0
2022-03-18	ABCM-DELISTED	Stock	17.5	18.11	17.47	18.01	401130.0
2022-03-18	ABEO	Stock	7.25	7.75	6.75	6.75	79088.0
2022-03-18	ABEV	Stock	2.75	2.84	2.75	2.84	18240900.0
2022-03-18	ABG	Stock	192.25	193.43	182.96	190.31	396700.0
2022-03-18	ABGI-DELISTED	Stock	9.78	9.78	9.765	9.765	509.0
2022-03-18	ABM	Stock	45.79	45.9	43.63	44.57	1411100.0
2022-03-18	ABMD-DELISTED	Stock	307.86	312.37	303.59	304.33	314258.0
2022-03-18	ABNB	Stock	156.07	167.18	155.7	167.0	8467500.0
2022-03-18	ABOS	Stock	6.2	6.71	6.2	6.41	2018900.0

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

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