PREVIEW / stock_daily / 2022-03-04

all stock daily files

  file:    by_date/stock_daily/2022/2022-03-04.parquet
  size:    260 KB
  rows:    8,033
  symbols: 2,507

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-04	AAPL	Stock	164.49	165.55	162.1	163.17	83737200.0
2022-03-04	MSFT	Stock	294.29	295.66	287.17	289.86	32356500.0
2022-03-04	NVDA	Stock	23.384	23.68	22.482	22.936	431415000.0
2022-03-04	AMZN	Stock	147.159	147.85	143.807	145.641	60934000.0
2022-03-04	GOOGL	Stock	132.9275	133.8515	130.3375	131.9065	30450640.0
2022-03-04	META	Stock	202.37	205.89	198.79	200.06	32130900.0
2022-03-04	TSLA	Stock	283.0333	285.2167	275.0533	279.43	66999600.0
2022-03-04	TLT	Stock	140.36	140.825	139.305	140.24	25854808.0
2022-03-04	ES	Stock	83.22	86.55	82.91	85.94	2704200.0
2022-03-04	CL	Stock	76.7	77.51	76.39	77.36	3670900.0
2022-03-04	A	Stock	135.85	137.12	132.14	133.89	3848500.0
2022-03-04	AA	Stock	82.01	90.95	81.73	90.66	19654000.0
2022-03-04	AAC-DELISTED	Stock	9.76	9.77	9.75	9.77	72866.0
2022-03-04	AACG	Stock	1.29	1.29	1.21	1.21	35000.0
2022-03-04	AAIC-DELISTED	Stock	3.48	3.51	3.43	3.5	103906.0
2022-03-04	AAIC.C-DELISTED	Stock	25.09	25.1121	24.9	24.95	3706.0
2022-03-04	AAL	Stock	15.27	15.48	14.42	14.59	76212200.0
2022-03-04	AAM.A-DELISTED	Stock	25.04	25.04	24.98	24.98	25696.0
2022-03-04	AAM.B-DELISTED	Stock	25.32	25.37	25.26	25.3382	6620.0
2022-03-04	AAME	Stock	2.51	2.51	2.42	2.42	2300.0
2022-03-04	AAMI	Stock	23.89	23.92	22.91	23.16	1001500.0
2022-03-04	AAN-DELISTED	Stock	22.39	22.5	21.551	22.37	238000.0
2022-03-04	AAOI	Stock	3.55	3.59	3.41	3.41	399400.0
2022-03-04	AAON	Stock	35.6467	36.3667	35.0333	36.2133	460650.0
2022-03-04	AAP	Stock	205.67	208.1	202.48	206.62	760000.0
2022-03-04	AAQC-DELISTED	Stock	9.7	9.71	9.7	9.71	85501.0
2022-03-04	AAT	Stock	36.79	37.63	36.66	37.61	269700.0
2022-03-04	AATC	Stock	6.99	6.99	6.61	6.61	14855.0
2022-03-04	AAU-DELISTED	Stock	0.282	0.3096	0.282	0.295	493334.0
2022-03-04	AAUAF-DELISTED	Stock	0.282	0.3096	0.282	0.295	498480.0
2022-03-04	AAWW-DELISTED	Stock	80.38	82.83	79.89	82.36	499728.0
2022-03-04	AAXJ	Stock	75.52	75.91	74.83	75.19	2727264.0
2022-03-04	AB	Stock	43.81	44.0	42.92	43.22	333700.0
2022-03-04	ABB-DELISTED	Stock	31.78	31.88	31.36	31.68	2991816.0
2022-03-04	ABBNY-DELISTED	Stock	31.78	31.88	31.36	31.68	3255531.0
2022-03-04	ABBV	Stock	148.6	150.68	148.1	150.56	5389500.0
2022-03-04	ABC-DELISTED	Stock	143.5	147.51	143.09	147.23	746050.0
2022-03-04	ABCB	Stock	47.57	48.19	46.11	46.77	555200.0
2022-03-04	ABCL	Stock	8.92	9.115	8.51	8.53	1224900.0
2022-03-04	ABCM-DELISTED	Stock	16.27	16.51	16.14	16.25	57786.0
2022-03-04	ABEO	Stock	6.75	7.0	6.5	6.75	73616.0
2022-03-04	ABEV	Stock	2.74	2.78	2.71	2.73	48903200.0
2022-03-04	ABG	Stock	192.3	195.4	189.83	190.85	451000.0
2022-03-04	ABGI-DELISTED	Stock	9.75	9.75	9.75	9.75	160658.0
2022-03-04	ABM	Stock	45.54	46.6	45.26	46.59	467700.0
2022-03-04	ABMD-DELISTED	Stock	309.3	314.5303	304.16	313.51	114786.0
2022-03-04	ABNB	Stock	150.77	151.89	140.46	142.7	8390800.0
2022-03-04	ABOS	Stock	5.45	5.45	4.96	5.02	170200.0
2022-03-04	ABR	Stock	17.5	17.73	17.41	17.69	1987400.0
2022-03-04	ABR.D	Stock	22.79	22.9658	22.5	22.61	29886.0

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

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