PREVIEW / stock_daily / 2022-02-01

all stock daily files

  file:    by_date/stock_daily/2022/2022-02-01.parquet
  size:    263 KB
  rows:    8,110
  symbols: 2,622

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-02-01	AAPL	Stock	174.01	174.84	172.31	174.61	86213900.0
2022-02-01	MSFT	Stock	310.41	310.63	305.13	308.76	40950400.0
2022-02-01	NVDA	Stock	25.104	25.145	23.89	24.638	518925000.0
2022-02-01	AMZN	Stock	150.0	151.708	147.6275	151.1935	59220000.0
2022-02-01	GOOGL	Stock	137.5945	137.7928	134.3685	137.644	68643640.0
2022-02-01	META	Stock	314.56	319.66	312.12	319.0	18023800.0
2022-02-01	TSLA	Stock	311.7367	314.5667	301.6667	310.4167	73138200.0
2022-02-01	TLT	Stock	142.28	142.36	141.055	141.72	20806097.0
2022-02-01	ES	Stock	89.16	89.86	87.1	87.97	1931800.0
2022-02-01	CL	Stock	82.75	82.95	81.52	81.92	5174700.0
2022-02-01	A	Stock	140.53	141.27	138.45	141.03	1655900.0
2022-02-01	AA	Stock	57.99	58.44	56.73	58.17	5939300.0
2022-02-01	AAC-DELISTED	Stock	9.71	9.75	9.71	9.74	45267.0
2022-02-01	AACG	Stock	1.53	1.65	1.52	1.61	56000.0
2022-02-01	AACIU	Stock	10.0	10.02	10.0	10.02	3032.0
2022-02-01	AACIW-DELISTED	Stock	0.2499	0.3	0.2302	0.2998	39110.0
2022-02-01	AAIC-DELISTED	Stock	3.4	3.48	3.39	3.44	73793.0
2022-02-01	AAIC.C-DELISTED	Stock	24.78	25.39	24.78	24.81	4585.0
2022-02-01	AAL	Stock	16.56	16.97	16.41	16.83	30798800.0
2022-02-01	AAM.A-DELISTED	Stock	25.23	25.27	25.11	25.24	113727.0
2022-02-01	AAM.B-DELISTED	Stock	25.99	26.07	25.78	25.98	56159.0
2022-02-01	AAME	Stock	2.6	2.6	2.41	2.51	6200.0
2022-02-01	AAMI	Stock	21.58	22.13	21.42	22.07	744000.0
2022-02-01	AAN-DELISTED	Stock	21.1	22.25	20.76	22.19	318000.0
2022-02-01	AAOI	Stock	4.13	4.23	4.05	4.12	364400.0
2022-02-01	AAON	Stock	43.1067	43.62	41.48	42.54	368100.0
2022-02-01	AAP	Stock	231.11	235.35	229.21	234.8	487500.0
2022-02-01	AAQC-DELISTED	Stock	9.7	9.71	9.68	9.71	24666.0
2022-02-01	AAT	Stock	35.85	36.07	35.3	35.84	261300.0
2022-02-01	AATC	Stock	6.98	6.98	6.87	6.93	45294.0
2022-02-01	AAU-DELISTED	Stock	0.2949	0.3	0.2949	0.2949	197932.0
2022-02-01	AAUAF-DELISTED	Stock	0.2949	0.3	0.2949	0.2953	201376.0
2022-02-01	AAWW-DELISTED	Stock	80.99	83.91	80.28	82.09	568893.0
2022-02-01	AAXJ	Stock	81.94	82.09	81.18	82.03	1065634.0
2022-02-01	AB	Stock	47.84	48.73	47.24	48.58	413600.0
2022-02-01	ABB-DELISTED	Stock	35.19	35.21	34.76	35.17	1805013.0
2022-02-01	ABBNY-DELISTED	Stock	35.19	35.21	34.76	35.18	1994881.0
2022-02-01	ABBV	Stock	137.37	137.84	136.04	137.0	7413900.0
2022-02-01	ABC-DELISTED	Stock	135.94	137.69	135.35	137.66	1165618.0
2022-02-01	ABCB	Stock	49.14	49.36	47.89	48.76	757500.0
2022-02-01	ABCL	Stock	9.1	9.53	8.77	9.31	1694600.0
2022-02-01	ABCM-DELISTED	Stock	17.94	17.94	17.45	17.62	115612.0
2022-02-01	ABEO	Stock	6.5	7.0	6.5	7.0	138052.0
2022-02-01	ABEV	Stock	2.84	2.86	2.8	2.82	12292200.0
2022-02-01	ABG	Stock	161.29	168.7	160.5	168.18	487500.0
2022-02-01	ABM	Stock	41.35	42.17	41.09	42.09	406400.0
2022-02-01	ABMD-DELISTED	Stock	301.44	304.02	295.99	300.95	265053.0
2022-02-01	ABNB	Stock	155.35	157.39	152.5	156.94	3799300.0
2022-02-01	ABOS	Stock	5.12	5.345	5.1	5.22	504200.0
2022-02-01	ABR	Stock	17.54	17.6	17.21	17.57	1531700.0

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

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