PREVIEW / stock_daily / 2018-12-28

all stock daily files

  file:    by_date/stock_daily/2018/2018-12-28.parquet
  size:    219 KB
  rows:    6,586
  symbols: 2,701

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-28	AAPL	Stock	39.375	39.63	38.6375	39.0575	169165600.0
2018-12-28	MSFT	Stock	102.09	102.41	99.52	100.39	38196300.0
2018-12-28	NVDA	Stock	3.3	3.4348	3.2578	3.3413	628728000.0
2018-12-28	AMZN	Stock	73.6675	75.6735	72.45	73.901	176580000.0
2018-12-28	GOOGL	Stock	52.975	53.2115	52.1	52.334	34367040.0
2018-12-28	META	Stock	135.34	135.92	132.2	133.2	22627600.0
2018-12-28	TSLA	Stock	21.54	22.416	21.2273	22.258	149085000.0
2018-12-28	TLT	Stock	120.4	121.05	120.29	121.05	9879116.0
2018-12-28	ES	Stock	64.83	65.48	64.47	64.67	1095900.0
2018-12-28	CL	Stock	59.84	60.35	59.41	59.62	5655700.0
2018-12-28	A	Stock	66.98	67.12	65.71	65.96	1927700.0
2018-12-28	AA	Stock	27.09	27.265	26.24	26.6	3010400.0
2018-12-28	AABA-DELISTED	Stock	58.21	58.99	57.59	58.35	3414496.0
2018-12-28	AAC-DELISTED	Stock	1.48	1.53	1.4	1.4	396456.0
2018-12-28	AACG	Stock	0.96	1.0	0.95	1.0	41100.0
2018-12-28	AAIC-DELISTED	Stock	7.52	7.6527	7.4	7.54	605328.0
2018-12-28	AAL	Stock	32.17	32.6	31.51	31.83	6379400.0
2018-12-28	AAM.A-DELISTED	Stock	21.83	22.1799	21.75	22.0	89492.0
2018-12-28	AAM.B-DELISTED	Stock	21.9939	22.2299	21.88	21.92	85942.0
2018-12-28	AAMC-DELISTED	Stock	11.1882	11.3971	10.8824	11.15	5035.0
2018-12-28	AAME	Stock	2.25	2.38	2.25	2.38	1500.0
2018-12-28	AAMI	Stock	10.62	10.75	10.51	10.52	762000.0
2018-12-28	AAOI	Stock	14.94	15.32	14.57	15.03	662400.0
2018-12-28	AAON	Stock	22.56	23.4667	22.56	23.2333	234600.0
2018-12-28	AAP	Stock	155.34	157.3	153.64	155.46	1009500.0
2018-12-28	AAT	Stock	40.25	40.92	39.59	40.07	219000.0
2018-12-28	AAU-DELISTED	Stock	0.59	0.6544	0.59	0.6399	203570.0
2018-12-28	AAUAF-DELISTED	Stock	0.59	0.6544	0.59	0.6399	208944.0
2018-12-28	AAWW-DELISTED	Stock	42.67	43.12	40.79	41.33	198435.0
2018-12-28	AAXJ	Stock	63.67	64.12	63.48	63.71	1256455.0
2018-12-28	AAXN-DELISTED	Stock	43.04	43.74	42.02	43.02	496145.0
2018-12-28	AB	Stock	26.28	27.04	26.28	26.82	642300.0
2018-12-28	ABAC-DELISTED	Stock	0.8705	0.8705	0.85	0.85	10187.0
2018-12-28	ABB-DELISTED	Stock	19.1	19.185	18.845	18.935	3491780.0
2018-12-28	ABBNY-DELISTED	Stock	19.1	19.185	18.845	18.93	3587750.0
2018-12-28	ABBV	Stock	90.09	92.82	90.0	91.12	6037700.0
2018-12-28	ABC-DELISTED	Stock	73.9	75.08	72.81	73.96	1321574.0
2018-12-28	ABCB	Stock	30.91	31.91	30.5	31.44	569600.0
2018-12-28	ABDC-DELISTED	Stock	6.36	6.5	6.24	6.41	46863.0
2018-12-28	ABEO	Stock	166.25	177.25	164.5	175.5	20088.0
2018-12-28	ABEV	Stock	3.89	4.0	3.89	3.9	11550200.0
2018-12-28	ABG	Stock	64.94	66.32	64.8	65.71	121200.0
2018-12-28	ABIL-DELISTED	Stock	2.61	2.78	1.9	2.0	9426018.0
2018-12-28	ABM	Stock	31.04	31.64	30.67	31.09	999800.0
2018-12-28	ABMD-DELISTED	Stock	317.47	324.7767	314.0	318.17	363187.0
2018-12-28	ABR	Stock	10.23	10.33	10.15	10.24	964400.0
2018-12-28	ABR.A-DELISTED	Stock	24.55	24.99	24.475	24.99	2800.0
2018-12-28	ABR.B-DELISTED	Stock	24.09	24.82	24.0646	24.8	5116.0
2018-12-28	ABR.C-DELISTED	Stock	25.241	26.19	25.241	26.17	12918.0
2018-12-28	ABT	Stock	71.05	72.05	70.3	71.09	6209600.0

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

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