PREVIEW / stock_daily / 2021-07-09

all stock daily files

  file:    by_date/stock_daily/2021/2021-07-09.parquet
  size:    258 KB
  rows:    7,888
  symbols: 2,866

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-07-09	AAPL	Stock	142.75	145.65	142.65	145.11	99890800.0
2021-07-09	MSFT	Stock	275.72	278.05	275.32	277.94	23916700.0
2021-07-09	NVDA	Stock	19.9625	20.0803	19.7542	20.0503	296624000.0
2021-07-09	AMZN	Stock	186.126	187.4	184.67	185.967	74964000.0
2021-07-09	GOOGL	Stock	125.025	125.7345	124.5512	125.5185	18631680.0
2021-07-09	META	Stock	345.32	350.71	345.27	350.42	13018700.0
2021-07-09	TSLA	Stock	217.7267	219.6367	214.8967	218.9833	54421500.0
2021-07-09	TLT	Stock	146.87	146.99	146.49	146.53	14483634.0
2021-07-09	ES	Stock	82.6	82.84	82.08	82.63	1343600.0
2021-07-09	CL	Stock	82.67	82.82	82.27	82.43	2801600.0
2021-07-09	A	Stock	149.49	150.23	148.92	150.03	1596800.0
2021-07-09	AA	Stock	36.5	37.78	36.28	37.44	6624400.0
2021-07-09	AAC-DELISTED	Stock	9.77	9.8192	9.77	9.81	132898.0
2021-07-09	AACG	Stock	2.68	2.78	2.67	2.73	73900.0
2021-07-09	AAIC-DELISTED	Stock	3.87	3.97	3.825	3.965	209908.0
2021-07-09	AAIC.C-DELISTED	Stock	25.3	25.4	25.2	25.2	5300.0
2021-07-09	AAL	Stock	20.79	21.0	20.5	20.89	21730900.0
2021-07-09	AAM.A-DELISTED	Stock	26.64	26.64	26.4	26.51	8092.0
2021-07-09	AAM.B-DELISTED	Stock	26.97	27.075	26.97	27.01	4334.0
2021-07-09	AAMC-DELISTED	Stock	5.25	5.3706	5.1971	5.2588	83144.0
2021-07-09	AAME	Stock	4.33	4.42	4.25	4.36	43500.0
2021-07-09	AAMI	Stock	23.94	24.22	23.68	24.16	346300.0
2021-07-09	AAN-DELISTED	Stock	30.2	30.93	29.89	30.8	315500.0
2021-07-09	AAOI	Stock	7.78	8.09	7.77	8.02	415200.0
2021-07-09	AAON	Stock	42.1933	42.54	41.4733	42.1133	124200.0
2021-07-09	AAP	Stock	213.05	213.68	210.0	213.47	653900.0
2021-07-09	AAQC-DELISTED	Stock	9.68	9.69	9.67	9.68	26256.0
2021-07-09	AAT	Stock	36.97	37.82	36.97	37.79	175700.0
2021-07-09	AAU-DELISTED	Stock	0.4578	0.4706	0.4572	0.4655	547428.0
2021-07-09	AAUAF-DELISTED	Stock	0.4578	0.4706	0.4572	0.4655	570875.0
2021-07-09	AAWW-DELISTED	Stock	66.92	67.93	66.785	67.81	219830.0
2021-07-09	AAXJ	Stock	91.12	91.7214	90.91	91.65	483667.0
2021-07-09	AB	Stock	45.0	46.44	45.0	46.29	190800.0
2021-07-09	ABB-DELISTED	Stock	35.63	36.05	35.61	35.98	1206513.0
2021-07-09	ABBNY-DELISTED	Stock	35.63	36.05	35.61	35.98	1385729.0
2021-07-09	ABBV	Stock	116.3	117.33	116.11	116.58	4823400.0
2021-07-09	ABC-DELISTED	Stock	115.29	115.82	114.74	115.09	434633.0
2021-07-09	ABCB	Stock	48.76	49.93	48.28	49.84	436800.0
2021-07-09	ABCL	Stock	18.75	19.42	17.91	19.37	1782200.0
2021-07-09	ABCM-DELISTED	Stock	19.24	19.38	19.07	19.25	244316.0
2021-07-09	ABEO	Stock	36.75	38.5	35.75	38.5	22884.0
2021-07-09	ABEV	Stock	3.34	3.37	3.33	3.36	21363700.0
2021-07-09	ABG	Stock	180.08	185.21	178.5	182.13	123900.0
2021-07-09	ABGI-DELISTED	Stock	9.87	9.87	9.85	9.85	2700.0
2021-07-09	ABM	Stock	42.96	43.69	42.88	43.1	350200.0
2021-07-09	ABMD-DELISTED	Stock	324.67	327.14	321.31	324.43	103131.0
2021-07-09	ABNB	Stock	143.3	150.26	143.3	149.64	7065100.0
2021-07-09	ABOS	Stock	17.78	19.57	17.78	18.9	46100.0
2021-07-09	ABR	Stock	17.65	18.12	17.53	18.11	1486300.0
2021-07-09	ABR.D	Stock	25.5	25.61	25.48	25.6	67814.0

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

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