PREVIEW / stock_daily / 2021-03-18

all stock daily files

  file:    by_date/stock_daily/2021/2021-03-18.parquet
  size:    252 KB
  rows:    7,652
  symbols: 2,879

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-03-18	AAPL	Stock	122.88	123.18	120.32	120.53	121229700.0
2021-03-18	MSFT	Stock	232.56	234.19	230.33	230.72	34833000.0
2021-03-18	NVDA	Stock	13.1365	13.184	12.717	12.7225	293896000.0
2021-03-18	AMZN	Stock	155.05	155.8315	151.25	151.3995	72992000.0
2021-03-18	GOOGL	Stock	102.409	103.4373	100.959	101.067	31712960.0
2021-03-18	META	Stock	279.87	285.19	278.28	278.62	18728300.0
2021-03-18	TSLA	Stock	228.0967	229.7433	217.3333	217.72	99674400.0
2021-03-18	TLT	Stock	133.31	134.47	133.19	133.92	21622014.0
2021-03-18	ES	Stock	81.8	82.04	80.9	81.37	1671800.0
2021-03-18	CL	Stock	75.66	76.21	74.67	76.07	3366700.0
2021-03-18	A	Stock	123.6	123.94	122.13	122.59	2067500.0
2021-03-18	AA	Stock	31.66	33.45	30.93	31.19	6723700.0
2021-03-18	AACG	Stock	4.53	5.14	4.46	4.74	681700.0
2021-03-18	AACQ-DELISTED	Stock	10.4	10.56	10.3089	10.35	2393176.0
2021-03-18	AACQU-DELISTED	Stock	11.0	11.28	11.0	11.13	5289.0
2021-03-18	AACQW-DELISTED	Stock	2.25	2.46	2.23	2.3	413954.0
2021-03-18	AAIC-DELISTED	Stock	4.14	4.14	4.03	4.04	102272.0
2021-03-18	AAIC.C-DELISTED	Stock	22.3	22.45	22.25	22.4001	5992.0
2021-03-18	AAL	Stock	25.12	26.09	24.55	24.7	53228500.0
2021-03-18	AAM.A-DELISTED	Stock	25.86	25.88	25.7979	25.87	28781.0
2021-03-18	AAM.B-DELISTED	Stock	26.6	26.66	26.54	26.58	22094.0
2021-03-18	AAMC-DELISTED	Stock	5.6529	5.7059	5.4471	5.7059	48878.0
2021-03-18	AAME	Stock	4.26	4.59	4.26	4.54	1105600.0
2021-03-18	AAMI	Stock	20.15	20.88	19.28	19.44	577500.0
2021-03-18	AAN-DELISTED	Stock	26.5	27.014	25.85	26.06	212200.0
2021-03-18	AAOI	Stock	8.74	9.02	8.27	8.37	582800.0
2021-03-18	AAON	Stock	48.22	49.2	47.5867	48.5667	219900.0
2021-03-18	AAP	Stock	181.14	184.91	181.14	183.73	862400.0
2021-03-18	AAT	Stock	35.16	35.38	34.53	34.83	420700.0
2021-03-18	AAU-DELISTED	Stock	0.6199	0.6279	0.605	0.6099	4309649.0
2021-03-18	AAUAF-DELISTED	Stock	0.6199	0.6279	0.605	0.6099	4383018.0
2021-03-18	AAWW-DELISTED	Stock	59.22	60.79	58.48	58.63	337542.0
2021-03-18	AAXJ	Stock	94.32	94.39	93.31	93.45	599046.0
2021-03-18	AB	Stock	40.5	41.58	40.28	41.49	613100.0
2021-03-18	ABB-DELISTED	Stock	31.11	31.3	30.835	30.86	1053364.0
2021-03-18	ABBNY-DELISTED	Stock	31.11	31.3	30.835	30.85	1610027.0
2021-03-18	ABBV	Stock	104.0	104.99	103.42	103.77	8675100.0
2021-03-18	ABC-DELISTED	Stock	113.71	116.7	113.28	115.65	696664.0
2021-03-18	ABCB	Stock	56.0	57.81	54.74	55.12	595300.0
2021-03-18	ABCL	Stock	36.0	36.15	30.75	31.37	1086200.0
2021-03-18	ABCM-DELISTED	Stock	20.77	21.12	20.54	20.71	45178.0
2021-03-18	ABEO	Stock	56.75	57.25	53.0	53.5	52116.0
2021-03-18	ABEV	Stock	2.77	2.82	2.76	2.76	12035700.0
2021-03-18	ABG	Stock	195.58	201.06	191.68	193.3	221300.0
2021-03-18	ABGI-DELISTED	Stock	9.95	10.02	9.91	9.935	68443.0
2021-03-18	ABM	Stock	50.3	51.86	50.12	50.26	431100.0
2021-03-18	ABMD-DELISTED	Stock	301.53	302.32	296.12	299.1	249584.0
2021-03-18	ABNB	Stock	196.8	199.9	190.68	191.45	3711500.0
2021-03-18	ABR	Stock	16.9	16.9	16.18	16.27	972200.0
2021-03-18	ABR.A-DELISTED	Stock	25.65	25.65	25.6086	25.6086	575.0

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

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