PREVIEW / stock_daily / 2019-03-12

all stock daily files

  file:    by_date/stock_daily/2019/2019-03-12.parquet
  size:    220 KB
  rows:    6,533
  symbols: 2,607

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-03-12	AAPL	Stock	45.0	45.6675	44.8425	45.2275	129870400.0
2019-03-12	MSFT	Stock	112.82	113.99	112.65	113.62	26132700.0
2019-03-12	NVDA	Stock	4.0565	4.1098	3.9798	4.063	579576000.0
2019-03-12	AMZN	Stock	83.45	84.2135	83.049	83.655	72290000.0
2019-03-12	GOOGL	Stock	59.115	60.2855	59.115	59.8625	42219580.0
2019-03-12	META	Stock	172.09	173.8	171.22	171.92	12155300.0
2019-03-12	TSLA	Stock	19.0993	19.2047	18.7373	18.8907	112561500.0
2019-03-12	TLT	Stock	121.3	122.23	121.255	122.06	6422386.0
2019-03-12	ES	Stock	70.54	70.75	70.14	70.51	1976600.0
2019-03-12	CL	Stock	65.97	66.39	65.59	65.74	2502900.0
2019-03-12	A	Stock	79.58	80.13	79.16	79.93	1532300.0
2019-03-12	AA	Stock	27.73	28.59	27.6	28.44	3112600.0
2019-03-12	AABA-DELISTED	Stock	73.92	74.16	73.25	73.58	2630601.0
2019-03-12	AAC-DELISTED	Stock	2.57	2.7945	2.57	2.77	260708.0
2019-03-12	AACG	Stock	1.08	1.09	1.05	1.05	20200.0
2019-03-12	AAIC-DELISTED	Stock	8.1	8.23	8.08	8.11	478945.0
2019-03-12	AAL	Stock	32.19	32.19	30.88	30.92	10887500.0
2019-03-12	AAM.A-DELISTED	Stock	25.0	25.14	25.0	25.01	23601.0
2019-03-12	AAM.B-DELISTED	Stock	24.86	24.89	24.7258	24.84	30623.0
2019-03-12	AAMC-DELISTED	Stock	10.5382	10.5382	9.9118	10.0882	13410.0
2019-03-12	AAME	Stock	2.52	2.53	2.52	2.52	1700.0
2019-03-12	AAMI	Stock	13.75	13.765	13.59	13.68	538100.0
2019-03-12	AAOI	Stock	13.29	13.75	13.11	13.49	721000.0
2019-03-12	AAON	Stock	27.5933	27.9933	27.26	27.7133	141900.0
2019-03-12	AAP	Stock	155.62	155.62	152.9	154.87	871900.0
2019-03-12	AAT	Stock	45.73	46.0	45.51	45.79	130100.0
2019-03-12	AAU-DELISTED	Stock	0.6	0.6045	0.5601	0.5999	297879.0
2019-03-12	AAUAF-DELISTED	Stock	0.6	0.6046	0.5601	0.5999	308802.0
2019-03-12	AAWW-DELISTED	Stock	49.29	49.77	49.01	49.29	120342.0
2019-03-12	AAXJ	Stock	69.75	69.91	69.59	69.79	654305.0
2019-03-12	AAXN-DELISTED	Stock	47.96	48.52	47.12	48.32	377953.0
2019-03-12	AB	Stock	29.05	29.28	29.01	29.08	157900.0
2019-03-12	ABB-DELISTED	Stock	18.97	19.07	18.92	18.93	1934869.0
2019-03-12	ABBNY-DELISTED	Stock	18.97	19.07	18.92	18.93	1999683.0
2019-03-12	ABBV	Stock	78.48	79.14	78.05	78.74	6128800.0
2019-03-12	ABC-DELISTED	Stock	78.1	79.12	78.1	78.43	1185172.0
2019-03-12	ABCB	Stock	38.41	38.72	37.99	38.23	260500.0
2019-03-12	ABDC-DELISTED	Stock	7.54	7.82	7.51	7.54	135423.0
2019-03-12	ABEO	Stock	188.75	195.25	186.75	191.0	21164.0
2019-03-12	ABEV	Stock	4.43	4.51	4.39	4.41	24793700.0
2019-03-12	ABG	Stock	68.08	68.24	67.38	68.0	111800.0
2019-03-12	ABIL-DELISTED	Stock	1.84	1.915	1.8	1.84	51062.0
2019-03-12	ABM	Stock	33.59	33.89	33.2	33.27	474200.0
2019-03-12	ABMD-DELISTED	Stock	319.64	324.24	318.3292	324.15	160609.0
2019-03-12	ABR	Stock	12.75	12.83	12.71	12.8	801500.0
2019-03-12	ABR.A-DELISTED	Stock	25.6011	25.67	25.6011	25.67	266.0
2019-03-12	ABR.B-DELISTED	Stock	25.7	25.96	25.5	25.81	3000.0
2019-03-12	ABR.C-DELISTED	Stock	26.0	26.0	25.8499	25.8499	2460.0
2019-03-12	ABT	Stock	77.99	78.48	77.63	78.24	4241200.0
2019-03-12	ABTC	Stock	304500.0	304500.0	303570.0	304500.0	0.29333333333333333

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

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