PREVIEW / stock_daily / 2020-06-03

all stock daily files

  file:    by_date/stock_daily/2020/2020-06-03.parquet
  size:    220 KB
  rows:    6,657
  symbols: 2,362

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
2020-06-03	AAPL	Stock	81.165	81.55	80.575	81.28	104491200.0
2020-06-03	MSFT	Stock	184.82	185.94	183.58	185.36	27311000.0
2020-06-03	NVDA	Stock	8.8222	8.8662	8.7	8.7695	365440000.0
2020-06-03	AMZN	Stock	123.4005	124.4	123.0585	123.92	53420000.0
2020-06-03	GOOGL	Stock	72.135	72.4505	71.581	71.9625	27732800.0
2020-06-03	META	Stock	232.11	232.65	228.53	230.16	15380300.0
2020-06-03	TSLA	Stock	59.208	59.8627	58.6733	58.864	119242500.0
2020-06-03	TLT	Stock	160.18	160.33	158.94	159.54	12255736.0
2020-06-03	ES	Stock	86.36	88.27	86.01	86.92	1571600.0
2020-06-03	CL	Stock	72.9	72.9	71.61	71.65	4535700.0
2020-06-03	A	Stock	90.65	91.14	90.26	90.49	1382500.0
2020-06-03	AA	Stock	10.2	10.89	10.085	10.77	8568700.0
2020-06-03	AACG	Stock	0.84	0.96	0.84	0.91	6600.0
2020-06-03	AAIC-DELISTED	Stock	2.52	2.66	2.5001	2.55	718174.0
2020-06-03	AAIC.C-DELISTED	Stock	18.23	18.23	18.0	18.05	4017.0
2020-06-03	AAL	Stock	11.56	12.2	11.44	11.85	86685300.0
2020-06-03	AAM.A-DELISTED	Stock	26.435	26.59	25.97	25.99	40062.0
2020-06-03	AAM.B-DELISTED	Stock	26.51	26.705	26.2	26.25	33402.0
2020-06-03	AAMC-DELISTED	Stock	5.1441	5.4648	5.075	5.3529	20012.0
2020-06-03	AAME	Stock	1.81	1.81	1.73	1.73	2500.0
2020-06-03	AAMI	Stock	8.94	9.44	8.94	9.35	252600.0
2020-06-03	AAOI	Stock	9.11	9.57	9.11	9.54	661900.0
2020-06-03	AAON	Stock	36.4867	37.2733	36.4867	36.92	320700.0
2020-06-03	AAP	Stock	139.76	144.63	139.76	142.32	519300.0
2020-06-03	AAT	Stock	27.62	29.64	27.59	29.42	681500.0
2020-06-03	AAU-DELISTED	Stock	0.475	0.477	0.45	0.4548	375760.0
2020-06-03	AAUAF-DELISTED	Stock	0.475	0.477	0.45	0.4548	388771.0
2020-06-03	AAWW-DELISTED	Stock	45.1	46.54	45.05	45.74	474496.0
2020-06-03	AAXJ	Stock	68.43	69.18	68.37	69.08	2134175.0
2020-06-03	AAXN-DELISTED	Stock	97.48	97.96	90.32	91.24	1618469.0
2020-06-03	AB	Stock	26.6	27.1	26.25	26.33	466500.0
2020-06-03	ABB-DELISTED	Stock	21.14	21.54	21.115	21.47	2746935.0
2020-06-03	ABBNY-DELISTED	Stock	21.14	21.54	21.115	21.47	2911045.0
2020-06-03	ABBV	Stock	91.47	91.5	89.6	90.89	8588400.0
2020-06-03	ABC-DELISTED	Stock	99.08	99.99	98.65	99.5	928766.0
2020-06-03	ABCB	Stock	24.6	26.51	24.35	25.67	429000.0
2020-06-03	ABEO	Stock	76.75	77.5	73.0	73.25	51100.0
2020-06-03	ABEV	Stock	2.65	2.74	2.63	2.66	36377900.0
2020-06-03	ABG	Stock	75.98	80.16	75.98	78.89	273200.0
2020-06-03	ABM	Stock	32.78	33.46	32.29	33.34	591900.0
2020-06-03	ABMD-DELISTED	Stock	233.79	242.67	230.66	237.7	437674.0
2020-06-03	ABR	Stock	8.95	9.43	8.79	9.24	4125800.0
2020-06-03	ABR.A-DELISTED	Stock	24.9	24.99	24.57	24.9899	4755.0
2020-06-03	ABR.B-DELISTED	Stock	23.42	23.6716	23.42	23.4813	1150.0
2020-06-03	ABR.C-DELISTED	Stock	24.69	25.285	24.69	24.98	5750.0
2020-06-03	ABT	Stock	92.56	92.7	90.56	91.4	8056300.0
2020-06-03	ABTC	Stock	281400.0	288300.0	275100.0	279000.0	1.0266666666666666
2020-06-03	ABTS	Stock	9.15	13.95	8.88	13.5	9133.0
2020-06-03	ABTX-DELISTED	Stock	26.07	26.96	25.845	26.47	43261.0
2020-06-03	ABUS	Stock	2.09	2.19	2.02	2.06	1310800.0

> showing 50 of 6,657 rows — these rows as CSV

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