PREVIEW / stock_daily / 2021-01-04

all stock daily files

  file:    by_date/stock_daily/2021/2021-01-04.parquet
  size:    240 KB
  rows:    7,263
  symbols: 2,629

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
2021-01-04	AAPL	Stock	133.52	133.61	126.76	129.41	143301900.0
2021-01-04	MSFT	Stock	222.53	223.0	214.81	217.69	37130100.0
2021-01-04	NVDA	Stock	13.1042	13.6525	12.9625	13.1135	560640000.0
2021-01-04	AMZN	Stock	163.5	163.6	157.201	159.3315	88228000.0
2021-01-04	GOOGL	Stock	88.0	88.1245	85.357	86.3065	37323900.0
2021-01-04	META	Stock	274.78	275.0	265.2	268.94	15106100.0
2021-01-04	TSLA	Stock	239.82	248.1633	239.0633	243.2567	145914600.0
2021-01-04	TLT	Stock	156.67	158.18	156.535	157.54	13152865.0
2021-01-04	ES	Stock	86.66	86.93	83.95	84.51	1744300.0
2021-01-04	CL	Stock	84.78	85.56	83.53	84.33	3506000.0
2021-01-04	A	Stock	118.94	120.09	117.11	118.64	2030700.0
2021-01-04	AA	Stock	23.62	24.45	23.125	23.25	5400000.0
2021-01-04	AACG	Stock	1.17	1.22	1.17	1.18	18000.0
2021-01-04	AACQ-DELISTED	Stock	10.69	10.8	10.54	10.66	1768693.0
2021-01-04	AACQU-DELISTED	Stock	11.94	11.94	11.2	11.25	249436.0
2021-01-04	AACQW-DELISTED	Stock	2.23	2.4	2.09	2.14	341806.0
2021-01-04	AAIC-DELISTED	Stock	3.83	3.84	3.665	3.76	219985.0
2021-01-04	AAIC.C-DELISTED	Stock	20.82	20.92	20.5	20.75	1600.0
2021-01-04	AAL	Stock	15.85	15.88	15.03	15.13	69732500.0
2021-01-04	AAM.A-DELISTED	Stock	26.89	26.89	26.46	26.49	9207.0
2021-01-04	AAM.B-DELISTED	Stock	27.43	27.43	26.98	27.12	13329.0
2021-01-04	AAMC-DELISTED	Stock	7.0297	7.0297	7.0297	7.0297	2241.0
2021-01-04	AAME	Stock	2.14	2.18	2.06	2.14	298100.0
2021-01-04	AAMI	Stock	19.49	19.67	18.58	18.8	468900.0
2021-01-04	AAN-DELISTED	Stock	19.13	19.25	17.99	18.81	555600.0
2021-01-04	AAOI	Stock	8.58	8.97	8.49	8.76	782800.0
2021-01-04	AAON	Stock	44.6067	44.9	42.86	43.14	420000.0
2021-01-04	AAP	Stock	157.9	159.57	155.96	157.34	849100.0
2021-01-04	AAT	Stock	28.8	29.21	27.32	27.39	236600.0
2021-01-04	AAU-DELISTED	Stock	0.4789	0.49	0.4751	0.4885	1634985.0
2021-01-04	AAUAF-DELISTED	Stock	0.4789	0.49	0.4751	0.49	1727876.0
2021-01-04	AAWW-DELISTED	Stock	55.0	56.56	54.685	55.39	389383.0
2021-01-04	AAXJ	Stock	91.24	91.55	90.06	90.43	1163479.0
2021-01-04	AAXN-DELISTED	Stock	123.27	123.39	115.57	116.76	481851.0
2021-01-04	AB	Stock	34.0	34.0	32.84	33.25	341300.0
2021-01-04	ABB-DELISTED	Stock	28.63	28.67	28.195	28.27	2238959.0
2021-01-04	ABBNY-DELISTED	Stock	28.63	28.67	28.195	28.27	2351959.0
2021-01-04	ABBV	Stock	107.18	107.35	103.86	105.41	9523400.0
2021-01-04	ABC-DELISTED	Stock	97.85	97.95	95.07	96.5	1326315.0
2021-01-04	ABCB	Stock	38.62	38.71	37.28	38.1	488500.0
2021-01-04	ABCL	Stock	40.0	40.3	38.775	39.1	1121800.0
2021-01-04	ABCM-DELISTED	Stock	21.17	21.17	20.2026	20.46	83737.0
2021-01-04	ABEO	Stock	39.25	42.5	37.5	42.25	126016.0
2021-01-04	ABEV	Stock	3.07	3.09	2.94	2.99	27847800.0
2021-01-04	ABG	Stock	146.53	148.78	139.0	142.7	149800.0
2021-01-04	ABM	Stock	37.98	38.14	36.7	36.92	406700.0
2021-01-04	ABMD-DELISTED	Stock	324.57	329.32	308.95	317.12	227633.0
2021-01-04	ABNB	Stock	150.99	151.005	137.0	139.15	6409900.0
2021-01-04	ABR	Stock	14.23	14.24	13.54	13.82	1593900.0
2021-01-04	ABR.A-DELISTED	Stock	25.64	25.6423	25.42	25.42	1100.0

> showing 50 of 7,263 rows — these rows as CSV

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