PREVIEW / stock_daily / 2021-06-07

all stock daily files

  file:    by_date/stock_daily/2021/2021-06-07.parquet
  size:    258 KB
  rows:    7,856
  symbols: 2,928

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-07	AAPL	Stock	126.17	126.32	124.83	125.9	71057600.0
2021-06-07	MSFT	Stock	249.98	254.09	249.81	253.81	23079200.0
2021-06-07	NVDA	Stock	17.5713	17.8125	17.1928	17.619	575756000.0
2021-06-07	AMZN	Stock	159.8665	160.4	158.61	159.9005	44316000.0
2021-06-07	GOOGL	Stock	119.4718	120.2255	119.05	120.115	24119320.0
2021-06-07	META	Stock	329.48	337.69	328.93	336.58	20136700.0
2021-06-07	TSLA	Stock	197.2767	203.3333	194.2933	201.71	67631100.0
2021-06-07	TLT	Stock	139.59	139.705	139.325	139.47	7799833.0
2021-06-07	ES	Stock	82.33	82.33	81.79	82.11	891600.0
2021-06-07	CL	Stock	84.09	84.09	83.37	83.9	3211600.0
2021-06-07	A	Stock	138.09	138.58	137.37	137.65	936000.0
2021-06-07	AA	Stock	38.74	38.74	37.385	37.74	5016400.0
2021-06-07	AAC-DELISTED	Stock	9.81	9.82	9.77	9.78	1867718.0
2021-06-07	AACG	Stock	3.24	3.35	3.19	3.35	34400.0
2021-06-07	AACQ-DELISTED	Stock	9.97	9.98	9.96	9.97	1928731.0
2021-06-07	AACQU-DELISTED	Stock	10.65	10.65	10.56	10.648	1200.0
2021-06-07	AACQW-DELISTED	Stock	2.0	2.0	1.85	1.93	40366.0
2021-06-07	AAIC-DELISTED	Stock	3.96	4.12	3.95	4.12	286410.0
2021-06-07	AAIC.C-DELISTED	Stock	25.15	25.17	25.14	25.15	12882.0
2021-06-07	AAL	Stock	24.49	24.77	24.18	24.25	21173200.0
2021-06-07	AAM.A-DELISTED	Stock	26.05	26.07	25.93	26.07	23312.0
2021-06-07	AAM.B-DELISTED	Stock	27.1	27.19	27.1	27.11	9431.0
2021-06-07	AAMC-DELISTED	Stock	4.9647	4.9941	4.9206	4.9941	24942.0
2021-06-07	AAME	Stock	4.2	4.27	4.12	4.14	98700.0
2021-06-07	AAMI	Stock	22.36	22.383	22.13	22.2	286200.0
2021-06-07	AAN-DELISTED	Stock	36.59	36.6	35.99	36.37	166800.0
2021-06-07	AAOI	Stock	8.42	8.74	8.42	8.68	510200.0
2021-06-07	AAON	Stock	42.9267	43.1733	42.54	42.98	165900.0
2021-06-07	AAP	Stock	193.76	195.28	191.32	193.01	1111500.0
2021-06-07	AAQC-DELISTED	Stock	9.75	9.76	9.75	9.75	43013.0
2021-06-07	AAT	Stock	38.09	38.76	37.91	38.39	543500.0
2021-06-07	AAU-DELISTED	Stock	0.54	0.5473	0.53	0.53	582327.0
2021-06-07	AAUAF-DELISTED	Stock	0.54	0.5473	0.53	0.5323	616728.0
2021-06-07	AAWW-DELISTED	Stock	74.5	75.1	74.2501	74.42	156069.0
2021-06-07	AAXJ	Stock	95.08	95.24	94.58	95.02	720200.0
2021-06-07	AB	Stock	45.37	45.45	44.8	44.99	312800.0
2021-06-07	ABB-DELISTED	Stock	35.28	35.28	35.04	35.16	737884.0
2021-06-07	ABBNY-DELISTED	Stock	35.28	35.28	35.04	35.17	821513.0
2021-06-07	ABBV	Stock	112.71	114.11	112.33	113.01	5570100.0
2021-06-07	ABC-DELISTED	Stock	117.39	119.15	116.67	118.25	541414.0
2021-06-07	ABCB	Stock	56.39	57.38	56.3	57.19	221600.0
2021-06-07	ABCL	Stock	25.8	27.46	25.62	26.23	815200.0
2021-06-07	ABCM-DELISTED	Stock	19.28	19.6158	19.2	19.37	137522.0
2021-06-07	ABEO	Stock	43.0	45.25	42.0	43.5	83388.0
2021-06-07	ABEV	Stock	3.85	3.94	3.81	3.9	23113600.0
2021-06-07	ABG	Stock	184.0	185.25	180.14	181.82	105700.0
2021-06-07	ABGI-DELISTED	Stock	9.875	9.875	9.875	9.875	1394.0
2021-06-07	ABM	Stock	49.68	49.79	48.34	48.56	571100.0
2021-06-07	ABMD-DELISTED	Stock	290.32	298.77	286.98	291.29	132035.0
2021-06-07	ABNB	Stock	150.96	150.96	146.4	148.97	7780200.0

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

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