PREVIEW / stock_daily / 2022-04-18

all stock daily files

  file:    by_date/stock_daily/2022/2022-04-18.parquet
  size:    260 KB
  rows:    8,056
  symbols: 2,494

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-04-18	AAPL	Stock	163.92	166.6	163.57	165.07	69023900.0
2022-04-18	MSFT	Stock	278.91	282.46	278.34	280.52	20778000.0
2022-04-18	NVDA	Stock	21.2	22.088	21.079	21.783	525701000.0
2022-04-18	AMZN	Stock	151.5235	154.0395	150.2505	152.785	46514000.0
2022-04-18	GOOGL	Stock	127.0	128.2125	126.182	127.6765	20808660.0
2022-04-18	META	Stock	210.0	213.38	208.3	210.77	16580800.0
2022-04-18	TSLA	Stock	329.6767	338.3067	324.47	334.7633	51715200.0
2022-04-18	TLT	Stock	120.87	121.08	119.69	120.15	18784253.0
2022-04-18	ES	Stock	92.61	93.14	91.24	91.67	648300.0
2022-04-18	CL	Stock	80.86	81.18	79.72	80.01	5230900.0
2022-04-18	A	Stock	126.44	126.75	123.13	123.84	1597100.0
2022-04-18	AA	Stock	88.0	90.98	86.94	89.45	4475000.0
2022-04-18	AAC-DELISTED	Stock	9.84	9.845	9.825	9.83	58242.0
2022-04-18	AACG	Stock	1.22	1.24	1.18	1.19	18800.0
2022-04-18	AACIW-DELISTED	Stock	0.3198	0.3198	0.3198	0.3198	5000.0
2022-04-18	AAIC-DELISTED	Stock	3.36	3.48	3.36	3.46	146880.0
2022-04-18	AAIC.C-DELISTED	Stock	24.7136	24.7136	24.68	24.68	4300.0
2022-04-18	AAL	Stock	18.86	19.09	18.47	18.54	27478900.0
2022-04-18	AAM.A-DELISTED	Stock	24.98	25.02	24.9601	24.9601	20403.0
2022-04-18	AAM.B-DELISTED	Stock	25.08	25.2	25.08	25.1599	37212.0
2022-04-18	AAMC-DELISTED	Stock	3.2054	3.2618	2.9706	3.1206	5709.0
2022-04-18	AAME	Stock	3.37	3.37	3.11	3.17	9300.0
2022-04-18	AAMI	Stock	21.94	22.18	21.65	22.1	501900.0
2022-04-18	AAN-DELISTED	Stock	21.26	21.59	21.075	21.2	140600.0
2022-04-18	AAOI	Stock	3.05	3.11	2.95	3.04	292200.0
2022-04-18	AAON	Stock	34.4667	35.0467	34.34	34.6133	295950.0
2022-04-18	AAP	Stock	217.38	221.44	217.38	218.25	603900.0
2022-04-18	AAQC-DELISTED	Stock	9.76	9.77	9.76	9.77	8820.0
2022-04-18	AAT	Stock	35.89	36.28	35.59	35.82	224100.0
2022-04-18	AATC	Stock	6.68	6.7202	6.41	6.65	19569.0
2022-04-18	AAU-DELISTED	Stock	0.38	0.38	0.37	0.38	488409.0
2022-04-18	AAUAF-DELISTED	Stock	0.38	0.38	0.37	0.3761	498420.0
2022-04-18	AAWW-DELISTED	Stock	69.28	69.86	68.45	68.95	318458.0
2022-04-18	AAXJ	Stock	72.75	73.23	72.505	72.87	1471739.0
2022-04-18	AB	Stock	44.52	44.86	42.42	42.49	673500.0
2022-04-18	ABB-DELISTED	Stock	30.66	31.06	30.66	30.85	1360549.0
2022-04-18	ABBNY-DELISTED	Stock	30.66	31.06	30.66	30.85	1525434.0
2022-04-18	ABBV	Stock	161.96	162.79	158.75	159.36	6500200.0
2022-04-18	ABC-DELISTED	Stock	160.34	162.72	160.34	161.96	596886.0
2022-04-18	ABCB	Stock	40.58	40.88	39.98	40.75	588300.0
2022-04-18	ABCL	Stock	8.92	8.92	8.21	8.41	1045800.0
2022-04-18	ABCM-DELISTED	Stock	18.35	18.35	18.035	18.1	137963.0
2022-04-18	ABEO	Stock	7.0	7.25	6.5	6.75	134932.0
2022-04-18	ABEV	Stock	3.11	3.14	3.09	3.11	18034000.0
2022-04-18	ABG	Stock	152.37	156.14	152.37	154.9	179400.0
2022-04-18	ABGI-DELISTED	Stock	9.845	9.845	9.81	9.81	5101.0
2022-04-18	ABM	Stock	49.16	50.42	48.83	50.09	498900.0
2022-04-18	ABMD-DELISTED	Stock	306.39	308.07	299.04	301.5	108279.0
2022-04-18	ABNB	Stock	169.27	170.12	164.35	165.74	3339900.0
2022-04-18	ABOS	Stock	3.97	4.03	3.83	3.87	180000.0

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

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