PREVIEW / stock_daily / 2021-10-04

all stock daily files

  file:    by_date/stock_daily/2021/2021-10-04.parquet
  size:    259 KB
  rows:    7,951
  symbols: 2,740

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
2021-10-04	AAPL	Stock	141.76	142.21	138.27	139.14	98322000.0
2021-10-04	MSFT	Stock	287.4	287.75	280.25	283.11	31350700.0
2021-10-04	NVDA	Stock	20.504	20.542	19.555	19.732	345635000.0
2021-10-04	AMZN	Stock	163.9695	163.9995	158.8125	159.489	90462000.0
2021-10-04	GOOGL	Stock	135.9605	135.9605	131.05	133.6595	51201940.0
2021-10-04	META	Stock	335.53	335.94	322.7	326.23	42885000.0
2021-10-04	TSLA	Stock	265.5	268.99	258.7067	260.51	91449900.0
2021-10-04	TLT	Stock	144.67	145.46	144.1	144.98	28027596.0
2021-10-04	ES	Stock	82.37	85.4	82.15	84.92	2506000.0
2021-10-04	CL	Stock	75.51	75.93	74.61	75.06	3943600.0
2021-10-04	A	Stock	155.24	156.3	151.26	152.36	1758300.0
2021-10-04	AA	Stock	50.53	51.23	49.06	49.18	4681700.0
2021-10-04	AAC-DELISTED	Stock	9.77	9.77	9.75	9.76	1398648.0
2021-10-04	AACG	Stock	2.39	2.4	2.31	2.37	11000.0
2021-10-04	AACIU	Stock	9.99	9.99	9.8	9.86	3574.0
2021-10-04	AAIC-DELISTED	Stock	3.71	3.7686	3.68	3.7	103707.0
2021-10-04	AAIC.C-DELISTED	Stock	25.15	25.2	25.15	25.175	930.0
2021-10-04	AAL	Stock	21.92	22.08	21.29	21.39	28623400.0
2021-10-04	AAM.A-DELISTED	Stock	25.59	25.76	25.55	25.65	10341.0
2021-10-04	AAM.B-DELISTED	Stock	26.97	27.07	26.8322	26.91	9435.0
2021-10-04	AAMC-DELISTED	Stock	7.0294	7.0294	6.5353	6.8	130050.0
2021-10-04	AAME	Stock	4.28	4.3	4.1	4.18	32900.0
2021-10-04	AAMI	Stock	26.01	26.41	25.93	25.94	575400.0
2021-10-04	AAN-DELISTED	Stock	27.99	28.31	27.47	27.6	146800.0
2021-10-04	AAOI	Stock	7.23	7.25	6.795	6.81	307800.0
2021-10-04	AAON	Stock	44.16	45.0133	43.8067	44.72	181350.0
2021-10-04	AAP	Stock	207.26	209.37	205.8	207.17	568800.0
2021-10-04	AAQC-DELISTED	Stock	9.75	9.75	9.7	9.7101	55018.0
2021-10-04	AAT	Stock	38.19	38.58	38.01	38.08	299600.0
2021-10-04	AATC	Stock	7.31	7.5899	7.31	7.34	14830.0
2021-10-04	AAU-DELISTED	Stock	0.3912	0.3914	0.3796	0.3841	463363.0
2021-10-04	AAUAF-DELISTED	Stock	0.3912	0.3914	0.3796	0.3841	473941.0
2021-10-04	AAWW-DELISTED	Stock	83.33	84.48	82.5	84.28	414319.0
2021-10-04	AAXJ	Stock	84.06	84.17	82.94	83.44	908637.0
2021-10-04	AB	Stock	50.39	50.87	49.77	50.33	197900.0
2021-10-04	ABB-DELISTED	Stock	33.12	33.14	32.78	32.94	1141584.0
2021-10-04	ABBNY-DELISTED	Stock	33.12	33.14	32.78	32.94	1303589.0
2021-10-04	ABBV	Stock	108.84	110.2	107.69	108.73	9779200.0
2021-10-04	ABC-DELISTED	Stock	120.0	121.48	117.49	118.37	702100.0
2021-10-04	ABCB	Stock	52.67	53.7	52.59	53.47	296900.0
2021-10-04	ABCL	Stock	16.98	17.0	16.22	16.43	2086800.0
2021-10-04	ABCM-DELISTED	Stock	20.13	20.21	19.85	20.04	25290.0
2021-10-04	ABEO	Stock	27.25	27.75	26.25	26.25	20496.0
2021-10-04	ABEV	Stock	2.7	2.77	2.7	2.74	19517100.0
2021-10-04	ABG	Stock	196.23	204.0	196.23	203.5	203200.0
2021-10-04	ABGI-DELISTED	Stock	9.72	9.72	9.71	9.72	108149.0
2021-10-04	ABM	Stock	47.11	47.55	46.56	46.81	286900.0
2021-10-04	ABMD-DELISTED	Stock	320.5	326.18	311.315	313.49	127143.0
2021-10-04	ABNB	Stock	171.99	172.26	164.03	164.5	4459400.0
2021-10-04	ABOS	Stock	15.37	15.5	14.76	15.15	90600.0

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

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