PREVIEW / stock_daily / 2013-01-23

all stock daily files

  file:    by_date/stock_daily/2013/2013-01-23.parquet
  size:    206 KB
  rows:    6,249
  symbols: 3,509

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-23	AAPL	Stock	18.1718	18.3925	18.0275	18.3575	861509600.0
2013-01-23	MSFT	Stock	27.2	27.64	27.2	27.61	50387700.0
2013-01-23	NVDA	Stock	0.3038	0.304	0.3	0.3032	421808000.0
2013-01-23	AMZN	Stock	13.5285	13.5545	13.3325	13.4055	50178000.0
2013-01-23	META	Stock	31.1	31.5	30.8	30.82	48899800.0
2013-01-23	TSLA	Stock	2.3347	2.416	2.3307	2.4	23464500.0
2013-01-23	TLT	Stock	120.34	120.58	119.95	120.09	2849315.0
2013-01-23	ES	Stock	39.66	39.83	39.31	39.77	1797400.0
2013-01-23	CL	Stock	54.11	54.435	53.97	54.405	2253200.0
2013-01-23	A	Stock	31.8598	31.917	31.5594	31.6881	3741048.0
2013-01-23	AABA-DELISTED	Stock	20.0	20.19	19.91	20.11	13769787.0
2013-01-23	AACC-DELISTED	Stock	4.87	5.19	4.84	5.03	18588.0
2013-01-23	AACG	Stock	5.69	5.81	5.69	5.81	4500.0
2013-01-23	AAIC-DELISTED	Stock	23.15	23.15	22.99	23.12	127513.0
2013-01-23	AAMC-DELISTED	Stock	35.8824	36.4706	34.7059	35.2941	64464.0
2013-01-23	AAME	Stock	3.3	3.32	3.29	3.3	6200.0
2013-01-23	AAMRQ-DELISTED	Stock	1.42	1.47	1.36	1.42	4009570.0
2013-01-23	AAON	Stock	6.7407	6.7496	6.6163	6.6548	119475.0
2013-01-23	AAP	Stock	73.86	74.94	73.78	74.75	409400.0
2013-01-23	AAT	Stock	28.82	28.89	28.51	28.53	250100.0
2013-01-23	AAU-DELISTED	Stock	3.18	3.2001	3.02	3.02	112495.0
2013-01-23	AAUAF-DELISTED	Stock	3.18	3.2001	3.02	3.02	112632.0
2013-01-23	AAV-DELISTED	Stock	3.17	3.23	3.16	3.19	286994.0
2013-01-23	AAWW-DELISTED	Stock	46.73	47.09	46.09	46.11	118215.0
2013-01-23	AAXJ	Stock	60.75	60.89	60.65	60.84	697459.0
2013-01-23	AAXN-DELISTED	Stock	9.46	9.5	9.1701	9.33	683305.0
2013-01-23	AB	Stock	20.6	20.72	20.38	20.51	216900.0
2013-01-23	ABAC-DELISTED	Stock	0.88	0.91	0.85	0.91	8062.0
2013-01-23	ABAX-DELISTED	Stock	39.38	39.38	38.72	38.75	34701.0
2013-01-23	ABB-DELISTED	Stock	20.86	21.05	20.84	20.97	3179170.0
2013-01-23	ABBNY-DELISTED	Stock	20.86	21.05	20.84	20.97	4093860.0
2013-01-23	ABBV	Stock	36.91	37.84	36.5	37.8	10981600.0
2013-01-23	ABC-DELISTED	Stock	45.67	46.59	45.6	46.17	3232978.0
2013-01-23	ABCB	Stock	13.1	13.1	12.95	13.05	22800.0
2013-01-23	ABCD-DELISTED	Stock	1.38	1.38	1.24	1.25	20682.0
2013-01-23	ABCO-DELISTED	Stock	53.23	53.66	52.6	53.32	79693.0
2013-01-23	ABCW-DELISTED	Stock	0.7	0.73	0.63	0.64	32263.0
2013-01-23	ABE-DELISTED	Stock	22.02	22.23	22.0101	22.1599	8332.0
2013-01-23	ABEO	Stock	437.5	475.0	412.5	475.0	14.0
2013-01-23	ABFS-DELISTED	Stock	10.75	10.76	10.38	10.43	217177.0
2013-01-23	ABG	Stock	33.67	34.6	33.53	34.59	294900.0
2013-01-23	ABM	Stock	21.01	21.02	20.92	21.01	222700.0
2013-01-23	ABMD-DELISTED	Stock	12.56	12.68	12.45	12.66	802264.0
2013-01-23	ABR	Stock	7.17	7.17	7.0	7.06	260100.0
2013-01-23	ABT	Stock	33.01	33.15	32.62	32.81	14987600.0
2013-01-23	ABTL-DELISTED	Stock	4.16	4.16	4.0	4.0	69858.0
2013-01-23	ABUS	Stock	4.94	4.98	4.76	4.92	49400.0
2013-01-23	ABV-DELISTED	Stock	45.09	45.35	45.01	45.18	1024542.0
2013-01-23	ABX-DELISTED	Stock	34.9	34.99	34.08	34.08	7569230.0
2013-01-23	ACAD	Stock	6.0	6.19	5.72	5.87	5254300.0

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

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