Create table

drop table if exists bitcoin cascade;
create table bitcoin (
    date date,
    symbol varchar(8),
    open decimal (10, 2),
    high decimal (10, 2),
    low decimal (10, 2),
    close decimal (10, 2),
    volume_btc decimal (10, 2),
    volume_ils decimal (10, 2),
    primary key(date, symbol)
);

Insert some data

insert into bitcoin (  date ,   symbol ,   open ,   high ,   low ,   close ,   volume_btc ,   volume_ils   )
    values (  '2020-10-12' ,   'BTCILS' ,   37820.02 ,   38773.04 ,   37416.01 ,   37754.11 ,   3.627 ,   138376.69   );

insert into bitcoin (  date ,   symbol ,   open ,   high ,   low ,   close ,   volume_btc ,   volume_ils   )
    values (  '2020-10-11' ,   'BTCILS' ,   38000 ,   38300 ,   37820.02 ,   37820.02 ,   6.144 ,   233601.97   );

insert into bitcoin (  date ,   symbol ,   open ,   high ,   low ,   close ,   volume_btc ,   volume_ils   )
    values (  '2020-10-10' ,   'BTCILS' ,   37685 ,   38400 ,   37685 ,   38000 ,   8.536 ,   325762.14   );

insert into bitcoin (  date ,   symbol ,   open ,   high ,   low ,   close ,   volume_btc ,   volume_ils   )
    values (  '2020-10-09' ,   'BTCILS' ,   37500 ,   37961.53 ,   36600 ,   37685 ,   4.156 ,   155042.32   );

insert into bitcoin (  date ,   symbol ,   open ,   high ,   low ,   close ,   volume_btc ,   volume_ils   )
    values (  '2020-10-08' ,   'BTCILS' ,   36412.82 ,   37500 ,   36102 ,   37500 ,   9.347 ,   343515.51   );

Query the data

select * from bitcoin order by date desc;
SQL Output