PREVIEW / stock_daily / 2017-12-26

all stock daily files

  file:    by_date/stock_daily/2017/2017-12-26.parquet
  size:    215 KB
  rows:    6,463
  symbols: 2,858

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
2017-12-26	AAPL	Stock	42.7	42.8675	42.42	42.6425	132742000.0
2017-12-26	MSFT	Stock	85.31	85.53	85.03	85.4	9891200.0
2017-12-26	NVDA	Stock	4.8258	4.9438	4.7955	4.936	355080000.0
2017-12-26	AMZN	Stock	58.418	58.916	58.0275	58.838	40104000.0
2017-12-26	GOOGL	Stock	53.432	53.443	52.932	53.2925	18375340.0
2017-12-26	META	Stock	176.63	177.0	174.67	175.99	8897300.0
2017-12-26	TSLA	Stock	21.5887	21.596	21.1053	21.1527	65676000.0
2017-12-26	TLT	Stock	124.98	125.53	124.97	125.14	3168442.0
2017-12-26	ES	Stock	62.62	62.76	61.93	61.96	653800.0
2017-12-26	CL	Stock	75.15	75.72	75.0	75.48	1213900.0
2017-12-26	A	Stock	67.31	67.45	67.05	67.25	532700.0
2017-12-26	AA	Stock	49.98	50.5	49.21	50.38	2759800.0
2017-12-26	AAAP-DELISTED	Stock	81.6	81.63	81.58	81.58	289814.0
2017-12-26	AABA-DELISTED	Stock	70.94	71.39	69.63	69.855	8055709.0
2017-12-26	AAC-DELISTED	Stock	9.06	9.12	9.0	9.02	52413.0
2017-12-26	AACG	Stock	5.05	5.19	5.05	5.19	400.0
2017-12-26	AAIC-DELISTED	Stock	12.5	12.5701	12.47	12.52	496781.0
2017-12-26	AAL	Stock	52.35	53.22	52.33	52.85	2774000.0
2017-12-26	AAM.A-DELISTED	Stock	26.3467	26.3467	26.22	26.22	15893.0
2017-12-26	AAME	Stock	3.65	3.65	3.5	3.6	6300.0
2017-12-26	AAMI	Stock	16.77	16.96	16.77	16.85	166800.0
2017-12-26	AAOI	Stock	39.51	39.91	38.58	38.91	734000.0
2017-12-26	AAON	Stock	24.4667	24.6333	24.2	24.4	214950.0
2017-12-26	AAP	Stock	100.8	102.75	100.65	101.96	565100.0
2017-12-26	AAT	Stock	37.76	38.13	37.55	37.95	102600.0
2017-12-26	AAU-DELISTED	Stock	1.04	1.04	1.01	1.02	144044.0
2017-12-26	AAUAF-DELISTED	Stock	1.04	1.04	1.01	1.02	146826.0
2017-12-26	AAV-DELISTED	Stock	4.1	4.2	4.04	4.175	140066.0
2017-12-26	AAWW-DELISTED	Stock	60.1	60.4	59.65	59.8	64185.0
2017-12-26	AAXJ	Stock	75.34	75.34	75.01	75.26	233076.0
2017-12-26	AAXN-DELISTED	Stock	26.16	26.7	26.16	26.47	179517.0
2017-12-26	AB	Stock	25.45	25.6	25.3	25.4	173300.0
2017-12-26	ABAC-DELISTED	Stock	2.85	3.14	2.85	3.14	968.0
2017-12-26	ABAX-DELISTED	Stock	49.38	50.08	48.83	49.66	120970.0
2017-12-26	ABB-DELISTED	Stock	26.6	26.68	26.59	26.665	598776.0
2017-12-26	ABBNY-DELISTED	Stock	26.6	26.68	26.59	26.66	636092.0
2017-12-26	ABBV	Stock	98.15	98.36	97.05	97.75	2363800.0
2017-12-26	ABC-DELISTED	Stock	92.48	93.88	91.91	93.21	611357.0
2017-12-26	ABCB	Stock	49.15	49.25	48.5	48.6	77700.0
2017-12-26	ABCD-DELISTED	Stock	5.56	5.7	5.56	5.6	12608.0
2017-12-26	ABDC-DELISTED	Stock	8.7	8.76	8.56	8.74	136753.0
2017-12-26	ABE-DELISTED	Stock	14.41	14.66	14.41	14.63	7461.0
2017-12-26	ABEO	Stock	397.5	410.0	391.25	405.0	22032.0
2017-12-26	ABEV	Stock	6.31	6.39	6.25	6.35	8813700.0
2017-12-26	ABG	Stock	64.4	65.08	63.95	64.35	129900.0
2017-12-26	ABIL-DELISTED	Stock	0.42	0.4388	0.4104	0.4265	49892.0
2017-12-26	ABLX-DELISTED	Stock	23.66	23.79	23.421	23.61	47870.0
2017-12-26	ABM	Stock	38.11	38.49	37.77	38.31	506900.0
2017-12-26	ABMD-DELISTED	Stock	191.31	191.46	189.29	189.64	98419.0
2017-12-26	ABR	Stock	8.64	8.69	8.59	8.6	257000.0

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

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