PREVIEW / stock_daily / 2022-03-25

all stock daily files

  file:    by_date/stock_daily/2022/2022-03-25.parquet
  size:    260 KB
  rows:    8,010
  symbols: 2,480

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-25	AAPL	Stock	173.88	175.28	172.75	174.72	80546200.0
2022-03-25	MSFT	Stock	305.23	305.5	299.29	303.68	22566500.0
2022-03-25	NVDA	Stock	27.886	28.358	27.271	27.692	579016000.0
2022-03-25	AMZN	Stock	164.0	165.3685	162.25	164.7735	49032000.0
2022-03-25	GOOGL	Stock	141.916	142.035	139.7375	141.673	24143080.0
2022-03-25	META	Stock	220.51	225.5	218.89	221.82	40039000.0
2022-03-25	TSLA	Stock	336.0	340.6	332.44	336.88	62031600.0
2022-03-25	TLT	Stock	129.5	129.52	127.65	128.66	25689789.0
2022-03-25	ES	Stock	85.93	86.68	85.53	86.66	969200.0
2022-03-25	CL	Stock	73.91	75.06	73.78	74.78	4401000.0
2022-03-25	A	Stock	137.3	137.66	133.7	135.71	1403700.0
2022-03-25	AA	Stock	95.89	98.09	91.02	91.96	6035100.0
2022-03-25	AAC-DELISTED	Stock	9.78	9.78	9.78	9.78	1981.0
2022-03-25	AACG	Stock	1.42	1.52	1.42	1.45	12500.0
2022-03-25	AACIW-DELISTED	Stock	0.3099	0.3099	0.24	0.24	3104.0
2022-03-25	AAIC-DELISTED	Stock	3.52	3.5402	3.49	3.5	23483.0
2022-03-25	AAL	Stock	16.75	17.44	16.74	17.01	39510300.0
2022-03-25	AAM.A-DELISTED	Stock	25.03	25.03	24.95	25.0	21906.0
2022-03-25	AAM.B-DELISTED	Stock	25.12	25.26	25.1	25.1086	10376.0
2022-03-25	AAMC-DELISTED	Stock	4.1765	4.625	4.1765	4.4794	113346.0
2022-03-25	AAME	Stock	2.85	3.09	2.83	2.85	27700.0
2022-03-25	AAMI	Stock	24.53	24.76	23.96	24.07	391500.0
2022-03-25	AAN-DELISTED	Stock	21.53	22.15	21.33	21.89	238400.0
2022-03-25	AAOI	Stock	3.36	3.37	3.23	3.27	201800.0
2022-03-25	AAON	Stock	35.2867	35.4733	34.5933	34.8267	286650.0
2022-03-25	AAP	Stock	216.13	216.27	211.72	215.58	802900.0
2022-03-25	AAQC-DELISTED	Stock	9.73	9.74	9.725	9.73	9820.0
2022-03-25	AAT	Stock	36.1	36.92	36.1	36.9	255700.0
2022-03-25	AATC	Stock	6.41	6.5644	6.26	6.36	13286.0
2022-03-25	AAU-DELISTED	Stock	0.365	0.37	0.3582	0.365	531900.0
2022-03-25	AAUAF-DELISTED	Stock	0.365	0.37	0.3582	0.365	543458.0
2022-03-25	AAWW-DELISTED	Stock	88.64	89.43	87.79	88.86	305162.0
2022-03-25	AAXJ	Stock	74.92	75.13	74.56	75.1	1003627.0
2022-03-25	AB	Stock	46.07	46.21	45.61	46.08	153900.0
2022-03-25	ABB-DELISTED	Stock	34.74	34.77	34.29	34.6	2047817.0
2022-03-25	ABBNY-DELISTED	Stock	34.74	34.77	34.29	34.61	2251093.0
2022-03-25	ABBV	Stock	160.55	161.98	160.23	161.33	5129400.0
2022-03-25	ABC-DELISTED	Stock	152.84	155.34	152.705	154.69	516635.0
2022-03-25	ABCB	Stock	44.71	45.49	44.66	44.94	480100.0
2022-03-25	ABCL	Stock	9.83	9.83	9.194	9.54	2500500.0
2022-03-25	ABCM-DELISTED	Stock	17.87	18.12	17.764	18.01	73721.0
2022-03-25	ABEO	Stock	7.25	7.5	7.0	7.5	47832.0
2022-03-25	ABEV	Stock	2.93	3.0	2.91	3.0	26354800.0
2022-03-25	ABG	Stock	174.64	176.0	171.09	172.69	209000.0
2022-03-25	ABM	Stock	44.71	45.79	44.68	44.99	346300.0
2022-03-25	ABMD-DELISTED	Stock	323.31	325.0	315.38	319.0	106768.0
2022-03-25	ABNB	Stock	169.94	170.61	164.134	167.22	2952300.0
2022-03-25	ABOS	Stock	5.66	5.68	5.055	5.14	194200.0
2022-03-25	ABR	Stock	17.23	17.35	17.07	17.17	1896100.0
2022-03-25	ABR.D	Stock	22.0	22.1599	22.0	22.05	14719.0

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

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