PREVIEW / stock_daily / 2022-03-07

all stock daily files

  file:    by_date/stock_daily/2022/2022-03-07.parquet
  size:    261 KB
  rows:    8,087
  symbols: 2,555

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-07	AAPL	Stock	163.36	165.02	159.04	159.3	96418800.0
2022-03-07	MSFT	Stock	288.53	289.69	278.53	278.91	43157200.0
2022-03-07	NVDA	Stock	22.817	23.033	21.33	21.352	450821000.0
2022-03-07	AMZN	Stock	145.4435	146.0945	137.4165	137.453	86934000.0
2022-03-07	GOOGL	Stock	131.488	131.735	126.295	126.3785	45112940.0
2022-03-07	META	Stock	200.79	200.89	187.28	187.47	38560600.0
2022-03-07	TSLA	Stock	285.4333	288.7133	268.19	268.1933	72494100.0
2022-03-07	TLT	Stock	139.12	140.64	138.77	139.17	23710932.0
2022-03-07	ES	Stock	85.77	86.91	84.86	86.66	1995900.0
2022-03-07	CL	Stock	76.91	77.24	75.86	76.68	4298600.0
2022-03-07	A	Stock	133.55	133.55	128.43	130.34	2376500.0
2022-03-07	AA	Stock	89.56	92.32	83.51	85.4	12623500.0
2022-03-07	AAC-DELISTED	Stock	9.76	9.77	9.76	9.76	670109.0
2022-03-07	AACG	Stock	1.21	1.26	1.16	1.2	65700.0
2022-03-07	AACIW-DELISTED	Stock	0.37	0.37	0.3488	0.3488	10270.0
2022-03-07	AAIC-DELISTED	Stock	3.49	3.64	3.49	3.58	130522.0
2022-03-07	AAIC.C-DELISTED	Stock	24.95	25.044	24.95	25.0	2200.0
2022-03-07	AAL	Stock	14.32	14.62	12.77	12.84	89360300.0
2022-03-07	AAM.A-DELISTED	Stock	25.02	25.02	24.83	24.85	31776.0
2022-03-07	AAM.B-DELISTED	Stock	25.28	25.28	24.99	25.01	39138.0
2022-03-07	AAME	Stock	2.46	2.46	2.34	2.34	5000.0
2022-03-07	AAMI	Stock	23.05	23.14	21.29	21.32	1104800.0
2022-03-07	AAN-DELISTED	Stock	22.54	22.57	21.51	21.66	314100.0
2022-03-07	AAOI	Stock	3.44	3.64	3.4	3.56	192600.0
2022-03-07	AAON	Stock	36.3467	36.6333	36.0267	36.1933	317100.0
2022-03-07	AAP	Stock	206.38	207.06	200.49	201.31	1289400.0
2022-03-07	AAQC-DELISTED	Stock	9.71	9.715	9.7	9.715	58476.0
2022-03-07	AAT	Stock	37.72	37.72	37.02	37.06	169800.0
2022-03-07	AATC	Stock	6.6	6.7472	6.511	6.55	3678.0
2022-03-07	AAU-DELISTED	Stock	0.3097	0.3471	0.3018	0.339	980194.0
2022-03-07	AAUAF-DELISTED	Stock	0.3097	0.3471	0.3018	0.339	994502.0
2022-03-07	AAWW-DELISTED	Stock	81.59	82.77	79.32	79.46	442255.0
2022-03-07	AAXJ	Stock	73.72	74.04	72.2	72.26	2553126.0
2022-03-07	AB	Stock	42.99	43.14	40.37	40.96	700400.0
2022-03-07	ABB-DELISTED	Stock	31.36	31.4736	30.42	30.51	3310099.0
2022-03-07	ABBNY-DELISTED	Stock	31.36	31.4736	30.42	30.5	3654263.0
2022-03-07	ABBV	Stock	149.0	150.75	148.19	149.45	7137700.0
2022-03-07	ABC-DELISTED	Stock	146.89	148.42	144.79	144.82	956941.0
2022-03-07	ABCB	Stock	46.84	47.03	44.23	44.36	928500.0
2022-03-07	ABCL	Stock	8.45	8.82	8.18	8.28	1648200.0
2022-03-07	ABCM-DELISTED	Stock	16.05	16.25	15.94	16.05	73576.0
2022-03-07	ABEO	Stock	6.5	7.0	6.5	7.0	73072.0
2022-03-07	ABEV	Stock	2.7	2.71	2.61	2.62	43541600.0
2022-03-07	ABG	Stock	189.14	191.89	187.75	188.07	374400.0
2022-03-07	ABGI-DELISTED	Stock	9.74	9.76	9.74	9.75	45508.0
2022-03-07	ABM	Stock	46.8	46.8	45.31	45.49	384300.0
2022-03-07	ABMD-DELISTED	Stock	314.26	317.38	297.24	298.0	137769.0
2022-03-07	ABNB	Stock	145.0	145.27	131.52	131.59	9177300.0
2022-03-07	ABOS	Stock	4.96	5.405	4.955	5.29	187600.0
2022-03-07	ABR	Stock	17.71	17.77	17.34	17.34	2231000.0

> showing 50 of 8,087 rows — these rows as CSV

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