PREVIEW / stock_daily / 2022-03-16

all stock daily files

  file:    by_date/stock_daily/2022/2022-03-16.parquet
  size:    261 KB
  rows:    8,041
  symbols: 2,507

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-03-16	AAPL	Stock	157.05	160.0	154.46	159.59	102300200.0
2022-03-16	MSFT	Stock	289.11	294.57	283.2	294.39	37826300.0
2022-03-16	NVDA	Stock	23.5	24.597	23.172	24.496	671422000.0
2022-03-16	AMZN	Stock	148.5	153.15	147.3535	153.104	84958000.0
2022-03-16	GOOGL	Stock	130.733	133.333	128.7345	133.2805	35576980.0
2022-03-16	META	Stock	194.7	203.73	194.52	203.63	40640300.0
2022-03-16	TSLA	Stock	269.6667	280.6667	267.42	280.0767	84028800.0
2022-03-16	TLT	Stock	131.83	133.13	130.32	132.82	25857702.0
2022-03-16	ES	Stock	84.09	84.36	82.35	84.03	2327400.0
2022-03-16	CL	Stock	75.53	75.9	74.44	75.15	4519900.0
2022-03-16	A	Stock	131.93	135.61	131.3	135.0	1673000.0
2022-03-16	AA	Stock	74.79	76.79	72.581	75.63	6809800.0
2022-03-16	AAC-DELISTED	Stock	9.76	9.77	9.76	9.77	196656.0
2022-03-16	AACG	Stock	1.33	1.45	1.22	1.3	95800.0
2022-03-16	AACIW-DELISTED	Stock	0.295	0.30243	0.27	0.27	1900.0
2022-03-16	AAIC-DELISTED	Stock	3.56	3.63	3.55	3.55	50904.0
2022-03-16	AAIC.C-DELISTED	Stock	24.75	24.89	24.75	24.89	2139.0
2022-03-16	AAL	Stock	15.85	16.49	15.53	16.47	66907400.0
2022-03-16	AAM.A-DELISTED	Stock	24.94	25.165	24.94	25.04	22028.0
2022-03-16	AAM.B-DELISTED	Stock	25.21	25.42	25.21	25.24	19145.0
2022-03-16	AAME	Stock	2.48	2.5	2.37	2.39	2200.0
2022-03-16	AAMI	Stock	24.78	25.78	24.78	25.39	1361800.0
2022-03-16	AAN-DELISTED	Stock	21.99	22.85	21.91	22.47	221400.0
2022-03-16	AAOI	Stock	3.175	3.34	3.11	3.28	277200.0
2022-03-16	AAON	Stock	36.3067	37.8933	36.3067	37.8	545250.0
2022-03-16	AAP	Stock	205.37	208.9	203.07	207.52	1235800.0
2022-03-16	AAQC-DELISTED	Stock	9.72	9.72	9.72	9.72	330.0
2022-03-16	AAT	Stock	36.38	36.58	35.49	36.38	314900.0
2022-03-16	AATC	Stock	6.655	6.655	6.42	6.5	7739.0
2022-03-16	AAU-DELISTED	Stock	0.32	0.34	0.32	0.3255	1085252.0
2022-03-16	AAUAF-DELISTED	Stock	0.32	0.34	0.32	0.325	1098939.0
2022-03-16	AAWW-DELISTED	Stock	84.96	85.69	83.02	83.95	327145.0
2022-03-16	AAXJ	Stock	73.09	75.88	72.75	75.88	3979268.0
2022-03-16	AB	Stock	43.67	44.8	43.2	44.56	500400.0
2022-03-16	ABB-DELISTED	Stock	34.0	34.69	33.83	34.69	3200952.0
2022-03-16	ABBNY-DELISTED	Stock	34.0	34.69	33.83	34.69	3474841.0
2022-03-16	ABBV	Stock	156.5	156.82	153.52	156.05	7178900.0
2022-03-16	ABC-DELISTED	Stock	151.68	153.0548	148.32	150.52	720753.0
2022-03-16	ABCB	Stock	47.62	48.4	46.43	48.3	524000.0
2022-03-16	ABCL	Stock	8.0	8.52	7.96	8.5	1695900.0
2022-03-16	ABCM-DELISTED	Stock	16.71	17.25	16.66	17.17	148270.0
2022-03-16	ABEO	Stock	6.5	7.25	6.5	7.0	52808.0
2022-03-16	ABEV	Stock	2.64	2.71	2.63	2.7	22085800.0
2022-03-16	ABG	Stock	186.81	196.84	186.81	192.73	349100.0
2022-03-16	ABGI-DELISTED	Stock	9.76	9.77	9.76	9.76	24430.0
2022-03-16	ABM	Stock	44.74	45.75	44.48	45.67	426500.0
2022-03-16	ABMD-DELISTED	Stock	294.38	299.97	284.38	294.83	272018.0
2022-03-16	ABNB	Stock	148.145	156.98	146.31	155.75	7105400.0
2022-03-16	ABOS	Stock	5.68	6.12	5.58	6.1	360600.0
2022-03-16	ABR	Stock	17.34	17.58	17.22	17.52	2547400.0

> showing 50 of 8,041 rows — these rows as CSV

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