PREVIEW / stock_daily / 2022-05-19

all stock daily files

  file:    by_date/stock_daily/2022/2022-05-19.parquet
  size:    255 KB
  rows:    7,904
  symbols: 2,365

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
2022-05-19	AAPL	Stock	139.88	141.66	136.6	137.35	136095600.0
2022-05-19	MSFT	Stock	253.9	257.67	251.88	253.14	32692300.0
2022-05-19	NVDA	Stock	16.937	17.687	16.734	17.124	621310000.0
2022-05-19	AMZN	Stock	106.2805	110.034	106.193	107.319	88142000.0
2022-05-19	GOOGL	Stock	111.4315	113.01	110.0	110.384	34144400.0
2022-05-19	META	Stock	191.2	195.29	189.6	191.29	24446900.0
2022-05-19	TSLA	Stock	235.6667	244.6667	231.37	236.4733	90296700.0
2022-05-19	TLT	Stock	118.64	118.72	116.8537	117.18	21937465.0
2022-05-19	ES	Stock	88.97	90.16	87.67	89.44	1936100.0
2022-05-19	CL	Stock	74.67	75.36	73.92	75.12	5477100.0
2022-05-19	A	Stock	120.31	123.58	119.53	122.4	2310100.0
2022-05-19	AA	Stock	60.16	64.47	60.11	62.05	6751700.0
2022-05-19	AAC-DELISTED	Stock	9.8	9.8	9.79	9.795	21605.0
2022-05-19	AACG	Stock	1.1	1.1	1.03	1.03	15700.0
2022-05-19	AACIW-DELISTED	Stock	0.25	0.25	0.2001	0.2001	32427.0
2022-05-19	AAIC-DELISTED	Stock	3.45	3.45	3.37	3.39	66707.0
2022-05-19	AAIC.C-DELISTED	Stock	22.8499	22.8499	22.7346	22.75	2619.0
2022-05-19	AAL	Stock	16.63	17.14	16.57	16.75	28299800.0
2022-05-19	AAM.A-DELISTED	Stock	23.95	24.19	23.83	24.1	55628.0
2022-05-19	AAM.B-DELISTED	Stock	24.55	24.98	24.38	24.81	30578.0
2022-05-19	AAMC-DELISTED	Stock	2.9794	2.9853	2.9412	2.9412	10951.0
2022-05-19	AAME	Stock	2.6	3.02	2.41	2.79	8000.0
2022-05-19	AAMI	Stock	19.65	20.095	19.65	19.86	570800.0
2022-05-19	AAN-DELISTED	Stock	19.18	19.72	19.04	19.05	223700.0
2022-05-19	AAOI	Stock	2.38	2.53	2.28	2.48	216900.0
2022-05-19	AAON	Stock	33.12	33.9267	32.9067	33.46	270150.0
2022-05-19	AAP	Stock	194.6	199.89	191.67	196.07	683600.0
2022-05-19	AAQC-DELISTED	Stock	9.7461	9.76	9.7461	9.76	300.0
2022-05-19	AAT	Stock	32.79	32.93	31.91	31.91	280900.0
2022-05-19	AATC	Stock	6.0999	6.69	6.03	6.17	19367.0
2022-05-19	AAU-DELISTED	Stock	0.2725	0.285	0.2706	0.2833	318505.0
2022-05-19	AAUAF-DELISTED	Stock	0.2725	0.285	0.2706	0.2832	323358.0
2022-05-19	AAWW-DELISTED	Stock	68.54	69.06	66.8501	66.98	359452.0
2022-05-19	AAXJ	Stock	68.21	69.29	68.21	69.06	2126504.0
2022-05-19	AB	Stock	38.43	38.91	38.23	38.55	354300.0
2022-05-19	ABB-DELISTED	Stock	28.86	29.685	28.83	29.415	2981479.0
2022-05-19	ABBNY-DELISTED	Stock	28.86	29.685	28.83	29.41	3206063.0
2022-05-19	ABBV	Stock	151.2	152.4	149.28	151.72	5994800.0
2022-05-19	ABC-DELISTED	Stock	149.43	150.43	146.83	149.42	809696.0
2022-05-19	ABCB	Stock	42.17	43.1	42.16	42.39	589000.0
2022-05-19	ABCL	Stock	7.95	8.52	7.92	8.3	1312100.0
2022-05-19	ABCM-DELISTED	Stock	13.65	13.97	13.63	13.82	118957.0
2022-05-19	ABEO	Stock	4.25	4.25	4.0	4.25	37804.0
2022-05-19	ABEV	Stock	2.84	2.86	2.81	2.82	31659100.0
2022-05-19	ABG	Stock	175.05	182.51	173.71	179.44	197600.0
2022-05-19	ABM	Stock	45.59	45.77	44.96	45.15	540500.0
2022-05-19	ABMD-DELISTED	Stock	239.3	243.765	237.57	238.31	384266.0
2022-05-19	ABNB	Stock	108.18	116.35	107.45	114.17	8926600.0
2022-05-19	ABOS	Stock	3.47	3.59	3.42	3.47	125000.0
2022-05-19	ABR	Stock	16.28	16.5	16.13	16.14	2887200.0

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

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