1. Home
  2. Datasets
  3. 002 -- Balance sheets of ...
To download the data set, please sign up or log in

002 -- Balance sheets of investment firms, by quarter starting from 2014

002 -- Balance sheets of investment firms, by quarter starting from 2014

Tables

Column Descriptions

Dim quarter, Statfinpas spy pxt 002 2017q4 px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 16 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 2014Q1 and maximum string is 2017Q4.
label string The label for the dimension value. Column label has 16 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 2014Q1 and maximum string is 2017Q4.

Fact, Statfinpas spy pxt 002 2017q4 px, Latest

Column Type Comment
arvo string Datasource did not contain a description for Arvo. Column arvo has 720 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Aineelliset_2016 and maximum string is Paaoma_velat_2016.
quarter string Datasource did not contain a description for Quarter. Column quarter has 720 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 2014Q1 and maximum string is 2017Q4.
balance_sheets_of_investment_firms int Datasource did not contain a description for Balance_sheets_of_investment_firms. Column balance_sheets_of_investment_firms has 720 rows, out of which 306 are empty, making the null percent 42.50. Minimum value is -4418 and maximum value is 461816.

Dim arvo, Statfinpas spy pxt 002 2017q4 px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 45 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Aineelliset_2016 and maximum string is Paaoma_velat_2016.
label string The label for the dimension value. Column label has 45 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: (-) Interim dividends... and first 25 characters of maximum string: TOTAL EQUITY AND TOTAL LI...
orig_extractdate string The date when the data was originally fetched from the source.

Fact, Statfinpas spy pxt 002 2017q4 px, Full history

Column Type Comment
arvo string Datasource did not contain a description for Arvo. Column arvo has 720 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Aineelliset_2016 and maximum string is Paaoma_velat_2016.
quarter string Datasource did not contain a description for Quarter. Column quarter has 720 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 2014Q1 and maximum string is 2017Q4.
balance_sheets_of_investment_firms int Datasource did not contain a description for Balance_sheets_of_investment_firms. Column balance_sheets_of_investment_firms has 720 rows, out of which 306 are empty, making the null percent 42.50. Minimum value is -4418 and maximum value is 461816.
orig_extractdate string The date when the data was originally fetched from the source.

Dim quarter, Statfinpas spy pxt 002 2017q4 px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 16 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 2014Q1 and maximum string is 2017Q4.
label string The label for the dimension value. Column label has 16 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 2014Q1 and maximum string is 2017Q4.
orig_extractdate string The date when the data was originally fetched from the source.

Dim arvo, Statfinpas spy pxt 002 2017q4 px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 45 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Aineelliset_2016 and maximum string is Paaoma_velat_2016.
label string The label for the dimension value. Column label has 45 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: (-) Interim dividends... and first 25 characters of maximum string: TOTAL EQUITY AND TOTAL LI...

Additional Info

Last Updated September 22, 2019
Created June 12, 2019