PREVIEW / stock_daily / 2021-10-18

all stock daily files

  file:    by_date/stock_daily/2021/2021-10-18.parquet
  size:    258 KB
  rows:    7,871
  symbols: 2,639

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-10-18	AAPL	Stock	143.45	146.84	143.16	146.55	85589200.0
2021-10-18	MSFT	Stock	303.57	308.21	302.69	307.29	22729300.0
2021-10-18	NVDA	Stock	21.749	22.291	21.644	22.222	189494000.0
2021-10-18	AMZN	Stock	169.418	172.4585	169.255	172.337	63482000.0
2021-10-18	GOOGL	Stock	141.0765	142.796	141.0695	142.778	20396160.0
2021-10-18	META	Stock	328.95	335.89	327.5	335.34	21585000.0
2021-10-18	TSLA	Stock	283.93	291.7533	283.8233	290.0367	72621600.0
2021-10-18	TLT	Stock	145.0	146.0	144.52	145.71	12115879.0
2021-10-18	ES	Stock	85.71	85.88	84.98	85.41	1168700.0
2021-10-18	CL	Stock	75.93	76.01	75.17	75.28	4331000.0
2021-10-18	A	Stock	153.63	155.42	152.39	154.78	1183600.0
2021-10-18	AA	Stock	54.99	57.57	54.96	57.24	9883800.0
2021-10-18	AAC-DELISTED	Stock	9.76	9.77	9.75	9.76	77885.0
2021-10-18	AACG	Stock	2.45	2.5	2.34	2.39	22800.0
2021-10-18	AAIC-DELISTED	Stock	3.93	3.99	3.9	3.945	116938.0
2021-10-18	AAIC.C-DELISTED	Stock	25.1001	25.25	25.1001	25.15	1269.0
2021-10-18	AAL	Stock	19.92	20.15	19.74	19.84	20604400.0
2021-10-18	AAM.A-DELISTED	Stock	25.93	26.07	25.86	25.98	41805.0
2021-10-18	AAM.B-DELISTED	Stock	26.98	27.11	26.88	27.05	35079.0
2021-10-18	AAMC-DELISTED	Stock	7.0882	7.1803	6.8441	7.0471	36380.0
2021-10-18	AAME	Stock	4.16	4.37	4.16	4.25	20300.0
2021-10-18	AAMI	Stock	26.45	26.68	26.45	26.52	324600.0
2021-10-18	AAN-DELISTED	Stock	27.48	28.57	27.41	28.28	147700.0
2021-10-18	AAOI	Stock	7.17	7.28	7.1	7.16	210000.0
2021-10-18	AAON	Stock	46.3333	47.3333	46.0933	47.2333	76950.0
2021-10-18	AAP	Stock	216.3	223.52	215.69	222.52	778800.0
2021-10-18	AAQC-DELISTED	Stock	9.72	9.73	9.71	9.72	1324.0
2021-10-18	AAT	Stock	39.37	39.77	39.14	39.32	165400.0
2021-10-18	AATC	Stock	6.91	7.11	6.91	7.09	10454.0
2021-10-18	AAU-DELISTED	Stock	0.39	0.39	0.3836	0.384	288978.0
2021-10-18	AAUAF-DELISTED	Stock	0.39	0.39	0.3836	0.3841	300793.0
2021-10-18	AAWW-DELISTED	Stock	78.41	79.89	78.33	79.04	173480.0
2021-10-18	AAXJ	Stock	86.84	87.51	86.81	87.26	452122.0
2021-10-18	AB	Stock	52.16	52.58	51.91	52.31	130300.0
2021-10-18	ABB-DELISTED	Stock	34.12	34.27	34.01	34.24	1194061.0
2021-10-18	ABBNY-DELISTED	Stock	34.12	34.27	34.01	34.24	1321298.0
2021-10-18	ABBV	Stock	108.99	108.99	107.09	107.43	7949400.0
2021-10-18	ABC-DELISTED	Stock	119.1	119.93	117.8	118.37	431333.0
2021-10-18	ABCB	Stock	51.87	52.67	51.53	51.63	213400.0
2021-10-18	ABCL	Stock	15.42	15.75	15.17	15.28	1075800.0
2021-10-18	ABCM-DELISTED	Stock	21.72	22.15	21.69	21.78	64135.0
2021-10-18	ABEO	Stock	23.0	23.25	22.0	22.25	39604.0
2021-10-18	ABEV	Stock	2.74	2.8	2.72	2.79	15838600.0
2021-10-18	ABG	Stock	210.6	212.43	209.44	212.1	125500.0
2021-10-18	ABGI-DELISTED	Stock	9.725	9.725	9.725	9.725	245.0
2021-10-18	ABM	Stock	44.94	45.27	44.5	44.84	238600.0
2021-10-18	ABMD-DELISTED	Stock	348.8	355.48	348.24	350.83	115729.0
2021-10-18	ABNB	Stock	167.5	172.7	167.11	172.32	2793700.0
2021-10-18	ABOS	Stock	13.58	13.58	12.84	13.46	67300.0
2021-10-18	ABR	Stock	19.15	19.65	19.15	19.58	1234400.0

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

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