PREVIEW / stock_daily / 2022-02-17

all stock daily files

  file:    by_date/stock_daily/2022/2022-02-17.parquet
  size:    261 KB
  rows:    8,009
  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-02-17	AAPL	Stock	171.03	171.91	168.47	168.88	69589300.0
2022-02-17	MSFT	Stock	296.36	296.8	290.0	290.73	32461600.0
2022-02-17	NVDA	Stock	25.63	25.785	24.165	24.507	810595000.0
2022-02-17	AMZN	Stock	158.146	160.349	154.5	154.6525	64032000.0
2022-02-17	GOOGL	Stock	136.243	137.1135	132.4785	132.539	38949500.0
2022-02-17	META	Stock	214.02	217.5	207.16	207.71	38747500.0
2022-02-17	TSLA	Stock	304.42	306.1667	291.3667	292.1167	55178400.0
2022-02-17	TLT	Stock	136.45	137.565	135.9	136.79	24508242.0
2022-02-17	ES	Stock	80.42	82.75	79.01	82.28	3924300.0
2022-02-17	CL	Stock	78.15	79.35	77.88	79.15	3840700.0
2022-02-17	A	Stock	134.64	134.64	129.71	130.25	2577800.0
2022-02-17	AA	Stock	77.06	77.66	75.435	76.47	5515000.0
2022-02-17	AAC-DELISTED	Stock	9.73	9.76	9.73	9.75	2772629.0
2022-02-17	AACG	Stock	1.55	1.57	1.47	1.55	15900.0
2022-02-17	AAIC-DELISTED	Stock	3.38	3.4005	3.3599	3.37	40238.0
2022-02-17	AAL	Stock	18.54	18.67	18.03	18.22	29950300.0
2022-02-17	AAM.A-DELISTED	Stock	25.295	25.31	25.2	25.22	21414.0
2022-02-17	AAM.B-DELISTED	Stock	25.66	25.747	25.45	25.54	20091.0
2022-02-17	AAME	Stock	2.74	2.86	2.59	2.75	8700.0
2022-02-17	AAMI	Stock	25.02	25.12	24.07	24.13	568900.0
2022-02-17	AAN-DELISTED	Stock	21.11	21.439	20.97	21.16	260000.0
2022-02-17	AAOI	Stock	4.28	4.53	4.155	4.22	548500.0
2022-02-17	AAON	Stock	39.6	39.6933	38.7067	38.76	370050.0
2022-02-17	AAP	Stock	222.37	223.01	219.69	220.41	983900.0
2022-02-17	AAT	Stock	36.77	37.06	36.36	36.94	366200.0
2022-02-17	AATC	Stock	7.45	7.4585	7.1952	7.3297	12543.0
2022-02-17	AAU-DELISTED	Stock	0.36	0.3715	0.287	0.3006	1726411.0
2022-02-17	AAUAF-DELISTED	Stock	0.36	0.3715	0.287	0.3	1733786.0
2022-02-17	AAWW-DELISTED	Stock	82.43	84.54	75.64	77.1	1233519.0
2022-02-17	AAXJ	Stock	82.59	82.8	81.8926	82.01	1092003.0
2022-02-17	AB	Stock	47.75	47.94	46.18	46.54	568700.0
2022-02-17	ABB-DELISTED	Stock	34.9	34.96	34.43	34.47	1454017.0
2022-02-17	ABBNY-DELISTED	Stock	34.9	34.96	34.43	34.46	1645770.0
2022-02-17	ABBV	Stock	144.8	145.47	143.58	144.97	5486600.0
2022-02-17	ABC-DELISTED	Stock	142.1	143.33	141.39	142.08	806102.0
2022-02-17	ABCB	Stock	50.73	50.89	49.57	49.62	219900.0
2022-02-17	ABCL	Stock	9.62	9.75	9.16	9.3	1208500.0
2022-02-17	ABCM-DELISTED	Stock	17.47	17.5345	17.13	17.25	102961.0
2022-02-17	ABEO	Stock	6.5	6.5	5.75	6.0	49688.0
2022-02-17	ABEV	Stock	2.88	2.89	2.84	2.86	17709300.0
2022-02-17	ABG	Stock	183.82	186.99	178.34	185.32	331300.0
2022-02-17	ABM	Stock	42.49	43.12	42.4	43.07	340200.0
2022-02-17	ABMD-DELISTED	Stock	320.78	321.1388	306.77	307.29	234653.0
2022-02-17	ABNB	Stock	184.9	188.98	181.54	183.6	7779200.0
2022-02-17	ABOS	Stock	5.79	5.928	5.66	5.75	153800.0
2022-02-17	ABR	Stock	16.99	17.0	16.72	16.73	1764800.0
2022-02-17	ABR.D	Stock	23.07	23.32	22.75	22.97	35288.0
2022-02-17	ABR.E	Stock	22.33	22.77	22.33	22.77	61301.0
2022-02-17	ABR.F	Stock	24.17	24.2399	24.0	24.15	61573.0
2022-02-17	ABSI	Stock	8.92	9.005	8.63	8.66	290200.0

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

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