PREVIEW / stock_daily / 2022-01-03

all stock daily files

  file:    by_date/stock_daily/2022/2022-01-03.parquet
  size:    263 KB
  rows:    8,075
  symbols: 2,630

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-03	AAPL	Stock	177.83	182.88	177.71	182.01	104487900.0
2022-01-03	MSFT	Stock	335.35	338.0	329.78	334.75	28865100.0
2022-01-03	NVDA	Stock	29.815	30.711	29.785	30.121	391547000.0
2022-01-03	AMZN	Stock	167.55	170.7035	166.1605	170.4045	63520000.0
2022-01-03	GOOGL	Stock	145.055	145.851	143.7128	144.9915	28678940.0
2022-01-03	META	Stock	338.3	341.08	337.19	338.54	14537900.0
2022-01-03	TSLA	Stock	382.5833	400.3567	378.68	399.9267	103931400.0
2022-01-03	TLT	Stock	146.41	146.94	144.28	144.3	33860382.0
2022-01-03	ES	Stock	90.68	90.85	88.38	89.13	1484600.0
2022-01-03	CL	Stock	84.55	84.8	83.49	84.59	5327000.0
2022-01-03	A	Stock	159.0	159.44	153.93	156.48	1606300.0
2022-01-03	AA	Stock	60.24	62.61	60.09	60.36	6206700.0
2022-01-03	AAC-DELISTED	Stock	9.75	9.77	9.75	9.76	203144.0
2022-01-03	AACG	Stock	1.17	1.31	1.15	1.19	127700.0
2022-01-03	AACIU	Stock	10.1	10.15	10.1	10.15	1208.0
2022-01-03	AACIW-DELISTED	Stock	0.5596	0.5596	0.55	0.55	9090.0
2022-01-03	AAIC-DELISTED	Stock	3.5	3.59	3.5	3.56	56230.0
2022-01-03	AAIC.C-DELISTED	Stock	25.264	25.264	25.264	25.264	1976.0
2022-01-03	AAL	Stock	18.23	19.18	18.2	18.75	42781000.0
2022-01-03	AAM.A-DELISTED	Stock	25.44	25.496	25.43	25.496	1741.0
2022-01-03	AAM.B-DELISTED	Stock	26.47	26.73	26.47	26.72	2303.0
2022-01-03	AAME	Stock	2.53	2.81	2.51	2.69	33100.0
2022-01-03	AAMI	Stock	25.83	26.0	25.25	25.38	683200.0
2022-01-03	AAN-DELISTED	Stock	24.81	25.72	24.78	25.15	138200.0
2022-01-03	AAOI	Stock	5.2	5.305	5.08	5.27	478600.0
2022-01-03	AAON	Stock	52.8267	52.8267	51.4867	52.22	460050.0
2022-01-03	AAP	Stock	240.64	242.15	234.87	236.78	899800.0
2022-01-03	AAQC-DELISTED	Stock	9.71	9.71	9.71	9.71	178.0
2022-01-03	AAT	Stock	37.59	38.1	37.35	37.66	187100.0
2022-01-03	AATC	Stock	6.24	6.4	6.23	6.29	6428.0
2022-01-03	AAU-DELISTED	Stock	0.293	0.31	0.293	0.305	384963.0
2022-01-03	AAUAF-DELISTED	Stock	0.293	0.31	0.293	0.305	392723.0
2022-01-03	AAWW-DELISTED	Stock	94.79	96.3	94.21	94.83	360147.0
2022-01-03	AAXJ	Stock	83.13	83.36	82.53	83.29	629877.0
2022-01-03	AB	Stock	49.01	49.73	48.6	48.72	245900.0
2022-01-03	ABB-DELISTED	Stock	38.62	38.66	38.255	38.46	1628618.0
2022-01-03	ABBNY-DELISTED	Stock	38.62	38.66	38.255	38.47	1926787.0
2022-01-03	ABBV	Stock	135.41	135.7	133.51	135.42	6839800.0
2022-01-03	ABC-DELISTED	Stock	132.58	132.92	130.87	132.65	727499.0
2022-01-03	ABCB	Stock	50.04	51.56	49.84	51.42	903500.0
2022-01-03	ABCL	Stock	14.47	14.79	13.93	14.14	1022500.0
2022-01-03	ABCM-DELISTED	Stock	23.66	24.0	23.43	23.95	37358.0
2022-01-03	ABEO	Stock	8.75	9.5	8.5	9.25	248328.0
2022-01-03	ABEV	Stock	2.72	2.72	2.68	2.72	23986500.0
2022-01-03	ABG	Stock	173.45	177.36	171.45	174.16	385500.0
2022-01-03	ABGI-DELISTED	Stock	9.77	9.79	9.77	9.79	7657.0
2022-01-03	ABM	Stock	40.89	41.48	40.42	40.88	585500.0
2022-01-03	ABMD-DELISTED	Stock	358.0	366.32	353.32	366.32	139638.0
2022-01-03	ABNB	Stock	165.297	172.84	165.22	172.68	4224900.0
2022-01-03	ABOS	Stock	6.86	7.035	6.525	6.73	329500.0

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

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