PREVIEW / stock_daily / 2022-10-10

all stock daily files

  file:    by_date/stock_daily/2022/2022-10-10.parquet
  size:    248 KB
  rows:    7,764
  symbols: 2,127

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-10-10	AAPL	Stock	140.42	141.89	138.57	140.42	74899000.0
2022-10-10	MSFT	Stock	233.05	234.56	226.73	229.25	29743600.0
2022-10-10	NVDA	Stock	12.037	12.124	11.408	11.67	698699000.0
2022-10-10	AMZN	Stock	115.1	116.25	112.43	113.67	42339700.0
2022-10-10	GOOGL	Stock	99.0	99.095	97.01	97.86	18225094.0
2022-10-10	META	Stock	133.55	136.11	131.87	133.79	24024000.0
2022-10-10	TSLA	Stock	223.93	226.99	218.36	222.96	67925000.0
2022-10-10	TLT	Stock	100.5	100.51	98.795	99.42	15652632.0
2022-10-10	ES	Stock	74.33	75.4	74.3	74.97	1352100.0
2022-10-10	CL	Stock	69.02	69.4	67.84	68.48	4756700.0
2022-10-10	A	Stock	128.05	128.05	124.31	125.95	1246000.0
2022-10-10	AA	Stock	39.5	40.19	38.462	38.84	5590100.0
2022-10-10	AAC-DELISTED	Stock	9.95	9.955	9.95	9.955	33211.0
2022-10-10	AACG	Stock	1.89	1.92	1.89	1.91	5600.0
2022-10-10	AACIW-DELISTED	Stock	0.1247	0.1268	0.1	0.1	900.0
2022-10-10	AAIC-DELISTED	Stock	2.71	2.7614	2.7	2.75	36339.0
2022-10-10	AAIC.C-DELISTED	Stock	18.9786	19.1388	18.9786	19.0783	400.0
2022-10-10	AAL	Stock	12.2	12.32	11.86	12.05	29602600.0
2022-10-10	AAM.A-DELISTED	Stock	23.36	23.36	22.85	22.93	13342.0
2022-10-10	AAM.B-DELISTED	Stock	23.36	23.36	22.6499	22.85	12637.0
2022-10-10	AAMC-DELISTED	Stock	4.4706	4.4706	4.4706	4.4706	697.0
2022-10-10	AAME	Stock	2.78	2.78	2.78	2.78	700.0
2022-10-10	AAMI	Stock	17.04	17.62	17.03	17.48	288500.0
2022-10-10	AAN-DELISTED	Stock	9.47	9.47	9.01	9.03	413500.0
2022-10-10	AAOI	Stock	2.77	2.79	2.55	2.67	272400.0
2022-10-10	AAON	Stock	35.4333	36.0933	35.28	35.8667	174150.0
2022-10-10	AAP	Stock	162.02	166.86	160.84	166.25	719800.0
2022-10-10	AAQC-DELISTED	Stock	9.83	9.835	9.82	9.835	13938.0
2022-10-10	AAT	Stock	25.1	25.2	24.68	24.93	386600.0
2022-10-10	AATC	Stock	4.5	4.72	4.47	4.51	6024.0
2022-10-10	AAU-DELISTED	Stock	0.24	0.24	0.23	0.2351	161153.0
2022-10-10	AAUAF-DELISTED	Stock	0.24	0.24	0.23	0.235	169454.0
2022-10-10	AAWW-DELISTED	Stock	98.15	99.0	98.0	98.68	193210.0
2022-10-10	AAXJ	Stock	58.92	58.96	58.25	58.44	685294.0
2022-10-10	AB	Stock	35.1	35.3	34.02	34.15	358900.0
2022-10-10	ABB-DELISTED	Stock	25.23	25.255	24.805	24.99	1177299.0
2022-10-10	ABBNY-DELISTED	Stock	25.23	25.255	24.805	24.99	1283368.0
2022-10-10	ABBV	Stock	139.03	139.59	136.87	138.31	3830800.0
2022-10-10	ABC-DELISTED	Stock	137.68	139.13	137.1	137.54	669907.0
2022-10-10	ABCB	Stock	48.6	48.98	47.85	47.93	350800.0
2022-10-10	ABCL	Stock	10.73	11.08	10.32	10.92	1283200.0
2022-10-10	ABCM-DELISTED	Stock	14.9	15.03	14.72	14.75	220248.0
2022-10-10	ABEO	Stock	4.38	5.05	3.95	4.95	1319700.0
2022-10-10	ABEV	Stock	2.91	2.94	2.87	2.89	23891200.0
2022-10-10	ABG	Stock	156.07	158.62	152.68	155.23	120900.0
2022-10-10	ABM	Stock	40.73	41.31	40.64	41.18	289200.0
2022-10-10	ABMD-DELISTED	Stock	257.09	257.09	246.79	247.075	158672.0
2022-10-10	ABNB	Stock	108.55	111.62	107.41	110.99	3945200.0
2022-10-10	ABOS	Stock	9.9	10.055	9.36	9.45	336300.0
2022-10-10	ABR	Stock	11.82	12.05	11.57	11.64	1911000.0

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

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