PREVIEW / stock_daily / 2018-12-27

all stock daily files

  file:    by_date/stock_daily/2018/2018-12-27.parquet
  size:    219 KB
  rows:    6,582
  symbols: 2,694

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
2018-12-27	AAPL	Stock	38.96	39.1925	37.5175	39.0375	212468400.0
2018-12-27	MSFT	Stock	99.3	101.19	96.4	101.18	49498500.0
2018-12-27	NVDA	Stock	3.2748	3.3095	3.1295	3.2792	637044000.0
2018-12-27	AMZN	Stock	72.71	73.45	69.5155	73.082	194440000.0
2018-12-27	GOOGL	Stock	51.31	52.667	50.35	52.645	45996120.0
2018-12-27	META	Stock	132.44	134.99	129.67	134.52	31202500.0
2018-12-27	TSLA	Stock	21.3227	21.478	20.1	21.0753	128626500.0
2018-12-27	TLT	Stock	121.26	121.38	119.98	120.04	12146772.0
2018-12-27	ES	Stock	64.26	64.78	63.31	64.78	2316600.0
2018-12-27	CL	Stock	58.99	59.69	57.97	59.69	6546100.0
2018-12-27	A	Stock	64.5	66.5	64.0	66.48	1655000.0
2018-12-27	AA	Stock	26.41	27.16	25.788	27.16	3036600.0
2018-12-27	AABA-DELISTED	Stock	56.84	58.04	56.62	57.98	5772435.0
2018-12-27	AAC-DELISTED	Stock	1.68	1.71	1.49	1.5	254656.0
2018-12-27	AACG	Stock	0.96	1.0	0.96	0.98	69100.0
2018-12-27	AAIC-DELISTED	Stock	7.83	7.857	7.575	7.84	729501.0
2018-12-27	AAL	Stock	31.71	32.05	30.87	32.04	7751300.0
2018-12-27	AAM.A-DELISTED	Stock	21.9	22.0	21.43	21.7496	83280.0
2018-12-27	AAM.B-DELISTED	Stock	22.25	22.25	21.5101	22.0	121816.0
2018-12-27	AAMC-DELISTED	Stock	11.0088	11.1853	10.8912	11.1765	6535.0
2018-12-27	AAME	Stock	2.34	2.37	2.34	2.37	1900.0
2018-12-27	AAMI	Stock	10.29	10.68	10.28	10.56	627100.0
2018-12-27	AAOI	Stock	14.72	15.43	14.33	14.92	651700.0
2018-12-27	AAON	Stock	21.9667	22.6	21.58	22.5533	199200.0
2018-12-27	AAP	Stock	153.44	154.77	149.58	154.69	1123400.0
2018-12-27	AAT	Stock	39.58	39.97	38.69	39.96	263600.0
2018-12-27	AAU-DELISTED	Stock	0.6159	0.6359	0.58	0.6149	289779.0
2018-12-27	AAUAF-DELISTED	Stock	0.6159	0.6359	0.58	0.6149	303734.0
2018-12-27	AAWW-DELISTED	Stock	40.49	42.48	40.0	42.48	292525.0
2018-12-27	AAXJ	Stock	62.6	63.33	62.32	63.31	1622097.0
2018-12-27	AAXN-DELISTED	Stock	41.17	43.01	41.0	43.01	713137.0
2018-12-27	AB	Stock	25.51	26.08	24.75	26.06	594300.0
2018-12-27	ABAC-DELISTED	Stock	0.94	0.95	0.85	0.85	5974.0
2018-12-27	ABB-DELISTED	Stock	18.37	18.63	18.18	18.63	3758912.0
2018-12-27	ABBNY-DELISTED	Stock	18.37	18.63	18.18	18.63	3858618.0
2018-12-27	ABBV	Stock	87.95	89.93	86.86	89.91	7272800.0
2018-12-27	ABC-DELISTED	Stock	72.24	73.53	70.395	73.53	988998.0
2018-12-27	ABCB	Stock	31.0	31.97	29.97	31.04	747600.0
2018-12-27	ABDC-DELISTED	Stock	6.5	6.68	6.41	6.52	79017.0
2018-12-27	ABEO	Stock	165.0	169.25	160.5	166.0	34224.0
2018-12-27	ABEV	Stock	3.86	3.91	3.82	3.91	15575600.0
2018-12-27	ABG	Stock	64.01	64.84	62.69	64.8	239600.0
2018-12-27	ABIL-DELISTED	Stock	1.78	1.83	1.7015	1.7476	125168.0
2018-12-27	ABM	Stock	30.68	31.1	29.97	30.81	744200.0
2018-12-27	ABMD-DELISTED	Stock	302.92	315.91	300.05	315.91	496881.0
2018-12-27	ABR	Stock	10.07	10.22	9.85	10.22	1594300.0
2018-12-27	ABR.A-DELISTED	Stock	24.9725	24.9725	24.38	24.38	4150.0
2018-12-27	ABR.B-DELISTED	Stock	24.1	24.1	24.1	24.1	100.0
2018-12-27	ABR.C-DELISTED	Stock	25.0	25.4194	25.0	25.384	450.0
2018-12-27	ABT	Stock	68.41	70.63	67.79	70.63	6713000.0

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

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