PREVIEW / stock_daily / 2013-01-03

all stock daily files

  file:    by_date/stock_daily/2013/2013-01-03.parquet
  size:    204 KB
  rows:    6,220
  symbols: 3,496

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-03	AAPL	Stock	19.5671	19.6311	19.3214	19.3607	352965200.0
2013-01-03	MSFT	Stock	27.63	27.65	27.16	27.25	48294400.0
2013-01-03	NVDA	Stock	0.318	0.3218	0.3145	0.3183	298888000.0
2013-01-03	AMZN	Stock	12.8635	13.044	12.8185	12.924	55018000.0
2013-01-03	META	Stock	27.88	28.47	27.59	27.77	63140600.0
2013-01-03	TSLA	Stock	2.3453	2.3633	2.3167	2.318	11130000.0
2013-01-03	TLT	Stock	119.38	119.49	117.9	117.94	10005682.0
2013-01-03	ES	Stock	39.86	40.05	39.55	39.6	1593100.0
2013-01-03	CL	Stock	53.095	53.425	52.995	53.33	2959600.0
2013-01-03	A	Stock	30.0	30.1431	29.7425	30.0644	5751791.0
2013-01-03	AABA-DELISTED	Stock	20.05	20.1	19.72	19.8	19296516.0
2013-01-03	AACC-DELISTED	Stock	4.86	4.95	4.62	4.74	78016.0
2013-01-03	AACG	Stock	5.98	6.38	5.98	6.03	3400.0
2013-01-03	AAIC-DELISTED	Stock	21.68	21.79	21.47	21.79	124937.0
2013-01-03	AAMC-DELISTED	Stock	22.2059	24.6765	21.6176	23.8971	236807.0
2013-01-03	AAME	Stock	3.19	3.32	3.09	3.2	5500.0
2013-01-03	AAMRQ-DELISTED	Stock	0.8525	0.86	0.831	0.836	1926327.0
2013-01-03	AAON	Stock	6.2963	6.4978	6.2548	6.4119	517050.0
2013-01-03	AAP	Stock	72.85	73.44	72.13	72.49	520600.0
2013-01-03	AAT	Stock	28.62	28.66	27.95	28.0	133600.0
2013-01-03	AAU-DELISTED	Stock	3.23	3.26	3.05	3.11	156269.0
2013-01-03	AAUAF-DELISTED	Stock	3.23	3.26	3.05	3.11	157855.0
2013-01-03	AAV-DELISTED	Stock	3.18	3.24	3.18	3.24	153612.0
2013-01-03	AAWW-DELISTED	Stock	45.7	46.14	44.62	44.78	171482.0
2013-01-03	AAXJ	Stock	61.32	61.66	61.23	61.29	416810.0
2013-01-03	AAXN-DELISTED	Stock	9.54	9.8	9.13	9.24	2093106.0
2013-01-03	AB	Stock	18.07	18.29	17.9	17.99	255300.0
2013-01-03	ABAC-DELISTED	Stock	0.9799	0.9799	0.8402	0.96	6425.0
2013-01-03	ABAX-DELISTED	Stock	37.92	38.23	37.0	37.72	123367.0
2013-01-03	ABB-DELISTED	Stock	20.87	21.06	20.84	20.89	1596389.0
2013-01-03	ABBNY-DELISTED	Stock	20.87	21.06	20.84	20.88	1640284.0
2013-01-03	ABBV	Stock	35.0	35.0	34.16	34.83	16739300.0
2013-01-03	ABC-DELISTED	Stock	43.54	43.55	43.2	43.39	1920881.0
2013-01-03	ABCB	Stock	12.89	12.98	12.71	12.79	49100.0
2013-01-03	ABCD-DELISTED	Stock	1.19	1.2499	1.19	1.2	19137.0
2013-01-03	ABCO-DELISTED	Stock	49.24	49.79	48.58	49.57	159387.0
2013-01-03	ABCW-DELISTED	Stock	0.42	0.42	0.35	0.39	13576.0
2013-01-03	ABE-DELISTED	Stock	21.71	21.73	21.65	21.7	14801.0
2013-01-03	ABEO	Stock	287.5	325.0	287.5	325.0	166.0
2013-01-03	ABFS-DELISTED	Stock	9.72	9.81	9.6	9.8	222158.0
2013-01-03	ABG	Stock	32.43	33.96	32.3	33.03	370700.0
2013-01-03	ABM	Stock	20.36	20.55	20.26	20.51	156500.0
2013-01-03	ABMD-DELISTED	Stock	13.74	13.77	13.39	13.45	565364.0
2013-01-03	ABR	Stock	6.04	6.3	5.99	6.2	221200.0
2013-01-03	ABT	Stock	32.9	33.38	32.74	33.27	22148200.0
2013-01-03	ABTL-DELISTED	Stock	4.0152	4.02	3.89	3.92	13650.0
2013-01-03	ABUS	Stock	5.03	5.06	4.91	4.95	5600.0
2013-01-03	ABV-DELISTED	Stock	42.21	42.67	42.01	42.49	1411939.0
2013-01-03	ABX-DELISTED	Stock	35.47	35.55	34.32	34.47	6540870.0
2013-01-03	ACAD	Stock	4.66	4.8	4.6	4.75	851900.0

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

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