PREVIEW / stock_daily / 2021-02-03

all stock daily files

  file:    by_date/stock_daily/2021/2021-02-03.parquet
  size:    244 KB
  rows:    7,397
  symbols: 2,714

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-02-03	AAPL	Stock	135.76	135.77	133.61	133.94	89880900.0
2021-02-03	MSFT	Stock	239.57	245.09	239.26	243.0	27158100.0
2021-02-03	NVDA	Stock	13.636	13.9318	13.5165	13.5305	245408000.0
2021-02-03	AMZN	Stock	171.2505	171.7	165.431	165.6265	141776000.0
2021-02-03	GOOGL	Stock	103.2805	105.3312	100.6775	102.944	97881640.0
2021-02-03	META	Stock	265.62	269.2	263.84	266.65	14223400.0
2021-02-03	TSLA	Stock	292.34	292.6933	284.3533	284.8967	55030500.0
2021-02-03	TLT	Stock	150.425	150.59	149.58	149.68	9633084.0
2021-02-03	ES	Stock	87.99	88.47	87.44	88.0	770700.0
2021-02-03	CL	Stock	79.0	79.41	78.53	78.88	3863600.0
2021-02-03	A	Stock	123.5	124.6	121.9	122.15	1448400.0
2021-02-03	AA	Stock	19.11	20.18	18.85	19.9	10453700.0
2021-02-03	AACG	Stock	1.41	1.41	1.35	1.36	21200.0
2021-02-03	AACQ-DELISTED	Stock	10.96	11.16	10.93	11.1263	995615.0
2021-02-03	AACQU-DELISTED	Stock	11.85	11.92	11.805	11.92	11150.0
2021-02-03	AACQW-DELISTED	Stock	2.25	2.5	2.24	2.41	290738.0
2021-02-03	AAIC-DELISTED	Stock	3.58	3.66	3.55	3.63	205521.0
2021-02-03	AAIC.C-DELISTED	Stock	21.835	21.835	21.835	21.835	297.0
2021-02-03	AAL	Stock	16.61	17.72	16.49	17.6	61414800.0
2021-02-03	AAM.A-DELISTED	Stock	26.41	26.61	26.32	26.42	20021.0
2021-02-03	AAM.B-DELISTED	Stock	27.35	27.35	27.03	27.23	14318.0
2021-02-03	AAMC-DELISTED	Stock	6.4706	6.4973	6.1824	6.4853	12430.0
2021-02-03	AAME	Stock	2.32	2.32	2.25	2.28	8400.0
2021-02-03	AAMI	Stock	19.72	20.12	19.7	20.05	416700.0
2021-02-03	AAN-DELISTED	Stock	18.37	18.554	17.89	17.99	249700.0
2021-02-03	AAOI	Stock	10.72	11.03	10.61	10.86	439800.0
2021-02-03	AAON	Stock	50.3067	51.1733	49.9933	50.36	207900.0
2021-02-03	AAP	Stock	155.11	156.33	152.14	155.28	1226900.0
2021-02-03	AAT	Stock	27.74	28.26	27.3	28.19	156400.0
2021-02-03	AAU-DELISTED	Stock	0.8	0.81	0.716	0.745	4939556.0
2021-02-03	AAUAF-DELISTED	Stock	0.8	0.81	0.716	0.745	5101927.0
2021-02-03	AAWW-DELISTED	Stock	52.4	53.62	51.66	51.67	294063.0
2021-02-03	AAXJ	Stock	98.19	98.308	97.65	98.11	1507162.0
2021-02-03	AB	Stock	37.61	37.66	36.89	37.02	677600.0
2021-02-03	ABB-DELISTED	Stock	30.46	30.64	30.385	30.56	1612710.0
2021-02-03	ABBNY-DELISTED	Stock	30.46	30.64	30.385	30.56	1778890.0
2021-02-03	ABBV	Stock	106.2	107.57	104.01	106.95	12101900.0
2021-02-03	ABC-DELISTED	Stock	105.18	106.08	103.4	105.36	906428.0
2021-02-03	ABCB	Stock	41.11	42.06	40.8	41.97	327000.0
2021-02-03	ABCL	Stock	49.72	49.97	48.15	48.55	579600.0
2021-02-03	ABCM-DELISTED	Stock	22.52	22.52	22.08	22.08	73790.0
2021-02-03	ABEO	Stock	52.0	60.5	51.5	58.5	263984.0
2021-02-03	ABEV	Stock	2.97	3.01	2.92	2.96	19115700.0
2021-02-03	ABG	Stock	145.95	147.14	138.43	146.77	189500.0
2021-02-03	ABM	Stock	38.36	38.8	37.58	38.71	248800.0
2021-02-03	ABMD-DELISTED	Stock	327.92	335.9664	321.01	326.21	557784.0
2021-02-03	ABNB	Stock	181.98	190.9	180.0	185.72	4169000.0
2021-02-03	ABR	Stock	14.85	14.99	14.73	14.77	799400.0
2021-02-03	ABR.A-DELISTED	Stock	25.93	26.0	25.9	25.98	2152.0
2021-02-03	ABR.B-DELISTED	Stock	25.6899	25.7	25.68	25.7	833.0

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

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