PREVIEW / stock_daily / 2013-01-04

all stock daily files

  file:    by_date/stock_daily/2013/2013-01-04.parquet
  size:    204 KB
  rows:    6,208
  symbols: 3,479

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
2013-01-04	AAPL	Stock	19.1775	19.2368	18.7796	18.8214	594333600.0
2013-01-04	MSFT	Stock	27.27	27.34	26.73	26.74	52521100.0
2013-01-04	NVDA	Stock	0.3188	0.3298	0.3178	0.3288	524968000.0
2013-01-04	AMZN	Stock	12.879	12.99	12.8325	12.9575	37484000.0
2013-01-04	META	Stock	28.01	28.93	27.83	28.76	72715400.0
2013-01-04	TSLA	Stock	2.32	2.32	2.2613	2.2933	10110000.0
2013-01-04	TLT	Stock	117.66	118.44	117.36	118.3997	9574607.0
2013-01-04	ES	Stock	39.69	39.93	39.59	39.64	1419900.0
2013-01-04	CL	Stock	53.345	54.03	53.34	53.95	2504800.0
2013-01-04	A	Stock	30.1431	30.7225	29.9428	30.6581	6432897.0
2013-01-04	AABA-DELISTED	Stock	19.76	19.95	19.72	19.86	12381700.0
2013-01-04	AACC-DELISTED	Stock	4.8	4.805	4.63	4.7	22066.0
2013-01-04	AACG	Stock	6.1	6.13	6.0	6.08	13900.0
2013-01-04	AAIC-DELISTED	Stock	21.79	21.91	21.76	21.79	89010.0
2013-01-04	AAMC-DELISTED	Stock	23.9706	25.2941	23.9706	25.0	87203.0
2013-01-04	AAME	Stock	3.15	3.25	3.15	3.2	3000.0
2013-01-04	AAMRQ-DELISTED	Stock	0.8405	0.878	0.831	0.8667	2680150.0
2013-01-04	AAON	Stock	6.4415	6.4652	6.3644	6.4444	211950.0
2013-01-04	AAP	Stock	72.75	73.64	72.39	73.62	615000.0
2013-01-04	AAT	Stock	28.17	28.38	27.96	28.25	59200.0
2013-01-04	AAU-DELISTED	Stock	3.05	3.075	2.98	3.01	190355.0
2013-01-04	AAUAF-DELISTED	Stock	3.04	3.07	2.98	3.02	196121.0
2013-01-04	AAV-DELISTED	Stock	3.23	3.27	3.21	3.21	194324.0
2013-01-04	AAWW-DELISTED	Stock	44.98	45.38	44.46	45.13	239811.0
2013-01-04	AAXJ	Stock	61.06	61.33	60.95	61.29	296315.0
2013-01-04	AAXN-DELISTED	Stock	9.34	9.43	9.1	9.25	724634.0
2013-01-04	AB	Stock	18.16	18.79	18.12	18.68	1229800.0
2013-01-04	ABAC-DELISTED	Stock	0.9	0.94	0.894	0.94	9254.0
2013-01-04	ABAX-DELISTED	Stock	37.96	38.18	37.06	37.66	106112.0
2013-01-04	ABB-DELISTED	Stock	20.81	21.1	20.79	21.09	1347510.0
2013-01-04	ABBNY-DELISTED	Stock	20.81	21.1	20.79	21.08	1355176.0
2013-01-04	ABBV	Stock	34.62	34.89	34.25	34.39	21372100.0
2013-01-04	ABC-DELISTED	Stock	43.22	43.73	43.01	43.67	2397693.0
2013-01-04	ABCB	Stock	12.88	12.92	12.75	12.9	118300.0
2013-01-04	ABCD-DELISTED	Stock	1.23	1.23	1.22	1.22	22300.0
2013-01-04	ABCO-DELISTED	Stock	49.82	50.19	49.13	49.77	130928.0
2013-01-04	ABCW-DELISTED	Stock	0.39	0.4099	0.38	0.405	14888.0
2013-01-04	ABE-DELISTED	Stock	21.84	21.84	21.661	21.676	1325.0
2013-01-04	ABEO	Stock	325.0	325.0	300.0	312.5	94.0
2013-01-04	ABFS-DELISTED	Stock	9.85	10.189	9.68	10.15	240928.0
2013-01-04	ABG	Stock	33.28	34.71	33.09	34.41	430900.0
2013-01-04	ABM	Stock	20.6	20.79	20.42	20.76	152400.0
2013-01-04	ABMD-DELISTED	Stock	13.44	13.56	13.31	13.4	340981.0
2013-01-04	ABR	Stock	6.2	6.65	6.15	6.56	319300.0
2013-01-04	ABT	Stock	33.33	33.43	32.85	33.07	15820100.0
2013-01-04	ABTL-DELISTED	Stock	3.95	3.99	3.9001	3.95	30567.0
2013-01-04	ABUS	Stock	4.89	5.07	4.89	5.07	6400.0
2013-01-04	ABV-DELISTED	Stock	42.46	42.65	42.22	42.45	1520945.0
2013-01-04	ABX-DELISTED	Stock	34.09	34.7	33.94	34.61	6897958.0
2013-01-04	ACAD	Stock	4.79	5.0	4.68	4.95	1584300.0

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

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