PREVIEW / stock_daily / 2018-12-19

all stock daily files

  file:    by_date/stock_daily/2018/2018-12-19.parquet
  size:    220 KB
  rows:    6,570
  symbols: 2,697

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-19	AAPL	Stock	41.5	41.8625	39.7725	40.2225	196189200.0
2018-12-19	MSFT	Stock	103.65	106.88	101.35	103.69	68198200.0
2018-12-19	NVDA	Stock	3.6395	3.6935	3.4108	3.4628	745364000.0
2018-12-19	AMZN	Stock	77.1525	79.2265	74.159	74.754	175844000.0
2018-12-19	GOOGL	Stock	52.3645	53.7855	50.9715	51.773	58264740.0
2018-12-19	META	Stock	141.21	144.91	132.5	133.24	57404900.0
2018-12-19	TSLA	Stock	22.5067	23.134	21.9827	22.198	124113000.0
2018-12-19	TLT	Stock	120.11	121.66	119.92	121.18	23046272.0
2018-12-19	ES	Stock	67.36	68.18	66.69	67.29	1776900.0
2018-12-19	CL	Stock	62.43	63.15	61.5	61.88	4225400.0
2018-12-19	A	Stock	68.27	69.09	65.81	66.83	2845500.0
2018-12-19	AA	Stock	28.32	29.43	27.04	27.61	4941600.0
2018-12-19	AABA-DELISTED	Stock	58.93	59.33	57.16	57.69	8890080.0
2018-12-19	AAC-DELISTED	Stock	1.98	1.98	1.77	1.78	370536.0
2018-12-19	AACG	Stock	0.99	1.06	0.94	1.02	42800.0
2018-12-19	AAIC-DELISTED	Stock	8.0	8.14	7.89	7.94	335027.0
2018-12-19	AAL	Stock	33.46	33.98	32.23	32.42	8120500.0
2018-12-19	AAM.A-DELISTED	Stock	21.29	21.77	21.29	21.45	91561.0
2018-12-19	AAM.B-DELISTED	Stock	21.49	21.6368	21.2	21.35	99026.0
2018-12-19	AAMC-DELISTED	Stock	12.1126	12.3206	11.7676	11.7676	3638.0
2018-12-19	AAME	Stock	2.34	2.39	2.33	2.33	3300.0
2018-12-19	AAMI	Stock	10.75	10.95	10.48	10.53	766000.0
2018-12-19	AAOI	Stock	15.41	16.1	14.63	14.91	1467800.0
2018-12-19	AAON	Stock	23.08	23.7067	22.34	22.4533	241500.0
2018-12-19	AAP	Stock	158.71	160.49	155.43	156.12	1174300.0
2018-12-19	AAT	Stock	41.16	41.16	40.16	40.48	249800.0
2018-12-19	AAU-DELISTED	Stock	0.59	0.6165	0.5826	0.5852	262127.0
2018-12-19	AAUAF-DELISTED	Stock	0.59	0.6165	0.5826	0.5852	299765.0
2018-12-19	AAWW-DELISTED	Stock	41.83	41.86	39.01	39.2	650243.0
2018-12-19	AAXJ	Stock	64.04	64.48	62.41	62.86	2122125.0
2018-12-19	AAXN-DELISTED	Stock	44.45	45.53	44.35	44.86	656749.0
2018-12-19	AB	Stock	25.53	26.47	25.11	25.12	591100.0
2018-12-19	ABAC-DELISTED	Stock	1.12	1.13	1.0	1.1	1994.0
2018-12-19	ABB-DELISTED	Stock	19.48	19.57	18.935	19.06	2938396.0
2018-12-19	ABBNY-DELISTED	Stock	19.48	19.57	18.935	19.06	3127710.0
2018-12-19	ABBV	Stock	84.33	86.3	82.65	83.52	5510800.0
2018-12-19	ABC-DELISTED	Stock	76.49	78.67	75.66	76.31	1387867.0
2018-12-19	ABCB	Stock	32.72	33.48	31.66	32.01	1006000.0
2018-12-19	ABDC-DELISTED	Stock	6.5	6.56	6.4	6.41	44892.0
2018-12-19	ABEO	Stock	178.75	184.75	165.75	169.25	28152.0
2018-12-19	ABEV	Stock	3.99	4.06	3.86	3.89	18563300.0
2018-12-19	ABG	Stock	66.7	67.36	64.22	64.43	194300.0
2018-12-19	ABIL-DELISTED	Stock	2.25	2.3111	2.18	2.2152	156501.0
2018-12-19	ABM	Stock	26.5	32.43	26.43	30.78	3126900.0
2018-12-19	ABMD-DELISTED	Stock	305.0	314.66	290.45	296.13	484557.0
2018-12-19	ABR	Stock	10.87	10.88	10.53	10.6	2008300.0
2018-12-19	ABR.A-DELISTED	Stock	24.86	24.9499	24.02	24.3773	11820.0
2018-12-19	ABR.B-DELISTED	Stock	24.683	24.7173	24.28	24.5999	4037.0
2018-12-19	ABR.C-DELISTED	Stock	24.4	25.39	24.4	25.39	4556.0
2018-12-19	ABT	Stock	70.34	71.47	68.19	69.0	7339700.0

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

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