PREVIEW / stock_daily / 2021-09-27

all stock daily files

  file:    by_date/stock_daily/2021/2021-09-27.parquet
  size:    257 KB
  rows:    7,895
  symbols: 2,704

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-09-27	AAPL	Stock	145.47	145.96	143.82	145.37	74150700.0
2021-09-27	MSFT	Stock	296.14	296.47	292.94	294.17	23571700.0
2021-09-27	NVDA	Stock	21.71	21.799	21.325	21.66	245215000.0
2021-09-27	AMZN	Stock	168.575	170.7785	166.9805	170.29	72690000.0
2021-09-27	GOOGL	Stock	140.8043	141.9385	140.0675	141.072	21881960.0
2021-09-27	META	Stock	349.81	355.15	347.08	353.58	15205800.0
2021-09-27	TSLA	Stock	257.7067	266.3333	256.4367	263.7867	84212100.0
2021-09-27	TLT	Stock	146.06	146.87	145.88	146.37	13464252.0
2021-09-27	ES	Stock	82.73	83.61	81.37	81.5	1027800.0
2021-09-27	CL	Stock	76.5	76.66	75.92	76.01	2899700.0
2021-09-27	A	Stock	171.06	171.15	164.26	166.38	1419700.0
2021-09-27	AA	Stock	48.56	51.71	48.48	51.56	8264600.0
2021-09-27	AAC-DELISTED	Stock	9.73	9.76	9.73	9.75	21357.0
2021-09-27	AACG	Stock	2.4	2.4	2.35	2.37	20300.0
2021-09-27	AACIU	Stock	9.8342	9.91	9.8342	9.9	2435.0
2021-09-27	AAIC-DELISTED	Stock	3.75	3.81	3.75	3.76	77545.0
2021-09-27	AAL	Stock	21.77	22.19	21.46	21.47	33190500.0
2021-09-27	AAM.A-DELISTED	Stock	25.685	25.73	25.64	25.73	9508.0
2021-09-27	AAM.B-DELISTED	Stock	26.74	26.76	26.67	26.76	11195.0
2021-09-27	AAMC-DELISTED	Stock	7.0588	7.4559	6.8706	6.8706	319892.0
2021-09-27	AAME	Stock	4.02	4.04	3.94	4.0	22100.0
2021-09-27	AAMI	Stock	26.69	27.015	26.69	26.8	291500.0
2021-09-27	AAN-DELISTED	Stock	27.76	29.315	27.525	28.85	168600.0
2021-09-27	AAOI	Stock	7.27	7.51	7.24	7.24	297000.0
2021-09-27	AAON	Stock	44.6067	45.3267	44.5333	44.8667	230400.0
2021-09-27	AAP	Stock	216.85	220.12	216.79	218.46	571600.0
2021-09-27	AAQC-DELISTED	Stock	9.7	9.7	9.7	9.7	200.0
2021-09-27	AAT	Stock	38.82	39.64	38.63	38.65	290100.0
2021-09-27	AATC	Stock	7.76	7.82	7.6538	7.8	24541.0
2021-09-27	AAU-DELISTED	Stock	0.4	0.404	0.39	0.3982	338811.0
2021-09-27	AAUAF-DELISTED	Stock	0.4	0.404	0.39	0.3982	344152.0
2021-09-27	AAWW-DELISTED	Stock	78.83	83.82	78.79	82.37	662087.0
2021-09-27	AAXJ	Stock	85.82	86.33	85.43	86.15	544306.0
2021-09-27	AB	Stock	52.11	52.5	51.53	51.67	210000.0
2021-09-27	ABB-DELISTED	Stock	34.41	34.68	34.355	34.45	1371373.0
2021-09-27	ABBNY-DELISTED	Stock	34.41	34.68	34.355	34.45	1548866.0
2021-09-27	ABBV	Stock	107.13	108.64	107.02	107.72	4969600.0
2021-09-27	ABC-DELISTED	Stock	122.12	123.33	122.08	122.63	473932.0
2021-09-27	ABCB	Stock	51.26	53.63	51.26	53.05	436200.0
2021-09-27	ABCL	Stock	21.17	21.46	20.47	20.99	2619200.0
2021-09-27	ABCM-DELISTED	Stock	20.59	20.71	20.4	20.68	28793.0
2021-09-27	ABEO	Stock	29.25	30.0	28.25	29.5	30204.0
2021-09-27	ABEV	Stock	2.92	2.94	2.87	2.88	35603100.0
2021-09-27	ABG	Stock	197.52	204.87	196.43	202.92	111400.0
2021-09-27	ABGI-DELISTED	Stock	9.705	9.705	9.705	9.705	100.0
2021-09-27	ABM	Stock	45.03	46.05	45.03	45.41	219000.0
2021-09-27	ABMD-DELISTED	Stock	347.37	347.37	332.5	338.44	94789.0
2021-09-27	ABNB	Stock	175.0	176.319	172.02	174.26	3551400.0
2021-09-27	ABOS	Stock	15.94	16.29	15.47	15.92	179600.0
2021-09-27	ABR	Stock	18.43	18.73	18.42	18.56	1192400.0

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

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