PREVIEW / stock_daily / 2022-01-25

all stock daily files

  file:    by_date/stock_daily/2022/2022-01-25.parquet
  size:    263 KB
  rows:    8,117
  symbols: 2,627

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-01-25	AAPL	Stock	158.98	162.76	157.02	159.78	115798400.0
2022-01-25	MSFT	Stock	291.52	294.99	285.17	288.49	72848600.0
2022-01-25	NVDA	Stock	22.546	22.943	22.0	22.324	664616000.0
2022-01-25	AMZN	Stock	142.2425	143.6	138.145	139.986	90824000.0
2022-01-25	GOOGL	Stock	128.74	129.399	126.5005	126.935	46960560.0
2022-01-25	META	Stock	299.95	306.23	297.58	300.15	25108500.0
2022-01-25	TSLA	Stock	304.7333	317.0867	301.07	306.1333	86595900.0
2022-01-25	TLT	Stock	143.11	143.71	141.8	142.22	15598988.0
2022-01-25	ES	Stock	85.44	86.26	84.57	85.57	1411700.0
2022-01-25	CL	Stock	83.19	83.32	81.49	81.74	7643300.0
2022-01-25	A	Stock	135.36	136.62	132.65	134.57	1705300.0
2022-01-25	AA	Stock	57.51	61.6	56.761	61.21	7780600.0
2022-01-25	AAC-DELISTED	Stock	9.7	9.73	9.7	9.72	766699.0
2022-01-25	AACG	Stock	1.7	1.76	1.7	1.72	48200.0
2022-01-25	AACIW-DELISTED	Stock	0.3	0.32	0.3	0.3005	58137.0
2022-01-25	AAIC-DELISTED	Stock	3.34	3.46	3.32	3.45	86519.0
2022-01-25	AAIC.C-DELISTED	Stock	24.6	24.71	24.6	24.7	1698.0
2022-01-25	AAL	Stock	16.05	16.54	15.89	16.46	42471600.0
2022-01-25	AAM.A-DELISTED	Stock	25.35	25.44	25.34	25.42	71446.0
2022-01-25	AAM.B-DELISTED	Stock	26.21	26.69	26.21	26.59	51225.0
2022-01-25	AAME	Stock	2.43	2.59	2.3	2.55	18300.0
2022-01-25	AAMI	Stock	21.47	21.58	20.83	21.05	932600.0
2022-01-25	AAN-DELISTED	Stock	22.22	22.49	21.6	22.24	259300.0
2022-01-25	AAOI	Stock	3.97	4.03	3.87	3.95	335300.0
2022-01-25	AAON	Stock	44.4133	44.5533	43.14	44.0267	551700.0
2022-01-25	AAP	Stock	229.68	232.5	226.24	230.18	520400.0
2022-01-25	AAQC-DELISTED	Stock	9.68	9.69	9.68	9.69	4121.0
2022-01-25	AAT	Stock	34.83	35.86	34.56	35.52	412400.0
2022-01-25	AATC	Stock	5.75	5.8586	5.06	5.54	86350.0
2022-01-25	AAU-DELISTED	Stock	0.27	0.2837	0.27	0.2771	263327.0
2022-01-25	AAUAF-DELISTED	Stock	0.27	0.2837	0.27	0.2771	267276.0
2022-01-25	AAWW-DELISTED	Stock	78.29	79.02	76.76	78.1	312541.0
2022-01-25	AAXJ	Stock	81.04	81.69	80.71	81.29	2262576.0
2022-01-25	AB	Stock	45.6	45.95	44.17	45.09	478300.0
2022-01-25	ABB-DELISTED	Stock	35.31	35.6	34.855	35.29	2427416.0
2022-01-25	ABBNY-DELISTED	Stock	35.3	35.6	34.855	35.28	2663250.0
2022-01-25	ABBV	Stock	131.49	134.32	130.79	133.09	10296500.0
2022-01-25	ABC-DELISTED	Stock	130.6	131.75	127.98	131.02	468928.0
2022-01-25	ABCB	Stock	51.18	52.12	50.11	51.41	334900.0
2022-01-25	ABCL	Stock	8.4	8.74	8.1	8.37	1566800.0
2022-01-25	ABCM-DELISTED	Stock	17.23	17.49	16.99	17.18	104880.0
2022-01-25	ABEO	Stock	5.75	6.5	5.5	6.0	136336.0
2022-01-25	ABEV	Stock	2.67	2.79	2.66	2.79	31879800.0
2022-01-25	ABG	Stock	165.26	170.3	163.25	166.85	238500.0
2022-01-25	ABM	Stock	41.63	43.05	41.52	42.48	606200.0
2022-01-25	ABMD-DELISTED	Stock	304.84	307.955	295.81	296.75	369351.0
2022-01-25	ABNB	Stock	143.9	147.38	140.13	144.56	5704900.0
2022-01-25	ABOS	Stock	5.16	5.24	4.853	5.09	720900.0
2022-01-25	ABR	Stock	16.84	17.43	16.66	17.31	1772100.0
2022-01-25	ABR.D	Stock	25.05	25.21	25.04	25.21	14831.0

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

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