PREVIEW / stock_daily / 2018-10-02

all stock daily files

  file:    by_date/stock_daily/2018/2018-10-02.parquet
  size:    222 KB
  rows:    6,554
  symbols: 2,747

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-10-02	AAPL	Stock	56.8125	57.5	56.6575	57.32	99152800.0
2018-10-02	MSFT	Stock	115.3	115.84	114.44	115.15	20787200.0
2018-10-02	NVDA	Stock	7.2062	7.319	7.1395	7.162	383964000.0
2018-10-02	AMZN	Stock	99.9995	100.6695	98.2885	98.5655	108014000.0
2018-10-02	GOOGL	Stock	60.3335	61.226	59.983	60.382	40179120.0
2018-10-02	META	Stock	161.58	162.28	158.67	159.33	36031000.0
2018-10-02	TSLA	Stock	20.93	21.1227	19.9433	20.068	176152500.0
2018-10-02	TLT	Stock	116.67	117.13	116.6	116.86	8266949.0
2018-10-02	ES	Stock	61.58	62.32	61.58	62.16	1177700.0
2018-10-02	CL	Stock	67.14	67.8	66.96	67.39	2722600.0
2018-10-02	A	Stock	71.24	71.73	70.98	71.68	2617500.0
2018-10-02	AA	Stock	40.96	41.86	40.86	41.56	4589900.0
2018-10-02	AABA-DELISTED	Stock	66.46	66.84	66.02	66.6299	3415274.0
2018-10-02	AAC-DELISTED	Stock	7.42	7.43	6.87	6.9	174750.0
2018-10-02	AACG	Stock	0.96	1.0	0.88	0.93	234000.0
2018-10-02	AAIC-DELISTED	Stock	9.13	9.1999	9.02	9.03	642660.0
2018-10-02	AAL	Stock	39.6	39.6	38.4	38.5	7625000.0
2018-10-02	AAM.A-DELISTED	Stock	24.82	25.03	24.82	24.89	31637.0
2018-10-02	AAM.B-DELISTED	Stock	24.73	24.73	24.6	24.6101	43682.0
2018-10-02	AAMC-DELISTED	Stock	17.3529	17.3529	17.3529	17.3529	3845.0
2018-10-02	AAME	Stock	2.7	2.7	2.45	2.45	5900.0
2018-10-02	AAMI	Stock	12.22	12.34	12.04	12.15	431700.0
2018-10-02	AAOI	Stock	23.9	24.69	23.05	23.36	1385700.0
2018-10-02	AAON	Stock	24.28	24.4467	23.5667	23.5867	312450.0
2018-10-02	AAP	Stock	170.47	171.13	168.03	168.4	819300.0
2018-10-02	AAT	Stock	36.97	37.14	36.74	36.78	154400.0
2018-10-02	AAU-DELISTED	Stock	0.6	0.6139	0.5904	0.6099	86618.0
2018-10-02	AAUAF-DELISTED	Stock	0.6	0.6139	0.5904	0.6099	91411.0
2018-10-02	AAWW-DELISTED	Stock	61.84	62.59	61.83	62.11	94584.0
2018-10-02	AAXJ	Stock	69.34	69.55	69.06	69.25	1035882.0
2018-10-02	AAXN-DELISTED	Stock	66.28	66.48	63.635	64.23	380925.0
2018-10-02	AB	Stock	30.78	30.92	30.43	30.47	251600.0
2018-10-02	ABAC-DELISTED	Stock	1.98	1.9963	1.83	1.8625	11481.0
2018-10-02	ABB-DELISTED	Stock	22.98	23.22	22.97	23.185	1830747.0
2018-10-02	ABBNY-DELISTED	Stock	22.98	23.22	22.97	23.18	2354378.0
2018-10-02	ABBV	Stock	95.34	95.35	93.47	94.23	6792200.0
2018-10-02	ABC-DELISTED	Stock	92.51	93.16	91.39	91.4	994927.0
2018-10-02	ABCB	Stock	44.94	45.1	44.48	44.74	230100.0
2018-10-02	ABCD-DELISTED	Stock	11.69	11.72	11.22	11.45	84184.0
2018-10-02	ABDC-DELISTED	Stock	6.0	6.05	5.97	6.05	134970.0
2018-10-02	ABEO	Stock	313.5	317.5	283.5	291.5	41560.0
2018-10-02	ABEV	Stock	4.69	4.69	4.6	4.65	28736600.0
2018-10-02	ABG	Stock	68.25	68.47	66.93	67.05	181800.0
2018-10-02	ABIL-DELISTED	Stock	3.48	3.519	3.32	3.3468	74622.0
2018-10-02	ABM	Stock	32.13	32.87	31.99	32.43	812500.0
2018-10-02	ABMD-DELISTED	Stock	442.92	442.92	426.39	429.3	615224.0
2018-10-02	ABR	Stock	11.38	11.44	11.35	11.43	599600.0
2018-10-02	ABR.A-DELISTED	Stock	25.66	25.66	25.45	25.56	3041.0
2018-10-02	ABR.C-DELISTED	Stock	26.1678	26.1678	26.06	26.06	416.0
2018-10-02	ABT	Stock	74.0	74.05	73.42	73.81	6251200.0

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

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