PREVIEW / stock_daily / 2021-05-24

all stock daily files

  file:    by_date/stock_daily/2021/2021-05-24.parquet
  size:    255 KB
  rows:    7,801
  symbols: 2,913

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-05-24	AAPL	Stock	126.01	127.94	125.94	127.1	63092900.0
2021-05-24	MSFT	Stock	247.79	251.16	247.51	250.78	21411500.0
2021-05-24	NVDA	Stock	15.2125	15.745	15.176	15.612	554816000.0
2021-05-24	AMZN	Stock	160.775	162.8975	160.525	162.2495	48456000.0
2021-05-24	GOOGL	Stock	115.7445	118.2775	115.5978	118.052	31832200.0
2021-05-24	META	Stock	318.21	325.95	318.03	324.63	16445400.0
2021-05-24	TSLA	Stock	193.8667	204.8267	191.2167	202.1467	103674300.0
2021-05-24	TLT	Stock	137.99	138.58	137.89	138.18	6736459.0
2021-05-24	ES	Stock	84.34	84.6	83.25	83.3	1528200.0
2021-05-24	CL	Stock	84.44	84.91	84.1	84.4	3196200.0
2021-05-24	A	Stock	133.51	134.41	132.53	133.34	1312300.0
2021-05-24	AA	Stock	36.11	36.79	35.4	36.5	5462000.0
2021-05-24	AAC-DELISTED	Stock	9.76	9.82	9.76	9.79	33656.0
2021-05-24	AACG	Stock	2.92	3.05	2.77	2.77	57800.0
2021-05-24	AACQ-DELISTED	Stock	9.9	9.93	9.85	9.92	953320.0
2021-05-24	AACQU-DELISTED	Stock	10.32	10.6399	10.31	10.42	1324.0
2021-05-24	AACQW-DELISTED	Stock	1.52	1.68	1.52	1.64	78028.0
2021-05-24	AAIC-DELISTED	Stock	4.09	4.1	4.05	4.09	112685.0
2021-05-24	AAIC.C-DELISTED	Stock	24.8	24.9928	24.8	24.95	8520.0
2021-05-24	AAL	Stock	22.85	23.05	22.35	22.99	26159300.0
2021-05-24	AAM.A-DELISTED	Stock	26.26	26.295	26.1948	26.29	7194.0
2021-05-24	AAM.B-DELISTED	Stock	27.1	27.16	27.06	27.16	7544.0
2021-05-24	AAMC-DELISTED	Stock	4.9176	5.1941	4.8941	5.0171	16691.0
2021-05-24	AAME	Stock	4.38	4.38	4.12	4.16	57900.0
2021-05-24	AAMI	Stock	22.61	22.9	21.915	22.69	381600.0
2021-05-24	AAN-DELISTED	Stock	34.7	34.962	33.9	34.59	246300.0
2021-05-24	AAOI	Stock	8.1	8.16	7.825	7.85	581100.0
2021-05-24	AAON	Stock	44.6667	44.78	44.14	44.24	232350.0
2021-05-24	AAP	Stock	194.92	194.93	190.51	190.65	1085500.0
2021-05-24	AAQC-DELISTED	Stock	9.66	9.68	9.65	9.65	22005.0
2021-05-24	AAT	Stock	35.06	35.98	35.06	35.74	234500.0
2021-05-24	AAU-DELISTED	Stock	0.535	0.5598	0.535	0.5587	482392.0
2021-05-24	AAUAF-DELISTED	Stock	0.535	0.5598	0.535	0.5598	516017.0
2021-05-24	AAWW-DELISTED	Stock	74.4	74.75	73.25	74.105	300512.0
2021-05-24	AAXJ	Stock	91.76	92.245	91.55	92.02	631580.0
2021-05-24	AB	Stock	44.5	44.77	44.25	44.33	300400.0
2021-05-24	ABB-DELISTED	Stock	33.54	33.83	33.5	33.75	842015.0
2021-05-24	ABBNY-DELISTED	Stock	33.54	33.83	33.5	33.75	929419.0
2021-05-24	ABBV	Stock	116.59	116.81	115.59	115.91	4821300.0
2021-05-24	ABC-DELISTED	Stock	120.48	120.81	118.38	118.57	452604.0
2021-05-24	ABCB	Stock	59.51	59.85	56.06	56.11	627500.0
2021-05-24	ABCL	Stock	31.84	33.229	31.84	32.62	343600.0
2021-05-24	ABCM-DELISTED	Stock	19.85	20.03	19.76	19.76	29181.0
2021-05-24	ABEO	Stock	39.25	40.5	38.25	38.75	29940.0
2021-05-24	ABEV	Stock	3.32	3.35	3.3	3.33	20971800.0
2021-05-24	ABG	Stock	198.65	199.81	196.43	197.11	113300.0
2021-05-24	ABGI-DELISTED	Stock	9.885	9.96	9.885	9.9	143960.0
2021-05-24	ABM	Stock	49.99	50.05	49.47	49.58	395700.0
2021-05-24	ABMD-DELISTED	Stock	282.65	283.09	279.52	279.87	103870.0
2021-05-24	ABNB	Stock	135.5	137.98	134.39	135.91	8543600.0

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

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