PREVIEW / stock_daily / 2021-12-02

all stock daily files

  file:    by_date/stock_daily/2021/2021-12-02.parquet
  size:    261 KB
  rows:    7,995
  symbols: 2,650

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-12-02	AAPL	Stock	158.74	164.2	157.8	163.76	136739200.0
2021-12-02	MSFT	Stock	330.3	333.49	327.8	329.49	30766000.0
2021-12-02	NVDA	Stock	31.214	32.478	31.025	32.126	472890000.0
2021-12-02	AMZN	Stock	173.0	174.635	171.1875	171.868	64726000.0
2021-12-02	GOOGL	Stock	141.25	143.8645	140.2145	142.966	29194840.0
2021-12-02	META	Stock	311.4	314.6	307.2	310.39	24396200.0
2021-12-02	TSLA	Stock	366.3533	371.0	352.2167	361.5333	73114800.0
2021-12-02	TLT	Stock	152.93	152.99	150.76	152.53	17754176.0
2021-12-02	ES	Stock	82.74	83.8	82.23	83.08	1285200.0
2021-12-02	CL	Stock	75.72	76.27	75.37	75.48	4665300.0
2021-12-02	A	Stock	147.91	152.47	147.73	150.99	1514100.0
2021-12-02	AA	Stock	44.435	45.29	43.82	44.82	5522500.0
2021-12-02	AAC-DELISTED	Stock	9.8	9.8	9.77	9.78	18167.0
2021-12-02	AACG	Stock	1.61	1.61	1.5	1.5	16500.0
2021-12-02	AACIU	Stock	10.02	10.02	10.02	10.02	100.0
2021-12-02	AACIW-DELISTED	Stock	0.52	0.52	0.495	0.5146	14300.0
2021-12-02	AAIC-DELISTED	Stock	3.58	3.69	3.58	3.68	171410.0
2021-12-02	AAL	Stock	16.49	17.44	16.15	17.42	58808900.0
2021-12-02	AAM.A-DELISTED	Stock	25.21	25.38	25.17	25.3	24661.0
2021-12-02	AAM.B-DELISTED	Stock	26.03	26.21	26.02	26.11	17807.0
2021-12-02	AAME	Stock	3.81	3.9	3.8	3.85	5000.0
2021-12-02	AAMI	Stock	30.4	30.79	30.09	30.2	8500000.0
2021-12-02	AAN-DELISTED	Stock	22.12	22.96	22.12	22.85	219400.0
2021-12-02	AAOI	Stock	5.64	5.745	5.49	5.53	549400.0
2021-12-02	AAON	Stock	51.86	53.0	51.62	52.86	331650.0
2021-12-02	AAP	Stock	220.27	230.0	219.12	228.76	838300.0
2021-12-02	AAQC-DELISTED	Stock	9.72	9.74	9.72	9.73	5976.0
2021-12-02	AAT	Stock	34.14	35.45	34.02	35.18	320900.0
2021-12-02	AATC	Stock	6.81	6.89	6.6003	6.71	17836.0
2021-12-02	AAU-DELISTED	Stock	0.3223	0.3223	0.3101	0.3152	535700.0
2021-12-02	AAUAF-DELISTED	Stock	0.3223	0.3223	0.3101	0.3151	541155.0
2021-12-02	AAWW-DELISTED	Stock	85.92	87.81	85.84	86.36	576394.0
2021-12-02	AAXJ	Stock	84.37	84.85	83.85	84.28	1413008.0
2021-12-02	AB	Stock	49.86	51.72	49.46	50.8	285900.0
2021-12-02	ABB-DELISTED	Stock	34.795	35.4	34.75	35.31	1794436.0
2021-12-02	ABBNY-DELISTED	Stock	34.795	35.4	34.75	35.3	2042628.0
2021-12-02	ABBV	Stock	116.25	117.6	115.6	116.87	4919800.0
2021-12-02	ABC-DELISTED	Stock	114.51	116.53	113.68	115.86	894839.0
2021-12-02	ABCB	Stock	48.31	50.08	48.31	49.69	261200.0
2021-12-02	ABCL	Stock	14.38	14.915	14.09	14.83	1140300.0
2021-12-02	ABCM-DELISTED	Stock	22.55	22.86	22.36	22.8	43539.0
2021-12-02	ABEO	Stock	15.75	16.25	15.0	15.25	39908.0
2021-12-02	ABEV	Stock	2.8	2.85	2.76	2.81	29560800.0
2021-12-02	ABG	Stock	162.37	171.06	161.86	167.83	357800.0
2021-12-02	ABM	Stock	44.29	45.82	44.29	45.31	569100.0
2021-12-02	ABMD-DELISTED	Stock	305.23	314.98	304.57	312.44	169594.0
2021-12-02	ABNB	Stock	161.36	170.295	160.49	169.6	5687600.0
2021-12-02	ABOS	Stock	7.55	8.47	7.52	8.13	181800.0
2021-12-02	ABR	Stock	17.4	17.79	17.21	17.67	1694600.0
2021-12-02	ABR.D	Stock	25.16	25.2	25.1	25.15	14530.0

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

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