PREVIEW / stock_daily / 2021-06-08

all stock daily files

  file:    by_date/stock_daily/2021/2021-06-08.parquet
  size:    258 KB
  rows:    7,872
  symbols: 2,937

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-08	AAPL	Stock	126.6	128.46	126.21	126.74	74403800.0
2021-06-08	MSFT	Stock	255.16	256.01	252.51	252.57	22455000.0
2021-06-08	NVDA	Stock	17.5273	17.6215	17.251	17.457	323848000.0
2021-06-08	AMZN	Stock	161.1305	163.9765	160.9005	163.2055	68334000.0
2021-06-08	GOOGL	Stock	120.6005	120.976	119.739	119.922	24239840.0
2021-06-08	META	Stock	336.7	338.3	332.24	333.68	14580500.0
2021-06-08	TSLA	Stock	207.67	207.6967	198.5	201.1967	78160200.0
2021-06-08	TLT	Stock	140.655	140.66	140.21	140.45	11231222.0
2021-06-08	ES	Stock	82.4	82.4	80.5	81.15	1380000.0
2021-06-08	CL	Stock	84.06	84.23	82.87	82.93	3233100.0
2021-06-08	A	Stock	138.6	138.92	137.57	138.75	1143900.0
2021-06-08	AA	Stock	37.63	38.92	36.7	38.62	5046300.0
2021-06-08	AAC-DELISTED	Stock	9.8	9.84	9.77	9.82	487704.0
2021-06-08	AACG	Stock	3.37	3.45	3.32	3.33	65900.0
2021-06-08	AACQ-DELISTED	Stock	9.99	10.02	9.97	9.99	2058271.0
2021-06-08	AACQU-DELISTED	Stock	10.58	10.65	10.58	10.65	1777.0
2021-06-08	AACQW-DELISTED	Stock	1.98	2.0001	1.9	2.0	132486.0
2021-06-08	AAIC-DELISTED	Stock	4.11	4.2	4.09	4.19	195959.0
2021-06-08	AAIC.C-DELISTED	Stock	25.15	25.25	24.8	25.1	10182.0
2021-06-08	AAL	Stock	24.42	24.49	23.86	24.22	26105600.0
2021-06-08	AAM.A-DELISTED	Stock	26.044	26.11	25.97	25.97	12782.0
2021-06-08	AAM.B-DELISTED	Stock	27.17	27.17	27.09	27.11	19005.0
2021-06-08	AAMC-DELISTED	Stock	5.025	5.0735	4.9706	4.9932	7742.0
2021-06-08	AAME	Stock	4.12	4.37	4.1	4.27	104400.0
2021-06-08	AAMI	Stock	22.22	22.31	21.97	22.26	197300.0
2021-06-08	AAN-DELISTED	Stock	36.28	37.24	35.98	36.76	173000.0
2021-06-08	AAOI	Stock	8.73	9.03	8.73	8.85	583300.0
2021-06-08	AAON	Stock	43.18	43.36	42.76	43.04	129000.0
2021-06-08	AAP	Stock	193.37	198.75	193.37	197.87	1305700.0
2021-06-08	AAQC-DELISTED	Stock	9.75	9.75	9.72	9.72	656.0
2021-06-08	AAT	Stock	38.29	38.98	38.28	38.59	304300.0
2021-06-08	AAU-DELISTED	Stock	0.5301	0.544	0.53	0.535	562680.0
2021-06-08	AAUAF-DELISTED	Stock	0.5301	0.544	0.53	0.535	580334.0
2021-06-08	AAWW-DELISTED	Stock	74.65	74.9247	73.28	74.27	201666.0
2021-06-08	AAXJ	Stock	94.71	94.76	94.21	94.54	809318.0
2021-06-08	AB	Stock	44.89	45.88	44.86	45.86	295900.0
2021-06-08	ABB-DELISTED	Stock	35.11	35.13	34.89	35.03	966759.0
2021-06-08	ABBNY-DELISTED	Stock	35.11	35.13	34.89	35.03	1061946.0
2021-06-08	ABBV	Stock	112.68	113.09	111.82	112.34	4114200.0
2021-06-08	ABC-DELISTED	Stock	118.89	118.94	116.5	117.96	448934.0
2021-06-08	ABCB	Stock	56.76	57.92	55.97	57.12	347000.0
2021-06-08	ABCL	Stock	26.31	26.83	24.75	24.98	1328800.0
2021-06-08	ABCM-DELISTED	Stock	19.27	19.45	19.15	19.39	275962.0
2021-06-08	ABEO	Stock	44.75	45.0	43.25	44.75	38956.0
2021-06-08	ABEV	Stock	3.88	3.95	3.87	3.9	34229800.0
2021-06-08	ABG	Stock	181.36	185.05	180.86	183.07	126200.0
2021-06-08	ABGI-DELISTED	Stock	9.87	9.88	9.87	9.88	2438.0
2021-06-08	ABM	Stock	48.98	49.19	48.55	48.93	527300.0
2021-06-08	ABMD-DELISTED	Stock	292.09	295.0	284.43	289.17	195867.0
2021-06-08	ABNB	Stock	150.6	150.75	145.8	147.01	7125800.0

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

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