PREVIEW / stock_daily / 2018-09-17

all stock daily files

  file:    by_date/stock_daily/2018/2018-09-17.parquet
  size:    218 KB
  rows:    6,527
  symbols: 2,739

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-09-17	AAPL	Stock	55.5375	55.7375	54.3175	54.47	148780400.0
2018-09-17	MSFT	Stock	113.69	113.7	111.86	112.14	20736500.0
2018-09-17	NVDA	Stock	6.885	6.9345	6.8288	6.8482	205528000.0
2018-09-17	AMZN	Stock	97.7365	97.841	94.3705	95.4015	141004000.0
2018-09-17	GOOGL	Stock	58.8885	59.091	57.9228	57.9915	34095800.0
2018-09-17	META	Stock	161.92	162.06	159.77	160.58	21005300.0
2018-09-17	TSLA	Stock	19.336	20.058	19.2087	19.656	103314000.0
2018-09-17	TLT	Stock	118.18	118.82	118.12	118.55	5432961.0
2018-09-17	ES	Stock	63.57	63.81	63.21	63.77	984000.0
2018-09-17	CL	Stock	68.0	68.82	67.89	68.81	2874500.0
2018-09-17	A	Stock	69.64	69.66	69.0	69.08	1816600.0
2018-09-17	AA	Stock	42.5	43.5	42.5	42.83	3015500.0
2018-09-17	AABA-DELISTED	Stock	66.82	67.2099	65.64	65.87	6745683.0
2018-09-17	AAC-DELISTED	Stock	7.44	7.54	7.21	7.33	129964.0
2018-09-17	AACG	Stock	1.33	1.36	1.26	1.28	66400.0
2018-09-17	AAIC-DELISTED	Stock	10.06	10.15	10.0	10.15	288807.0
2018-09-17	AAL	Stock	39.7	40.55	39.7	40.32	5072800.0
2018-09-17	AAM.A-DELISTED	Stock	25.39	25.39	25.25	25.25	38771.0
2018-09-17	AAM.B-DELISTED	Stock	24.84	24.8899	24.77	24.82	63906.0
2018-09-17	AAMC-DELISTED	Stock	18.0882	18.0882	18.0882	18.0882	806.0
2018-09-17	AAME	Stock	2.65	3.0	2.45	3.0	11300.0
2018-09-17	AAMI	Stock	12.64	12.72	12.595	12.65	309200.0
2018-09-17	AAOI	Stock	34.07	34.34	33.052	34.04	711400.0
2018-09-17	AAON	Stock	26.8	27.1333	26.3333	27.0	217350.0
2018-09-17	AAP	Stock	167.51	169.76	163.21	163.5	1093400.0
2018-09-17	AAT	Stock	38.25	38.57	38.01	38.49	191800.0
2018-09-17	AAU-DELISTED	Stock	0.64	0.6634	0.64	0.6634	58443.0
2018-09-17	AAUAF-DELISTED	Stock	0.64	0.6634	0.64	0.6634	61237.0
2018-09-17	AAV-DELISTED	Stock	2.6	2.6	2.5	2.55	84852.0
2018-09-17	AAWW-DELISTED	Stock	63.9	63.9	63.15	63.5	261390.0
2018-09-17	AAXJ	Stock	68.96	69.18	68.62	68.71	627564.0
2018-09-17	AAXN-DELISTED	Stock	73.43	74.14	68.3701	68.66	755898.0
2018-09-17	AB	Stock	30.95	31.05	30.35	30.45	233100.0
2018-09-17	ABAC-DELISTED	Stock	2.03	2.42	1.98	2.41	35802.0
2018-09-17	ABB-DELISTED	Stock	24.04	24.11	24.005	24.015	1024083.0
2018-09-17	ABBNY-DELISTED	Stock	24.04	24.11	24.005	24.01	1600524.0
2018-09-17	ABBV	Stock	95.4	96.16	94.8	95.37	3987200.0
2018-09-17	ABC-DELISTED	Stock	86.02	87.39	85.36	86.78	828223.0
2018-09-17	ABCB	Stock	48.15	48.3	46.9	47.25	283100.0
2018-09-17	ABCD-DELISTED	Stock	12.74	12.97	12.371	12.48	98982.0
2018-09-17	ABDC-DELISTED	Stock	6.57	6.57	6.4	6.41	38489.0
2018-09-17	ABEO	Stock	355.0	358.25	342.5	350.0	31440.0
2018-09-17	ABEV	Stock	4.37	4.47	4.35	4.45	24333100.0
2018-09-17	ABG	Stock	73.2	73.5	71.05	71.35	194800.0
2018-09-17	ABIL-DELISTED	Stock	3.98	4.15	3.5	3.5423	492399.0
2018-09-17	ABM	Stock	34.59	34.74	34.32	34.51	422300.0
2018-09-17	ABMD-DELISTED	Stock	395.6	399.62	367.71	368.85	446220.0
2018-09-17	ABR	Stock	12.05	12.06	11.98	12.02	979500.0
2018-09-17	ABR.A-DELISTED	Stock	25.88	25.89	25.8677	25.889	2725.0
2018-09-17	ABR.B-DELISTED	Stock	25.74	25.75	25.6127	25.72	1300.0

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

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