PREVIEW / stock_daily / 2022-01-12

all stock daily files

  file:    by_date/stock_daily/2022/2022-01-12.parquet
  size:    261 KB
  rows:    8,013
  symbols: 2,570

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-12	AAPL	Stock	176.12	177.18	174.82	175.53	74805200.0
2022-01-12	MSFT	Stock	319.67	323.41	317.08	318.27	34372200.0
2022-01-12	NVDA	Stock	28.067	28.595	27.608	27.999	383413000.0
2022-01-12	AMZN	Stock	166.575	166.878	164.417	165.207	50030000.0
2022-01-12	GOOGL	Stock	141.15	142.6078	140.6945	141.4305	26112040.0
2022-01-12	META	Stock	335.18	336.37	330.03	333.26	14104900.0
2022-01-12	TSLA	Stock	359.6167	371.6133	357.53	368.74	83739000.0
2022-01-12	TLT	Stock	143.9	144.01	142.995	143.01	14440646.0
2022-01-12	ES	Stock	86.21	87.72	85.73	87.49	1558200.0
2022-01-12	CL	Stock	83.02	83.32	82.55	82.87	5112700.0
2022-01-12	A	Stock	147.8	150.39	147.55	149.51	2250800.0
2022-01-12	AA	Stock	63.66	64.37	60.86	61.88	6435000.0
2022-01-12	AAC-DELISTED	Stock	9.76	9.77	9.76	9.76	8230.0
2022-01-12	AACG	Stock	2.29	2.29	1.95	2.01	516800.0
2022-01-12	AACIW-DELISTED	Stock	0.5799	0.6089	0.5102	0.5104	11383.0
2022-01-12	AAIC-DELISTED	Stock	3.62	3.62	3.6	3.6	64222.0
2022-01-12	AAIC.C-DELISTED	Stock	25.2	25.27	25.0624	25.25	4011.0
2022-01-12	AAL	Stock	19.16	19.26	18.35	18.5	41140900.0
2022-01-12	AAM.A-DELISTED	Stock	25.39	25.53	25.36	25.4	22537.0
2022-01-12	AAM.B-DELISTED	Stock	26.31	26.45	26.26	26.26	14496.0
2022-01-12	AAME	Stock	2.86	2.9	2.7	2.74	13000.0
2022-01-12	AAMI	Stock	24.59	24.96	24.23	24.53	525800.0
2022-01-12	AAN-DELISTED	Stock	23.06	23.344	22.715	22.87	197600.0
2022-01-12	AAOI	Stock	4.47	4.57	4.41	4.42	530900.0
2022-01-12	AAON	Stock	49.54	50.08	48.3	48.62	523500.0
2022-01-12	AAP	Stock	233.56	238.04	233.26	237.53	517300.0
2022-01-12	AAQC-DELISTED	Stock	9.72	9.725	9.72	9.72	23000.0
2022-01-12	AAT	Stock	38.34	38.57	37.95	37.99	122900.0
2022-01-12	AATC	Stock	6.37	6.3745	6.25	6.25	8096.0
2022-01-12	AAU-DELISTED	Stock	0.29	0.2998	0.2841	0.2952	389840.0
2022-01-12	AAUAF-DELISTED	Stock	0.29	0.2998	0.2841	0.2977	399124.0
2022-01-12	AAWW-DELISTED	Stock	87.5	88.7	85.9086	85.95	232140.0
2022-01-12	AAXJ	Stock	85.39	85.72	85.04	85.6	4308734.0
2022-01-12	AB	Stock	52.05	52.52	50.78	51.17	273400.0
2022-01-12	ABB-DELISTED	Stock	38.32	38.6399	38.3	38.6	1329984.0
2022-01-12	ABBNY-DELISTED	Stock	38.32	38.6399	38.3	38.61	1520441.0
2022-01-12	ABBV	Stock	136.52	137.39	136.03	137.29	6589300.0
2022-01-12	ABC-DELISTED	Stock	135.84	135.87	133.83	135.72	663031.0
2022-01-12	ABCB	Stock	54.0	54.27	52.88	54.15	464700.0
2022-01-12	ABCL	Stock	12.3	12.345	11.63	11.67	1205000.0
2022-01-12	ABCM-DELISTED	Stock	20.05	20.18	19.61	19.84	315313.0
2022-01-12	ABEO	Stock	8.0	8.0	7.25	7.25	154684.0
2022-01-12	ABEV	Stock	2.67	2.72	2.66	2.69	28516300.0
2022-01-12	ABG	Stock	175.16	175.83	163.55	166.74	429700.0
2022-01-12	ABM	Stock	42.97	44.02	42.97	43.58	722800.0
2022-01-12	ABMD-DELISTED	Stock	319.59	324.095	310.06	315.43	172300.0
2022-01-12	ABNB	Stock	170.24	171.04	165.11	169.54	3534300.0
2022-01-12	ABOS	Stock	5.965	5.965	5.25	5.26	70500.0
2022-01-12	ABR	Stock	18.83	18.86	18.61	18.7	1429700.0
2022-01-12	ABR.D	Stock	25.385	25.48	25.37	25.48	11758.0

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

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