PREVIEW / stock_daily / 2022-03-30

all stock daily files

  file:    by_date/stock_daily/2022/2022-03-30.parquet
  size:    261 KB
  rows:    8,015
  symbols: 2,466

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-30	AAPL	Stock	178.55	179.61	176.7	177.77	92633200.0
2022-03-30	MSFT	Stock	313.76	315.95	311.58	313.86	28163600.0
2022-03-30	NVDA	Stock	28.304	28.496	27.503	27.69	463487000.0
2022-03-30	AMZN	Stock	168.5095	168.9505	165.5	166.301	56168000.0
2022-03-30	GOOGL	Stock	142.46	142.7203	141.6	141.9385	19884760.0
2022-03-30	META	Stock	228.91	231.15	226.71	227.85	25588000.0
2022-03-30	TSLA	Stock	363.7233	371.3167	361.3333	364.6633	59865000.0
2022-03-30	TLT	Stock	130.07	132.01	129.985	131.76	16310219.0
2022-03-30	ES	Stock	87.77	88.68	87.41	88.64	1451100.0
2022-03-30	CL	Stock	75.55	76.38	75.39	76.36	4191400.0
2022-03-30	A	Stock	137.93	138.22	134.52	135.46	1439800.0
2022-03-30	AA	Stock	92.6	93.99	90.96	92.19	5513600.0
2022-03-30	AAC-DELISTED	Stock	9.77	9.805	9.77	9.8	28171.0
2022-03-30	AACG	Stock	1.39	1.42	1.33	1.4	31000.0
2022-03-30	AACIW-DELISTED	Stock	0.3099	0.31	0.305	0.31	2601.0
2022-03-30	AAIC-DELISTED	Stock	3.56	3.57	3.47	3.49	55199.0
2022-03-30	AAIC.C-DELISTED	Stock	24.75	24.88	24.75	24.88	346.0
2022-03-30	AAL	Stock	17.92	18.25	17.77	18.05	28866400.0
2022-03-30	AAM.A-DELISTED	Stock	25.04	25.18	25.04	25.17	3511.0
2022-03-30	AAM.B-DELISTED	Stock	25.5	25.69	25.5	25.62	5769.0
2022-03-30	AAMC-DELISTED	Stock	4.3265	4.4588	4.1176	4.1471	36526.0
2022-03-30	AAME	Stock	2.96	3.1	2.83	3.08	11300.0
2022-03-30	AAMI	Stock	24.77	24.85	24.3	24.38	317100.0
2022-03-30	AAN-DELISTED	Stock	21.92	22.11	20.74	20.75	320000.0
2022-03-30	AAOI	Stock	3.33	3.62	3.31	3.49	625500.0
2022-03-30	AAON	Stock	37.3467	37.9067	37.1133	37.26	231900.0
2022-03-30	AAP	Stock	214.17	214.17	211.66	211.82	716800.0
2022-03-30	AAQC-DELISTED	Stock	9.73	9.74	9.73	9.74	421.0
2022-03-30	AAT	Stock	38.88	39.1	38.39	38.47	134400.0
2022-03-30	AATC	Stock	6.26	6.4291	6.26	6.3	7311.0
2022-03-30	AAU-DELISTED	Stock	0.35	0.37	0.35	0.37	513836.0
2022-03-30	AAUAF-DELISTED	Stock	0.35	0.37	0.35	0.35	519624.0
2022-03-30	AAWW-DELISTED	Stock	88.65	89.55	87.81	88.39	220247.0
2022-03-30	AAXJ	Stock	76.57	77.175	76.29	76.51	850836.0
2022-03-30	AB	Stock	47.13	47.7	46.76	47.08	242000.0
2022-03-30	ABB-DELISTED	Stock	32.93	33.12	32.515	32.63	1947411.0
2022-03-30	ABBNY-DELISTED	Stock	32.93	33.12	32.515	32.63	2202478.0
2022-03-30	ABBV	Stock	161.72	164.35	161.72	163.75	5151800.0
2022-03-30	ABC-DELISTED	Stock	155.43	156.25	153.9	155.13	512491.0
2022-03-30	ABCB	Stock	45.91	46.42	44.6	45.0	734800.0
2022-03-30	ABCL	Stock	9.78	10.22	9.605	9.75	1601900.0
2022-03-30	ABCM-DELISTED	Stock	18.22	18.67	18.18	18.46	133795.0
2022-03-30	ABEO	Stock	7.75	8.0	7.5	7.75	40932.0
2022-03-30	ABEV	Stock	3.16	3.18	3.13	3.14	13625100.0
2022-03-30	ABG	Stock	172.49	173.66	164.13	164.41	161200.0
2022-03-30	ABM	Stock	46.0	46.0	45.3	45.8	477200.0
2022-03-30	ABMD-DELISTED	Stock	329.98	332.25	326.015	328.36	96320.0
2022-03-30	ABNB	Stock	173.131	176.82	172.02	173.63	3707400.0
2022-03-30	ABOS	Stock	4.31	4.335	3.91	3.97	220900.0
2022-03-30	ABR	Stock	17.38	17.45	17.24	17.28	1423200.0

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

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