PREVIEW / stock_daily / 2021-06-24

all stock daily files

  file:    by_date/stock_daily/2021/2021-06-24.parquet
  size:    258 KB
  rows:    7,864
  symbols: 2,895

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-06-24	AAPL	Stock	134.45	134.64	132.93	133.41	68711000.0
2021-06-24	MSFT	Stock	266.16	267.85	265.47	266.69	21446900.0
2021-06-24	NVDA	Stock	19.2278	19.42	19.0882	19.2055	320924000.0
2021-06-24	AMZN	Stock	175.382	176.243	171.5425	172.454	76640000.0
2021-06-24	GOOGL	Stock	122.7	123.0555	122.3	122.5	21365140.0
2021-06-24	META	Stock	341.85	344.9	341.79	343.18	12329100.0
2021-06-24	TSLA	Stock	224.9967	232.54	222.5367	226.6067	137947200.0
2021-06-24	TLT	Stock	143.42	143.9	143.33	143.5	8788460.0
2021-06-24	ES	Stock	78.8	79.5	78.44	79.28	1240300.0
2021-06-24	CL	Stock	80.27	80.86	80.21	80.56	3449800.0
2021-06-24	A	Stock	147.92	148.33	146.57	146.67	1426800.0
2021-06-24	AA	Stock	35.93	36.67	35.269	36.35	6733800.0
2021-06-24	AAC-DELISTED	Stock	9.76	9.79	9.76	9.79	167936.0
2021-06-24	AACG	Stock	2.97	3.12	2.94	3.02	55600.0
2021-06-24	AACQ-DELISTED	Stock	9.84	10.735	9.8	10.03	3808237.0
2021-06-24	AACQU-DELISTED	Stock	10.67	11.05	10.67	11.05	3933.0
2021-06-24	AACQW-DELISTED	Stock	2.48	2.66	2.3	2.54	522504.0
2021-06-24	AAIC-DELISTED	Stock	3.99	4.02	3.915	4.01	332026.0
2021-06-24	AAIC.C-DELISTED	Stock	24.9001	25.0299	24.7501	24.98	7459.0
2021-06-24	AAL	Stock	22.21	22.5	21.95	22.35	22667500.0
2021-06-24	AAM.A-DELISTED	Stock	26.26	26.35	26.25	26.26	24039.0
2021-06-24	AAM.B-DELISTED	Stock	27.18	27.1948	27.11	27.14	6336.0
2021-06-24	AAMC-DELISTED	Stock	5.7794	5.7794	5.6427	5.6715	48620.0
2021-06-24	AAME	Stock	4.12	4.26	4.11	4.24	28800.0
2021-06-24	AAMI	Stock	24.06	24.06	23.59	23.82	259300.0
2021-06-24	AAN-DELISTED	Stock	33.44	33.68	32.85	33.16	289300.0
2021-06-24	AAOI	Stock	8.43	8.54	8.37	8.4	475600.0
2021-06-24	AAON	Stock	40.7933	41.2933	40.4	40.84	193950.0
2021-06-24	AAP	Stock	200.71	201.83	199.46	200.96	527200.0
2021-06-24	AAQC-DELISTED	Stock	9.67	9.73	9.67	9.67	11799.0
2021-06-24	AAT	Stock	37.67	37.83	37.15	37.38	209500.0
2021-06-24	AAU-DELISTED	Stock	0.5	0.5043	0.498	0.4996	522522.0
2021-06-24	AAUAF-DELISTED	Stock	0.5	0.5043	0.498	0.5	540610.0
2021-06-24	AAWW-DELISTED	Stock	69.24	70.08	68.92	69.59	151031.0
2021-06-24	AAXJ	Stock	93.79	94.12	93.7376	94.06	1304361.0
2021-06-24	AB	Stock	45.31	46.55	45.15	45.85	309000.0
2021-06-24	ABB-DELISTED	Stock	33.79	34.3677	33.72	34.3	1750044.0
2021-06-24	ABBNY-DELISTED	Stock	33.79	34.3677	33.72	34.3	1872907.0
2021-06-24	ABBV	Stock	114.42	116.19	114.26	114.74	7712300.0
2021-06-24	ABC-DELISTED	Stock	116.46	116.46	115.03	115.45	570998.0
2021-06-24	ABCB	Stock	51.92	53.03	51.46	52.82	276100.0
2021-06-24	ABCL	Stock	22.274	22.38	20.8	21.26	3417100.0
2021-06-24	ABCM-DELISTED	Stock	19.06	19.295	19.05	19.25	118206.0
2021-06-24	ABEO	Stock	40.5	42.25	39.75	42.25	57644.0
2021-06-24	ABEV	Stock	3.6	3.64	3.58	3.64	19728900.0
2021-06-24	ABG	Stock	163.93	164.11	159.45	161.01	155900.0
2021-06-24	ABGI-DELISTED	Stock	9.85	9.9	9.85	9.9	19582.0
2021-06-24	ABM	Stock	45.29	45.29	44.52	45.17	309500.0
2021-06-24	ABMD-DELISTED	Stock	322.3	324.54	310.85	311.55	215512.0
2021-06-24	ABNB	Stock	152.67	153.627	149.86	150.73	8173400.0

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

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