PREVIEW / stock_daily / 2014-01-03

all stock daily files

  file:    by_date/stock_daily/2014/2014-01-03.parquet
  size:    216 KB
  rows:    6,437
  symbols: 3,515

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
2014-01-03	AAPL	Stock	19.745	19.775	19.3011	19.3207	392467600.0
2014-01-03	MSFT	Stock	37.2	37.22	36.6	36.91	31134800.0
2014-01-03	NVDA	Stock	0.3973	0.398	0.3905	0.3918	259332000.0
2014-01-03	AMZN	Stock	19.9145	20.1355	19.811	19.822	44204000.0
2014-01-03	META	Stock	55.02	55.65	54.53	54.56	38246200.0
2014-01-03	TSLA	Stock	10.0	10.146	9.9067	9.9707	70425000.0
2014-01-03	TLT	Stock	101.81	102.45	101.76	102.17	4083831.0
2014-01-03	ES	Stock	41.75	41.85	41.31	41.52	2252000.0
2014-01-03	CL	Stock	64.21	64.49	63.99	64.18	2113700.0
2014-01-03	A	Stock	40.3362	41.0229	40.2432	40.7153	2609647.0
2014-01-03	AABA-DELISTED	Stock	40.16	40.36	39.82	40.12	14994606.0
2014-01-03	AACG	Stock	3.95	3.95	3.93	3.93	10000.0
2014-01-03	AAIC-DELISTED	Stock	26.23	26.4975	26.16	26.28	94384.0
2014-01-03	AAL	Stock	25.75	26.75	25.51	26.54	13829600.0
2014-01-03	AAMC-DELISTED	Stock	265.2971	273.5294	265.2971	271.9676	26989.0
2014-01-03	AAME	Stock	4.03	4.11	4.03	4.07	12500.0
2014-01-03	AAOI	Stock	14.63	14.75	14.26	14.35	47300.0
2014-01-03	AAON	Stock	14.1422	14.3644	13.96	14.08	152325.0
2014-01-03	AAP	Stock	111.23	114.33	110.58	112.88	987700.0
2014-01-03	AAT	Stock	31.21	31.83	31.01	31.74	98600.0
2014-01-03	AAU-DELISTED	Stock	1.22	1.27	1.2	1.2598	114657.0
2014-01-03	AAUAF-DELISTED	Stock	1.22	1.27	1.2	1.26	124697.0
2014-01-03	AAV-DELISTED	Stock	4.36	4.4	4.33	4.38	92993.0
2014-01-03	AAWW-DELISTED	Stock	40.54	40.67	39.98	40.52	219485.0
2014-01-03	AAXJ	Stock	58.48	58.48	57.95	58.03	627744.0
2014-01-03	AAXN-DELISTED	Stock	15.32	15.74	15.32	15.68	533294.0
2014-01-03	AB	Stock	21.37	21.88	21.25	21.73	245800.0
2014-01-03	ABAC-DELISTED	Stock	2.1	2.22	1.87	2.17	208577.0
2014-01-03	ABAX-DELISTED	Stock	40.03	40.334	39.883	40.01	200822.0
2014-01-03	ABB-DELISTED	Stock	26.11	26.22	26.05	26.15	1045397.0
2014-01-03	ABBNY-DELISTED	Stock	26.11	26.22	26.05	26.14	1084908.0
2014-01-03	ABBV	Stock	52.25	52.67	51.97	52.3	4794300.0
2014-01-03	ABC-DELISTED	Stock	69.89	70.21	69.81	69.95	1007168.0
2014-01-03	ABCB	Stock	20.9	20.98	20.5	20.78	75800.0
2014-01-03	ABCD-DELISTED	Stock	1.75	1.83	1.74	1.78	31792.0
2014-01-03	ABCO-DELISTED	Stock	61.05	61.97	60.2	61.7	126785.0
2014-01-03	ABE-DELISTED	Stock	13.76	13.77	13.6	13.76	8855.0
2014-01-03	ABEO	Stock	312.5	325.0	287.5	325.0	11.0
2014-01-03	ABEV	Stock	7.21	7.23	7.08	7.14	6440000.0
2014-01-03	ABFS-DELISTED	Stock	33.88	34.49	32.78	33.83	394345.0
2014-01-03	ABG	Stock	54.02	54.03	52.68	53.03	292200.0
2014-01-03	ABGB-DELISTED	Stock	14.89	14.89	14.6265	14.7546	3460.0
2014-01-03	ABM	Stock	28.23	28.6	27.97	28.43	163800.0
2014-01-03	ABMD-DELISTED	Stock	26.84	27.15	26.5	27.05	191540.0
2014-01-03	ABR	Stock	6.71	6.81	6.7	6.76	67300.0
2014-01-03	ABR.A-DELISTED	Stock	24.3	24.3	24.25	24.25	700.0
2014-01-03	ABR.B-DELISTED	Stock	22.322	22.322	22.322	22.322	500.0
2014-01-03	ABT	Stock	38.37	38.78	38.27	38.64	4301600.0
2014-01-03	ABTL-DELISTED	Stock	14.47	14.87	14.11	14.46	106532.0
2014-01-03	ABUS	Stock	7.75	7.95	7.74	7.8	14500.0

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

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