PREVIEW / stock_daily / 2019-01-14

all stock daily files

  file:    by_date/stock_daily/2019/2019-01-14.parquet
  size:    218 KB
  rows:    6,524
  symbols: 2,637

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
2019-01-14	AAPL	Stock	37.7125	37.8175	37.305	37.5	129756800.0
2019-01-14	MSFT	Stock	101.9	102.87	101.26	102.05	28437100.0
2019-01-14	NVDA	Stock	3.668	3.7865	3.6443	3.761	730168000.0
2019-01-14	AMZN	Stock	80.75	82.41	79.7575	80.8605	120118000.0
2019-01-14	GOOGL	Stock	52.667	52.9225	52.4275	52.5755	28489720.0
2019-01-14	META	Stock	142.0	146.57	141.27	145.39	20520300.0
2019-01-14	TSLA	Stock	22.8253	22.8333	22.2667	22.2933	78709500.0
2019-01-14	TLT	Stock	120.9	121.01	120.2416	120.48	6730681.0
2019-01-14	ES	Stock	65.33	65.76	64.73	65.58	2219400.0
2019-01-14	CL	Stock	61.81	62.04	61.37	61.61	3887100.0
2019-01-14	A	Stock	69.72	70.29	69.67	69.75	2182700.0
2019-01-14	AA	Stock	29.06	29.17	27.89	28.79	4035500.0
2019-01-14	AABA-DELISTED	Stock	61.77	62.46	61.15	62.3	8337924.0
2019-01-14	AAC-DELISTED	Stock	2.41	2.97	2.2631	2.91	1001597.0
2019-01-14	AACG	Stock	0.98	1.06	0.96	1.03	31000.0
2019-01-14	AAIC-DELISTED	Stock	7.91	8.0501	7.91	8.01	199899.0
2019-01-14	AAL	Stock	31.4	31.93	30.7	31.71	5878500.0
2019-01-14	AAM.A-DELISTED	Stock	24.12	24.16	24.0	24.12	26512.0
2019-01-14	AAM.B-DELISTED	Stock	24.07	24.14	23.91	24.1	19518.0
2019-01-14	AAMC-DELISTED	Stock	8.8235	9.0868	8.8075	8.9912	7681.0
2019-01-14	AAME	Stock	2.57	2.57	2.44	2.49	6300.0
2019-01-14	AAMI	Stock	11.16	11.48	10.98	11.27	663300.0
2019-01-14	AAOI	Stock	16.22	16.3	15.595	15.95	426500.0
2019-01-14	AAON	Stock	23.68	23.8667	23.3333	23.7467	133800.0
2019-01-14	AAP	Stock	157.79	159.49	156.69	158.72	1307700.0
2019-01-14	AAT	Stock	40.79	41.03	40.48	40.51	384200.0
2019-01-14	AAU-DELISTED	Stock	0.82	0.837	0.8	0.812	243483.0
2019-01-14	AAUAF-DELISTED	Stock	0.82	0.837	0.8	0.812	270699.0
2019-01-14	AAWW-DELISTED	Stock	47.85	48.86	47.4952	47.7	166437.0
2019-01-14	AAXJ	Stock	64.63	65.03	64.48	64.73	894628.0
2019-01-14	AAXN-DELISTED	Stock	49.0	50.11	48.24	49.78	397334.0
2019-01-14	AB	Stock	28.42	28.94	28.17	28.33	455800.0
2019-01-14	ABAC-DELISTED	Stock	1.271	1.8	1.2701	1.401	448707.0
2019-01-14	ABB-DELISTED	Stock	19.29	19.52	19.25	19.42	1613561.0
2019-01-14	ABBNY-DELISTED	Stock	19.29	19.52	19.25	19.41	1674247.0
2019-01-14	ABBV	Stock	86.97	86.97	84.49	84.76	6368500.0
2019-01-14	ABC-DELISTED	Stock	76.03	77.62	76.01	76.84	1302749.0
2019-01-14	ABCB	Stock	34.52	35.2	34.48	34.5	311800.0
2019-01-14	ABDC-DELISTED	Stock	6.85	7.04	6.75	6.92	17891.0
2019-01-14	ABEO	Stock	177.75	179.75	174.25	174.25	18452.0
2019-01-14	ABEV	Stock	4.66	4.7	4.62	4.67	34416900.0
2019-01-14	ABG	Stock	69.13	69.9	68.32	69.12	217100.0
2019-01-14	ABIL-DELISTED	Stock	1.89	1.955	1.85	1.874	407179.0
2019-01-14	ABM	Stock	34.0	34.62	33.7	34.11	659300.0
2019-01-14	ABMD-DELISTED	Stock	321.9	322.0	314.06	315.2	226397.0
2019-01-14	ABR	Stock	11.32	11.39	11.27	11.35	719700.0
2019-01-14	ABR.B-DELISTED	Stock	25.39	25.39	25.205	25.205	1060.0
2019-01-14	ABR.C-DELISTED	Stock	25.5	25.9255	25.5	25.9255	787.0
2019-01-14	ABT	Stock	68.41	68.8	68.13	68.27	5122900.0
2019-01-14	ABTC	Stock	309000.0	309000.0	300300.0	302400.0	0.2533333333333333

> showing 50 of 6,524 rows — these rows as CSV

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