PREVIEW / stock_daily / 2021-07-02

all stock daily files

  file:    by_date/stock_daily/2021/2021-07-02.parquet
  size:    258 KB
  rows:    7,869
  symbols: 2,858

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-07-02	AAPL	Stock	137.9	140.0	137.75	139.96	78852600.0
2021-07-02	MSFT	Stock	272.82	278.0	272.5	277.65	26458000.0
2021-07-02	NVDA	Stock	20.4403	20.5053	20.2878	20.487	342764000.0
2021-07-02	AMZN	Stock	172.582	175.586	171.846	175.549	63388000.0
2021-07-02	GOOGL	Stock	123.15	125.404	123.0595	125.2575	26002180.0
2021-07-02	META	Stock	355.1	356.44	352.62	354.7	11521300.0
2021-07-02	TSLA	Stock	226.3267	233.3333	224.42	226.3	81163500.0
2021-07-02	TLT	Stock	144.23	145.04	144.11	145.04	9650170.0
2021-07-02	ES	Stock	80.34	80.89	79.79	80.7	1071900.0
2021-07-02	CL	Stock	81.92	82.12	81.59	81.7	2752200.0
2021-07-02	A	Stock	148.11	148.89	147.25	148.82	1400700.0
2021-07-02	AA	Stock	37.44	38.5	37.13	37.92	7334500.0
2021-07-02	AAC-DELISTED	Stock	9.76	9.76	9.74	9.75	70997.0
2021-07-02	AACG	Stock	2.99	2.99	2.84	2.88	44500.0
2021-07-02	AAIC-DELISTED	Stock	4.07	4.09	4.0	4.01	111384.0
2021-07-02	AAIC.C-DELISTED	Stock	25.14	25.25	25.14	25.25	3001.0
2021-07-02	AAL	Stock	21.62	21.65	21.11	21.48	20814100.0
2021-07-02	AAM.A-DELISTED	Stock	26.3	26.425	26.29	26.31	16671.0
2021-07-02	AAM.B-DELISTED	Stock	26.95	26.98	26.88	26.9	9152.0
2021-07-02	AAMC-DELISTED	Stock	5.6176	5.6324	5.6176	5.6324	6803.0
2021-07-02	AAME	Stock	4.4	4.46	4.21	4.39	26500.0
2021-07-02	AAMI	Stock	24.04	24.23	23.875	24.11	383900.0
2021-07-02	AAN-DELISTED	Stock	32.31	33.0	31.83	32.34	173200.0
2021-07-02	AAOI	Stock	8.47	8.5	8.29	8.39	326200.0
2021-07-02	AAON	Stock	41.9467	42.42	41.5133	42.0933	267600.0
2021-07-02	AAP	Stock	208.93	211.16	208.22	211.05	522300.0
2021-07-02	AAQC-DELISTED	Stock	9.68	9.69	9.67	9.69	23272.0
2021-07-02	AAT	Stock	37.73	37.77	37.2	37.46	157800.0
2021-07-02	AAU-DELISTED	Stock	0.5036	0.5099	0.4984	0.4996	706678.0
2021-07-02	AAUAF-DELISTED	Stock	0.5036	0.5099	0.4984	0.4984	719479.0
2021-07-02	AAWW-DELISTED	Stock	68.6	69.19	67.63	68.98	186449.0
2021-07-02	AAXJ	Stock	93.22	93.64	93.07	93.61	3187758.0
2021-07-02	AB	Stock	46.84	47.0	46.45	46.91	81800.0
2021-07-02	ABB-DELISTED	Stock	34.59	34.61	34.331	34.52	805288.0
2021-07-02	ABBNY-DELISTED	Stock	34.59	34.61	34.331	34.52	898094.0
2021-07-02	ABBV	Stock	114.52	115.49	113.89	115.17	5719500.0
2021-07-02	ABC-DELISTED	Stock	116.18	116.92	115.05	116.65	559713.0
2021-07-02	ABCB	Stock	51.11	51.24	50.13	50.39	195500.0
2021-07-02	ABCL	Stock	20.22	20.59	19.83	20.48	1780900.0
2021-07-02	ABCM-DELISTED	Stock	19.64	19.68	19.04	19.18	301539.0
2021-07-02	ABEO	Stock	40.0	40.0	38.25	38.75	26640.0
2021-07-02	ABEV	Stock	3.47	3.49	3.41	3.43	16662000.0
2021-07-02	ABG	Stock	176.01	179.28	175.33	177.59	146000.0
2021-07-02	ABM	Stock	44.53	44.7	43.69	44.23	596200.0
2021-07-02	ABMD-DELISTED	Stock	315.49	318.22	312.79	317.13	105589.0
2021-07-02	ABNB	Stock	153.31	154.95	149.56	150.23	4826500.0
2021-07-02	ABOS	Stock	19.5	20.99	16.928	20.28	414600.0
2021-07-02	ABR	Stock	18.1	18.11	17.67	17.77	1180600.0
2021-07-02	ABR.D	Stock	25.46	25.46	25.41	25.42	39208.0
2021-07-02	ABST-DELISTED	Stock	14.5	14.52	14.17	14.48	39560.0

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

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