PREVIEW / stock_daily / 2019-02-08

all stock daily files

  file:    by_date/stock_daily/2019/2019-02-08.parquet
  size:    218 KB
  rows:    6,497
  symbols: 2,603

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
2019-02-08	AAPL	Stock	42.2475	42.665	42.105	42.6025	95280000.0
2019-02-08	MSFT	Stock	104.39	105.78	104.26	105.67	21461100.0
2019-02-08	NVDA	Stock	3.6178	3.715	3.6032	3.7042	461604000.0
2019-02-08	AMZN	Stock	79.3	79.4295	78.338	79.411	113150000.0
2019-02-08	GOOGL	Stock	54.744	55.2548	54.712	55.119	21766540.0
2019-02-08	META	Stock	164.47	167.37	164.21	167.33	12561400.0
2019-02-08	TSLA	Stock	20.4553	20.4967	19.9	20.3867	87663000.0
2019-02-08	TLT	Stock	122.26	122.47	122.07	122.35	5885427.0
2019-02-08	ES	Stock	69.8	70.08	69.4	70.05	2071600.0
2019-02-08	CL	Stock	64.92	65.69	64.75	65.69	3040100.0
2019-02-08	A	Stock	75.07	75.81	74.76	75.8	1318100.0
2019-02-08	AA	Stock	27.12	27.68	26.51	27.65	4784900.0
2019-02-08	AABA-DELISTED	Stock	67.47	68.7	67.41	68.48	2290195.0
2019-02-08	AAC-DELISTED	Stock	2.72	3.0	2.7039	2.8	482268.0
2019-02-08	AACG	Stock	1.03	1.08	1.03	1.04	37400.0
2019-02-08	AAIC-DELISTED	Stock	8.71	8.72	8.6228	8.68	337486.0
2019-02-08	AAL	Stock	35.8	36.23	35.39	36.0	4973300.0
2019-02-08	AAM.A-DELISTED	Stock	24.4324	24.6	24.4324	24.57	16996.0
2019-02-08	AAM.B-DELISTED	Stock	24.34	24.4	24.3	24.39	70655.0
2019-02-08	AAMC-DELISTED	Stock	8.8235	8.8235	8.8235	8.8235	663.0
2019-02-08	AAME	Stock	2.68	2.68	2.68	2.68	200.0
2019-02-08	AAMI	Stock	12.99	13.37	12.945	13.36	1269500.0
2019-02-08	AAOI	Stock	15.66	16.095	15.59	15.88	563100.0
2019-02-08	AAON	Stock	24.7667	25.2133	24.5933	25.2067	112350.0
2019-02-08	AAP	Stock	161.99	163.61	161.12	162.41	740700.0
2019-02-08	AAT	Stock	43.8	44.12	43.8	43.99	133800.0
2019-02-08	AAU-DELISTED	Stock	0.71	0.7159	0.7	0.7001	163824.0
2019-02-08	AAUAF-DELISTED	Stock	0.71	0.7159	0.7	0.7001	176891.0
2019-02-08	AAWW-DELISTED	Stock	51.12	51.67	50.25	51.57	156516.0
2019-02-08	AAXJ	Stock	67.97	68.3	67.8	68.24	782575.0
2019-02-08	AAXN-DELISTED	Stock	51.75	51.83	50.81	51.43	264693.0
2019-02-08	AB	Stock	30.0	30.68	29.7	30.5	319200.0
2019-02-08	ABB-DELISTED	Stock	19.05	19.2	18.97	19.2	2586916.0
2019-02-08	ABBNY-DELISTED	Stock	19.05	19.2	18.97	19.2	2798437.0
2019-02-08	ABBV	Stock	79.03	79.86	78.89	79.67	4598900.0
2019-02-08	ABC-DELISTED	Stock	85.3	85.445	83.7	84.31	1325803.0
2019-02-08	ABCB	Stock	38.19	38.36	37.42	37.74	280000.0
2019-02-08	ABDC-DELISTED	Stock	7.3	7.41	7.3	7.31	8381.0
2019-02-08	ABEO	Stock	165.5	169.25	158.25	163.25	13484.0
2019-02-08	ABEV	Stock	5.03	5.05	4.78	4.8	94192400.0
2019-02-08	ABG	Stock	69.18	69.66	68.67	69.02	221800.0
2019-02-08	ABIL-DELISTED	Stock	1.86	1.88	1.75	1.8399	180267.0
2019-02-08	ABM	Stock	34.53	34.75	34.3	34.61	234500.0
2019-02-08	ABMD-DELISTED	Stock	338.53	341.52	336.935	341.26	230178.0
2019-02-08	ABR	Stock	11.83	11.91	11.77	11.9	355000.0
2019-02-08	ABR.A-DELISTED	Stock	25.53	25.6	25.51	25.53	1931.0
2019-02-08	ABR.B-DELISTED	Stock	25.7	25.7	25.5087	25.68	2148.0
2019-02-08	ABR.C-DELISTED	Stock	25.68	25.8	25.6	25.72	6140.0
2019-02-08	ABT	Stock	72.16	73.48	72.12	73.33	6063700.0
2019-02-08	ABTC	Stock	305100.0	305100.0	303600.0	304200.0	1.7466666666666666

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

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