PREVIEW / stock_daily / 2018-12-12

all stock daily files

  file:    by_date/stock_daily/2018/2018-12-12.parquet
  size:    220 KB
  rows:    6,577
  symbols: 2,709

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-12	AAPL	Stock	42.6	42.98	42.255	42.275	142510800.0
2018-12-12	MSFT	Stock	110.89	111.27	109.04	109.08	36183000.0
2018-12-12	NVDA	Stock	3.7105	3.8195	3.6205	3.7225	654136000.0
2018-12-12	AMZN	Stock	83.45	85.2495	83.0135	83.177	131960000.0
2018-12-12	GOOGL	Stock	53.854	54.5866	53.5985	53.6865	28959460.0
2018-12-12	META	Stock	143.08	147.19	142.51	144.5	23696900.0
2018-12-12	TSLA	Stock	24.628	24.794	24.344	24.44	75405000.0
2018-12-12	TLT	Stock	118.58	118.72	118.24	118.35	6182206.0
2018-12-12	ES	Stock	70.0	70.5	69.42	69.45	2220600.0
2018-12-12	CL	Stock	64.89	65.64	64.77	65.28	5902200.0
2018-12-12	A	Stock	72.17	73.04	71.6	71.75	2842900.0
2018-12-12	AA	Stock	28.89	29.99	28.82	29.24	3116400.0
2018-12-12	AABA-DELISTED	Stock	63.645	64.0	62.665	62.85	6597778.0
2018-12-12	AAC-DELISTED	Stock	2.76	2.83	2.4	2.4	399533.0
2018-12-12	AACG	Stock	1.09	1.1	1.01	1.05	77200.0
2018-12-12	AAIC-DELISTED	Stock	8.42	8.44	8.3	8.31	253787.0
2018-12-12	AAL	Stock	34.55	34.79	34.09	34.35	7630500.0
2018-12-12	AAM.A-DELISTED	Stock	22.51	22.75	22.3	22.3	106364.0
2018-12-12	AAM.B-DELISTED	Stock	22.46	22.61	22.25	22.27	64919.0
2018-12-12	AAMC-DELISTED	Stock	13.8236	14.2621	12.4515	13.7794	13593.0
2018-12-12	AAME	Stock	2.41	2.41	2.35	2.35	700.0
2018-12-12	AAMI	Stock	11.53	11.82	11.41	11.6	301900.0
2018-12-12	AAOI	Stock	20.04	20.2	19.54	19.84	441100.0
2018-12-12	AAON	Stock	23.8933	24.2867	23.6867	23.9467	147300.0
2018-12-12	AAP	Stock	166.95	168.86	166.12	166.98	1461100.0
2018-12-12	AAT	Stock	41.92	41.92	40.95	41.14	355800.0
2018-12-12	AAU-DELISTED	Stock	0.68	0.68	0.63	0.6729	357345.0
2018-12-12	AAUAF-DELISTED	Stock	0.68	0.68	0.63	0.6729	359819.0
2018-12-12	AAWW-DELISTED	Stock	48.6	49.53	48.115	48.57	137484.0
2018-12-12	AAXJ	Stock	65.95	66.43	65.8	65.8	2706485.0
2018-12-12	AAXN-DELISTED	Stock	45.88	46.88	45.0	45.59	910518.0
2018-12-12	AB	Stock	26.69	27.47	26.68	27.25	807800.0
2018-12-12	ABAC-DELISTED	Stock	1.23	1.24	1.1575	1.18	5429.0
2018-12-12	ABB-DELISTED	Stock	19.87	19.99	19.74	19.74	3332120.0
2018-12-12	ABBNY-DELISTED	Stock	19.87	19.99	19.74	19.75	3535928.0
2018-12-12	ABBV	Stock	89.32	90.17	88.36	88.6	4185100.0
2018-12-12	ABC-DELISTED	Stock	83.08	84.98	83.07	83.22	983828.0
2018-12-12	ABCB	Stock	36.54	36.74	35.9	36.28	224500.0
2018-12-12	ABCD-DELISTED	Stock	14.47	14.49	14.46	14.47	156804.0
2018-12-12	ABDC-DELISTED	Stock	6.62	7.0533	6.6	7.0	143869.0
2018-12-12	ABEO	Stock	200.0	213.25	200.0	207.0	23320.0
2018-12-12	ABEV	Stock	4.13	4.16	4.07	4.09	24248000.0
2018-12-12	ABG	Stock	64.2	65.98	64.07	64.66	165100.0
2018-12-12	ABIL-DELISTED	Stock	2.62	2.74	2.2601	2.4001	2908968.0
2018-12-12	ABM	Stock	27.41	27.63	27.03	27.29	456000.0
2018-12-12	ABMD-DELISTED	Stock	335.0	341.09	330.32	330.62	260485.0
2018-12-12	ABR	Stock	11.7	11.86	11.67	11.77	1660600.0
2018-12-12	ABR.A-DELISTED	Stock	25.46	25.48	25.46	25.48	520.0
2018-12-12	ABR.B-DELISTED	Stock	25.3476	25.4	25.3476	25.4	500.0
2018-12-12	ABR.C-DELISTED	Stock	25.83	25.9	25.8	25.8	1650.0

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

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