PREVIEW / stock_daily / 2021-05-10

all stock daily files

  file:    by_date/stock_daily/2021/2021-05-10.parquet
  size:    257 KB
  rows:    7,827
  symbols: 2,949

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-05-10	AAPL	Stock	129.41	129.54	126.81	126.85	88071200.0
2021-05-10	MSFT	Stock	250.87	251.73	247.12	247.18	29299900.0
2021-05-10	NVDA	Stock	14.7872	14.806	14.25	14.2658	268904000.0
2021-05-10	AMZN	Stock	164.116	164.15	159.5	159.5245	116772000.0
2021-05-10	GOOGL	Stock	116.407	116.55	114.227	114.5875	30914580.0
2021-05-10	META	Stock	314.35	314.58	304.83	305.97	24239200.0
2021-05-10	TSLA	Stock	221.6333	221.6833	209.2033	209.68	94177200.0
2021-05-10	TLT	Stock	138.95	139.25	137.69	137.82	15146246.0
2021-05-10	ES	Stock	84.23	85.8	84.23	85.45	1766700.0
2021-05-10	CL	Stock	82.65	83.93	82.44	83.34	4206000.0
2021-05-10	A	Stock	133.76	133.93	131.76	131.87	1034300.0
2021-05-10	AA	Stock	42.75	44.42	41.02	41.04	11649700.0
2021-05-10	AAC-DELISTED	Stock	9.88	9.88	9.82	9.85	73045.0
2021-05-10	AACG	Stock	2.86	2.93	2.81	2.88	34000.0
2021-05-10	AACQ-DELISTED	Stock	9.99	10.015	9.895	9.9	877488.0
2021-05-10	AACQU-DELISTED	Stock	10.57	10.798	10.5	10.5245	10565.0
2021-05-10	AACQW-DELISTED	Stock	1.8	1.89	1.7501	1.76	227592.0
2021-05-10	AAIC-DELISTED	Stock	4.1	4.11	4.04	4.06	160098.0
2021-05-10	AAIC.C-DELISTED	Stock	24.405	24.75	24.405	24.56	6659.0
2021-05-10	AAL	Stock	22.23	22.54	21.96	22.0	32570000.0
2021-05-10	AAM.A-DELISTED	Stock	26.24	26.24	26.1601	26.19	5680.0
2021-05-10	AAM.B-DELISTED	Stock	27.15	27.15	27.0	27.034	6143.0
2021-05-10	AAMC-DELISTED	Stock	5.1706	5.1706	5.0372	5.0971	27095.0
2021-05-10	AAME	Stock	4.0	4.06	3.95	3.98	43500.0
2021-05-10	AAMI	Stock	23.03	23.547	22.71	22.75	726200.0
2021-05-10	AAN-DELISTED	Stock	32.43	32.62	30.95	31.29	356700.0
2021-05-10	AAOI	Stock	7.57	7.675	7.25	7.53	873400.0
2021-05-10	AAON	Stock	43.8267	44.5133	43.7067	43.9467	213900.0
2021-05-10	AAP	Stock	204.81	210.18	204.81	208.59	999600.0
2021-05-10	AAQC-DELISTED	Stock	9.95	9.96	9.7802	9.7802	2367.0
2021-05-10	AAT	Stock	35.53	36.03	34.91	34.91	343000.0
2021-05-10	AAU-DELISTED	Stock	0.5613	0.5679	0.5399	0.54	993070.0
2021-05-10	AAUAF-DELISTED	Stock	0.5613	0.5679	0.5399	0.5408	1020440.0
2021-05-10	AAWW-DELISTED	Stock	75.0	75.48	73.29	73.29	312976.0
2021-05-10	AAXJ	Stock	93.73	93.73	92.36	92.41	1879133.0
2021-05-10	AB	Stock	44.44	45.59	44.44	44.83	676800.0
2021-05-10	ABB-DELISTED	Stock	33.86	33.88	33.5	33.51	1010497.0
2021-05-10	ABBNY-DELISTED	Stock	33.86	33.88	33.5	33.51	1130698.0
2021-05-10	ABBV	Stock	116.38	117.2	115.97	116.22	7093300.0
2021-05-10	ABC-DELISTED	Stock	120.52	124.85	120.43	123.28	748091.0
2021-05-10	ABCB	Stock	57.04	57.81	55.77	55.77	351300.0
2021-05-10	ABCL	Stock	28.89	29.09	27.56	27.67	784400.0
2021-05-10	ABCM-DELISTED	Stock	20.94	21.23	20.87	21.105	140852.0
2021-05-10	ABEO	Stock	38.5	38.5	33.25	33.75	88716.0
2021-05-10	ABEV	Stock	3.12	3.22	3.12	3.21	20620100.0
2021-05-10	ABG	Stock	209.03	212.45	204.64	205.49	105500.0
2021-05-10	ABGI-DELISTED	Stock	9.844	9.97	9.83	9.97	9480.0
2021-05-10	ABM	Stock	52.77	53.38	52.35	52.36	376200.0
2021-05-10	ABMD-DELISTED	Stock	296.41	297.0	282.15	282.67	193062.0
2021-05-10	ABNB	Stock	150.284	150.5	144.52	146.73	5827200.0

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

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