PREVIEW / stock_daily / 2022-02-09

all stock daily files

  file:    by_date/stock_daily/2022/2022-02-09.parquet
  size:    261 KB
  rows:    8,021
  symbols: 2,525

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-09	AAPL	Stock	176.05	176.65	174.9	176.28	71285000.0
2022-02-09	MSFT	Stock	309.87	311.93	307.39	311.21	31284700.0
2022-02-09	NVDA	Stock	25.622	26.725	25.353	26.705	524282000.0
2022-02-09	AMZN	Stock	162.8735	163.8345	160.25	161.1895	68786000.0
2022-02-09	GOOGL	Stock	140.9635	142.5243	140.187	141.592	40143880.0
2022-02-09	META	Stock	224.2	233.37	222.21	232.0	86563300.0
2022-02-09	TSLA	Stock	311.6667	315.4233	306.6667	310.6667	52259400.0
2022-02-09	TLT	Stock	138.72	139.37	138.19	138.43	14349139.0
2022-02-09	ES	Stock	88.37	88.57	87.02	87.36	1885500.0
2022-02-09	CL	Stock	81.1	81.36	80.31	80.87	3757200.0
2022-02-09	A	Stock	142.73	145.1	142.15	144.44	1216900.0
2022-02-09	AA	Stock	69.52	72.37	68.97	71.91	10244700.0
2022-02-09	AAC-DELISTED	Stock	9.76	9.76	9.73	9.75	38284.0
2022-02-09	AACG	Stock	1.58	1.67	1.57	1.59	52900.0
2022-02-09	AACIU	Stock	9.9218	9.9218	9.9218	9.9218	104.0
2022-02-09	AAIC-DELISTED	Stock	3.42	3.4885	3.41	3.42	80529.0
2022-02-09	AAL	Stock	18.45	18.97	18.35	18.76	42407300.0
2022-02-09	AAM.A-DELISTED	Stock	25.24	25.2965	25.22	25.23	29427.0
2022-02-09	AAM.B-DELISTED	Stock	25.74	25.79	25.69	25.74	33364.0
2022-02-09	AAME	Stock	2.57	2.61	2.48	2.56	6200.0
2022-02-09	AAMI	Stock	24.47	24.99	24.43	24.72	848400.0
2022-02-09	AAN-DELISTED	Stock	21.87	22.13	21.14	22.06	357900.0
2022-02-09	AAOI	Stock	3.9	4.11	3.9	4.05	411100.0
2022-02-09	AAON	Stock	39.9533	40.6133	39.68	39.88	356700.0
2022-02-09	AAP	Stock	231.92	234.23	230.42	232.18	523500.0
2022-02-09	AAT	Stock	35.45	36.43	35.17	35.61	295800.0
2022-02-09	AATC	Stock	7.41	7.41	7.03	7.35	14204.0
2022-02-09	AAU-DELISTED	Stock	0.3265	0.35	0.325	0.3489	420643.0
2022-02-09	AAUAF-DELISTED	Stock	0.3265	0.35	0.325	0.3417	427023.0
2022-02-09	AAWW-DELISTED	Stock	79.58	80.58	79.16	80.44	295627.0
2022-02-09	AAXJ	Stock	82.67	83.33	82.64	83.32	917936.0
2022-02-09	AB	Stock	48.58	49.75	48.55	49.5	315500.0
2022-02-09	ABB-DELISTED	Stock	35.82	35.865	35.675	35.81	2032600.0
2022-02-09	ABBNY-DELISTED	Stock	35.82	35.865	35.675	35.81	2217649.0
2022-02-09	ABBV	Stock	143.98	143.98	142.84	143.2	5989100.0
2022-02-09	ABC-DELISTED	Stock	142.48	143.56	141.03	142.94	1026194.0
2022-02-09	ABCB	Stock	50.63	51.38	50.4	51.19	471300.0
2022-02-09	ABCL	Stock	9.45	9.93	9.43	9.68	1899900.0
2022-02-09	ABCM-DELISTED	Stock	17.5	17.7	17.3	17.57	84243.0
2022-02-09	ABEO	Stock	6.75	6.75	6.25	6.75	55088.0
2022-02-09	ABEV	Stock	2.73	2.81	2.71	2.78	28005100.0
2022-02-09	ABG	Stock	160.43	165.0	159.69	164.76	197200.0
2022-02-09	ABM	Stock	41.61	42.44	41.61	41.78	306300.0
2022-02-09	ABMD-DELISTED	Stock	310.19	319.69	310.19	316.16	134541.0
2022-02-09	ABNB	Stock	165.37	170.07	165.08	169.53	4868300.0
2022-02-09	ABOS	Stock	5.53	5.849	5.48	5.8	283700.0
2022-02-09	ABR	Stock	17.44	17.61	17.4	17.47	1569200.0
2022-02-09	ABR.D	Stock	23.6	23.6	23.28	23.39	31540.0
2022-02-09	ABR.E	Stock	23.07	23.4108	22.81	23.09	21983.0
2022-02-09	ABR.F	Stock	24.04	24.04	23.55	23.9	74859.0

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

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