PREVIEW / stock_daily / 2022-04-27

all stock daily files

  file:    by_date/stock_daily/2022/2022-04-27.parquet
  size:    260 KB
  rows:    8,090
  symbols: 2,506

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-04-27	AAPL	Stock	155.91	159.79	155.38	156.57	88063200.0
2022-04-27	MSFT	Stock	282.1	290.97	279.16	283.22	63477700.0
2022-04-27	NVDA	Stock	18.598	19.167	18.29	18.415	499460000.0
2022-04-27	AMZN	Stock	140.1915	141.9485	135.7835	138.167	71336000.0
2022-04-27	GOOGL	Stock	114.4693	117.242	112.7365	114.2945	91820580.0
2022-04-27	META	Stock	174.43	181.21	169.0	174.95	71062900.0
2022-04-27	TSLA	Stock	299.5267	306.0	292.4533	293.8367	76956300.0
2022-04-27	TLT	Stock	122.19	122.32	120.77	120.84	14560521.0
2022-04-27	ES	Stock	89.81	90.81	88.84	89.51	1065800.0
2022-04-27	CL	Stock	80.28	81.7	80.2	80.69	4415500.0
2022-04-27	A	Stock	118.2	120.85	117.53	117.68	2007500.0
2022-04-27	AA	Stock	68.265	71.54	67.54	69.99	8631100.0
2022-04-27	AAC-DELISTED	Stock	9.85	9.85	9.84	9.84	872975.0
2022-04-27	AACG	Stock	1.16	1.19	1.15	1.15	9900.0
2022-04-27	AACIU	Stock	10.02	10.02	10.01	10.02	886.0
2022-04-27	AACIW-DELISTED	Stock	0.335	0.4001	0.2899	0.4	17518.0
2022-04-27	AAIC-DELISTED	Stock	3.22	3.22	3.15	3.18	113899.0
2022-04-27	AAIC.C-DELISTED	Stock	24.55	24.58	24.5	24.5	11381.0
2022-04-27	AAL	Stock	18.68	19.18	18.47	18.97	31101300.0
2022-04-27	AAM.A-DELISTED	Stock	24.9	24.98	24.06	24.36	31338.0
2022-04-27	AAM.B-DELISTED	Stock	25.07	25.18	24.85	24.89	32001.0
2022-04-27	AAMC-DELISTED	Stock	3.0176	3.0713	2.9324	2.9565	42269.0
2022-04-27	AAME	Stock	3.02	3.14	2.99	3.13	7700.0
2022-04-27	AAMI	Stock	20.67	20.9	20.26	20.36	440700.0
2022-04-27	AAN-DELISTED	Stock	19.96	20.45	19.3	19.51	367600.0
2022-04-27	AAOI	Stock	2.68	2.68	2.48	2.5	489300.0
2022-04-27	AAON	Stock	33.9733	34.4467	32.6133	32.6667	395250.0
2022-04-27	AAP	Stock	224.46	227.74	223.28	224.88	1127100.0
2022-04-27	AAQC-DELISTED	Stock	9.785	9.785	9.78	9.78	3052.0
2022-04-27	AAT	Stock	35.71	37.55	35.39	37.21	543600.0
2022-04-27	AATC	Stock	6.66	6.745	6.52	6.5699	10663.0
2022-04-27	AAU-DELISTED	Stock	0.29	0.31	0.285	0.3076	709221.0
2022-04-27	AAUAF-DELISTED	Stock	0.29	0.31	0.285	0.3076	714463.0
2022-04-27	AAWW-DELISTED	Stock	67.55	68.3733	66.8	67.61	357577.0
2022-04-27	AAXJ	Stock	69.08	69.86	69.01	69.39	3154988.0
2022-04-27	AB	Stock	39.49	40.29	39.24	39.61	447800.0
2022-04-27	ABB-DELISTED	Stock	29.62	29.98	29.48	29.67	2563202.0
2022-04-27	ABBNY-DELISTED	Stock	29.62	29.98	29.48	29.66	2806725.0
2022-04-27	ABBV	Stock	156.56	159.5	154.56	157.62	6039100.0
2022-04-27	ABC-DELISTED	Stock	157.4	159.24	155.38	157.47	680405.0
2022-04-27	ABCB	Stock	40.44	43.04	39.97	42.11	1243700.0
2022-04-27	ABCL	Stock	7.7	7.84	7.43	7.76	991600.0
2022-04-27	ABCM-DELISTED	Stock	15.88	16.0	15.43	15.45	103114.0
2022-04-27	ABEO	Stock	5.75	5.75	5.5	5.5	63536.0
2022-04-27	ABEV	Stock	2.91	2.95	2.89	2.92	25964100.0
2022-04-27	ABG	Stock	160.24	162.4	155.2	158.18	255200.0
2022-04-27	ABGI-DELISTED	Stock	9.83	9.83	9.81	9.81	34841.0
2022-04-27	ABM	Stock	48.02	49.21	47.35	48.31	554000.0
2022-04-27	ABMD-DELISTED	Stock	284.98	288.77	275.855	277.42	207300.0
2022-04-27	ABNB	Stock	153.82	157.3	150.44	152.23	4826000.0

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

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