PREVIEW / stock_daily / 2021-06-18

all stock daily files

  file:    by_date/stock_daily/2021/2021-06-18.parquet
  size:    260 KB
  rows:    7,881
  symbols: 2,931

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-18	AAPL	Stock	130.71	131.51	130.24	130.46	108953300.0
2021-06-18	MSFT	Stock	259.63	262.3	258.75	259.43	37202200.0
2021-06-18	NVDA	Stock	18.784	19.375	18.584	18.6387	968856000.0
2021-06-18	AMZN	Stock	173.9995	175.35	173.6855	174.345	104954000.0
2021-06-18	GOOGL	Stock	121.367	121.603	120.015	120.111	46115200.0
2021-06-18	META	Stock	334.53	336.15	329.0	329.66	23039500.0
2021-06-18	TSLA	Stock	204.4567	209.45	203.9333	207.77	73682700.0
2021-06-18	TLT	Stock	144.28	146.04	144.12	145.73	26616912.0
2021-06-18	ES	Stock	82.19	82.39	79.71	79.92	4128900.0
2021-06-18	CL	Stock	81.92	82.22	81.0	81.02	7471300.0
2021-06-18	A	Stock	146.31	146.83	144.94	145.01	3220700.0
2021-06-18	AA	Stock	33.05	33.45	31.9	32.08	9979900.0
2021-06-18	AAC-DELISTED	Stock	9.7661	9.77	9.75	9.76	21779.0
2021-06-18	AACG	Stock	2.97	3.14	2.93	2.99	102900.0
2021-06-18	AACQ-DELISTED	Stock	9.95	9.95	9.72	9.88	3025197.0
2021-06-18	AACQU-DELISTED	Stock	10.62	10.91	10.5601	10.5601	13441.0
2021-06-18	AACQW-DELISTED	Stock	2.37	2.41	2.28	2.365	217901.0
2021-06-18	AAIC-DELISTED	Stock	3.99	4.0099	3.93	3.97	339679.0
2021-06-18	AAIC.C-DELISTED	Stock	24.78	24.8	24.75	24.8	2282.0
2021-06-18	AAL	Stock	22.07	22.53	21.91	22.29	28009900.0
2021-06-18	AAM.A-DELISTED	Stock	26.41	26.48	26.26	26.41	172164.0
2021-06-18	AAM.B-DELISTED	Stock	27.166	27.25	27.166	27.2	15610.0
2021-06-18	AAMC-DELISTED	Stock	5.6118	5.6853	5.4588	5.6029	6970.0
2021-06-18	AAME	Stock	4.03	4.13	4.01	4.08	83800.0
2021-06-18	AAMI	Stock	22.84	22.865	22.5	22.68	611000.0
2021-06-18	AAN-DELISTED	Stock	34.72	35.46	33.96	34.66	539700.0
2021-06-18	AAOI	Stock	8.65	8.65	8.11	8.24	836500.0
2021-06-18	AAON	Stock	41.5867	41.8867	40.44	40.6	462150.0
2021-06-18	AAP	Stock	191.72	194.26	191.4	193.33	1006300.0
2021-06-18	AAQC-DELISTED	Stock	9.7235	9.75	9.7235	9.73	12797.0
2021-06-18	AAT	Stock	37.58	37.66	36.87	36.96	570700.0
2021-06-18	AAU-DELISTED	Stock	0.5	0.5058	0.495	0.4997	568121.0
2021-06-18	AAUAF-DELISTED	Stock	0.5	0.5058	0.495	0.5	591348.0
2021-06-18	AAWW-DELISTED	Stock	69.32	70.1	66.83	66.98	678006.0
2021-06-18	AAXJ	Stock	93.2	93.25	92.74	92.9	1116294.0
2021-06-18	AB	Stock	44.47	44.66	43.23	43.26	323800.0
2021-06-18	ABB-DELISTED	Stock	33.07	33.15	32.8	32.81	1678561.0
2021-06-18	ABBNY-DELISTED	Stock	33.07	33.15	32.8	32.81	1818911.0
2021-06-18	ABBV	Stock	113.64	114.2	113.05	113.12	7415400.0
2021-06-18	ABC-DELISTED	Stock	117.23	117.23	114.31	114.43	950024.0
2021-06-18	ABCB	Stock	51.87	52.5	49.96	50.03	1405600.0
2021-06-18	ABCL	Stock	22.8	23.4	22.345	23.19	2929400.0
2021-06-18	ABCM-DELISTED	Stock	18.82	18.98	18.71	18.76	141117.0
2021-06-18	ABEO	Stock	42.0	43.0	40.25	42.5	55780.0
2021-06-18	ABEV	Stock	3.78	3.8	3.68	3.69	33543300.0
2021-06-18	ABG	Stock	166.07	167.06	157.8	158.27	280700.0
2021-06-18	ABGI-DELISTED	Stock	9.95	9.95	9.9157	9.9157	201.0
2021-06-18	ABM	Stock	45.08	45.33	44.61	44.78	697900.0
2021-06-18	ABMD-DELISTED	Stock	315.87	322.08	313.995	318.57	356751.0
2021-06-18	ABNB	Stock	150.38	154.8	149.4	152.52	11628900.0

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

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