PREVIEW / stock_daily / 2021-03-17

all stock daily files

  file:    by_date/stock_daily/2021/2021-03-17.parquet
  size:    252 KB
  rows:    7,645
  symbols: 2,873

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-03-17	AAPL	Stock	124.05	125.86	122.34	124.76	111932600.0
2021-03-17	MSFT	Stock	236.15	238.55	233.23	237.04	29562100.0
2021-03-17	NVDA	Stock	13.0398	13.4532	12.9895	13.3412	243864000.0
2021-03-17	AMZN	Stock	153.661	158.6525	153.511	156.7865	62372000.0
2021-03-17	GOOGL	Stock	103.4235	104.95	102.2061	104.111	26382520.0
2021-03-17	META	Stock	275.71	286.23	275.41	284.01	21315000.0
2021-03-17	TSLA	Stock	218.9567	234.5767	217.0033	233.9367	121117500.0
2021-03-17	TLT	Stock	135.15	135.525	134.15	135.29	27107490.0
2021-03-17	ES	Stock	82.78	83.05	81.84	81.94	996800.0
2021-03-17	CL	Stock	76.15	76.42	75.4	75.8	3914900.0
2021-03-17	A	Stock	122.34	123.11	121.5	122.52	1453000.0
2021-03-17	AA	Stock	30.17	31.81	30.04	31.81	6861300.0
2021-03-17	AACG	Stock	4.23	4.65	4.23	4.6	294100.0
2021-03-17	AACQ-DELISTED	Stock	10.3	10.4	10.3	10.35	2043936.0
2021-03-17	AACQU-DELISTED	Stock	11.21	11.23	11.11	11.133	7100.0
2021-03-17	AACQW-DELISTED	Stock	2.13	2.24	2.06	2.22	189586.0
2021-03-17	AAIC-DELISTED	Stock	4.0	4.17	4.0	4.14	121386.0
2021-03-17	AAIC.C-DELISTED	Stock	22.54	22.55	22.3005	22.448	5310.0
2021-03-17	AAL	Stock	24.12	25.22	23.9	25.16	38540100.0
2021-03-17	AAM.A-DELISTED	Stock	25.94	25.97	25.86	25.93	20568.0
2021-03-17	AAM.B-DELISTED	Stock	26.66	26.66	26.6	26.6	8334.0
2021-03-17	AAMC-DELISTED	Stock	5.7794	5.7794	5.5	5.5853	54618.0
2021-03-17	AAME	Stock	4.18	4.29	4.06	4.26	44700.0
2021-03-17	AAMI	Stock	19.64	20.2	19.355	20.07	357600.0
2021-03-17	AAN-DELISTED	Stock	26.7	26.86	26.06	26.52	260700.0
2021-03-17	AAOI	Stock	8.74	8.85	8.565	8.77	555600.0
2021-03-17	AAON	Stock	48.36	48.68	47.7867	48.3733	266400.0
2021-03-17	AAP	Stock	180.77	183.09	178.99	181.96	1094600.0
2021-03-17	AAT	Stock	34.21	35.05	34.16	34.98	396000.0
2021-03-17	AAU-DELISTED	Stock	0.6171	0.6275	0.601	0.6235	5223325.0
2021-03-17	AAUAF-DELISTED	Stock	0.6171	0.6275	0.601	0.6235	5324436.0
2021-03-17	AAWW-DELISTED	Stock	58.21	59.62	58.05	59.22	238586.0
2021-03-17	AAXJ	Stock	93.78	95.19	93.49	94.88	534574.0
2021-03-17	AB	Stock	39.34	40.39	39.08	40.37	577000.0
2021-03-17	ABB-DELISTED	Stock	30.73	31.04	30.615	31.015	894070.0
2021-03-17	ABBNY-DELISTED	Stock	30.73	31.04	30.615	31.02	1002148.0
2021-03-17	ABBV	Stock	103.76	105.09	102.8	105.04	19445600.0
2021-03-17	ABC-DELISTED	Stock	113.5	114.63	112.7	114.06	624056.0
2021-03-17	ABCB	Stock	55.78	56.51	55.12	55.59	378000.0
2021-03-17	ABCL	Stock	36.55	36.91	34.745	36.29	445900.0
2021-03-17	ABCM-DELISTED	Stock	21.31	21.34	21.025	21.17	23243.0
2021-03-17	ABEO	Stock	55.75	59.5	55.0	57.75	62656.0
2021-03-17	ABEV	Stock	2.69	2.8	2.65	2.79	18577300.0
2021-03-17	ABG	Stock	190.21	195.64	189.34	194.26	143400.0
2021-03-17	ABGI-DELISTED	Stock	9.93	9.98	9.93	9.96	24913.0
2021-03-17	ABM	Stock	51.25	51.39	49.91	50.26	333700.0
2021-03-17	ABMD-DELISTED	Stock	305.76	308.9054	300.4753	304.66	251942.0
2021-03-17	ABNB	Stock	195.63	203.46	194.44	201.36	3781900.0
2021-03-17	ABR	Stock	16.49	16.8	16.39	16.8	711200.0
2021-03-17	ABR.A-DELISTED	Stock	25.51	25.61	25.48	25.61	2778.0

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

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