OpenSea Collections

OpenSea, the largest NFT marketplace

@kaggle.mathurinache_opensea_collections

Table List

1 table(2.21 MB)

Opensea Collections

@kaggle.mathurinache_opensea_collections.opensea_collections

2.21 MB
50100 rows
37 columns

primary_asset_contracts Primary Asset Contracts	created_date Created Date	dev_seller_fee_basis_points Dev Seller Fee Basis Points	hidden Hidden	safelist_request_status Safelist Request Status	name Name	opensea_seller_fee_basis_points Opensea Seller Fee Basis Points	slug Slug	display_data_card_display_style Display Data.card Display Style
[]	Sun Nov 21 2021 20:16:26 GMT+0000 (Coordinated Universal Time)			not_requested	Bkruser27	250	bkruser27	contain
[]	Sun Nov 21 2021 20:16:26 GMT+0000 (Coordinated Universal Time)		true	not_requested	JDB94 Collection	250	jdb94-collection	contain
[]	Sun Nov 21 2021 20:16:23 GMT+0000 (Coordinated Universal Time)		true	not_requested	Untitled Collection #135886578	250	untitled-collection-135886578	contain
[]	Sun Nov 21 2021 20:16:23 GMT+0000 (Coordinated Universal Time)		true	not_requested	BILLIONAIRESVISN Collection	250	billionairesvisn-collection	contain
[]	Sun Nov 21 2021 20:16:21 GMT+0000 (Coordinated Universal Time)			not_requested	different stories same artist	250	different-stories-same-artist	contain
[]	Sun Nov 21 2021 20:16:15 GMT+0000 (Coordinated Universal Time)	1000		not_requested	CryptOxelium	250	cryptoxelium	contain
[]	Sun Nov 21 2021 20:16:11 GMT+0000 (Coordinated Universal Time)		true	not_requested	Untitled Collection #137136141	250	untitled-collection-137136141	contain
[]	Sun Nov 21 2021 20:16:10 GMT+0000 (Coordinated Universal Time)		true	not_requested	Untitled Collection #137140511	250	untitled-collection-137140511	contain
[]	Sun Nov 21 2021 20:16:10 GMT+0000 (Coordinated Universal Time)		true	not_requested	abfilm Collection	250	abfilm-collection	contain
[]	Sun Nov 21 2021 20:16:07 GMT+0000 (Coordinated Universal Time)		true	not_requested	Untitled Collection #77968341	250	untitled-collection-77968341	contain


CREATE TABLE opensea_collections (
  "primary_asset_contracts" VARCHAR,
  "created_date" TIMESTAMP,
  "default_to_fiat" BOOLEAN,
  "dev_buyer_fee_basis_points" BIGINT,
  "dev_seller_fee_basis_points" BIGINT,
  "featured" BOOLEAN,
  "hidden" BOOLEAN,
  "safelist_request_status" VARCHAR,
  "is_subject_to_whitelist" BOOLEAN,
  "name" VARCHAR,
  "only_proxied_transfers" BOOLEAN,
  "opensea_buyer_fee_basis_points" BIGINT,
  "opensea_seller_fee_basis_points" BIGINT,
  "require_email" BOOLEAN,
  "slug" VARCHAR,
  "stats_one_day_volume" DOUBLE,
  "stats_one_day_change" DOUBLE,
  "stats_one_day_sales" DOUBLE,
  "stats_one_day_average_price" DOUBLE,
  "stats_seven_day_volume" DOUBLE,
  "stats_seven_day_change" DOUBLE,
  "stats_seven_day_sales" DOUBLE,
  "stats_seven_day_average_price" DOUBLE,
  "stats_thirty_day_volume" DOUBLE,
  "stats_thirty_day_change" DOUBLE,
  "stats_thirty_day_sales" DOUBLE,
  "stats_thirty_day_average_price" DOUBLE,
  "stats_total_volume" DOUBLE,
  "stats_total_sales" DOUBLE,
  "stats_total_supply" DOUBLE,
  "stats_count" DOUBLE,
  "stats_num_owners" BIGINT,
  "stats_average_price" DOUBLE,
  "stats_num_reports" BIGINT,
  "stats_market_cap" DOUBLE,
  "stats_floor_price" BIGINT,
  "display_data_card_display_style" VARCHAR
);