PREVIEW / stock_daily / 2021-11-18

all stock daily files

  file:    by_date/stock_daily/2021/2021-11-18.parquet
  size:    263 KB
  rows:    8,023
  symbols: 2,684

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-11-18	AAPL	Stock	153.71	158.67	153.05	157.87	137827700.0
2021-11-18	MSFT	Stock	338.18	342.45	337.12	341.27	22463500.0
2021-11-18	NVDA	Stock	32.367	32.76	31.321	31.675	781711000.0
2021-11-18	AMZN	Stock	178.3175	185.21	178.05	184.803	114070000.0
2021-11-18	GOOGL	Stock	148.2415	150.5805	147.8845	149.8385	35628220.0
2021-11-18	META	Stock	339.72	342.46	335.3	338.69	17487200.0
2021-11-18	TSLA	Stock	368.85	370.6667	358.34	365.46	62696700.0
2021-11-18	TLT	Stock	145.9917	146.9	145.95	146.81	11055620.0
2021-11-18	ES	Stock	83.77	83.85	82.91	83.21	888100.0
2021-11-18	CL	Stock	77.49	77.55	76.17	76.39	3416600.0
2021-11-18	A	Stock	162.53	162.82	160.4	162.16	1475800.0
2021-11-18	AA	Stock	47.55	47.83	46.49	47.7	4351900.0
2021-11-18	AAC-DELISTED	Stock	9.82	9.85	9.81	9.82	523351.0
2021-11-18	AACG	Stock	2.05	2.12	1.85	1.94	36600.0
2021-11-18	AACIU	Stock	10.02	10.04	10.0	10.01	27307.0
2021-11-18	AACIW-DELISTED	Stock	0.52	0.52	0.5	0.5	5750.0
2021-11-18	AAIC-DELISTED	Stock	3.73	3.7714	3.7022	3.72	137237.0
2021-11-18	AAIC.C-DELISTED	Stock	25.705	25.705	25.705	25.705	200.0
2021-11-18	AAL	Stock	19.87	19.93	19.14	19.39	31051900.0
2021-11-18	AAM.A-DELISTED	Stock	25.77	25.79	25.73	25.73	14480.0
2021-11-18	AAM.B-DELISTED	Stock	26.8	26.8	26.55	26.71	9521.0
2021-11-18	AAMC-DELISTED	Stock	7.0147	7.3382	6.6206	6.6206	52962.0
2021-11-18	AAME	Stock	4.25	4.3	4.01	4.09	15800.0
2021-11-18	AAMI	Stock	30.37	30.49	30.17	30.46	1233400.0
2021-11-18	AAN-DELISTED	Stock	24.98	25.68	24.82	25.65	209400.0
2021-11-18	AAOI	Stock	6.01	6.14	5.89	6.03	779900.0
2021-11-18	AAON	Stock	50.8333	51.5867	50.4933	51.06	303750.0
2021-11-18	AAP	Stock	232.55	233.17	229.0	231.92	663600.0
2021-11-18	AAQC-DELISTED	Stock	9.75	9.77	9.75	9.77	699.0
2021-11-18	AAT	Stock	38.13	38.34	37.59	37.88	252500.0
2021-11-18	AATC	Stock	7.0113	7.1	6.9001	7.08	42898.0
2021-11-18	AAU-DELISTED	Stock	0.3769	0.381	0.365	0.3719	889852.0
2021-11-18	AAUAF-DELISTED	Stock	0.3769	0.381	0.365	0.3719	897191.0
2021-11-18	AAWW-DELISTED	Stock	88.91	89.99	88.19	89.7	321502.0
2021-11-18	AAXJ	Stock	86.68	86.82	86.17	86.6	946908.0
2021-11-18	AB	Stock	55.35	55.57	54.51	54.8	128500.0
2021-11-18	ABB-DELISTED	Stock	35.65	35.7	35.52	35.69	634195.0
2021-11-18	ABBNY-DELISTED	Stock	35.65	35.7	35.52	35.69	730121.0
2021-11-18	ABBV	Stock	117.41	118.37	116.64	117.07	3160300.0
2021-11-18	ABC-DELISTED	Stock	125.03	125.03	123.73	124.5	348365.0
2021-11-18	ABCB	Stock	52.41	52.86	51.68	52.48	296800.0
2021-11-18	ABCL	Stock	15.0	15.31	14.75	15.31	1442200.0
2021-11-18	ABCM-DELISTED	Stock	22.93	23.0784	22.695	22.95	25585.0
2021-11-18	ABEO	Stock	21.5	21.75	18.25	19.25	73172.0
2021-11-18	ABEV	Stock	3.12	3.13	3.08	3.11	28694100.0
2021-11-18	ABG	Stock	166.49	170.05	162.5	169.23	480000.0
2021-11-18	ABGI-DELISTED	Stock	9.82	9.82	9.76	9.76	1354.0
2021-11-18	ABM	Stock	47.8	47.8	46.86	46.91	251900.0
2021-11-18	ABMD-DELISTED	Stock	345.43	346.66	335.27	339.91	86803.0
2021-11-18	ABNB	Stock	199.34	205.0	196.0	204.33	4597700.0

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

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