PREVIEW / stock_daily / 2021-06-10

all stock daily files

  file:    by_date/stock_daily/2021/2021-06-10.parquet
  size:    258 KB
  rows:    7,864
  symbols: 2,937

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-06-10	AAPL	Stock	127.02	128.19	125.94	126.11	71186400.0
2021-06-10	MSFT	Stock	254.29	257.46	253.67	257.24	24563600.0
2021-06-10	NVDA	Stock	17.35	17.492	17.176	17.425	287772000.0
2021-06-10	AMZN	Stock	164.1005	167.55	164.0575	167.4825	69530000.0
2021-06-10	GOOGL	Stock	120.346	121.8	120.189	121.7565	25907500.0
2021-06-10	META	Stock	330.79	333.94	328.55	332.46	13240200.0
2021-06-10	TSLA	Stock	201.2933	205.53	200.1667	203.3733	71758800.0
2021-06-10	TLT	Stock	140.83	142.56	140.68	142.54	19698410.0
2021-06-10	ES	Stock	82.8	83.4	82.45	83.12	1536700.0
2021-06-10	CL	Stock	82.55	83.67	82.55	83.6	4075900.0
2021-06-10	A	Stock	140.32	143.35	140.01	143.06	1462400.0
2021-06-10	AA	Stock	38.26	38.8	37.24	37.42	3736100.0
2021-06-10	AAC-DELISTED	Stock	9.79	9.82	9.77	9.79	40046.0
2021-06-10	AACG	Stock	3.37	3.4	3.11	3.22	40000.0
2021-06-10	AACQ-DELISTED	Stock	10.05	10.05	9.9973	10.005	2254770.0
2021-06-10	AACQU-DELISTED	Stock	10.785	10.8	10.6001	10.79	3303.0
2021-06-10	AACQW-DELISTED	Stock	2.32	2.38	2.22	2.36	100903.0
2021-06-10	AAIC-DELISTED	Stock	4.18	4.2142	4.11	4.12	137457.0
2021-06-10	AAIC.C-DELISTED	Stock	25.23	25.265	25.1238	25.265	2488.0
2021-06-10	AAL	Stock	24.14	24.24	23.26	23.46	28988300.0
2021-06-10	AAM.A-DELISTED	Stock	26.13	26.13	26.05	26.11	5499.0
2021-06-10	AAM.B-DELISTED	Stock	27.05	27.05	27.03	27.05	9388.0
2021-06-10	AAMC-DELISTED	Stock	5.5882	5.6912	5.3825	5.5882	38814.0
2021-06-10	AAME	Stock	4.19	4.29	4.07	4.18	125600.0
2021-06-10	AAMI	Stock	22.41	22.525	22.21	22.3	313000.0
2021-06-10	AAN-DELISTED	Stock	37.15	37.19	35.8	35.95	232300.0
2021-06-10	AAOI	Stock	8.7	8.8	8.53	8.63	388000.0
2021-06-10	AAON	Stock	43.24	43.24	42.2667	42.5067	213750.0
2021-06-10	AAP	Stock	197.37	197.97	194.1	195.85	925900.0
2021-06-10	AAQC-DELISTED	Stock	9.77	9.77	9.71	9.7217	24696.0
2021-06-10	AAT	Stock	38.55	38.59	38.28	38.36	207600.0
2021-06-10	AAU-DELISTED	Stock	0.54	0.5542	0.538	0.55	837866.0
2021-06-10	AAUAF-DELISTED	Stock	0.54	0.5542	0.538	0.5537	858389.0
2021-06-10	AAWW-DELISTED	Stock	74.41	74.73	73.36	73.68	154764.0
2021-06-10	AAXJ	Stock	94.32	94.78	94.28	94.72	351592.0
2021-06-10	AB	Stock	46.33	46.5	45.23	45.5	289900.0
2021-06-10	ABB-DELISTED	Stock	34.61	34.735	34.55	34.62	1038984.0
2021-06-10	ABBNY-DELISTED	Stock	34.61	34.735	34.55	34.63	1135211.0
2021-06-10	ABBV	Stock	114.36	116.99	114.15	116.24	6263800.0
2021-06-10	ABC-DELISTED	Stock	117.99	121.1199	117.58	120.97	608626.0
2021-06-10	ABCB	Stock	56.46	56.46	53.98	54.05	258100.0
2021-06-10	ABCL	Stock	24.475	25.02	23.85	24.84	3645800.0
2021-06-10	ABCM-DELISTED	Stock	18.88	19.2478	18.79	19.1	236639.0
2021-06-10	ABEO	Stock	42.75	46.75	42.75	46.25	60276.0
2021-06-10	ABEV	Stock	3.81	3.87	3.78	3.8	17863400.0
2021-06-10	ABG	Stock	181.17	181.66	175.26	175.26	161700.0
2021-06-10	ABGI-DELISTED	Stock	9.945	9.945	9.9	9.94	1486.0
2021-06-10	ABM	Stock	49.16	49.16	47.58	47.62	348400.0
2021-06-10	ABMD-DELISTED	Stock	293.71	299.59	292.68	298.13	100575.0
2021-06-10	ABNB	Stock	142.15	147.45	141.04	146.12	9482500.0

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

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