PREVIEW / stock_daily / 2022-06-14

all stock daily files

  file:    by_date/stock_daily/2022/2022-06-14.parquet
  size:    257 KB
  rows:    8,007
  symbols: 2,408

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-06-14	AAPL	Stock	133.13	133.89	131.48	132.76	84784300.0
2022-06-14	MSFT	Stock	243.86	245.74	241.51	244.49	28651500.0
2022-06-14	NVDA	Stock	15.731	16.066	15.412	15.836	469680000.0
2022-06-14	AMZN	Stock	104.19	104.88	101.43	102.31	69728800.0
2022-06-14	GOOGL	Stock	106.535	107.9245	105.8	106.7155	33706260.0
2022-06-14	META	Stock	166.03	166.75	161.36	163.73	27244300.0
2022-06-14	TSLA	Stock	218.2867	226.33	211.7367	220.89	97988700.0
2022-06-14	TLT	Stock	110.53	110.98	108.59	108.81	21865876.0
2022-06-14	ES	Stock	84.08	84.65	79.84	80.74	1592800.0
2022-06-14	CL	Stock	75.86	76.04	73.66	74.27	3960400.0
2022-06-14	A	Stock	115.99	116.7	113.25	116.01	1314000.0
2022-06-14	AA	Stock	50.17	50.51	48.3	48.92	5759100.0
2022-06-14	AAC-DELISTED	Stock	9.83	9.83	9.82	9.82	103322.0
2022-06-14	AACG	Stock	1.02	1.1	1.02	1.04	3100.0
2022-06-14	AAIC-DELISTED	Stock	3.24	3.24	3.11	3.135	63542.0
2022-06-14	AAIC.C-DELISTED	Stock	23.03	23.1088	22.5	22.5	4517.0
2022-06-14	AAL	Stock	13.6	13.66	12.76	12.95	43628700.0
2022-06-14	AAM.A-DELISTED	Stock	23.76	23.76	23.33	23.44	12464.0
2022-06-14	AAM.B-DELISTED	Stock	23.94	24.28	23.5599	24.265	7539.0
2022-06-14	AAMC-DELISTED	Stock	3.4412	3.4412	3.1294	3.1353	23096.0
2022-06-14	AAME	Stock	2.68	3.11	2.56	2.85	10800.0
2022-06-14	AAMI	Stock	19.22	19.27	18.58	18.97	372100.0
2022-06-14	AAN-DELISTED	Stock	17.16	17.31	16.44	16.64	347400.0
2022-06-14	AAOI	Stock	2.01	2.019	1.91	1.94	315300.0
2022-06-14	AAON	Stock	34.4867	35.0933	34.0867	34.6733	362850.0
2022-06-14	AAP	Stock	172.13	173.72	169.59	171.48	908400.0
2022-06-14	AAQC-DELISTED	Stock	9.77	9.77	9.77	9.77	4626.0
2022-06-14	AAT	Stock	29.58	29.58	28.5	28.8	359800.0
2022-06-14	AATC	Stock	5.38	5.49	5.2499	5.42	15145.0
2022-06-14	AAU-DELISTED	Stock	0.2409	0.2648	0.24	0.245	368112.0
2022-06-14	AAUAF-DELISTED	Stock	0.2409	0.2648	0.24	0.245	371131.0
2022-06-14	AAWW-DELISTED	Stock	64.84	66.87	64.03	64.34	268065.0
2022-06-14	AAXJ	Stock	68.49	69.09	68.35	68.87	1761002.0
2022-06-14	AB	Stock	40.44	41.51	40.08	40.35	362500.0
2022-06-14	ABB-DELISTED	Stock	27.71	27.9	27.2725	27.535	2489132.0
2022-06-14	ABBNY-DELISTED	Stock	27.71	27.9	27.2725	27.54	2672051.0
2022-06-14	ABBV	Stock	139.44	140.66	136.32	137.62	5861800.0
2022-06-14	ABC-DELISTED	Stock	141.51	142.63	140.1	141.27	796287.0
2022-06-14	ABCB	Stock	41.45	43.37	40.48	41.85	288300.0
2022-06-14	ABCL	Stock	8.24	9.0	8.045	8.8	3267300.0
2022-06-14	ABCM-DELISTED	Stock	13.58	13.65	13.3	13.4	106059.0
2022-06-14	ABEO	Stock	4.0	4.0	3.75	4.0	52824.0
2022-06-14	ABEV	Stock	2.55	2.57	2.48	2.51	36940700.0
2022-06-14	ABG	Stock	170.74	178.0	170.47	173.66	186400.0
2022-06-14	ABGI-DELISTED	Stock	9.8	9.81	9.79	9.7901	358614.0
2022-06-14	ABM	Stock	38.6	39.07	38.08	38.42	505700.0
2022-06-14	ABMD-DELISTED	Stock	239.92	242.37	229.27	229.66	243283.0
2022-06-14	ABNB	Stock	99.54	101.35	97.201	98.87	5915300.0
2022-06-14	ABOS	Stock	3.66	3.67	3.49	3.56	72400.0
2022-06-14	ABR	Stock	13.96	13.98	13.22	13.34	6379800.0

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

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